Re: JT400 SQLException -- "SQL0101N The statement is too long ortoocomplex"

["Mark Phippard" <MarkP@xxxxxxxxxxxxxxx>]

David,

I had to write it out but it looks like each of those CLOB field is 1 GB
correct?  If so, then the problem is that you are exceeding the maximum
size for a row, which is around 3-4 GB.

I am a little surprised the error message is not more clear, as they make
it sound like the problem is in the length (in chars) of the statement
itself.

Mark

      To:   java400-l@midrange.com
      cc:
      bcc:
      Subject:    JT400 SQLException -- "SQL0101N The statement is too long
or too complex"
"David Gibbs" <david@midrange.com>
Sent by: java400-l-bounces+markp=softlanding.com@midrange.com
01/16/2003 05:27 PM CST
Please respond to Java Programming on and around the iSeries / AS400
<font size=-1></font>





















Folks:

One of the developers I work with is trying to implement DB2/400 functions
in a java application.

We're encountering a problem when we try to execute the following
statement:

CREATE TABLE SiLocks (ID INTEGER NOT null, ArchiveID VARCHAR(255) NOT null,
RevisionID VARCHAR(80) NOT null, UserID VARCHAR(254) NOT null, LockTime
TIMESTAMP NOT null, Annotation CLOB(1073741824), ChangePackageID
VARCHAR(20), ProjectID CLOB(1073741824) NOT null, VariantProjectID
VARCHAR(254), Sandbox CLOB(1073741824), Hostname CLOB(1073741824), MemberID
CLOB(1073741824))

We're getting the following exception:

SQLException: SQLState(54001) vendor code(-101)
java.sql.SQLException: [SQL0101] SQL statement too long or complex.

If we reduce the CLOB sizes for some of the fields, the statement works.

Any idea why this would happen?

We're using JTOpen 3.1 and connecting to a V5R1 system.

Thanks!

david



_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.