Thread: JDBC 8.0-310 + Crystal Reports 10 == Not Implemented
When trying to use the Business Objects Business View Manager to create a Data Foundation through the aforementioned JDBC driver, tables containing NUMERIC fields fail to be addable, giving only the non-helpful error message: "Not Implemented". I know it's a problem with the JDBC driver, because the ODBC driver works just fine. If I must, I will use the ODBC driver, but I prefer the JDBC driver because it seems to work better in other cases. I don't have a stack trace because I'm not accessing the JDBC driver programmatically. I know it's a problem with NUMERIC fields because tables not having NUMERIC fields work just fine, and only those with NUMERIC fields fail. I also notice that the problem is not fixed in the development version. __ David B. Held Software Engineer/Array Services Group 200 14th Ave. East, Sartell, MN 56377 320.534.3637 320.253.7800 800.752.8129
On Wed, 31 Aug 2005, Dave Held wrote: > When trying to use the Business Objects Business View > Manager to create a Data Foundation through the > aforementioned JDBC driver, tables containing NUMERIC > fields fail to be addable, giving only the non-helpful > error message: "Not Implemented". Someone else reported this before and we added additional error text to the not implemented message to help track down what it needed to work. Unfortunately they never tried it and got back to us. Does the development driver provide any more detail? Kris Jurka
> -----Original Message----- > From: Kris Jurka [mailto:books@ejurka.com] > Sent: Wednesday, August 31, 2005 2:08 PM > To: Dave Held > Cc: pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] JDBC 8.0-310 + Crystal Reports 10 == Not > Implemented > > > Someone else reported this before and we added additional > error text to the not implemented message to help track > down what it needed to work. > Unfortunately they never tried it and got back to us. > Does the development driver provide any more detail? Unfortunately not. It gives exactly the same message as the production driver. I wonder if this problem has to do with incomplete support for DatabaseMetaData methods? After all, the tool I am using shows table schema information rather than raw data (it's a modeling/designer tool). __ David B. Held Software Engineer/Array Services Group 200 14th Ave. East, Sartell, MN 56377 320.534.3637 320.253.7800 800.752.8129
On Wed, 31 Aug 2005, Dave Held wrote:
> Unfortunately not. It gives exactly the same message as the
> production driver. I wonder if this problem has to do with
> incomplete support for DatabaseMetaData methods? After all,
> the tool I am using shows table schema information rather
> than raw data (it's a modeling/designer tool).
>
Actually looking closer, the 8.0-310 driver should report "This method is
not yet implemented." and newer drivers should report "Method {0} is not
yet implemented." Getting exactly "Not Implemented" from Crystal
Reports seems to indicate that this is their error message, not ours.
Unless of course they are taking our SQLState code for "Feature not
supported" and reporting that as "Not Implemented". I don't have any
suggestions other than to try and contact Crystal Reports support.
Kris Jurka
Did anybody use Crystal Reports with PostgreSQL for business critical
stuff? Recently we have seen some Crystal Reports cores with PostgreSQL.
Best regards,
Hans
Kris Jurka wrote:
>
> On Wed, 31 Aug 2005, Dave Held wrote:
>
>> When trying to use the Business Objects Business View
>> Manager to create a Data Foundation through the
>> aforementioned JDBC driver, tables containing NUMERIC
>> fields fail to be addable, giving only the non-helpful
>> error message: "Not Implemented".
>
>
> Someone else reported this before and we added additional error text to
> the not implemented message to help track down what it needed to work.
> Unfortunately they never tried it and got back to us. Does the
> development driver provide any more detail?
>
> Kris Jurka
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Cybertec Geschwinde & Schönig GmbH
Schöngrabern 134; A-2020 Hollabrunn
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at
> -----Original Message-----
> From: Kris Jurka [mailto:books@ejurka.com]
> Sent: Wednesday, August 31, 2005 3:16 PM
> To: Dave Held
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] JDBC 8.0-310 + Crystal Reports 10 == Not
> Implemented
>
> Actually looking closer, the 8.0-310 driver should report
> "This method is not yet implemented." and newer drivers
> should report "Method {0} is not yet implemented." Getting
> exactly "Not Implemented" from Crystal Reports seems to indicate
> that this is their error message, not ours.
That is my conclusion as well. After hacking around the driver a
bit, I seem to have eliminated all PSQLExceptions as the cause of
the failure. So either one of the other exceptions is getting
thrown, or Crystal has a problem with a function result, rather
than an exception. I got the driver to give me a log file of the
debug messages, if anyone thinks it would help.
__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East, Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129