RE: Patch 9.2.0.8/Java on Windows 2003 Problem

From: Ken Naim <kennaim_at_gmail.com>
Date: Fri, 22 Sep 2006 09:18:10 -0500
Message-ID: <014601c6de51$ef0d95c0$b4ae6a44@KenHome>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald
Sent: Friday, September 22, 2006 7:42 AM To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 22 2006 - 09:18:10 CDT