Re: Errors trying to insert values on Oracle LONG data type with Cayenne

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jan 26 2005 - 10:51:52 EST

  • Next message: Andrus Adamchik: "Re: Long type for input parameter"

    Hmm, maybe something that has to be fixed with a custom ExtendedType
    (http://objectstyle.org/cayenne/userguide/access-stack/extended-types.html)...
    BTW, how do you bind a LONGVARCHAR parameter to PreparedStatement in the
    manual JDBC code - this should give hint on how to configure Cayenne
    adapter (and maybe come up with a solution that does not require a custom
    extended type).

    Andrus

    > Hi Andrus,
    >
    > we have tried to use both the 9.0.2 and 8.1.7 (release 2) JDBC
    > drivers, but with the same outcome. With both drivers, we have been able
    > to write to LONG fields using bare bones jdbc calls.
    >
    > The error we are seeing is this:
    > 192.168.1.6: INFO 2005-01-26 12:57:32,015 *** error.
    > java.sql.SQLException: Data size bigger than max size for this type:
    > 5633 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at
    > oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:147)
    > at
    > oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2460)
    > at
    > oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1190)
    > at
    > oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1610)
    > at
    > oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2856)
    > at
    > oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3107)
    > at
    > org.objectstyle.cayenne.access.types.AbstractType.setJdbcObject(AbstractType.java:78)
    > at
    > org.objectstyle.cayenne.access.types.CharType.setJdbcObject(CharType.java:202)
    > at
    > org.objectstyle.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:544)
    > at

    This archive was generated by hypermail 2.0.0 : Wed Jan 26 2005 - 10:51:53 EST