java.sql.SQLException: ORA-24813: cannot send or receive an unsupported LOB

Hello everyone:

Our JSP application with a whole bunch of classes talks to an Oracle database using JDBC. The Oracle DB was 9i, but we upgraded to 10g. When this happened, we get the following error during processing a call that brings out a clob out of the DB.

I googled the error message to find out that it is caused by the difference in versions of the Oracle.

Thus, here is an interesting point. When the app had 10g on his side and the database being 9i, everything worked fine. But, now that they are both of 10g, it does not work.

Does anyone have any idea what's causing this error?

Thank you in advance for your help.

Sincerely,

Yosep

[778 byte] By [backend.tigera] at [2007-10-3 4:23:13]

«« JPanel & JMenu
»» sending Chararray of hexadecimal

# 1

Just to add in some more background to this problem...

The app machine has Oracle 10g under c://oracle/product/10.2. Since this is only copy of Oracle, this lead me to believe that 10g is what the app is using to connect to the DB through its JDBC classes.

Another interesting point is that the app is JSP/java solution via Tomcat. So, perhaps Tomcat provides its own JDBC kind of libraries?

Any help or comments would be greatly appreciated.

Yosep

backend.tigera at 2007-7-14 22:25:32 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

java.sql.SQLException: ORA-24813: cannot send or receive an unsupported LOB

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified