If we just let them register something like the DatabaseObject mentioned
(keyed by dialect) I guess I'm fine with that.  Maybe something like:

<database-object class="MyTransactSQLTrigger ">
    <!-- optional "dialect scoping" -->
    <dialect class="o.h.d.SybaseDialect"/>
    <dialect class="o.h.d.SQLServerDialect"/>
</database-object>

<database-object class="MyPLSQLTrigger">
    <!-- optional "dialect scoping" -->
    <dialect class="o.h.d.OracleDialect"/>
    <dialect class="o.h.d.Oracle9Dialect"/>
</database-object>

Due to "export" feature, I guess DatabaseObject would really instead
need to expose the create/drop strings.

-----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

Reply via email to