Friday 13 March 2009

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.