TechnoBuzz

A Techno Blog, mainly about Java

WAS 5 connection manager

In Websphere version 5, its supports a new connection manager connector. It is implemented as JCA style connector.

http://localhost:9090/admin

Resources -> JDBC Providers : On this screen you can create a new JDBC provider or click on an existing provider (i.e DB2Universal JDBC Driver).

By clicking on the Provider name brings up a new screen (General Properties):

classpath: location of db2cc.jar

implementation classname: com.ibm.db2.jcc.DB2ConnectionPoolDataSource

On this same screen, there is a title of additional properties which should have data sources, click on that link which brings up a new screen.

This page has a title of Configuration. Here is where you configure the data source name and JNDI name.

name: test

jndi name:jdbc/test

Also, on this page is a button to test the connection.

Now, you are all set to go in java with your pooled connection.

ctx = new InitialContext();
ds = (DataSource)ctx.lookup("jdbc/test");

try {
Connection con = ds.getConnection("","");
}
catch (Exception ex){}
finally
{if (con!=null) con.close();}

Advertisements

November 16, 2004 - Posted by | SW Tools

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: