Thanks for confirming this. Ralf, I wonder how to make this(new) knowledge available on the HTML site ?
Werner [EMAIL PROTECTED] wrote: > Hi Ralf, > > The columns costprice and labourrate are defined as string in the table, > but as double in the mapping. > I think this is the reason for the error. > > > Met vriendelijke groet/with kind regards, > > > Ad Kerremans > > > > > > Ralf Joachim > > <[EMAIL PROTECTED] To: > [email protected] > con.eu> cc: > > Subject: Re: [castor-user] > castor and postgres 8.3 > 15-10-2008 22:18 > > Please respond to > > user > > > > > > > > Hi Ad, > > can you also send us the script to create the 'employee' table and the > mapping for it. Could it be that 'status' column is created as varchar > but defined as numeric in mapping? Maybe this worked in older releases > of postgresql but newer do stricter type checking. > > Regards > Ralf > > > [EMAIL PROTECTED] schrieb: >> 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 >> > > --------------------------------------------------------------------- > 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
