Herv� Guidetti wrote:
>
> Hi all,
>
> I am trying Castor to probally use it in our projects.
> I read the doc and try the examples, but I still have some questions.
>
> 1. For some specific applications, I would like to create my own SQL
> query. It is possible to get the JDBC connection from the Database
> Object to directly execute my SQL ? (I don't want to define twice the
> connection parameter. They are already in the database.xml).
The OQL parser has enhancements to support native SQL similar to the
support for stored procedures (see
http://castor.exolab.org/list-archive/msg07913.html). Also see line #440
of src/main/org/exolab/castor/jdo/engine/SQLEngine.java in castor-0.9.3
to present CVS for the implementation. I've not used it but I know it's
there. Thanks to Thorsten Mauch for its creation and Thomas Yip for its
implementation.
>
> 2. Is there a simple way to create the persistant objects (for example
> from an XML file [mapping.xml]) ?
Need more information... Persistent objects are created via some type of
client code and committed to persistence via Castor.
>
> 3. Is there a simple way to generate the database SQL file (for example
> from the same XML file) ?
The only one that I know if is here:
http://pages.infinit.net/bansi/home.html.
>
> 4. Is it possible to connect with native drivers in spite of JDBC
> drivers ?
There is not method of connecting with native drivers, however, to
connect to Oracle I have used both the type 2 and type 4 JDBC drivers
from Oracle.
>
> Thanks for your help.
>
> Herv� G.
>
--
Bruce Snyder
Software Engineer
I W I T N E S S, Inc.
Mitigating the regulatory and legal risks
associated with doing business digitally.
+1 303-545-9000 x126 Office
+1 303-545-9155 Fax
2995 Wilderness Pl., Suite 2N
Boulder, CO 80301 USA
http://www.iwitness.com
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
