Hi Werner
Here is the info I have
2008/Oct/14 16:24:39.805-> SEND TO CASTOR: <transaction
version="2005-08"><insert/><overwrite><employee
TIMESTAMP="1223987107093"><dataEntryEmployee>Suzanne
Reijm</dataEntryEmployee><dateOfDataEntry>20081014</dateOfDataEntry><timeOfDataEntry>000000</timeOfDataEntry><dateOfDataModification>20081014</dateOfDataModification><timeOfDataModification>000000</timeOfDataModification><dataModificationEmployee>SAP</dataModificationEmployee><statusMask>1</statusMask><employeeCode>10</employeeCode><projects/><profiles/><currencyCode>EUR</currencyCode><costPrice>0.0</costPrice><name>Alexander
Wolf</name><totalHours/><status>bs</status><accessCode/><workCentreCode>1</workCentreCode><labourRate>0.0</labourRate><languageCode>31</languageCode><emailAddress/></employee></overwrite><update/><delete/></transaction>
2008/Oct/14 16:24:39.808-> DatabaseBewerkingen, starting new transaction
Oct 14, 2008 4:24:39 PM org.apache.commons.logging.impl.Jdk14Logger fatal
SEVERE: A fatal error occurred while creating/updating
nl.serac.dbengine.elements.Employee using SQL: UPDATE "employee" SET
"emplname"=?,"workcncd"=?,"labrrate"=?,"currnccd"=?,"costpric"=?,"totalhrs"=?,"acccode"=?,"langcode"=?,"email"=?,"status"=?,"entrdate"=?,"entrtime"=?,"entrempl"=?,"modidate"=?,"moditime"=?,"modiempl"=?,"statmask"=?
WHERE "employcd"=? AND "emplname"=? AND "workcncd"=? AND "labrrate"=? AND
"currnccd"=? AND "costpric"=? AND "totalhrs"=? AND "acccode"=? AND
"langcode"=? AND "email"=? AND "status"=? AND "entrdate"=? AND "entrtime"=?
AND "entrempl"=? AND "modidate"=? AND "moditime"=? AND "modiempl"=? AND
"statmask"=?
java.sql.SQLException: ERROR: operator does not exist: character varying
= numeric at character 408
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:113)
at
org.exolab.castor.jdo.engine.SQLStatementStore.executeStatement(SQLStatementStore.java:277)
at org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:323)
at
org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:799)
at org.exolab.castor.persist.LockEngine.store(LockEngine.java:792)
at
org.castor.persist.AbstractTransactionContext.prepareForCreate(AbstractTransactionContext.java:1247)
at
org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
at
org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:169)
at
nl.serac.dbengine.DatabaseBewerkingen.commit(DatabaseBewerkingen.java:264)
at
nl.serac.dbengine.TransactionHandler.handle(TransactionHandler.java:137)
at
nl.serac.backoffice.hotsale.server.BackOfficeDistributionThread.BrancheServiceRun(BackOfficeDistributionThread.java:67)
at
nl.serac.backoffice.hotsale.server.BackOfficeDistributionThread.onMessage(BackOfficeDistributionThread.java:452)
at nl.serac.messenger.Messenger.onMessage(Messenger.java:92)
at nl.serac.messenger.SimpleServer.onMessage(SimpleServer.java:53)
at nl.serac.messenger.JAXMService.onMessage(JAXMService.java:97)
at javax.xml.messaging.JAXMServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:366)
at
org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:581)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1687)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1637)
at org.mortbay.http.HttpServer.service(HttpServer.java:875)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:806)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:956)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:823)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:202)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:290)
at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)
at java.lang.Thread.run(Thread.java:595)
Oct 14, 2008 4:24:39 PM org.apache.commons.logging.impl.Jdk14Logger error
SEVERE: This transaction has been aborted and rolled back: Nested error:
org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: ERROR: operator does not exist: character varying
= numeric at character 408
: ERROR: operator does not exist: character varying = numeric at character
408
: Nested error: java.sql.SQLException: ERROR: operator does not exist:
character varying = numeric at character 408
: ERROR: operator does not exist: character varying = numeric at character
408
org.exolab.castor.jdo.TransactionAbortedException: Nested error:
org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: ERROR: operator does not exist: character varying
= numeric at character 408
: ERROR: operator does not exist: character varying = numeric at character
408
: Nested error: java.sql.SQLException: ERROR: operator does not exist:
character varying = numeric at character 408
: ERROR: operator does not exist: character varying = numeric at character
408
at
org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1224)
at
org.exolab.castor.jdo.engine.LocalDatabaseImpl.commit(LocalDatabaseImpl.java:169)
at
nl.serac.dbengine.DatabaseBewerkingen.commit(DatabaseBewerkingen.java:264)
at
nl.serac.dbengine.TransactionHandler.handle(TransactionHandler.java:137)
at
nl.serac.backoffice.hotsale.server.BackOfficeDistributionThread.BrancheServiceRun(BackOfficeDistributionThread.java:67)
at
nl.serac.backoffice.hotsale.server.BackOfficeDistributionThread.onMessage(BackOfficeDistributionThread.java:452)
at nl.serac.messenger.Messenger.onMessage(Messenger.java:92)
at nl.serac.messenger.SimpleServer.onMessage(SimpleServer.java:53)
at nl.serac.messenger.JAXMService.onMessage(JAXMService.java:97)
at javax.xml.messaging.JAXMServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:366)
at
org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:581)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1687)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1637)
at org.mortbay.http.HttpServer.service(HttpServer.java:875)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:806)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:956)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:823)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:202)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:290)
at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: ERROR: operator does not exist: character varying
= numeric at character 408
: ERROR: operator does not exist: character varying = numeric at character
408
at
org.exolab.castor.jdo.engine.SQLStatementStore.executeStatement(SQLStatementStore.java:333)
at org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:323)
at
org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:799)
at org.exolab.castor.persist.LockEngine.store(LockEngine.java:792)
at
org.castor.persist.AbstractTransactionContext.prepareForCreate(AbstractTransactionContext.java:1247)
at
org.castor.persist.AbstractTransactionContext.prepare(AbstractTransactionContext.java:1211)
... 24 more
Caused by: java.sql.SQLException: ERROR: operator does not exist:
character varying = numeric at character 408
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:113)
at
org.exolab.castor.jdo.engine.SQLStatementStore.executeStatement(SQLStatementStore.java:277)
... 29 more
Caused by: org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: ERROR: operator does not exist: character varying
= numeric at character 408
: ERROR: operator does not exist: character varying = numeric at character
408
at
org.exolab.castor.jdo.engine.SQLStatementStore.executeStatement(SQLStatementStore.java:333)
Kind regards,
Ad
Werner Guttmann
<[EMAIL PROTECTED] To:
[email protected]
.org> cc:
Subject: Re: [castor-user]
castor and postgres 8.3
15-10-2008 08:47
Please respond to
user
Hi Ad,
can you show us a complete SQL statement that used to work with 8.1, but
does not work with 8.3 anymore due to autocasting being not available
anymore ?
Regards
Werner
[EMAIL PROTECTED] wrote:
> Ls,
>
> We are using postgrest 8.1 and castor 1.0 , but want to upgrade postgres
to
> 8.3.
> We have done some test and the following errors occur.
>
> Caused by: java.sql.SQLException: ERROR: operator does not exist:
> character varying = numeric at character 408
>
> This error is caused by postgres not autoCasting anymore.
>
> Is this a known problem with castor and has it already been solved.
>
> Kind regards,
>
>
> Ad Kerremans
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
> http://xircles.codehaus.org/manage_email
>
>
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
