hi
im unable to insert blob data (actually a pdf ) into the database(oracle9i)
i’m using wmIS 6.1 and am getting this error
2006-06-08 12:24:59 BST [ADA.0001.0103V1] Begin local transaction.
2006-06-08 12:25:00 BST [ART.0114.1007E] Adapter Runtime: Error Logged. See Erro
r log for details. Error: [ADA.1.316] Cannot execute the SQL statement “INSERT I
NTO OP_TRADE_DOC(TRADE_DOC_ID, FILE_NAME, DOC_TYPE, PDF_BYTESTREAM, OP_UPDATE_U
SER_NAME) VALUES (?, ?, ?, ?, ?)”. "
(17002) Io exception: Connection reset"
Io exception: Connection reset
2006-06-08 12:25:00 BST [ART.0118.5518V1] Adapter Runtime (Connection): Handling
adapter connection exception.
2006-06-08 12:25:00 BST [ART.0118.5521V1] Adapter Runtime (Connection): Handling
fatal connection exception.
2006-06-08 12:25:00 BST [ART.0118.5517V1] Adapter Runtime (Connection): Creating
connection manager properties: >>>BasicData:poolable=true,minimumPoolSize=1,max
imumPoolSize=20,poolIncrementSize=1,blockingTimeout=1000,expireTimeout=1000,sele
ctionSize=1,poolOnCommit=true<<<.
2006-06-08 12:25:00 BST [SCC.0126.0001E] SCC ConnectionManager Pool Started
2006-06-08 12:25:01 BST [ART.0114.1007E] Adapter Runtime: Error Logged. See Erro
r log for details. Error: [ART.117.4002] Adapter Runtime (Adapter Service): Unab
le to invoke adapter service AAB_OP_DB.jdbc:addPDFTradeDoc_WA.
[ADA.1.316] Cannot execute the SQL statement “INSERT INTO OP_TRADE_DOC(TRADE_DO
C_ID, FILE_NAME, DOC_TYPE, PDF_BYTESTREAM, OP_UPDATE_USER_NAME) VALUES (?, ?, ?,
?, ?)”. "
(17002) Io exception: Connection reset"
Io exception: Connection reset
2006-06-08 12:25:01 BST [ADA.0001.0104V1] Commit local transaction.
2006-06-08 12:25:01 BST [ADA.0001.0106V1] Failed to commit local transaction. “j
ava.sql.SQLException: Io exception: Connection reset by peer: socket write error
"
2006-06-08 12:25:01 BST [ART.0114.1007E] Adapter Runtime: Error Logged. See Erro
r log for details. Error: [ADA.1.208] Cannot disconnect from the database. "
(17002) Io exception: Connection reset by peer: socket write error”
Io exception: Connection reset by peer: socket write error
2006-06-08 12:25:01 BST [SCC.0126.9998C] WmConnectionPool Exception → com.wm.a
dk.error.AdapterConnectionException: [ADA.1.208] Cannot disconnect from the data
base. "
(17002) Io exception: Connection reset by peer: socket write error"
Io exception: Connection reset by peer: socket write error

Hello,

Insert classes12.jar and ojdbc14.jar into you IS/lib/Jars and restart the IS. It should work now.

Hi,

you will only need either classes12.jar (if IS is running on Java 1.2 or Java 1.3) or ojdbc14.jar (if IS is running on Java 1.4 and newer).

Remember to use a 10g Driver version if you are planning to use Thin mode.
They are compatible with 9i Database (at least 9i R2).

Normally the JAR-File should be placed under <IS_ROOT>/packages/WmJDBCAdapter/code/jars, as it is (normally) only used by this Adapter.
If it is also used by the WmDB package it must be placed under <IS_ROOT>/lib/jars (additionally).

Regards,
Holger