Hi,
I'm facing such problem with CR 2008
We have our custom GenericJDBC driver which we use ilke below:
connection string
jdbc:xxxx:sql:http://hostname:9001/virtualjdbc/service
driver
de.xxxx.virtual.VirtualDriver

and then credentails for a user/password as usual.

If i use some other client like DBVisualiser for connectinhg via our driver  - it works fine.
But using CR 2008 we are encountering something like :

Failed to open the connection.
Details: JDBC driver not found.


We added our driver jar to CrConfig.xml
...
<keycode>CFK0A-Y0TTM2M-00UFAFF-N43M</keycode>
<Javaserver-configuration>
<DataDriverCommon>
    <JavaDir>G:\work\tools\cr9_install\javasdk\bin</JavaDir>
    <Classpath>G:\work\tools\cr9_install\Common\4.0\java/lib/crlovmanifest.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/CRLOVExternal.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/CRDBJDBCServer.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/CRDBXMLServer.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/CRDBJavaBeansServer.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/external/CRDBXMLExternal.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/external/log4j.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/CRDBSForceServer.jar;G:\work\tools\cr9_install\Common\4.0\java/lib/external/CRDBSForceExternal.jar;G:\work\tools\cr9_install\Common\4.0\java\lib\external\xxxx-virtualjdbc.jar;G:\work\tools\cr9_install\Common\4.0\java\lib\external\mysql.jar;${CLASSPATH}</Classpath>
    <IORFileLocation>${TEMP}</IORFileLocation>
    <JavaServerTimeout>1800</JavaServerTimeout>
    <JavaServerStartupTimeout>30</JavaServerStartupTimeout>
    <JVMMaxHeap>64000000</JVMMaxHeap>
    <JVMMinHeap>32000000</JVMMinHeap>
    <NumberOfThreads>100</NumberOfThreads>
</DataDriverCommon>
.....
Are there any limitation regarding connection string in CR 2008, or library jar structure ???

It is not a matter of JDBC url,
if we would support jdbc:xxxx:sql://hostname:9001/virtualjdbc/service
it also does not work ...
It seems to me something is wrong with jar.
But have no cluse
we also provided services/java.sql.Driver in META-INF containing :
de.xxx.vjdbc.VirtualDriver


The very similar case with mysql driver works perfectly in my CR 2008
Thanks Mariusz D.







Edited by maryoush - 13 Sep 2010 at 3:49am