[jira] [Created] (DERBY-6728) Reading from a Clob fails.

[Johannes Lichtenberger (JIRA)]

Johannes Lichtenberger created DERBY-6728:
---------------------------------------------

             Summary: Reading from a Clob fails.
                 Key: DERBY-6728
                 URL: https://issues.apache.org/jira/browse/DERBY-6728
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.11.1.1
            Reporter: Johannes Lichtenberger


In the Java-Code below the reading from a CLOB-column fails. In no other tested 
relational database it seems to fail (PostgreSQL / DB2 / MSSQL). It somehow 
seems to be related to reading the maximum integer primary key value beforehand.

import java.sql.Clob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

import de.uplanet.util.Safely;

public class DerbyClobTest
{
        public static void main(String[] args)
        {
                try
                {
                        Connection conn = DriverManager
                                        
.getConnection("jdbc:derby://localhost:1527/ixixtsumImport;user=derby;password=derby");
                        Statement stmt = conn.createStatement();
                        ResultSet rs = stmt.executeQuery("SELECT * FROM 
XCAL3FD1DDEA");

                        while (rs.next())
                        {
                                PreparedStatement l_stmt = null;
                                int l_iMaxLid = -1;

                                try
                                {
                                        l_stmt = conn.prepareStatement("SELECT 
MAX(LID) FROM XCAL3FD1DDEA");

                                        ResultSet l_rs = l_stmt.executeQuery();

                                        try
                                        {
                                                if (l_rs.next())
                                                        l_iMaxLid = 
l_rs.getInt(1);
                                        }
                                        finally
                                        {
                                                l_rs.close();
                                                l_rs = null;
                                        }
                                }
                                finally
                                {
                                        l_stmt.close();
                                        l_stmt = null;
                                }

                                PreparedStatement stmtNew = conn
                                                .prepareStatement("INSERT INTO 
XCAL3FD1DDEA (LID, TXTBODY) VALUES(?, ?)");

                                stmtNew.setInt(1, l_iMaxLid);

                                final Clob clob = rs.getClob("TXTBODY");

                                if (clob == null)
                                        return;

                                final String str = clob.getSubString(1, (int) 
clob.length());

                                // Do something with str.

                                stmtNew.setClob(2, clob);

                                stmtNew.executeUpdate();
                                stmtNew.close();
                        }
                }
                catch (Exception except)
                {
                        except.printStackTrace();
                }
        }
}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)