cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report JDBC error

Former Member
0 Kudos

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>

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Please move this thread to SAP Crystal Reports - Data Connectivity and update whether it happens to only stored procedure(s) or tables/views also.

This is the link:

http://scn.sap.com/community/crystal-reports/data-connectivity

Thanks,

Prathamesh