RE: Patch 9.2.0.8/Java on Windows 2003 Problem

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Fri, 22 Sep 2006 16:18:50 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C060B971B@enhbgpri05.backup>

I went from 9.2.0.7 with all current bug fixes, I think last was 12, to 9.2.0.8.

	-----Original Message-----
	From: Pande, Rajendra [mailto:rajendra.pande_at_ubs.com] 
	Sent: Friday, September 22, 2006 2:45 PM
	To: dofreeman_at_state.pa.us; oracle-l_at_freelists.org
	Subject: RE: Patch 9.2.0.8/Java on Windows 2003 Problem
	
	

	When you say patched - did you upgrade to 9208 or apply a patch.

What was the older version.

        If you upgraded then can you replace the C:\SDEIMPORT\lib\ojdbc14.jar with the latest file that is part of 10GR2. I have seen some jdbc issues after upgrade.

        Beyond that it would need debugging.         

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald

	Sent: Friday, September 22, 2006 8: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 



	Please do not transmit orders or instructions regarding a UBS

account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

        UBS Financial Services Inc.

        UBS International Inc.

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

Received on Fri Sep 22 2006 - 15:18:50 CDT