Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 54109 invoked from network); 20 Jun 2004 08:16:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 20 Jun 2004 08:16:06 -0000 Received: (qmail 50767 invoked by uid 500); 20 Jun 2004 08:16:08 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 50719 invoked by uid 500); 20 Jun 2004 08:16:07 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 50698 invoked by uid 99); 20 Jun 2004 08:16:07 -0000 Received: from [213.165.64.20] (HELO mail.gmx.net) (213.165.64.20) by apache.org (qpsmtpd/0.27.1) with SMTP; Sun, 20 Jun 2004 01:16:07 -0700 Received: (qmail 23354 invoked by uid 65534); 20 Jun 2004 08:15:41 -0000 Received: from adsl-62-167-200-45.adslplus.ch (EHLO gmx.ch) (62.167.200.45) by mail.gmx.net (mp020) with SMTP; 20 Jun 2004 10:15:41 +0200 X-Authenticated: #15507884 Message-ID: <40D547CC.4010303@gmx.ch> Date: Sun, 20 Jun 2004 10:16:12 +0200 From: Jakob Braeuchi User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Developers List Subject: Re: Unit test errors with PostgreSQL References: <40D45292.40005@first.fhg.de> <200406192007.36260.jbraeuchi@gmx.ch> <40D489B7.2000605@first.fhg.de> <200406192211.53839.jbraeuchi@gmx.ch> <4199BC77-C231-11D8-B976-000A95782782@forthillcompany.com> In-Reply-To: <4199BC77-C231-11D8-B976-000A95782782@forthillcompany.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N hi, the doc says: "The default escape character is the backslash but a different one may be selected by using the ESCAPE clause. To match the escape character itself, write two escape characters." may be we should try using another character in the escape clause, not the default one ie: SELECT A0.LASTNAME,A0.FIRSTNAME,A0.ID FROM PERSON A0 WHERE A0.FIRSTNAME LIKE 'h%!%' ESCAPE '!' does this run in postgresql ? jakob Brian McCallister wrote: > using psql directly, with one email address: > mccallister%forthillcompany.com and a bunch like %@forthillcompany.com > I get the following behavior: > > select count(*) from profiles where email like '%\\%forthillcompany.com'; > returns 1 row (correct) > > select count(*) from profiles where email like '%\%forthillcompany.com'; > returns 47 rows (incorrect) > > psql may be escaping these, or postgres may be. > > -Brian > > On Jun 19, 2004, at 4:11 PM, Jakob Braeuchi wrote: > >> hi thomas, >> >> postgres does not seem to like the ESCAPE clause: >> >> SELECT A0.LASTNAME,A0.FIRSTNAME,A0.ID FROM PERSON A0 WHERE >> A0.FIRSTNAME LIKE >> 'h%\%' ESCAPE '\' >> >> do you know how to escape wildcards in postgres ? >> >> jakob >> >> Am Sa Juni 19 2004 20.45 schrieb Thomas Dudziak: >> >>> Jakob Braeuchi wrote: >>> >>>> hi thomas, >>>> >>>> the easiest thing is to use a debugger and to direct the output of >>>> p6spy >>>> to the console. that's how i do it in eclipse. >>> >>> >>> Ok, with a bit of tweaking I got the unit tests to run. Here's what the >>> exception is and what the spy.log shows for the individual tests (I >>> hope >>> it suffixes, don't have more time today for OJB): >>> >>> >>> *org.apache.ojb.broker.QueryTest.testLikeEscapedCriteria1*: >>> ----------------------------------------------------------- >>> >>> testLikeEscapedCriteria1(org.apache.ojb.broker.QueryTest) >>> org.apache.ojb.broker.PersistenceBrokerException: >>> org.apache.ojb.broker.PersistenceBrokerSQLException: >>> org.postgresql.util.PSQLException: FEHLER: Fehler \x{FEB5}nterminated >>> quoted string\x{FA60}bei \x{FE67}\'\x{FA40}P93 >>> >>> at >>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q >>> ueryR >>> eferenceBroker.java:240) at >>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q >>> ueryR >>> eferenceBroker.java:252) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery( >>> Persi >>> stenceBrokerImpl.java:1238) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy >>> Query >>> (DelegatingPersistenceBroker.java:332) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionBy >>> Query >>> (DelegatingPersistenceBroker.java:332) at >>> org.apache.ojb.broker.QueryTest.testLikeEscapedCriteria1(QueryTest.jav >>> a:285 >>> ) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: >>> org.apache.ojb.broker.PersistenceBrokerSQLException: >>> org.postgresql.util.PSQLException: FEHLER: Fehler \x{FEB5}nterminated >>> quoted string\x{FA60}bei \x{FE67}\'\x{FA40}P93 >>> >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce >>> ssImp >>> l.java:318) at >>> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryOb >>> ject. >>> java:74) at >>> org.apache.ojb.broker.accesslayer.RsIterator.(RsIterator.java: >>> 183) at >>> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIt >>> erato >>> rFactoryImpl.java:58) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuer >>> y(Per >>> sistenceBrokerImpl.java:1824) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery( >>> Persi >>> stenceBrokerImpl.java:1354) at >>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q >>> ueryR >>> eferenceBroker.java:110) at >>> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Q >>> ueryR >>> eferenceBroker.java:232) ... 18 more >>> Caused by: org.postgresql.util.PSQLException: FEHLER: Fehler >>> \x{FEB5}nterminated quoted string\x{FA60}bei \x{FE67}\'\x{FA40}P93 >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1 >>> State >>> ment.java:231) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeQuery(P6LogPrep >>> aredS >>> tatement.java:172) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAcce >>> ssImp >>> l.java:283) ... 25 more >>> >>> >>> >>> 1087669389722|20|0|statement|SELECT A0.LASTNAME,A0.FIRSTNAME,A0.ID FROM >>> PERSON A0 WHERE A0.FIRSTNAME LIKE ? ESCAPE '\'|SELECT >>> A0.LASTNAME,A0.FIRSTNAME,A0.ID FROM PERSON A0 WHERE A0.FIRSTNAME LIKE >>> 'h%\%' ESCAPE '\' >>> >>> >>> *org.apache.ojb.broker.KeyConstraintViolationTest.testKeyViolation*: >>> -------------------------------------------------------------------- >>> >>> >>> testKeyViolation(org.apache.ojb.broker.KeyConstraintViolationTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.Article, PK of the >>> given object is [ articleId=12366], object was ---- >>> Article No: 12366 >>> Description: repeated Article >>> ProductGroupId: 1 >>> ProductGroupName: null >>> stock: 0 >>> price: 0.0 >>> stock-value 0.0 >>> , exception message is [FEHLER: duplizierter Schl\x{BCB3}el verletzt >>> Unique-Constraint \x{FEA1}rtikel_pkey\x{FA40}Fnbtinsert.c >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1526) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:180) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:180) at >>> org.apache.ojb.broker.KeyConstraintViolationTest.testKeyViolation(KeyC >>> onstr >>> aintViolationTest.java:50) at >>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> duplizierter Schl\x{BCB3}el verletzt Unique-Constraint >>> \x{FEA1}rtikel_pkey\x{FA40}Fnbtinsert.c >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 19 more >>> >>> >>> >>> 1087669751753|77|1|statement|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = ?|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = 'SEQ_Artikel' >>> 1087669751779|2|1|statement|UPDATE OJB_HL_SEQ SET >>> MAX_KEY=?,GRAB_SIZE=?,VERSION=? WHERE TABLENAME = ? AND FIELDNAME = ? >>> AND VERSION = ? |UPDATE OJB_HL_SEQ SET >>> MAX_KEY='12385',GRAB_SIZE='20',VERSION='2' WHERE TABLENAME = >>> 'SEQ_Artikel' AND FIELDNAME = 'deprecatedColumn' AND VERSION = '1' >>> 1087669751782|2|1|commit|| >>> 1087669751790|3|0|statement|INSERT INTO Artikel >>> (Artikel_Nr,Artikelname,Lieferanten_Nr,Kategorie_Nr,Liefereinheit,Einz >>> elpre >>> is,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel) >>> VALUES >>> (?,?,?,?,?,?,?,?,?,?) |INSERT INTO Artikel >>> (Artikel_Nr,Artikelname,Lieferanten_Nr,Kategorie_Nr,Liefereinheit,Einz >>> elpre >>> is,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel) >>> VALUES >>> ('12366','repeated Article','0','1','','0.0','0','0','0','0') >>> 1087669751797|3|0|commit|| >>> 1087669751951|151|0|statement|INSERT INTO Artikel >>> (Artikel_Nr,Artikelname,Lieferanten_Nr,Kategorie_Nr,Liefereinheit,Einz >>> elpre >>> is,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel) >>> VALUES >>> (?,?,?,?,?,?,?,?,?,?) |INSERT INTO Artikel >>> (Artikel_Nr,Artikelname,Lieferanten_Nr,Kategorie_Nr,Liefereinheit,Einz >>> elpre >>> is,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel) >>> VALUES >>> ('12366','repeated Article','0','1','','0.0','0','0','0','0') >>> 1087669751960|0|0|rollback|| >>> >>> >>> *org.apache.ojb.broker.BlobTest.testBlobInsertion*: >>> --------------------------------------------------- >>> >>> testBlobInsertion(org.apache.ojb.broker.BlobTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class >>> org.apache.ojb.broker.BlobTest$ObjectWithBlob, PK of the given >>> object is >>> [ id=1], object was >>> org.apache.ojb.broker.BlobTest$ObjectWithBlob@10ffb38, exception >>> message >>> is [Unbekannter Zieltyp] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.BlobTest.testBlobInsertion(BlobTest.java:82) at >>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: Unbekannter >>> Zieltyp >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Sta >>> temen >>> t.java:1675) at >>> org.postgresql.jdbc3.AbstractJdbc3Statement.setObject(AbstractJdbc3Sta >>> temen >>> t.java:1370) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Sta >>> temen >>> t.java:1681) at >>> com.p6spy.engine.spy.P6PreparedStatement.setObject(P6PreparedStatement >>> .java >>> :294) at >>> org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatem >>> ent(P >>> latformDefaultImpl.java:227) at >>> org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForSta >>> temen >>> t(PlatformPostgreSQLImpl.java:40) at >>> org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Statemen >>> tMana >>> ger.java:449) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:194) ... 21 more >>> >>> >>> 1087670081775|10|0|statement|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = ?|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = 'SEQ_BLOB_TEST' >>> 1087670081791|2|1|statement||SELECT MAX(ID) FROM BLOB_TEST >>> 1087670081808|3|0|statement|INSERT INTO OJB_HL_SEQ >>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>> >>> |INSERT INTO OJB_HL_SEQ (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) >>> >>> VALUES ('SEQ_BLOB_TEST','deprecatedColumn','20','20','1') >>> 1087670081820|8|0|commit|| >>> >>> >>> *org.apache.ojb.broker.ReferenceTest.testAbstractReferenceStore*: >>> ----------------------------------------------------------------- >>> >>> >>> testAbstractReferenceStore(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=1], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@d507e9, exception message is >>> [FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum >>> Ende der Transaktion ignoriert >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceStore(Referen >>> ceTes >>> t.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> aktuelle >>> Transaktion wurde abgebrochen, Befehle werden bis zum Ende der >>> Transaktion ignoriert >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> testAbstractReferenceQuery(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=2], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@32060c, exception message is >>> [FEHLER: Relation \x{FEB2}ef_animal\x{FA60}existiert nicht >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceQuery(Referen >>> ceTes >>> t.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> Relation >>> \x{FEB2}ef_animal\x{FA60}existiert nicht >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> testAbstractReferenceDelete(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=3], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@1efb4be, exception message is >>> [FEHLER: Relation \x{FEB2}ef_animal\x{FA60}existiert nicht >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceDelete(Refere >>> nceTe >>> st.java:837) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> Relation >>> \x{FEB2}ef_animal\x{FA60}existiert nicht >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> >>> 1087670371111|10|1|statement|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = ?|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = 'SEQ_REF_ANIMAL' >>> 1087670371146|28|0|statement||SELECT MAX(A_ID) FROM REF_ANIMAL >>> 1087670371160|2|1|statement|INSERT INTO OJB_HL_SEQ >>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>> >>> |INSERT INTO OJB_HL_SEQ (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) >>> >>> VALUES ('SEQ_REF_ANIMAL','deprecatedColumn','20','20','1') >>> 1087670371274|39|1|commit|| >>> 1087670371277|1|0|statement|INSERT INTO REF_ANIMAL >>> (A_ID,CLASS_NAME,LENGTH_,NAME) VALUES (?,?,?,?) |INSERT INTO REF_ANIMAL >>> (A_ID,CLASS_NAME,LENGTH_,NAME) VALUES >>> ('1','org.apache.ojb.broker.ReferenceTest$Bird','0.99','testAbstractRe >>> feren >>> ceStore_1087670370715') >>> >>> 1087670371286|0|0|rollback|| >>> >>> >>> *org.apache.ojb.broker.ReferenceTest.testAbstractReferenceQuery*: >>> ----------------------------------------------------------------- >>> >>> testAbstractReferenceStore(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=1], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@d507e9, exception message is >>> [FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum >>> Ende der Transaktion ignoriert >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceStore(Referen >>> ceTes >>> t.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> aktuelle >>> Transaktion wurde abgebrochen, Befehle werden bis zum Ende der >>> Transaktion ignoriert >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> testAbstractReferenceQuery(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=2], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@32060c, exception message is >>> [FEHLER: Relation \x{FEB2}ef_animal\x{FA60}existiert nicht >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceQuery(Referen >>> ceTes >>> t.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> Relation >>> \x{FEB2}ef_animal\x{FA60}existiert nicht >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> testAbstractReferenceDelete(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=3], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@1efb4be, exception message is >>> [FEHLER: Relation \x{FEB2}ef_animal\x{FA60}existiert nicht >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceDelete(Refere >>> nceTe >>> st.java:837) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> Relation >>> \x{FEB2}ef_animal\x{FA60}existiert nicht >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> >>> 1087670482134|10|1|statement|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = ?|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = 'SEQ_REF_ANIMAL' >>> 1087670482160|19|0|statement||SELECT MAX(A_ID) FROM REF_ANIMAL >>> 1087670482174|1|1|statement|INSERT INTO OJB_HL_SEQ >>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>> >>> |INSERT INTO OJB_HL_SEQ (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) >>> >>> VALUES ('SEQ_REF_ANIMAL','deprecatedColumn','20','20','1') >>> 1087670482294|2|1|commit|| >>> 1087670482297|1|0|statement|INSERT INTO REF_ANIMAL >>> (A_ID,CLASS_NAME,LENGTH_,NAME) VALUES (?,?,?,?) |INSERT INTO REF_ANIMAL >>> (A_ID,CLASS_NAME,LENGTH_,NAME) VALUES >>> ('1','org.apache.ojb.broker.ReferenceTest$Bird','0.99','testAbstractRe >>> feren >>> ceQuery_1087670481726') >>> >>> 1087670482306|1|0|rollback|| >>> >>> >>> *org.apache.ojb.broker.ReferenceTest.testAbstractReferenceDelete*: >>> ------------------------------------------------------------------ >>> >>> testAbstractReferenceStore(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=1], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@d507e9, exception message is >>> [FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum >>> Ende der Transaktion ignoriert >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceStore(Referen >>> ceTes >>> t.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> aktuelle >>> Transaktion wurde abgebrochen, Befehle werden bis zum Ende der >>> Transaktion ignoriert >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> testAbstractReferenceQuery(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=2], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@32060c, exception message is >>> [FEHLER: Relation \x{FEB2}ef_animal\x{FA60}existiert nicht >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceQuery(Referen >>> ceTes >>> t.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> Relation >>> \x{FEB2}ef_animal\x{FA60}existiert nicht >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> testAbstractReferenceDelete(org.apache.ojb.broker.ReferenceTest) >>> org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while >>> insert object data for class org.apache.ojb.broker.ReferenceTest$Bird, >>> PK of the given object is [ id=3], object was >>> org.apache.ojb.broker.ReferenceTest$Bird@1efb4be, exception message is >>> [FEHLER: Relation \x{FEB2}ef_animal\x{FA60}existiert nicht >>> ] >>> at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:243) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistence >>> Broke >>> rImpl.java:1658) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:1575) at >>> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrok >>> erImp >>> l.java:707) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegatin >>> gPers >>> istenceBroker.java:174) at >>> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceDelete(Refere >>> nceTe >>> st.java:837) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >>> ava:3 >>> 9) at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >>> orImp >>> l.java:25) at java.lang.reflect.Method.invoke(Method.java:324) >>> at junit.framework.TestCase.runTest(TestCase.java:154) >>> at junit.framework.TestCase.runBare(TestCase.java:127) >>> at junit.framework.TestResult$1.protect(TestResult.java:106) >>> at junit.framework.TestResult.runProtected(TestResult.java:124) >>> at junit.framework.TestResult.run(TestResult.java:109) >>> at junit.framework.TestCase.run(TestCase.java:118) >>> at junit.framework.TestSuite.runTest(TestSuite.java:208) >>> at junit.framework.TestSuite.run(TestSuite.java:203) >>> at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(Remote >>> TestR >>> unner.java:421) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestR >>> unner >>> .java:305) at >>> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTest >>> Runne >>> r.java:186) Caused by: org.postgresql.util.PSQLException: FEHLER: >>> Relation >>> \x{FEB2}ef_animal\x{FA60}existiert nicht >>> >>> at >>> org.postgresql.util.PSQLException.parseServerError(PSQLException.java: >>> 139) >>> at >>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:154) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) >>> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) >>> at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1State >>> ment. >>> java:515) at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State >>> ment. >>> java:50) at >>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc >>> 1Stat >>> ement.java:271) at >>> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPre >>> pared >>> Statement.java:183) at >>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcc >>> essIm >>> pl.java:198) ... 21 more >>> >>> >>> 1087670561940|10|1|statement|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = ?|SELECT >>> A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM >>> OJB_HL_SEQ A0 WHERE A0.TABLENAME = 'SEQ_REF_ANIMAL' >>> 1087670562017|70|0|statement||SELECT MAX(A_ID) FROM REF_ANIMAL >>> 1087670562038|8|1|statement|INSERT INTO OJB_HL_SEQ >>> (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) VALUES (?,?,?,?,?) >>> >>> |INSERT INTO OJB_HL_SEQ (TABLENAME,FIELDNAME,MAX_KEY,GRAB_SIZE,VERSION) >>> >>> VALUES ('SEQ_REF_ANIMAL','deprecatedColumn','20','20','1') >>> 1087670562154|3|1|commit|| >>> 1087670562157|1|0|statement|INSERT INTO REF_ANIMAL >>> (A_ID,CLASS_NAME,LENGTH_,NAME) VALUES (?,?,?,?) |INSERT INTO REF_ANIMAL >>> (A_ID,CLASS_NAME,LENGTH_,NAME) VALUES >>> ('1','org.apache.ojb.broker.ReferenceTest$Bird','0.99','testAbstractRe >>> feren >>> ceDelete_1087670561546') >>> >>> 1087670562201|0|0|rollback|| >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org >>> For additional commands, e-mail: ojb-dev-help@db.apache.org >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org >> For additional commands, e-mail: ojb-dev-help@db.apache.org >> >> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org > For additional commands, e-mail: ojb-dev-help@db.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org