Welcome Guest  |  Register  |  Login
Login Name Password
  Search  
  Index  | Recent Threads  | Unanswered Threads  | Who's Online  | User List  | Help


Quick Go »

No member browsing this thread
Thread Status: Active
Total posts in this thread: 6
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 1132 times and has 5 replies Next Thread
Male jfrantzius
Advanced Member
Member's Avatar

Germany
Joined: Jun 18, 2004
Post Count: 407
Status: Offline
Reply to this Post  Reply with Quote 
0 Most tests currently fail on Oracle?


Hi,

when running the JUnit tests, lots of tests fail on Oracle because some autoassign id fields are used, e.g.
[2006-01-04 23:12:30,150] ERROR RDBMSManager.java:248 - Failed initialising database. Exception : Class "org.jpox.samples.rate.Rate" has field "id" specified as using autoassign/id
entity, yet the RDBMS in use doesnt support this feature
javax.jdo.JDOFatalInternalException: Class "org.jpox.samples.rate.Rate" has field "id" specified as using autoassign/identity, yet the RDBMS in use doesnt support this feature
at org.jpox.store.rdbms.table.ClassTable.initializePK(ClassTable.java:650)

I'd guess this is not intended? Or is Oracle going to be removed from the list of supported databases ;)
(In my opinion, it should deserve that already for calling itself "10g" in the year 2006, while it still does not support table names longer than 32 characters :-/ )







---------------------------------------
This post has been recovered after a database corruption and might completely or partially lack replies. This thread had 5 replies before corruption.
[Jan 4, 2006 10:21:53 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male andy
Expert
Member's Avatar

UK
Joined: Mar 13, 2004
Post Count: 5235
Status: Offline
Reply to this Post  Reply with Quote 
0 Re: Most tests currently fail on Oracle?


lots of tests fail on Oracle because some autoassign id fields are used,
I'd guess this is not intended? Or is Oracle going to be removed from the list of supported databases ;)

It's never been on my list of supported databases since I dont have it. If you look at the unit tests for other RDBMS that dont support autoassign (e.g Postgresql) you will find no problem at all. The unit tests should check if autoassign is supported and only run the test for that RDBMS. Its up to people with Oracle to sort it out



----------------------------------------

Andy






---------------------------------------
This post has been recovered after a database corruption and might completely or partially lack replies. This thread had 5 replies before corruption.
----------------------------------------
-Andy smile

[Jan 5, 2006 5:41:47 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male jfrantzius
Advanced Member
Member's Avatar

Germany
Joined: Jun 18, 2004
Post Count: 407
Status: Offline
Reply to this Post  Reply with Quote 
0 Re: Most tests currently fail on Oracle?


The unit tests should check if autoassign is supported and only run the test for that RDBMS. Its up to people with Oracle to sort it out

Then we'd ignore some tests for Oracle (can't count them right now). I wonder why autoassign is used anyway? If it's about testing autoassign, then there probably should be a dedicated test which we could lightheartedly ignore on Oracle?







---------------------------------------
This post has been recovered after a database corruption and might completely or partially lack replies. This thread had 5 replies before corruption.
[Jan 5, 2006 7:29:30 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male andy
Expert
Member's Avatar

UK
Joined: Mar 13, 2004
Post Count: 5235
Status: Offline
Reply to this Post  Reply with Quote 
0 Re: Most tests currently fail on Oracle?


I wonder why autoassign is used anyway? If it's about testing autoassign, then there probably should be a dedicated test which we could lightheartedly ignore on Oracle?

Because you can't just test "autoassign", since it impacts on other things. You have to test autoassign with other functionality ... inheritance, relationships, attachj/detach, everything else. Auto-assign is NOT used in that many tests, or at least shouldn't be. It is possible to use it with Postgresql with no issues so I dont see why you have so many things in Oracle causing problems - perhaps some misconfigured test setup



----------------------------------------

Andy






---------------------------------------
This post has been recovered after a database corruption and might completely or partially lack replies. This thread had 5 replies before corruption.
----------------------------------------
-Andy smile

[Jan 5, 2006 7:48:00 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male jfrantzius
Advanced Member
Member's Avatar

Germany
Joined: Jun 18, 2004
Post Count: 407
Status: Offline
Reply to this Post  Reply with Quote 
0 Re: Most tests currently fail on Oracle?


I wonder why autoassign is used anyway? If it's about testing autoassign, then there probably should be a dedicated test which we could lightheartedly ignore on Oracle?
Because you can't just test "autoassign", since it impacts on other things. You have to test autoassign with other functionality ... inheritance, relationships, attachj/detach, everything else.
But then consequently you'd have to have all combinations of tests and value-strategies for PKs?
Auto-assign is NOT used in that many tests, or at least shouldn't be. It is possible to use it with Postgresql with no issues so I dont see why you have so many things in Oracle causing problems - perhaps some misconfigured test setup

Well, Oracle simply doesn't have that feature, that's why there are so many problems with it :-(







---------------------------------------
This post has been recovered after a database corruption and might completely or partially lack replies. This thread had 5 replies before corruption.
[Jan 5, 2006 8:22:34 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male andy
Expert
Member's Avatar

UK
Joined: Mar 13, 2004
Post Count: 5235
Status: Offline
Reply to this Post  Reply with Quote 
0 Re: Most tests currently fail on Oracle?


Well, Oracle simply doesn't have that feature, that's why there are so many problems with it :-(

Please read my first post above. As I said, Postgresql simply <U>does not have that feature</U> either ... and the tests work. You have to work out why you have issues with Oracle because I cant. There is a DatabaseAdapter.supportsAutoIncrementFields or something. This is checked in the tests and RDBMS with it set to false (which is Oracle, or Postgresql) dont run those tests. There are only 2 sets of test samples using autoassign ... Currency/Rate, and the autoincrement package.



----------------------------------------

Andy






---------------------------------------
This post has been recovered after a database corruption and might completely or partially lack replies. This thread had 5 replies before corruption.
----------------------------------------
-Andy smile

[Jan 5, 2006 8:33:21 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
[ Jump to Last Post ]
Show Printable Version of Thread  Post new Thread