Andreas,
please register the JDBC DataSource with Tomcat as explained in their docs by
defining a <Resource> entry in server.xml (or elsewhere as there are
alternatives, depending on whether deploy a WAR file or not). The DataSource
defined there will be bound to Tomcat's JNDI context at startup and will
be available to client programs under 'jdbc/MYDB'.
To make Castor use this JDBC DataSource (with pooling capabilities), please
incl. the following fragment in your jdo-conf.xml (formerly known as
database.xml) file:
<database ... >
<jndi name="java:comp/env/jdbc/MYDB" />
</database>
Also, don't forget to add a <resource-ref> entry to your web aplication in
web.xml.
Regards
Werner
On Wed, 15 Dec 2004 08:35:59 +0100, Andreas Vombach wrote:
>
>To do this following the tomcat doc I need to specify
>
> <Resource name="jdbc/MYDB" auth="Container"
> type="javax.sql.DataSource"
>driverClassName="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@dbip:1521:MYDB"
> username="user" password="pass" maxActive="20" maxIdle="10"
> maxWait="-1"/>
>
>in <tomcat-dir>/bin/server.xml
>
>How do I do the JNDI binding? Or do I have to follow the castor DBCP doc
>like
>
><data-source class-name="org.apache.commons.dbcp.BasicDataSource">
> <params driver-class-name="com.mysql.jdbc.Driver"
> username="test"
> password="test"
> url="jdbc:mysql://localhost/test"
> max-active="10" />
> </data-source>
>
>This would go into the database.xml file and appended by the mapping
>descriptor?
>
>Thanks for any help
>Andreas
>
>
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-user
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
