This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Journey To Enterprise Agility and have Daryl Kulak & Hong Li on-line!
See this thread for details.
Win a copy of The Journey To Enterprise Agility this week in the Agile and Other Processes forum! And see the welcome thread for 20% off.
  • 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:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
Bartenders:
  • Carey Brown
  • Tim Holloway
  • Joe Ess

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!