Skip to Content
author's profile photo Former Member
Former Member

CLOB BLOB support in J2EE Engine

i posted this in the Technology forum couple of days ago, but not sure that was the right place. so here it is again. apologize for repeated postings, perhaps we ought to have a J2EE Engine forum?



i am in the process of porting our company's j2ee application to the SAP J2EE Engine 6.20. our app was built to run on Weblogic as the app server and Oracle as the db server. One of the things i am trying to figure out is how the CLOB and BLOB table columns are supported in SAP J2EE Engine. in java, these corresponds to java.sql.Clob and java.sql.Blob interfaces.

i did find some information in CLOB and BLOB support in "SAP Library - J2EE Technology in SAP Web Application Server". there is a section titled "Working with LOBs". but the information is too rudimentary. specifically, i need to be able to update contents in a CLOB and BLOB column after it is inserted.

jdbc driver vendors such as Oracle and Weblogic all seem to provide additional support exactly for updating CLOB and BLOB data. for example, Weblogic has the following classes:



once we cast the ResultSet.getClob() or getBlob() to the above types, we can use the getCharacterOutputStream() or getBinaryOutputStream() methods to easily manipulate the clob/blob contents.

similarly Oracle has oracle.sql.CLOB and oracle.sql.BLOB classes, which also implement the getCharacterOutputStream() or getBinaryOutputStream() methods.

Question: does SAP J2EE Engine provide its own implementation of the java.sql.Clob and java.sql.Blob interfaces, with support for updating LOB contents similar to Oracle and Weblogic? if not, how would you suggest to deal with updating LOB table colulmns?

thanks in advance.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 12, 2004 at 08:39 PM

    Hi Wentao,

    there is no special implementation in the engine for this. Though, there nothing but the standard JDBC implementations of your driver.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.