db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Armin Waibel <arm...@apache.org>
Subject Rollback QuotedTest fix
Date Fri, 23 Jun 2006 19:21:48 GMT
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


Mime
View raw message