ToolBox JDBC driver question

as400

    Sponsored Links

    Next

  • 1. IBM Software Support FYI
    Has anyone noticed that the support calls do not seem to be staying in the country anymore, it has become extremely hard to understand the call takers.

ToolBox JDBC driver question

Postby atu0830 » Fri, 14 May 2004 16:56:20 GMT

WAS use ToolBox JDBC driver connect a local as/400 java application to a
remote as/400 (V5R2) of own a IASP(independent auxiliary storage pool ). if
the remote database name is "test", the WAS can start this instance . But
when the remote database name is "test.cn.ibm.com" , WAS can't start this
instance.  No IASP at the remote as/400, the instance always successfully
start.
 RDB entry of the local as/400,
  Relational Database    Remote Location
 test      test.cn.ibm.com

 I can connect this remote as/400 by run STRSQL command on the local as400.
And create a test java program of use ToolBox JDBC connect this remote
database by use "test" or "test.cn.ibm.com" ,both of them are successfully .
 So I guess the WAS can't get the right remote database name of as/400 of
own a IASP by ToolBox JDBC driver.



ToolBox JDBC driver question

Postby atu0830 » Fri, 14 May 2004 16:58:13 GMT

WAS use ToolBox JDBC driver connect a local as/400 java application to a
remote as/400 (V5R2) of own a IASP(independent auxiliary storage pool ). if
the remote database name is "test", the WAS can start this instance . But
when the remote database name is "test.dhc.com" , WAS can't start this
instance.  No IASP at the remote as/400, the instance always successfully
start.
 RDB entry of the local as/400,
  Relational Database    Remote Location
 test      test.dhc.com

 I can connect this remote as/400 by run STRSQL command on the local as400.
And create a test java program of use ToolBox JDBC connect this remote
database by use "test" or "test.dhc.com" ,both of them are successfully .
 So I guess the WAS can't get the right remote database name of as/400 of
own a IASP by ToolBox JDBC driver.



Similar Threads:

1.JDBC driver for Database Toolbox

I am trying to use the Database Toolbox and I am unable to establish
a connection to the databse using the JDBC driver that I have. I get
the message : 'No suitable driver'.

What is a suitable JDBC driver to use with the Database Toolbox?

Thanks,
Dinkar

2.SQLSummit.com lists: JDBC drivers, ODBC drivers, .NET data providers, OLE DB providers, XQuery engines

3.Toolbox modification of IBM Toolbox for Java on AS/400

Hello

How can I check on AS/400 machine  which  toolbox modification of "IBM
Toolbox for Java" is there installed?

Emi

4.java toolbox question - WizardStateMachine

Can anybody supply me with a working example - nothing in the docs.

Thanks

Kevin


5.JDBC driver fro DB2?

Java web application, based on J2EE  and JBOSS 4.0.0.2, installed on
Windows 2003 Server

Database: DB2 on AS/400 iSeries V5R3M0

Which JDBC driver can be used? One choice is DataDirect, but they are
*too* expensive.

TIA!

6. native JDBC driver

7. DRDA JDBC Drivers

8. DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generated field



Return to as400

 

Who is online

Users browsing this forum: No registered users and 20 guest