SQL0102N string too long

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SQL0102N string too long

Russell.A.Rogers

Greetings,

Has anybody seen this error with log4j before ?

I'm getting an error SQL0102N when trying to log to a DB2 table. The error occurs when I try to
insert a message which has a length is greater than 256 bytes. The attribute in the DB2 table is a
VARCHAR(1200). I'm using the PooledJDBCAppender and my insert statement is defined within the log4j.properties file.
Here's the error I'm getting:

[5/16/05 9:01:08:533 CDT] 56e296e0 SystemErr     R log4j:ERROR Failed to excute sql
[5/16/05 9:01:08:533 CDT] 56e296e0 SystemErr     R COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0102N  The string constant beginning with "org.frb.st" is too long.  SQLSTATE=54002

thanks,

Russ