Urgent, everybody help out. Use jdbc connection to write blob to oracle successfully, but it won’t work if it is repla

eses123

Use jdbc to connect to write blob to oracle successfully, but it won’t work if you change to jndi

Prompt to roll back, multiple settings setAutoCommit (true/false) will not work, check a lot of information can not be resolved, please help

hyysios

If it is a WebLogic server, pay attention to the writing of Blob to determine which implementation class is for special processing.

forde001

Heavyweight servers treat Blobs, and Clobs have their own characteristics
Therefore, at this time, there will be differences between the JDBC and JNDI database operations, and it does not matter if the database is exported
The next section of Coding hopes to help you

    //Get database connection through JNDI
    Context context = new InitialContext();
    ds = (DataSource) context.lookup("ORA_JNDI");
    Connection con = ds.getConnection();
    con.setAutoCommit(false);
    Statement st = con.createStatement();
    //Insert an empty object empty_clob()
    st.executeUpdate("insert into TESTCLOB (ID, NAME, CLOBATTR) values ​​(1, "thename", empty_clob())");
    //Lock the data row for update, pay attention to the "for update" statement
    ResultSet rs = st.executeQuery("select CLOBATTR from TESTCLOB where ID=1 for update");
    if (rs.next())
    {
        //Forcibly convert to weblogic.jdbc.vendor.oracle.OracleThinClob after obtaining the java.sql.Clob object (different App Server may correspond to different)
        weblogic.jdbc.vendor.oracle.OracleThinClob clob = (weblogic.jdbc.vendor.oracle.OracleThinClob) rs.getClob("CLOBATTR");
        Writer outStream = clob.getCharacterOutputStream();
        //data is the incoming string, definition: String data
        char[] c = data.toCharArray();
        outStream.write(c, 0, c.length);
    }
    outStream.flush();
    outStream.close();
    con.commit();
    con.close();

eses123

Nothing else is wrong, I basically did this, the key is
//Forcibly convert to weblogic.jdbc.vendor.oracle.OracleThinClob after obtaining the java.sql.Clob object (different App Server may correspond to different)
        weblogic.jdbc.vendor.oracle.OracleThinClob clob = (weblogic.jdbc.vendor.oracle.OracleThinClob) rs.getClob("CLOBATTR");

In this sentence, weblogic.jdbc.vendor.oracle.OracleThinClob I can't find a similar class in WebSphere and cannot be replaced. I am stuck here because I must use WebSphere

hyysios

Is there a problem with WebSphere POOL? If there is a problem, add WebLogic's weblogic.jar to the CLASSPATH

angelppp

That weblogic has 48M, which is too big, is there any convenient way?