RE: Patch 9.2.0.8/Java on Windows 2003 Problem

While I have not experienced this issue personally I believe this happened
to a coworker of mine, but unfortunately he is out today and java isn't my
strong suit. Hopefully I can give you some info that may point you or maybe
someone else from the list in the right direction. In 9.2.0.6 I believe
oracle updated how it complies with some java standard, so jdbc now uses
java timestamps instead of java dates, which broke our application ability
to connect to the database.
 
  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Freeman, Donald
Sent: Friday, September 22, 2006 7:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Patch 9.2.0.8/Java on Windows 2003 Problem
 
I patched my production system last night and now am having a problem with,
I guess, jdbc.  We have a little java program which runs and loads GIS point
data.   It no longer seems to be able to connect.  This is a black box kind
of thing and we don't have any java knowledgeable people on staff.  Can
anybody interpret this?  We do have a maintenance contract with this company
but I don't know when the guy will show up. Anyone have any suggestions?
C:\SDEIMPORT>java -cp
C:\SDEIMPORT\lib\jpe91_sdk.jar;C:\SDEIMPORT\lib\jsde91_sdk 
.jar;C:\SDEIMPORT\lib\ojdbc14.jar;C:\SDEIMPORT\bin com.doh.importengine.Run 
IMPORT INITIATED 
Exception in thread "main" java.lang.UnsatisfiedLinkError:
create_stmt_c_copy 
        at oracle.jdbc.oci8.OCIDBAccess.create_stmt_c_copy(Native Method) 
        at
oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1893) 
        at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja 
va:2047) 
        at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav 
a:1940) 
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme 
nt.java:2709) 
        at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:854) 
        at
oracle.jdbc.dbaccess.DBAccess.setNlsParamsClient(DBAccess.java:1659) 
        at oracle.jdbc.oci8.OCIDBAccess.initNls(OCIDBAccess.java:641) 
        at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:392) 
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja 
va:468) 
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) 
        at java.sql.DriverManager.getConnection(Unknown Source) 
        at java.sql.DriverManager.getConnection(Unknown Source) 
        at com.doh.importengine.DBConnect.<init>(DBConnect.java:48) 
        at com.doh.importengine.Run.init(Run.java:21) 
        at com.doh.importengine.Run.main(Run.java:12) 
C:\SDEIMPORT> 
Don Freeman 
Database Administrator 1 
Bureau of Information Technology 
Pennsylvania Department of Health 
(717) 703-5782

Other related posts: