In Theme page and click the customize button then error

[BinGao <bl...@yahoo.co.jp>]

HI

In Theme page and click the customize button then error
Maybe clob type's problem when use oracle.

## My server environment
server: tomcat5.5.9
Browser Version:  IE6
Database:  oracle9i
JDK Version:  jdk1.5

## roller.log
ERROR 2006-08-16 09:59:36,093 ThemeManagerImpl:saveThemePages - ERROR in 
action
org.apache.roller.RollerException
at 
org.apache.roller.business.hibernate.HibernateUserManagerImpl.getPageByName(HibernateUserManagerImpl.java:677)
at 
org.apache.roller.business.ThemeManagerImpl.saveThemePages(ThemeManagerImpl.java:337)
at 
org.apache.roller.presentation.website.actions.ThemeEditorAction.customize(ThemeEditorAction.java:372)
                      ....
--- ROOT CAUSE --- 
org.hibernate.exception.GenericJDBCException: could not insert: 
[org.apache.roller.pojos.WeblogTemplate]
at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
                     ....

Caused by: java.sql.SQLException: the column size is big: 4263
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                    ....

## WeblogTemplate.hbm.xml file define.
        <property
            name="contents"
            type="java.lang.String"
            update="true"
            insert="true"
            column="template"
            unique="false"
        />


But I modified type="text" then another error.

DEBUG 2006-08-16 12:10:03,093 JDBCExceptionReporter:logExceptions - could 
not insert: [org.apache.roller.pojos.WeblogTemplate] [insert into webpage 
(websiteid, name, description, link, template, updatetime, id) values (?, ?, 
?, ?, ?, ?, ?)]
java.sql.SQLException: cann't process : streams type cannot be used in 
batching
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at 
oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3999)
at 
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.addBatch(DelegatingPreparedStatement.java:171)
at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:30)
at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2062)

WARN 2006-08-16 12:10:03,109 JDBCExceptionReporter:logExceptions - SQL 
Error: 17090, SQLState: null
ERROR 2006-08-16 12:10:03,109 JDBCExceptionReporter:logExceptions - cann't 
process : streams type cannot be used in batching
ERROR 2006-08-16 12:10:03,109 
AbstractFlushingEventListener:performExecutions - Could not synchronize 
database state with session
org.hibernate.exception.GenericJDBCException: could not insert: 
[org.apache.roller.pojos.WeblogTemplate]
at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


What do I need to change same setting?

Thanks,

bean.


--------------------------------------
For All Sports Lovers!
http://pr.mail.yahoo.co.jp/yells/