Search This Blog

Wednesday, December 16, 2009

How to configure JDBC and datasource in WAS

Configuration:
à AdminConsoleà Resourcesà JDBCprovidersÃ
à Select the scope (cell level or node level)
à click new
à select the Database type (Sybase,oracle,etc)
à select the provider type (oracle jbdc driver)
à select the implementation type (connection pool)
à click on the driver
à select the DataSource
à Click on new
à give a name to the datasource
à oracleDatasourceProperties(URL:jdbc:oracle:thin:@192.168.1.14:1521:XE)
à click on J2EE Connector Architecture (J2C) authentication data entries
à Give username and password and
à give the component-managed authentication aliases
à and set the environment variable
à go to Environmentà websphere variablesà click on the level-à click on
newà Oracle_jdbc_driver_path and give the address of the 14.jar
-Ã Test the connection

No comments:

Post a Comment