1. Error during CLOB update coderanch.comHello all, I am coding a java program, using JDBC connection, to update CLOB field. I am getting an error when I try to close 'Write' stream and no data is updated in the CLOB field. The code section I have to update the field does not throw an error. So I am assuming that it is writing the data ok ... |
2. Help with updating CLOB coderanch.comHi everyone. Maybe someone can help me. The issue here is that I am getting class cast exception when trying to update a clob. This code was working perfectly with OC4J but we have just switched to OC4J Release 2 and it's suddenly failing. The exception is:java.lang.ClassCastException: com.evermind.sql.OrclResultSet and it happens when I select the CLOB for update and try to ... |
3. help: lock problem during Clob update coderanch.com |
4. Question on update CLOB column when the column value is null coderanch.comHi all, I have a Oracle database table column that is a CLOB column. I have a program that updates individual records of this table. For the CLOB column, I use the following steps to update the column value: 1. Use "Select...for update" statement to select the row. 2. Use getClob() method on the ResultSet to get the locator and cast ... |
5. JDBC Update example using empty_clob() function coderanch.comThis should get you going. I am leaving all the error handling and null checks etc. for you. *************************************************************************** Connection conn; Clob tempClob; String ClobData="";//This is what your clob data is going to be. tempClob = CLOB.createTemporary((Connection) getConnection.invoke(Conn, new Object[0]),false, CLOB.DURATION_SESSION); // Create a new temporary CLOB. tempClob = CLOB.createTemporary(Conn,false, CLOB.DURATION_SESSION); // Open the temporary CLOB in readwrite mode to enable ... |
6. Update XML to CLOB coderanch.comHi, I have an xml file in Oracle database's CLOB column. I am trying to fetch it, parse it using JDOM, and update one of the elements with Chinese characters which come from my web page. The database charset is AL32UTF8. Following is the steps io follow. 1. Select data using getAsciiStream() of result set. 2. SAXBulder to build it. 3. ... |
7. Problem updating BLOB coderanch.comHello, I have problem updating my empty_blob() in the database.Here's my code: 1)I insert the empty_blob first: insert into TPI_DBA.SCHEDULED_REPORTS (SHR_REPORT, SHR_REPORT_TYPE, SHR_FREQUENCY, SHR_START_DATE, PDT_PARTNER_CD_SHR) values(empty_blob(), 'MT202', 'OFTEN', ?, ?) 2)I then retrieve the blob from the DB: Select * from scheduled_reports where SHR_REPORT_TYPE='MT202' for update BlobVO vo = new BlobVO(); vo.setBlob((BLOB)((OracleResultSet)rs).getBLOB(2)); 3)I then update my empty_blob: BLOB blob = (BLOB) ... |
8. Updating a blob field dbforums.com |
9. core dump when updating blob on unix forums.oracle.comI have a string and use code like this to update it in database using jdbc: String sql = "update abc set notes=? where id="+id; jdbcu.setStatement(sql); jdbcu.setBytes(1, newNotes); 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 ... |