TechnoBuzz

A Techno Blog, mainly about Java

Open Source for Win2k

AbiWord is an award winning small, fast, featureful and crossplatform word processor.

Vim is an advanced text editor that seeks to provide the power of the de-facto Unix editor ‘Vi’, with a more complete feature set.

Fabforce’s DBDesigner is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.

OpenOffice

Advertisements

November 16, 2004 Posted by | Open Source | Leave a comment

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();}

November 16, 2004 Posted by | SW Tools | Leave a comment