Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues

Reply
Thread Tools

Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues

 
 
dugmcgee@gmail.com
Guest
Posts: n/a
 
      07-18-2006
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

 
Reply With Quote
 
 
 
 
joeNOSPAM@BEA.com
Guest
Posts: n/a
 
      07-18-2006

http://www.velocityreviews.com/forums/(E-Mail Removed) wrote:
> 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


Hi. We have seen none. Oracle has no scope for returning anything
but a java.sql.Timestamp from a getTimestamp() call. If it returns
an oracle.sql.Timestamp, that *must be* a java.sql.Timestamp, and
shoudl continue to operate exactly like a java.sql.Timestamp, but may
also offer Oracle-specific extensions.
Joe Weinstein at BEA Systems

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Exception thrown while accessing Oracle through oracle client =?Utf-8?B?TmVv?= ASP .Net 2 07-12-2005 06:59 PM
Oracle adapter don't work with Oracle 10.1.0.2 v. Client vaidas gudas ASP .Net 1 10-11-2004 01:11 PM
Re: Error Connecting to Oracle after an Oracle shutdown David Rudder Java 0 07-30-2003 01:22 PM
Re: Error Connecting to Oracle after an Oracle shutdown Juha Laiho Java 0 07-30-2003 10:22 AM



Advertisments