Re: Glassfish

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:

http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=177&cat=10

To your question:

The driver should be installed in:

GlassfishInstallDir/lib

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:

com.ibm.as400.access.AS400JDBCDataSource

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"
<java400-l@xxxxxxxxxxxx>
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
(jdbc:as400://<machine-name>).

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.