Skip to Content
author's profile photo Former Member
Former Member

Posible bug...

Hi

I am using CR4E, JRC, Tomcat 5.0 and sqlServer 2000 to present reports in a java based web application.

When I try to use a Store procedure with a query that includes money/currency fields, JRC shows the following error:

Error JDBC: [SQLServer 2000 Driver for JDBC]Value can not be converted to requested type

I am using Microsoft JDBC driver SP3 form SQL Server 2000. JNDI datasource Works fine.

Actually JTDS Driver for SQL Server doesn't works fine with JRC and is not an option

¿is there any way to solve this?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 25, 2006 at 12:47 PM

    I did a quick search for the error message and found the following article on Microsoft's site:

    http://support.microsoft.com/kb/823689

    Does" target="_blank">http://support.microsoft.com/kb/823689">http://support.microsoft.com/kb/823689

    Does the issue described in the MS KBase seem familiar to your issue? Also, what happens if you attempt to run the same stored procedure from a Java class (e.g. return a ResultSet and output the results)? This will help us determine if the issue is specific to the JRC or the JDBC driver.

    Give this a try and let me know how you make out.

    By the way, it appears that you are using CR4E. We have a forum dedicated to CR4E issues found here:

    http://diamond.businessobjects.com/forum/193>

    Regards,
    Sean Johnson (CR4E Product Manager)

    Rate" target="_blank">http://www.eclipseplugincentral.com/Web_Links-index-req-ratelink-lid-639.html">Rate this plugin @ Eclipse Plugin Central

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      <p>By mistake I don&#39;t well analyze Errors I have with CR4E, JRC And JDBC Driver for SQL Server 2K SP3.</p><p>Issue you found at KBase and mine are very similar indeed however columns on a temporal table used by store procedure of Real Database Type accept null values. JDBC Driver and Crystal Reports individually can Manage Real Database Types without problems, but when I use CR4E with JDBC driver for SQL Server 2K, Them can&#39;t do it. Really Currency/money fields are well understood by JRC<br /></p><p>I supose that is a bug of Driver </p><p>Regards<br /></p>

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.