MQSeries.net :: View topic

Rajat

Hi Friends,

Its a really urgent issue for me.

I am inserting a xml in the Mainframe DB2 table using a simple java code

data type of the column is CLOB(size 1 GB)

But when i am trying to insert data more than 32 kb(approx), i am getting

DB2 SQL Error: SQLCODE=-102, SQLSTATE= 54002

Code I am using (Both the mentioned methods I have tried)

Connection Conn = null;
try{
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
Conn = DriverManager.getConnection("jdbc:db2://172.27.234.55:2222/TEST","xxxxx","xxxx");
System.out.println("connection established"+Conn);
Statement st = Conn.createStatement();
String strVal = "XML Data, size > 35kb";
String msgID = "768569";
String sqlStatement = "INSERT INTO NUIYG1.ZOPLOG "
+ "(MB_UNIQUE_ID,MESSAGE)"
+ "VALUES "
+ "('" + msgID + "',"
+ "('" + strVal + "')";
st.executeUpdate(sqlStatement);

*****************************************************

PreparedStatement preparedStatement = Conn.prepareStatement("INSERT INTO NUPG1.TPGRLOG VALUES(?,?)");

preparedStatement.setString(1,"123456209");
preparedStatement.setString(2,stringVal);

I did some research, I got few points

1)
*******************************************
SQLCODE=-102, SQLSTATE= 54002

Explanation: String constant beginning with &1 too long.

-102 LITERAL STRING IS TOO LONG. STRING BEGINS string

Â¦ Explanation: The string constant beginning with string has a length
Â¦ greater than the maximum allowed length. Most strings have these limits:

Â¦ o For a hexadecimal constant (X, GX, or UX), the number of hexadecimal
Â¦ digits must not exceed 32704.
Â¦ o Any other character string constant must be short enough so that its
Â¦ UTF-8 representation requires no more than 32704 bytes.
Â¦ o Any other graphic string constant must be short enough so that its
Â¦ UTF-8 representation requires no more than 32704 bytes.

Â¦ In some contexts, however, the limit is smaller; see the DB2 SQL Reference
Â¦ for the specific cases.

Â¦ For special registers, the allowable length depends on the particular
Â¦ special register. A string that exceeds the limit can be specified only
Â¦ through assignment from a host variable. If this release of DB2 increases
Â¦ the maximum allowed length of a string constant, then an attempt to
Â¦ exploit the new length before using the New Function Mode produces this
Â¦ SQL return code.

Two consecutive string delimiters are used to represent one string
delimiter within the character string, but these count as 2 bytes when
calculating the lengths of character string constants.

System Action: The statement cannot be executed.

Programmer Response: The requested function is not available
interactively. If the error occurred in the context of an SQL statement
embedded in an application program, the desired result can be achieved by
assigning the long string to a host variable, and substituting that
variable for the string literal in the SQL statement.

SQLSTATE: 54002

***************************************
2) May be a limitation from the JDBC driver side.