db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ben Hardill (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5551) DB2 .NET Data Provider no longer able to connect.
Date Wed, 21 Dec 2011 17:05:31 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Ben Hardill updated DERBY-5551:

    Attachment: Server1.trace

A trace file from the failed connection (with
> DB2 .NET Data Provider no longer able to connect.
> -------------------------------------------------
>                 Key: DERBY-5551
>                 URL: https://issues.apache.org/jira/browse/DERBY-5551
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server
>    Affects Versions:,
>         Environment: Network Server running on any platform (Tested on Windows 2003 Server
and Fedora 14 Linux) using IBM JRE (1.6.0 SR9)
> DB2 .NET Data Provider running on Windows 2003 Server
>            Reporter: Ben Hardill
>         Attachments: Derby.NET-Test.zip, Server1.trace, derby-sysinfo
> While looking for a solution for connecting a .NET C# application to a Derby database
I tried the DB2 .NET Data Provider. I thought this might work since both DB2 and Derby both
use DRDA and that the DB2 JDBC driver will happily connect to Derby as well.
> I had 2 different Derby instances that I used to test this and one worked just fine and
the other would fail to connect with the following error:
> ERROR [58004] [IBM] SQL0901N  The SQL statement failed because of a non-severe system
error. Subsequent SQL statements can be processed.  (Reason "DRDA AR: Parser Invalid Value".)
> Investigation showed that the failing instance was using the latest Derby version (
and the working version was using an older build ( Trying the release versions in
order shows that the regression happens with the release builds and later. 
> The DB2 .NET Data Provider can be downloaded here:
> http://www-01.ibm.com/software/data/db2/ad/dotnet.html
> A quick sample app can be found here:
> http://www.hardill.me.uk/Derby.NET-Test.zip 
> You can run it as follows:
> TestDB2Connection.exe -host -port 1547 -database IPA -user user -password
foo -query "select * from APP.PERSONS"
> It outputs a CSV dump of the result set

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message