Solved

Database driver to use

Posted on 2009-07-07
1
450 Views
Last Modified: 2013-12-19
Hi,

We upgraded our database from 9i to 10g and webpshere from 5-1 to 6-1. We are still using the old database driver in the upgraded (6-1, 10g) environment. This driver is the one we used for the ws5-1 9i setup. Should we change this? Is there a 10g driver that we should be using? I was talking to our dba and he said we were using 9i driver with 10g helper classes.
"ojdbc14.jar" is the name of the driver we are using.

We are currently having some max thread issues and every occurance of the max threads is started by a stalled thread created by a database query. Just wondering if the driver could be the issue.
0
Comment
Question by:aibdev
1 Comment
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24793559
There is an updated ojdbc14.jar with the 10g database, you should definitely use one of the latest. We found various bugs with the 9i version as well as early versions of even the 10g. Get the one with the latest 10.2 download.
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question