db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ben Hardill (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5551) DB2 .NET Data Provider no longer able to connect.
Date Wed, 21 Dec 2011 16:41:30 GMT
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: 10.8.2.2, 10.8.1.2
         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


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".)  SQLSTATE=58004

Investigation showed that the failing instance was using the latest Derby version (10.8.2.2)
and the working version was using an older build (10.6.1.0). Trying the release versions in
order shows that the regression happens with the release builds 10.8.1.2 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 192.168.229.1 -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

        

Mime
View raw message