CODEWITHSUNDEEP
javatomcatojdbc
Jose Martinez
Jose Martinez

Reputation: 11992

exception while trying to upgrade oto ojdbc7.jar from ojdb6.jar

I swapped out my ojdb6.jar file in tomcat/lib with ojdb7.jar. Turned on Tomcat and I get the following error when trying to use it... 

Could not get JDBC Connection; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 
ORA-01882: timezone region not found

here is the connection pool configuration I am using.... 

<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" type="javax.sql.DataSource" 
    maxActive="25" maxIdle="25" maxWait="2000" 
    name="jdbc/getcontacts" 
    timeBetweenEvictionRunsMillis="1000" 
    minEvictableIdleTimeMillis="30000" 
    removeAbandoned="true" 
    removeAbandonedTimeout="30000" 
    logAbandoned="true" 
    username="xxxx" password="xxxxx" 
    validationQuery="Select 1 from dual" connectionProperties="defaultRowPrefetch=10000" 
    url="jdbcracle:thin:@//xxxxx.net/xxxxx" />

Any idea what could be causing this? We are using Oracle database 11g. 

/usr/jdk7/bin/java -version 
java version "1.7.0_17" 
Java(TM) SE Runtime Environment (build 1.7.0_17-b02) 
Java HotSpot(TM) 64-Bit Server VM (build 23.7-b01, mixed mode)

Any help would be greatly appreciated. When I put the ojdb6.jar file back and remove the ojdb7.jar file everything works fine.

Upvotes: 2

Views: 2754

Answers (1)

jgitter
jgitter

Reputation: 3414

Try adding VM arg

-Doracle.jdbc.timezoneAsRegion=false

Upvotes: 7

Related Questions