db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakob Braeuchi <jbraeu...@gmx.ch>
Subject Re: Unit test errors with PostgreSQL
Date Sat, 19 Jun 2004 20:11:53 GMT
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(QueryR
>eferenceBroker.java:240) at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryR
>eferenceBroker.java:252) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persi
>stenceBrokerImpl.java:1238) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
>(DelegatingPersistenceBroker.java:332) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery
>(DelegatingPersistenceBroker.java:332) at
> org.apache.ojb.broker.QueryTest.testLikeEscapedCriteria1(QueryTest.java:285
>) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(JdbcAccessImp
>l.java:318) at
> org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.
>java:74) at
> org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183) at
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIterato
>rFactoryImpl.java:58) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Per
>sistenceBrokerImpl.java:1824) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persi
>stenceBrokerImpl.java:1354) at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryR
>eferenceBroker.java:110) at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryR
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1State
>ment.java:231) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeQuery(P6LogPreparedS
>tatement.java:172) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImp
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1526) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:180) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:180) at
> org.apache.ojb.broker.KeyConstraintViolationTest.testKeyViolation(KeyConstr
>aintViolationTest.java:50) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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,Einzelpre
>is,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel) VALUES
> (?,?,?,?,?,?,?,?,?,?) |INSERT INTO Artikel
> (Artikel_Nr,Artikelname,Lieferanten_Nr,Kategorie_Nr,Liefereinheit,Einzelpre
>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,Einzelpre
>is,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel) VALUES
> (?,?,?,?,?,?,?,?,?,?) |INSERT INTO Artikel
> (Artikel_Nr,Artikelname,Lieferanten_Nr,Kategorie_Nr,Liefereinheit,Einzelpre
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>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.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>r.java:186) Caused by: org.postgresql.util.PSQLException: Unbekannter
> Zieltyp
> 	at
> org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statemen
>t.java:1675) at
> org.postgresql.jdbc3.AbstractJdbc3Statement.setObject(AbstractJdbc3Statemen
>t.java:1370) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statemen
>t.java:1681) at
> com.p6spy.engine.spy.P6PreparedStatement.setObject(P6PreparedStatement.java
>:294) at
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(P
>latformDefaultImpl.java:227) at
> org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForStatemen
>t(PlatformPostgreSQLImpl.java:40) at
> org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(StatementMana
>ger.java:449) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceStore(ReferenceTes
>t.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceQuery(ReferenceTes
>t.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceDelete(ReferenceTe
>st.java:837) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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','testAbstractReferen
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceStore(ReferenceTes
>t.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceQuery(ReferenceTes
>t.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceDelete(ReferenceTe
>st.java:837) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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','testAbstractReferen
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceStore(ReferenceTes
>t.java:654) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceQuery(ReferenceTes
>t.java:740) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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(JdbcAccessIm
>pl.java:243) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroke
>rImpl.java:1658) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:1575) at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImp
>l.java:707) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPers
>istenceBroker.java:174) at
> org.apache.ojb.broker.ReferenceTest.testAbstractReferenceDelete(ReferenceTe
>st.java:837) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
>9) at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
>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(RemoteTestR
>unner.java:421) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner
>.java:305) at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne
>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(AbstractJdbc1Statement.
>java:515) at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
>java:50) at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Stat
>ement.java:271) at
> com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepared
>Statement.java:183) at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessIm
>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','testAbstractReferen
>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


Mime
View raw message