The problem is:
statement.execute("CREATE OR REPLACE FUNCTION
allEmployments \n" +
" RETURN SYS_REFCURSOR \n" +
"AS \n" +
" st_cursor SYS_REFCURSOR; \n" +
"BEGIN \n" +
" OPEN st_cursor FOR \n" +
" SELECT EMPLOYEE, EMPLOYER, \n" +
" STARTDATE, ENDDATE, \n" +
" REGIONCODE, EID, VALUE, CURRENCY \n" +
" FROM EMPLOYMENT; \n" +
" RETURN st_cursor; \n " +
"END;\n");
in testEntityStoredProcedure()
You reference a column EMPLOYMENT.EID that does not exist. Oracle does
not throw exceptions on failed stored-procedure/function creation. It
simply returns warnings. I modified this test to fix this bit...
-----Original Message-----
From: Max Andersen
Sent: Monday, August 08, 2005 6:36 AM
To: Steve Ebersole; [EMAIL PROTECTED]; Hibernate devel
Subject: Re: testing question
>
> This is the same reason why I always get failures on the tests
relating
> to stored procedure support.
>
These tests creates the SP's before testing - thus if you get errors
while
running
junit test then that is something that should be failing.
How about simply extending hibernate with the possibility for user
provided additional DDL's ?
(been suggested before by users, but not had any compelling usecase for
it...maybe our own
testing is ?)
/max
> I think we should come up with a unified way to approach this. So
I'll
> throw out my proposal as a starting point and see if anyone has better
> solutions.
>
> The basic idea is to have the individual tests in this category
register
> "additional db objects" with the base test case class; these would be
> used during setUp() and tearDown() processing. DatabaseObject might
> look like:
>
> interface DatabaseObject {
> void doCreate(Connection conn);
> void doDrop(Connection conn);
> }
>
> I am thinking of a new test base class that tests relying on non-table
> db-object creation could extend; or even add this functionality to the
> existing TestCase. It would add a single new method "DatabaseObject[]
> getAdditionalDatabaseObjects(Dialect dialect)" which it would call
> during setUp() processing. The reason for this instead of just
> overriding setUp()/tearDown() would be to only execute this stuff when
> we actually rebuild the session fatory.
>
> The simple option would be to have each test class do this work
> themselves in setUp() and tearDown() for each test execution even
though
> we are not necessarily creating/dropping the schema at that frequency.
>
> Anyway, thoughts?
>
> Steve
>
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
