ORA-01874: time zone hour must be between -12 and 14

[Deb Sadhukhan]

I have an application which retrieves current time from the system (JVM) and accordingly does some oracle database updates. For testing purpose, I'm using following code to set JVM clock to past date, so that I can test the application without spending much time for setting up the test data every day. But I get the following error when when I try to connect to oracle. Any idea what's going on?

Code for setting JVM time

    
public static void changeTime(final int hoursBehindParm) {

int hoursBehind = 6 + hoursBehindParm;

TimeZone.setDefault(new SimpleTimeZone((-hoursBehind * 60 * 60 * 1000)
, "GMT" + Integer.toString(-hoursBehind)
, Calendar.MARCH
, 2
, Calendar.SUNDAY
, 7200000
, Calendar.NOVEMBER
, 1
, Calendar.SUNDAY
, 7200000)
);


System.out.println("*** Current Time *** " + new Date());
}

Error I get when I try to connect to oracle after setting the time.

    
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01874: time zone hour must be between -12 and 14
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:784)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:361)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at walgreens.databean.JDBCDriverConnMgr.getDBConnection(JDBCDriverConnMgr.java:64)
at walgreens.services.DBConnectionProvider.getConnection(DBConnectionProvider.java:136)
at wag.sls.batch.bcs.TestOraBcsChangeStatus.test(TestOraBcsChangeStatus.java:56)
at wag.sls.batch.bcs.TestOraBcsChangeStatus.main(TestOraBcsChangeStatus.java:33)

Thanks

[Jeanne Boyarsky]

Deb,
Can you post the actual JDBC code and query that throws that error?

[Stevi Deter]

Deb,

Here's a couple links from the Oracle forums that might help:

http://forums.oracle.com/forums/thread.jspa?threadID=395601
http://forums.oracle.com/forums/message.jspa?messageID=1249073#1249073

I included the second because someone in the first thread said that solved the issue, even though it was a different ORA message number.