aspose file tools*
The moose likes Websphere and the fly likes drivers JDBC on WAS4.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "drivers JDBC on WAS4.0" Watch "drivers JDBC on WAS4.0" New topic
Author

drivers JDBC on WAS4.0

Francette Dunyach
Greenhorn

Joined: Jan 07, 2002
Posts: 8
Someone can tell me which JDBC drivers and versions are installed by default on WAS4.0?
If I need a JDBC driver not installed, does I have to include it in my ear, as an utility jar?
Thanks in advance
Patrick Finnegan
Ranch Hand

Joined: Mar 05, 2002
Posts: 179
No idea if you can specify third party DB drivers if WebSphere is not configured to use them.
Default Drivers are:
The name of the Java data source class provided by the database vendor.
DB2:
* COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource (one phase commit protocol)
* COM.ibm.db2.jdbc.DB2XADataSource (two phase commit protocol)
DB2 on iSeries - toolbox driver
* com.ibm.as400.access.AS400JDBCConnectionPoolDataSource (one phase commit protocol)
* com.ibm.as400.access.AS400JDBCXADataSource (two phase commit protocol)
DB2 on iSeries - native driver
* com.ibm.db2.jdbc.app.DB2StdConnectionPoolDataSource (one phase commit protocol)
* com.ibm.db2.jdbc.app.DB2StdXADataSource (two phase commit protocol)
Oracle:
* oracle.jdbc.pool.OracleConnectionPoolDataSource (one phase commit protocol)
* oracle.jdbc.xa.client.OracleXADataSource (two phase commit protocol)
Sybase:
* com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource (one phase commit protocol)
* com.sybase.jdbc2.jdbc.SybXADataSource (two phase commit protocol)
Merant:
* com.merant.sequelink.jdbcx.datasource.SequeLinkDataSource (one and two phase commit protocol)
Informix
* com.informix.jdbcx.IfxConnection PoolDataSource (one phase commit protocol)
* com.informix.jdbcx.IfxXADataSource (two phase commit protocol)
InstantDB (NOT supported as an administrative database)
* com.ibm.ejs.cm.portability.IDBConnectionPoolDataSource (one phase commit protocol)
Name Property name in the Java-based administrative console Property name in the Web-based administrative console Property name in the application client resource configuration tool
Francette Dunyach
Greenhorn

Joined: Jan 07, 2002
Posts: 8
Thanks a lot for your response.
The following url http://www-3.ibm.com/software/webservers/appserv/doc/v40/prereqs/ae_v403.htm#Footnotes gives you Third Party JDBC Drivers Managers supported by WAS4.0
In your response, do you mean that the Driver Manager class has a name of a datasource class?
Besides, for you, "Default drivers" are drivers already installed?
Thanks
Francette
Patrick Finnegan
Ranch Hand

Joined: Mar 05, 2002
Posts: 179
JDBC drivers are installed through resources/jdbc drivers dialog in the WebSphere Console. Applications use the specified jndi name to access a database which is configured to use the appropriate driver.
Third party drivers cannot be installed unless they are supported.
 
Consider Paul's rocket mass heater.
 
subject: drivers JDBC on WAS4.0