Patch 9.2.0.8/Java on Windows 2003 Problem

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Fri, 22 Sep 2006 08:41:35 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C060B9717@enhbgpri05.backup>

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 - 07:41:35 CDT