SQLDeveloper Ldap success and failure modes

(slightly clearer update:

Works/Happy day scenario:

1/LDAP Server: your.ldap.com:389:636
(machine:nonssl port:ssl port)
(bug in 154 ssl port required, can be entered but non ssl is used)
(fix in development, ssl port can be left out entirely i.e.
machine:nonssl port)
2/press enter in the LDAP Server field
3/choose context (with a db service)
4/press load->get db service populated with pull down ,
5/select db service enter username/password
6/test gives successfull connection

Error scenarios with bad error messages:

LDAP Server: your.ldap.com:389:636
(machine:nonssl port:ssl port) (bug ssl port required can be entered but nonssl is used) EDIT typo switched to "nonssl is used".
Error_mode:press test: Status -Test failed: Required property 'hostname' is not set on the DataProvider (because no Db service is available and selected)

LDAP Server: your.ldap.com:389:636
press enter
Error_mode:different contexts are available do not select one
press load->get Status: Failure -null (as no context is selected)

Error_mode:choose a context with no db service,
press load->get Status: Failure -setSelectedIndex:0 out of bounds (as there are no db services with this context.

End of update)

LDAP Server: your.ldap.com:389:636
Error_mode:press test: Status -Test failed: Required property 'hostname' is not set on the DataProvider (because no Db service is available and selected)

1/LDAP Server: your.ldap.com:389:636
(machine:nonssl port:ssl port) (bug ssl port required in sqldeveloper, though I do not think ssl is used)
2/press enter
Error_mode:different contexts are available do not select one
press load->get Stataus: Failure -null (as no context is selected)
3/NON Error mode:choose context with a db service
4/press load->get db service populated with pull down , select db service enter username/password -> test(->>>>>>success)

FYI
Error_mode:choose a context with no db service,
press load->get Status: Failure -setSelectedIndex:0 out of bounds (as there are no db services with this contxt.

I think that describes getting the connection details [internally hostname, port and sid] - need to add username/password.

GET ERROR ORA-00942 ON DATA MOVE STEP

For data move when you are not dba and not data move user additional privileges are required:

8228281 04-FEB-09 2 (null) 11 1875 MIGRATION NO RELEASE MYSQL QUICK
MIGRATION STOPED IN CONVERT STEP WHEN MIGRATE TABLE AND DATA

where hrcp2 is the user doing the data move:

Multi schema requires the following if you are not dba:

--disable triggers and disable table constraints
alter any table to hrcp2;

--disable primary keys also affects indexes.
create any index to hrcp2;
drop any index to hrcp2;
alter any index to hrcp2;

and if you are not the dba or the datamove user:

--select to get the datatypes (where 1 = 0) and insert to insert the data
grant select any table to hrcp2;
grant insert into table to hrcp2;

(optionally sqldeveloper created) datamove user is granted:
alter any trigger
and on each table is individually granted
select insert and alter

not sure how datamove user gets around:
create any index to hrcp2;
drop any index to hrcp2;
alter any index to hrcp2;
which is implicitly required as disabling a primary key constraint affects an
index.

Issue:Square boxes as text characters Solution:Add fonts

http://forums.oracle.com/forums/thread.jspa?forumID=260&threadID=683208

The above link did not come out very well in the previous post...

under

Issue:Square boxes as text characters Solution:Add fonts

Installing mathematical fonts

THERE HAS GOT TO BE A MORE CONVIENIENT WAY TO GET MATHEMATICAL/
FULL UNICODE FONT SET , please post if you have better information

Getting mathematical fonts on Linux

There may be mathematical truetype fonts already on your system
or available through you packaging system.
I searched the internet for them.

http://www.mozilla.org/projects/mathml/fonts/
points to a STIX Fonts Project beta font download
http://www.mozilla.org/projects/mathml/fonts/stix/STIXBeta.zip

download and extract these fonts they are *.otf they can
be converted to *.ttf as described here:

http://www.stuermer.ch/blog/convert-otf-to-ttf-font-on-ubuntu.html

the ttf fonts can be installed in Linux and installed in the
fallback directory (which may need to be created)
jdk1.5.0_06jre/lib/fonts/fallback

I tried the raw *.otf and it did not work so the conversion
to ttf may well be necessary.

I copied to /usr/share/fonts/truetype

Then I did
xset fp rehash
and could use the fonts but they may have been already installed.

Testcase (supplied by customer):

create table test ( testcol VARCHAR2(10));

insert into test values (unistr('\D835\DCAB'));

then view the table in SQLDeveloper.

Please comment if you have any problem/improvements.

Issue:Square boxes as text characters Solution:Add fonts

Chinese characters in Linux see Debian Chinese How To [1] basically:

1. create a jre/lib/fonts/fallback directory if necessary and
2. copy or link the fonts files into this directory. (On my Linux system: /usr/share/fonts/truetype/arphic/gbsn00lp.ttf )
3. I will install Japanese fonts when the business need arises.