Re: Accessing DB2 with Java?
- From: Charles Finley <cfinley@xxxxxxxxxxx>
- Date: Thu, 10 Aug 2006 12:10:52 -0700
We use DB2 a lot, however, we have not tried to access it from the HP 3000.
One thing I would suspect is an incompatibility between the driver and the
JVM. Therefore, I would research if the type 4 driver requires a newer JVM
than jre 1.3. Even if it requires 1.3.1, that could make a difference. If it
does, you might be sucessfull with the older driver. The older driver comes
in a db2java.zip or db2java.jar file as opposed to the 1.4 driver which
comes in the db2jcc.jar.
Charles Finley
619-795-0720
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:HP3000-L@xxxxxxxxxxxxx]On
Behalf Of Jeff Stothart
Sent: Thursday, August 10, 2006 10:21 AM
To: HP3000-L@xxxxxxxxxxxxx
Subject: Accessing DB2 with Java?
Hello all -
We have a need to access a DB2 database from the hp3000. We thought we
could accomplish this with Java, but we have not been successful.
We are on MPE/iX version 7.0. We downloaded and installed the Java SDK
1.3 from Jazz. We believe that the Java environment is set up correctly
on the hp3000 because we're able to compile and run other (albeit
simpler) Java programs. We're using the type 4 JDBC DB2 drivers that we
got from IBM. When we run the program on the hp3000 it looks like we
connect to the JDBC listener on the IBM, but then the listener rejects
the connection because it says the arguments that we're giving it are
invalid. We're passing the target DB name, user id, and password.
Our speculation is that the listener, for some reason, is not receiving
the arguments in the format that it expects. We are not in control of
opening the socket or communicating with the listener. All of the
tcp/ip communications are done by the driver, so we're not exactly sure
how it's doing it.
There is security on the IBM side (lots of it), but we've worked with
our internal IBM contact and we don't believe this issue is security
related.
The interesting thing is that we can move the program that we compiled
on the hp3000 to either a Windows or HP-UX system and it works.
We know there are 3rd party solutions available but our client would
rather look at other solutions before going down the 3rd party path. We
also think we can accomplish this with Perl and XML Remote Procedure
Calls (using Frontier::RPC, XML::Parser, expat XML parser). We have
tested this method with a simple program using a Windows system as the
target, and it works. Downsides to this method are we'd have to write a
listener/DB2 caller (probably Perl) that would run on the IBM. Since
that would be a special, nonstandard background process, we're more at
risk that if it would have problems, they might not be addressed as
quickly as problems with the JDBC job. So we'd really like to get this
working with Java.
Finally......my question! Has anyone done this before or does anyone
have any ideas on what we can try to get this to work?
Thanks! Jeff
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
__________ NOD32 1.1701 (20060810) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
.
- Follow-Ups:
- Re: Accessing DB2 with Java?
- From: Chris Thompson
- Re: Accessing DB2 with Java?
- References:
- Accessing DB2 with Java?
- From: Jeff Stothart
- Accessing DB2 with Java?
- Prev by Date: Re: Accessing DB2 with Java?
- Next by Date: Re: cognos license for N series.
- Previous by thread: Re: Accessing DB2 with Java?
- Next by thread: Re: Accessing DB2 with Java?
- Index(es):
Relevant Pages
|
