...
| Code Block |
|---|
<resource-def>
<url>YOUR database Url HERE</url>
<driver>YOUR driver HERE</driver>
<user>YOUR database user HERE</user>
<password>YOUR password HERE</password>
</resource-def> |
The <resource-def> defines the database connection inside the database connector itself.
| Note |
|---|
Under most operating systems the database connector will automatically reload the configuration.xml as soon as you edit and save changes, without the need to restart tomcat or the database connector itself. However under Mac OS auto reload does not work. To ensure that the change is reflected restart tomcat manually via the stop/start scripts. |
Configuring a <resource-ref>
There is an alternate approach that defines the database connection in the application container (Tomcat if you are using the frevvo-tomcat bundle) instead of inside the database connector. To use this approach:
- Edit <frevvo-home>\tomcat\conf\Catalina\localhost\context.xml.default.
- Define a <resource> as shown below.
- Replace the <resource-def> element shown above in configuration.xml with a <resource-ref> element as shown below.
The XML samples below assume a MySql database driver. You will need to replace this sample values to match your database type.
This is the format of the <resource> element in context.xml.default.
| Code Block |
|---|
<Resource name="jdbc/mystore_ds"
auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
username="root"
password="root"
type="javax.sql.DataSource"
url="jdbc:mysql://localhost/mystore?autoconnect=true"/> |
This is the format of the <resource-def> element in configuration.xml.
| Code Block |
|---|
<resource-ref>
<description>MySQL Customers</description>
<res-ref-name>jdbc/mystore_ds</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref> |
mySQL example
A mySql database named "test" running on localhost on the default port when the login for user "root" requires no password:
...