Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues

Discussion in 'Java' started by dugmcgee@gmail.com, Jul 18, 2006.

  1. Guest

    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
     
    , Jul 18, 2006
    #1
    1. Advertising

  2. Guest

    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
     
    , Jul 18, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. vaidas gudas
    Replies:
    1
    Views:
    471
    =?Utf-8?B?Q293Ym95IChHcmVnb3J5IEEuIEJlYW1lcikgLSBN
    Oct 11, 2004
  2. =?Utf-8?B?TmVv?=
    Replies:
    2
    Views:
    729
    =?Utf-8?B?TWljaGFlbCBCYWx0aWM=?=
    Jul 12, 2005
  3. =?Utf-8?B?RnJhbmsxMjEz?=

    Upgrading to ASP.NET 2.0 causes issues with LinkButton

    =?Utf-8?B?RnJhbmsxMjEz?=, Mar 30, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    610
    =?Utf-8?B?RnJhbmsxMjEz?=
    Mar 30, 2006
  4. Juha Laiho
    Replies:
    0
    Views:
    569
    Juha Laiho
    Jul 30, 2003
  5. Feyruz
    Replies:
    4
    Views:
    2,353
    Sherm Pendley
    Oct 14, 2005
Loading...

Share This Page