To my knowledge we have some database specific informations in our FAQ. Will try to add something for this.
Ralf Werner Guttmann schrieb: > 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 > --------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email
