Re: Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues

#1

dugmcgee (AT) gmail (DOT) com wrote:

Quote:

Hi all,

We are upgrading our oracle database from 10.1.0.5 to 10.2.0.2. has
anyone had previous experience with this that they can point out
potential pitfalls? I am talking more on the java side than actually
the installation.

We have a java system talking to the oracle database. One system is
using hibernate, the other is using a DAO pattern with direct JDBC
calls. Does anyone know if this change will effect the application and
what changes we must do to accomadate? For example I know that oracle
10.2.0.2 has a different timestamp (oracle.timestamp) than that of it
predecesor (sql.timestamp)

We have a lot of stored procedures and soem direct JDBC calls to the
database. Is anyonw aware of pitfalls or what type of testplans we must
put together to test for issues?

Much appreciated for the assistance.
Dougless

I have not had any problems upgrading 10.1 to 10.2. My upgrades went
smoothly. But no matter how *my* upgrades went, *your* upgrades may not
be the same since we use different data and different applications. I
strongly suggest setting up a test system running Oracle 10.1. Then
upgrade that database to 10.2 and exercise your application against the
upgraded database. There is no substitute for good testing. Good testing
will point out the majority if your problem areas.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues - 07-18-2006 , 07:56 AM