Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

drivers JDBC on WAS4.0

 
Francette Dunyach
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 179
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 179
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic