db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian McCallister <mccallis...@forthillcompany.com>
Subject Re: Unit test errors with PostgreSQL
Date Sat, 19 Jun 2004 20:38:19 GMT
http://www.postgresql.org/docs/7.4/interactive/functions-matching.html


"To match a literal underscore or percent sign without matching other  
characters, the respective character in  pattern must be preceded by  
the escape character. 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."

It should accept ESCAPE '\'

Any chance the escape is being handled in the Java string rather than  
passed though? I should think this would error elsewhere though.

-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


Mime
View raw message