I have a string and use code like this to update it in database using jdbc:
String sql = "update abc set notes=? where id="+id;
int upd = jdbcu.runUpdateSQL();
it works fine when I run it from desktop but when i run the same code from unix, the jvm core dumps:
please help me why its happening?
and whats the best way to update the blob in a table using jdbc so I dont have problem on either env.
Are you using a pure Java JDBC driver or one which uses a shared library?
It is likely to be a bug in your JDBC driver.
When you get a dump, where in the stack trace does the error occur (you should be able to read it)
It is using weblogic jdbc and it works fine for any other update. which does not involve blob.
only blob data update is causing the problem and happens at the time when i run the update sql command. here is the core dump log:
# An unexpected error has been detected by HotSpot Virtual Machine:
# SIGSEGV (0xb) at pc=0xfed630c4, pid=28747, tid=1
# Java VM: Java HotSpot(TM) Client VM (1.4.2_13-b06 mixed mode)
# Problematic frame:
# V [libjvm.so+0x1630c4]
--------------- T H R E A D ---------------
Current thread (0x00037050): JavaThread "main" [_thread_in_vm, id=1]
The thin client is pure Java, whereas the OCI driver uses a native library (.so file in your case) in order to communicate to Oracle's OCI interface. We ceased to use the OCI version like 10 years ago, cause it was giving us constant trouble and practically no performance gain.