Hi Glenn,

I'll answer here, but if you want to do me a favor, please also ask the
question at developerWorks' Java Filter forum. That way it gets distributed
to the largest possible audience, and helps me to look better since I'm the
moderator ;-) You do have to register to post to, but not to read, the
forums. You can give the bare minimum info, and IBM doesn't bother you.
The link is:


To your question:

The driver should be installed in:


As to the rest, they don't make it easy for non-out of the box supported
drivers. For that reason, you might want to try the included DB2 driver.
But, I got this to ping our dev AS/400. I don't have time to go all the way
through, but if it pings, the rest should work.

First, you need to use:


with javax.sql.DataSource as the Resource Type.

Then you have to set all the properties yourself. I don't know why they
don't query the driver, but that's the way it is. Here's what I put under "Additional Properties":

Name Value

servername I used the IP address

user The user ID

password The password

I also added "libraries" and "naming" but the above should get you started. Once you've saved, clock "Ping" under the "General" tab. You can customize more once you're past that point. HTH,

Joe Sam

Joe Sam Shirah - http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Que Java400? http://www.jguru.com/faq/Java400

----- Original Message ----- From: "Glenn Holmer" <gholmer@xxxxxxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
Sent: Monday, October 29, 2007 1:32 PM
Subject: Re: Glassfish

On Monday 29 October 2007 11:26, Joe Sam Shirah wrote:
The SJSAS admin console has "Create a new JDBC connection pool"
under Other Tasks on the main page, or you can click
Resources->JDBC->Connection Pools from the left panel. Pretty
straightforward setup. While they talk about "supported drivers",
you're able to enter the driver class name.

OK, I got that far. I put com.ibm.as400.access.AS400JDBCDriver for the
datasource class name and selected javax.sql.DataSource for the
resource type. Then under "Additional Properties", I entered a URL

But the error I'm getting is:

javax.resource.ResourceException: com.ibm.as400.access.AS400JDBCDriver

which looks like he can't find jt400.jar. I put it in both lib/ and
domains/<domain-name>/lib/ext, not sure which is right.

Glenn Holmer gholmer@xxxxxxxxxxxxxx
Software Engineer phone: 414-908-1809
Weyco Group, Inc. fax: 414-908-1601

This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.