This content has been marked as final. Show 2 replies
There are three ways to do this.
1. Use a JNDI data store connection that is configured on the app server and just specify the JNDI name in EDQ. This is fine as long as the app server can handle complex connect strings like the one you specified.
2. Use an Oracle TNS data store connection. This option will appear in the Data Store setup wizard if you set the oracle.net.tns_admin Java system property to the directory containing tnsnames.ora. Note that there is no need for Oracle client software to be installed - just the tnsnames.ora file. This is normally done by creating a file called jvm.properties in your EDQ config directory, or you can set the property in the app server when setting up EDQ (for example -d oracle.net.tns_admin = c:\temp)
3. Use an Oracle LDAP data store connection. This also requires setting Java system properties, such as these:
dn.oracle.directory.servers = ldap://servername:port
dn.oracle.default.admin.context = dc=datanomic,dc=local
The first property gives the location of the LDAP server(s), the second sets the context within the LDAP tree. These properties are used to construct an Oracle/LDAP JDBC connection string, which looks something like:
Edited by: MikeMatthews on Nov 12, 2012 4:37 AM
Thanks for your comprehensive reply. This is very helpful.