• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Devaka Cooray
Saloon Keepers:
  • Ganesh Patekar
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
Bartenders:
  • Ron McLeod
  • Frits Walraven
  • Pete Letkeman

drivers JDBC on WAS4.0  RSS feed

 
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
 
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
Boost this thread!