库文件格式不对的问题，急救!

ziggler

http://www.ibm.com/developerwork ... spa?threadID=142802

ziggler

Hi all:
This is a solved problem but I want to post it because it has produced me a lot of headache. My problem is related with WebSphere Process Server 6.0.2.3 and Oracle 9i. I made an installation with all datasources configured with JDBC Oracle Thin Driver.
In some cases I obtained the following error:
"
[11/16/06 17:04:41:411 CET] 0000000a ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adaptor for resource jdbc/WPSDB. The exception which was received is com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket
"
There is an article in IBM Support Website that helped me to identify the problem:
http://www-1.ibm.com/support/docview.wss?uid=swg21225859
"
Cause
The Oracle 9i 9.2.0.7 JDBC thin client driver has a restriction of a maximum of 4 KB for data, which is insufficient for the dynamic artifact repository.
Solution
Use the Oracle 9i OCI driver or upgrade the Oracle installation to 10g.
"
So I changed to OCI driver in the datasources that caused errors, and I obteined the following error:
"
java.sql.SQLException: java.lang.UnsatisfiedLinkError: /users/oracle