Generic JDBC connection with CR 2008
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11099
Printed Date: 08 May 2024 at 2:37am
Topic: Generic JDBC connection with CR 2008
Posted By: maryoush
Subject: Generic JDBC connection with CR 2008
Date Posted: 13 Sep 2010 at 1:12am
|
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. |