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 Sun, 20 Jun 2004 08:16:12 GMT
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.<init>(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


Mime
View raw message