ToolBox JDBC driver question

as400

    Sponsored Links

    Next

  • 1. change max open file handles for unix tasks in qsh
    I am having a problem with MQ QMGR running out of file handles and this causes a catastrophic ABEND which can only be cured by rebooting the system. I can see in qsh that doing a unlimit -a shows an open files value of 200. this value is just too low. Does anyone have any ideas on how to up this value in the O/S? Regards Chris
  • 2. Info Center on CD image to download ?
    Hello, is there any way to get Info Center CD separately (without buying iSeries). I know that info center can be reach on line via internet, but what about off-line version on CD ? I'm looking for IC for 5.2 and 5.3 OS version. Currently I'm unemployed and want to stay tune with any new features of OS/400. Best regards. GG
  • 3. Bind services to specified interface
    Hi, is there a way to bind for example *NETSVR only to local interface. On our AS/400 we have 2 interfaces: local and internet but we want to set *NETSVR to listen only on local interface. Do we need to write some program to do that or there is command ?!?!? We have couple of as/400 with releases from 4.2 to 4.5 Best regards Tom
  • 4. EVAL Question.
    Why do these statements produce different results: SLAEXP = 000000000045696 (15,0) SLURAT = 000000013338000 (15,0) Z-ADD 0 SALESAMT 29 9 EVAL SALESAMT = SLAEXP * SLURAT / 1000000000 Result: SALESAMT = 00000000000000000609.000000000 EVAL SALESAMT = SLAEXP * SLURAT EVAL SALESAMT = SALESAMT / 1000000000 Result: SALESAMT = 00000000000000000609.493248000 Thank You.
  • 5. Code 5.2.1 embedded sql problem
    When I open an sqlrpgle in code, all the c/exec sql... and c+ lines get flagged as being unknown compiler directives. If I manually delete the error lines, the program verifies & compiles without error. I'm new to code - am I doing something wrong?

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 43 guest