Ben
At night I get the following errors in my log file ...
INFO 2006-03-16 00:00:00,002 TurnoverReferersTask:run - task started
WARN 2006-03-16 00:00:00,699 JDBCExceptionReporter:logExceptions - SQL
Error: 932, SQLState: 42000
ERROR 2006-03-16 00:00:00,700 JDBCExceptionReporter:logExceptions -
ORA-00932: inconsistent datatypes: expected - got CLOB
ERROR 2006-03-16 00:00:00,708 HibernateRefererManagerImpl:clearReferrers -
EXCEPTION resetting referers
org.hibernate.exception.GenericJDBCException: could not execute update
query
at
org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.hql.ast.UpdateStatementExecutor.execute(UpdateStatementExecutor.java:99)
at
org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:297)
at
org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:871)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:89)
at
org.roller.business.hibernate.HibernateRefererManagerImpl.clearReferrers(HibernateRefererManagerImpl.java:485)
at
org.roller.presentation.TurnoverReferersTask.run(TurnoverReferersTask.java:44)
at java.util.TimerThread.mainLoop(Timer.java:432)
at java.util.TimerThread.run(Timer.java:382)
Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes:
expected - got CLOB
"Ben Avery" <[EMAIL PROTECTED]>
14/03/2006 01:10
Please respond to
[email protected]
To
<[email protected]>
cc
Subject
RE: Oracle users: verify that we should use "clob" instead of "text"
that's right, I've just upgraded from 2.0 to 2.1 and had to fix this.
I sent a revised version of the database creation script to the Roller dev
list a few days ago - should be in the archives. The script for 2.0 was,
if I
recall correctly, fine for Oracle, and the error is just in the 2.1
version,
which looks like a copy of the MySql version.
The other mistyped field is BIT, which Oracle (9) doesn't have either.
This
needs to be replaced with NUMBER(1) as a single digit number, as Oracle
also
doesn't have boolean fields.
I found another problem with the Oracle database creation script, a not
null
field for the template table, I think. which means an error is thrown when
you try to create a new template through the web interface, as empty
varchar
fields are null. I'll confirm this from work tomorrow.
-----Original Message-----
From: Dave Johnson [mailto:[EMAIL PROTECTED]
Sent: Mon 13/03/2006 19:55
To: [email protected]; [email protected]
Subject: Oracle users: verify that we should use "clob" instead of "text"
According to issue ROL-1077, we should use the CLOB instead of
TEXT data type in the create database script for Oracle.
Can any Oracle users verify that this change is needed?
http://opensource2.atlassian.com/projects/roller/browse/ROL-1077
-Dave
