You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by Armin Waibel <ar...@apache.org> on 2006/06/23 21:21:48 UTC
Rollback QuotedTest fix
Hi Martin,
I have tested your patch
http://www.mail-archive.com/ojb-dev%40db.apache.org/msg02892.html
<snip>
...
<class-descriptor
class="org.apache.ojb.broker.QuotedTest$QuotedArticle"
proxy="dynamic"
- table="'QUOTED_ARTICLE'"
+ table="'quoted_article'"
...
</snip>
and it seems that hsql, maxDB and oracle don't pass QuotedTest after
change to lower case.
For example, below you can find the stack trace running this test
against Oracle (same for hsql and maxDB).
Do we need additional settings to run this test with your patched
repository_junit.xml version against these DB?
regards,
Armin
#########
oracle
#########
Testcase: testDelete took 0,094 sec
Caused an ERROR
* SQLException during execution of sql-statement:
* sql statement was 'INSERT INTO "quoted_article"
("article_id","article_name",GROUP_ID,"unit",PRICE,STOCK) VALUES
(?,?,?,?,?,?) '
* Exception message is [ORA-00942: Tabelle oder View nicht vorhanden
]
* Vendor error code [942]
* SQL state code [42000]
* Target class is 'org.apache.ojb.broker.QuotedTest$QuotedArticle'
* PK of the target object is [articleId=200001]
* Source object: org.apache.ojb.broker.QuotedTest$QuotedArticle@1176e5f
org.apache.ojb.broker.PersistenceBrokerSQLException:
* SQLException during execution of sql-statement:
* sql statement was 'INSERT INTO "quoted_article"
("article_id","article_name",GROUP_ID,"unit",PRICE,STOCK) VALUES
(?,?,?,?,?,?) '
* Exception message is [ORA-00942: Tabelle oder View nicht vorhanden
]
* Vendor error code [942]
* SQL state code [42000]
* Target class is 'org.apache.ojb.broker.QuotedTest$QuotedArticle'
* PK of the target object is [articleId=200001]
* Source object: org.apache.ojb.broker.QuotedTest$QuotedArticle@1176e5f
at
org.apache.ojb.broker.util.ExceptionHelper.generateException(ExceptionHelper.java:256)
at
org.apache.ojb.broker.util.ExceptionHelper.generateException(ExceptionHelper.java:90)
at
org.apache.ojb.broker.util.ExceptionHelper.generateException(ExceptionHelper.java:71)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:232)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:2021)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:977)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1014)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:884)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:220)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:220)
at org.apache.ojb.broker.QuotedTest.testDelete(QuotedTest.java:139)
Caused by: java.sql.SQLException: ORA-00942: Tabelle oder View nicht
vorhanden
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Rollback QuotedTest fix
Posted by Martin Kalén <mk...@apache.org>.
Armin Waibel wrote:
> It's already done, please excuse my anticipation ;-)
That's OK - I should not have left this "hanging".
Cheers,
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: Rollback QuotedTest fix
Posted by Armin Waibel <ar...@apache.org>.
Hi Martin,
Martin Kalén wrote:
> Hi Armin,
>
> Armin Waibel wrote:
>> I have tested your patch
> ...
>> and it seems that hsql, maxDB and oracle don't pass QuotedTest after
>> change to lower case.
>
> The test is a bit defunct since it relies on the RBDMS default behaviour
> when creating tables with Torque without strictly beeing able to
> reproduce/assert this through OJB.
>
> I never got a consistent state across Oracle, HSQLdb and PostgreSQL,
> so until we have more time to look into QutoedTest and make a more
> reliable testcase I'm rolling my changes back.
>
It's already done, please excuse my anticipation ;-)
regards,
Armin
> Regards,
> Martin
>
>
> ---------------------------------------------------------------------
> 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
Re: Rollback QuotedTest fix
Posted by Martin Kalén <mk...@apache.org>.
Hi Armin,
Armin Waibel wrote:
> I have tested your patch
...
> and it seems that hsql, maxDB and oracle don't pass QuotedTest after
> change to lower case.
The test is a bit defunct since it relies on the RBDMS default behaviour
when creating tables with Torque without strictly beeing able to
reproduce/assert this through OJB.
I never got a consistent state across Oracle, HSQLdb and PostgreSQL,
so until we have more time to look into QutoedTest and make a more
reliable testcase I'm rolling my changes back.
Regards,
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org