[opencms-dev] publishing with Oracle

[Laura Bacci]

Hi,
 
I have  troubles when publishing using Oracle 8.1.7 as DB (Win2k SP2,
jdk 1.3, Tomcat 4.0.1 OpenCms 4.6.0).
I imported newsModulw4 and then modified NewsContentDefinition.java
because the table news_entries has a colunm named ‘date’ that cannot be
used in Oracle (invalid column name). Then I tried to publish and I got
the following error:

PublishProject 12 CmsObject Time:Mon May 13 17:23:57 CEST 2002
currentUser:[User]:Admin , Id=2 , flags=0 , type=0 :the admin-user
[CmsException]: 4 Sql exception. 
Detailed Error: [com.opencms.file.genericSql.CmsDbAccess] ORA-01483:
invalid length for DATE or NUMBER bind variable. 
Caught Exception: >java.sql.SQLException: ORA-01483: invalid length for
DATE or NUMBER bind variable

at
com.opencms.file.genericSql.CmsDbAccess.publishProject(CmsDbAccess.java:5002)
at
com.opencms.file.genericSql.CmsResourceBroker.publishProject(CmsResourceBroker.java:4477)
at com.opencms.file.CmsObject.publishProject(CmsObject.java:2279)
at
com.opencms.workplace.CmsAdminPublishProjectThread.run(CmsAdminPublishProjectThread.java:68)

java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind
variable

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at
com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.java:170)
at
com.opencms.file.genericSql.CmsDbAccess.publishProject(CmsDbAccess.java:4999)
at
com.opencms.file.genericSql.CmsResourceBroker.publishProject(CmsResourceBroker.java:4477)
at com.opencms.file.CmsObject.publishProject(CmsObject.java:2279)
at
com.opencms.workplace.CmsAdminPublishProjectThread.run(CmsAdminPublishProjectThread.java:68)

Thanks for any help. 
Regards

Laura