Getting CRXI to talk to a remote Derby database

[Former Member]

I have a Derby database on a remote Linux server and I want to get CRXI to connect to it. I am not at all familiar with JDBC, but the manual seems to imply that JDBC is the standard way to talk to Java Databases like JDBC and this should be easy.

I entered a JDBC URL based on one used to connect from another product and class name "org.apache.jdbc.ClientDriver", which appears from a web search to be the right class to use, but I just get the message "JDBC driver not found". I assume that this means it can't find the class "org.apache.jdbc.ClientDriver". Do I need to install this somewhere, or am I going about this entirely the wrong way?

[former_member11696]

Thank you for posting your solution

[Former Member]

A colleague found http://support.businessobjects.com/communityCS/TechnicalPapers/cr_xi_jdbc_connections.pdf, which I adapted slightly.

I added "e:\Program Files\Business Objects\Common\3.5\java/lib/external/derbyclient.jar" to the <Classpath> tag and in the <JDBC> tag I edited the following tags

<JDBCURL>jdbc:derby://SERVERNAME:PORTNUMBER</JDBCURL>

<JDBCClassName>org.apache.derby.jdbc.ClientDriver</JDBCClassName>

<JDBCUserName>XXXXX</JDBCUserName>

I was then able to successfully establish a connection to the local database.

[Former Member]

I've now set up the derby database on the same machine. It is running because I can access it through jxtray. I also copied derbyclient.jar, which contains class org.apache.jdbc.ClientDriver into "Business Objects\Common\3.5\java\lib\external"

I still get the same error.

Some of the documentation for version 10 suggests I need to use JNDI. Would that help?