RE: JNDI on tomcat and Web Logic application server for AS400usingJT400 -- JAVA400-L

Excellent! I believe the piece is in the web.xml because I picked it up
in the tags and just us db_datasource name to get to it. I believe
that's the JNDI piece, but I don't much remember now.

Glad it worked for you.

Coy Krill
Systems Analyst
Whidbey Island Bank

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Friday, September 28, 2007 09:48
To: Java Programming on and around the iSeries / AS400
Subject: RE: JNDI on tomcat and Web Logic application server for
AS400usingJT400

Hi
Thanks, it works

and i did not had to put anything in web.xml it just
picked every thing it want from context.xml
Ashish
--- Coy Krill <coyk@xxxxxxxxxx> wrote:

Forgot to paste the web.xml file!

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee";

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";

xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";>
<display-name>WIB Dashboard</display-name>
<context-param>
<param-name>db_dataSource</param-name>
<param-value>jdbc/db400</param-value>
</context-param>
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>
index.jsp
</welcome-file>
</welcome-file-list>
<resource-ref>
<res-ref-name>jdbc/db400</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>

<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>

Coy Krill
Systems Analyst
Whidbey Island Bank

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Coy Krill
Sent: Thursday, September 27, 2007 10:27
To: Java Programming on and around the iSeries /
AS400
Subject: RE: JNDI on tomcat and Web Logic
application server for AS400
usingJT400

Ashish,

The files I'm putting in here are from a
proof-of-concept that
management never went with so it may not be the best
way to do it, but
it worked here.

The following xml is the context.xml file for the
web app. You'll notice
that there are two different resources. The one
currently uncommented is
for off the as400 and the other is for when it's
deployed on the as400.
In either case, the username and password should be
real ones, I just
replaced them with asterisks for posting. You'll
need to change the url
to match your environment as well.

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/dashboard">
<Resource name="jdbc/db400"
auth="Container"

factory="org.apache.commons.dbcp.BasicDataSourceFactory"

type="javax.sql.DataSource"
maxActive="100"
maxIdle="20"
maxWait="300"
removeAbandoned="true"
removeAbandonedTimeout="120"
logAbandoned="false"
username="******"
password="******"

driverClassName="com.ibm.as400.access.AS400JDBCDriver"

url="jdbc:as400://as400.wibank.com/"
/>

</Context>

This next one is the web.xml and it reference the
dat

I remember using the tomcat reference to get this
accomplished. We never
took it anywhere and we've done nothing web wise on
the as400 since.
We're an MS shop for everything but our core banking
software so it's
hard to get management buyoff on anything but MS
Sharepoint and SQL
Sever 200x.

Hopefully this will get you started.

Coy Krill
Systems Analyst
Whidbey Island Bank

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Ashish Kulkarni
Sent: Thursday, September 27, 2007 07:23
To: java400-l@xxxxxxxxxxxx
Subject: JNDI on tomcat and Web Logic application
server for AS400 using
JT400

Hi
Has anyone setup JNDI for AS400 DB2 on tomcat and
Web
Logic application using JT400.jar?

Can you give some points how you did setit up and
used
it in your web application

Ashish

A$HI$H