[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jetspeed-dev
Subject:    Dbpsml error
From:       Glenn Golden <ggolden () umich ! edu>
Date:       2002-08-28 13:11:47
[Download RAW message or body]

Anyone ever see this one, a horrible exception from a portlet customize?

Have we modeled some field for the psml definition that doesn't fit into the
database?

Caused by: java.sql.SQLException: Data size bigger than max size for this
type: 4007


Here's the sql for the group profile - I changed the BLOB to LONG RAW:

CREATE TABLE JETSPEED_GROUP_PROFILE
(
    PSML_ID NUMBER NOT NULL,
    GROUP_NAME VARCHAR2 (99) NOT NULL,
    MEDIA_TYPE VARCHAR2 (99),
    LANGUAGE VARCHAR2 (2),
    COUNTRY VARCHAR2 (2),
    PAGE VARCHAR2 (99),
    PROFILE LONG RAW,
    CONSTRAINT JETSPEED_GROUP_PROFILE_UNIQUE UNIQUE (GROUP_NAME, MEDIA_TYPE,
LANGUAGE, COUNTRY, PAGE)
);


I don't know my way around the torque / village jdbc writing code, but I do
know that there's a limit to what can be sent in a sql statement, and the
the long raw must be done with a prepared statement and "?" parameter (and
blobs are even worse).  Anyone know if torque handles this in this way?

Thanks.

Full(er) exception:

Caused by: java.sql.SQLException: Data size bigger than max size for this
type: 4007
        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:95)
        at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2414)
        at
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.j
ava:1134)
        at
oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedStatement.
java:2170)
        at com.workingdogs.village.Value.setPreparedStatementValue(Unknown
Source)
        at com.workingdogs.village.Record.saveWithUpdate(Unknown Source)
        at com.workingdogs.village.Record.save(Unknown Source)
        at com.workingdogs.village.Record.save(Unknown Source)
        at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:1050)
        ... 55 more
org.apache.torque.TorqueException: Data size bigger than max size for this
type: 4007
        at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1939)
        at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1824)
        at
org.apache.jetspeed.om.dbpsml.JetspeedGroupProfilePeer.doInsertOrUpdate(Jets
peedGroupProfilePeer.java:94)
        at
org.apache.jetspeed.om.dbpsml.JetspeedGroupProfilePeer.update(JetspeedGroupP
rofilePeer.java:67)
        at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eOrSaveDocument(DatabasePsmlManag
erService.java:612)
        at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.store
(DatabasePsmlManagerService.java:
555)
        at
org.apache.jetspeed.services.PsmlManager.store(PsmlManager.java:131)
        at
org.apache.jetspeed.portal.service.JetspeedPersistenceService$Page.store(Jet
speedPersistenceService.java:373)
        at
org.apache.jetspeed.portal.service.JetspeedPersistenceService$Page.access$10
0(JetspeedPersistenceService.java
:242)
        at
org.apache.jetspeed.portal.service.JetspeedPersistenceService.store(Jetspeed
PersistenceService.java:167)
        at
org.apache.jetspeed.modules.actions.portlets.CustomizeAction.doUpdate(Custom
izeAction.java:196)


- Glenn

--------------------------------------------
Glenn R. Golden, Systems Research Programmer 
University of Michigan School of Information
ggolden@umich.edu               734-615-1419
--------------------------------------------

--
To unsubscribe, e-mail:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>

[prev in list] [next in list] [prev in thread] [next in thread]