Skip to Content
0
Former Member
May 28, 2012 at 08:38 AM

Crystal Report JDBC error

194 Views

Dear all,

I am using Crystal Report XI R2 SP6. When I create JDBC connection to MS SQL Server 2008 database and select a Store Procedure, it prompt out an error message:

My environment are:

- OS: Windows 7 32bit

- Java: JDK 1.6 update 31 (32-bit)

- DB: MS SQL Server 2008 SP2

- JDBC Drive: 4.0 (sqljdbc4.jar)

The CrConfig.xml is locate at: C:\Program Files\Business Objects\Common\3.5\java. The contact bellow:

<?xml version="1.0" encoding="utf-8"?><CrystalReportEngine-configuration>

<reportlocation>../..</reportlocation>

<timeout>10</timeout>

<ExternalFunctionLibraryClassNames>

<classname> </classname>

<classname> </classname>

</ExternalFunctionLibraryClassNames>

<keycode>B6W60-01CS200-0000AF0-0CX0</keycode>

<Javaserver-configuration>

<DataDriverCommon>

<JavaDir>C:\Program Files\Java\jdk1.6.0_31\bin</JavaDir>

<Classpath>C:\Dev\crDemo_workspace\libraries\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc4.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/crlovmanifest.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/CRLOVExternal.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/CRDBJavaServerCommon.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/CRDBJavaServer.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/CRDBJDBCServer.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/CRDBXMLServer.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/CRDBJavaBeansServer.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/external/CRDBXMLExternal.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/external/log4j.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/cecore.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/celib.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/ebus405.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/corbaidl.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/external/freessl201.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/external/asn1.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/external/certj.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/external/jsafe.jar;C:\Program Files\Business Objects\Common\3.5\java/lib/external/sslj.jar;${CLASSPATH}</Classpath>

<IORFileLocation>${TEMP}</IORFileLocation>

<JavaServerTimeout>1800</JavaServerTimeout>

<JavaServerStartupTimeout>30</JavaServerStartupTimeout>

<JVMMaxHeap>64000000</JVMMaxHeap>

<JVMMinHeap>32000000</JVMMinHeap>

<NumberOfThreads>100</NumberOfThreads>

</DataDriverCommon>

<JDBC>

<CacheRowSetSize>100</CacheRowSetSize>

<JDBCURL>jdbc:sqlserver://SQLSERVER:1433;</JDBCURL>

<JDBCClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</JDBCClassName>

<JDBCUserName>dbuser</JDBCUserName>

<JNDIURL></JNDIURL>

<JNDIConnectionFactory></JNDIConnectionFactory>

<JNDIInitContext>/</JNDIInitContext>

<JNDIUserName>weblogic</JNDIUserName>

<GenericJDBCDriver>

<Default>

<ServerType>UNKNOWN</ServerType>

<QuoteIdentifierOnOff>ON</QuoteIdentifierOnOff>

<StoredProcType>Standard</StoredProcType>

<LogonStyle>Standard</LogonStyle>

</Default>

<Sybase>

<ServerType>SYBASE</ServerType>

<QuoteIdentifierOnOff>OFF</QuoteIdentifierOnOff>

<DriverClassName>com.sybase.jdbc2.jdbc.SybDriver</DriverClassName>

<StoredProcType>Standard</StoredProcType>

<LogonStyle>MySQL</LogonStyle>

</Sybase>

</GenericJDBCDriver>

</JDBC>

<XML>

<CacheRowSetSize>100</CacheRowSetSize>

<PreReadNBytes>4096</PreReadNBytes>

<MaxCacheXMLSize>153600</MaxCacheXMLSize>

<XMLLocalURL></XMLLocalURL>

<SchemaLocalURL></SchemaLocalURL>

<XMLHttpURL></XMLHttpURL>

<SchemaHttpURL></SchemaHttpURL>

</XML>

<JavaBeans>

<CacheRowSetSize>100</CacheRowSetSize>

<JavaBeansClassPath></JavaBeansClassPath>

</JavaBeans>

</Javaserver-configuration>

</CrystalReportEngine-configuration>

Attachments

Capture.PNG (7.4 kB)