Getting ‘JDBC driver not found error’ while trying to connect DOMSQL from crystal through jdbc
August 7, 2012 – 9:09 amI could do with some help as i’m pretty well stuck.
I’m trying to connect crystal report 11.5 ( XI R2 ) developer to DOMSQL on a remote server via jdbc.
I have copied com.ibm.domino.domsql.driver_1.0.0.jar into “C:\Program Files\Common Files\Business Objects\3.0\java\lib\external”
I then opened the CRConfig.xml in “C:\Program Files\Common Files\Business Objects\3.0\java\lib” and added “C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/com.ibm.domino.domsql.driver_1.0.0.jar;” after the last semicolon just before ${CLASSPATH}
I then open Crystal reports, standerd report wizard, create new connection, JDBC (JNDI), I then enter my DB URL: “jdbc:domsql://serv01/cois_v2/cois_crm.nsf/crm” and driver class “com.ibm.domino.domsql.DomSQLDriver”.
Then next, username and password. When I try to connect, I get the error:
Failed to Open Connection
Details: JDBC Driver not found
Any idea? I think I’ve done everything right
UPDATE: The problem is in the JDK that is installed with CR. I have installed an updated version of the Java JDK (c:\jdk) and changed the path for JavaDir in CRConfig.xml. Now I am able to connect to the DomSQL server
UPDATE 2: I have also successfully tested with JRE instead of JDK. here is the exact version, I used
java version “1.6.0_24″
Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)
6 Responses to “Getting ‘JDBC driver not found error’ while trying to connect DOMSQL from crystal through jdbc”
Maybe it doesn’t like those forward slashes it the path?
By Martin Jinoch on Aug 7, 2012
Tried also with backslash; no difference
By Ulrich Krause on Aug 7, 2012
What version of JRE did you use or did it have to be the JDK?
Thanks
-Toby
By Toby Samples on Aug 7, 2012
Jre should wirk also. Will test when back in the office. I used Java 1.6. 1.5 should be fine as well. It depends on the driver. The domsql driver obviously requires a higher version than 1.4.
By Ulrich Krause on Aug 7, 2012
I have also successfully tested with JRE instead of JDK. here is the exact version, I used
java version “1.6.0_24″
Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)
By Ulrich Krause on Aug 8, 2012
Certainly a fantastic piece of work … It has relevant information. Thanks for posting this. Your blog is so interesting and very informative.Thanks sharing. Definitely a great piece of work Thanks for your work.
By moving companies washington on Aug 10, 2012