2 Replies Latest reply on Jun 20, 2002 2:49 PM by Thomas Schmegg

    how to store objects that are larger than 32kb ?

    Thomas Schmegg Newbie


      I'm using jboss 2.4.4 with hsqldb where i use CMP to store java.lang.Object's.
      Somehow it doesn't store objects that are larger than
      (approximately) 32kb. But it works fine if their
      size is less.
      Is there a limitation on the "object" column type?
      A also tried to change the standardjaws.xml so that the java.lang.Object is mapped to a varchar(500000) but this has had the same limitations :-(
      So i rather guess the problem lies somwhere else, but
      have no idea what to do next as i am also new to j2ee.

      I would be very pleased for any suggestions.
      Thank you very much in advance.

      Here is the exceptions stacktrace (server side):

      [ERROR,EntitySynchronizationInterceptor] Store failed
      java.rmi.ServerException: Store failed; nested exception is:
      java.sql.SQLException: Connection is broken
      java.sql.SQLException: Connection is broken
      at org.hsqldb.Trace.getError(Trace.java:180)
      at org.hsqldb.Trace.getError(Trace.java:144)
      at org.hsqldb.Trace.error(Trace.java:205)
      at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:904)
      at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
      at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
      at org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)
      at org.hsqldb.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:152)
      at org.jboss.pool.jdbc.PreparedStatementInPool.executeUpdate(Unknown Source)