Results 1 to 4 of 4
  1. #1
    pira is offline Member
    Join Date
    Nov 2013
    Posts
    3
    Rep Power
    0

    Default How to avoid oracle.jdbc.driver.OracleConnection

    i'am new in Java but recently i've got a project on support.
    Problem:
    solution worked on jvm 1.4, now on 1.7.
    Respectively, class oracle.jdbc.driver.OracleConnection has been used.
    Now I need class oracle.jdbc.OracleConnection to use CLOB.createTemporary() but...I can't.
    According to this article, it's enough to replace in code and config files one class declaration on another. But NO. I replaced all of them in all config files and anyway, there was only oracle.jdbc.driver.OracleConnection has been created. (there is no explicit declaration of connection type in code, everything is configured in config files)
    Project uses marven, mybatis. I reloaded comp. Nothing changed
    May be there is some java cache? I do not know...
    Anybody knows?
    Last edited by pira; 11-06-2013 at 12:39 PM.

  2. #2
    gimbal2 is offline Just a guy
    Join Date
    Jun 2013
    Location
    Netherlands
    Posts
    3,876
    Rep Power
    5

    Default Re: How to avoid oracle.jdbc.driver.OracleConnection

    Yes well that "article" (API documentation...) that you refer to assumes that you know what you are doing. Likely you also need to update the OJDBC driver jar to one compatible with Java 7.
    "Syntactic sugar causes cancer of the semicolon." -- Alan Perlis

  3. #3
    pira is offline Member
    Join Date
    Nov 2013
    Posts
    3
    Rep Power
    0

    Default Re: How to avoid oracle.jdbc.driver.OracleConnection

    another trouble is that client uses oracle 9
    ojdbc14-9.2.0.5.jar contains both classes: both oracle.jdbc.driver.OracleConnection (for backward compatibility) and oracle.jdbc.OracleConnection
    the matter is what should i do to use second one instead of first one.
    (JDBC Driver Downloads page does not contain driver for oracle 9 already)

  4. #4
    pira is offline Member
    Join Date
    Nov 2013
    Posts
    3
    Rep Power
    0

    Default Re: How to avoid oracle.jdbc.driver.OracleConnection

    I solved the issue!

    This thread helped me: https://forums.oracle.com/thread/556426 ("I have to use classes12.zip for it to work.")

    The main problem was jdbc driver - I tried all ones that I found on oracle download page and the only driver that maked the job was classes12.jar (Oracle Database 10g Release 2 (10.2.0.1.0)). I replaced it in "ORACLE_HOME\jdbc\lib\" and in "apache-tomcat\lib\"
    Every driver has its own bugs and i did also different things so i can't say that just driver replacemet is enough. F.e. I changed database timezone, run tzupdater, set vm param -Duser.timezone="-07:00", may be something else.

    Thanks a lot everybody!

Similar Threads

  1. Replies: 1
    Last Post: 04-08-2013, 10:22 AM
  2. Replies: 10
    Last Post: 03-20-2012, 08:23 AM
  3. Replies: 6
    Last Post: 02-19-2010, 01:57 PM
  4. Replies: 6
    Last Post: 12-14-2008, 09:14 AM
  5. Jdbc Driver For Oracle
    By Swamipsn in forum New To Java
    Replies: 0
    Last Post: 08-14-2007, 04:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •