I see from the ebase documentation that I need to:
I have added the definition to the web.xml file, but am not sure whether I also need to "add the database to the web application context". I also can't figure out what I need to do to complete steps 2 and 3 given that "details vary by application server".1. Add the database to the web application context. Add a definition like the one below to the web.xml file in the Web-Inf directory for the Ebase web application.
<resource>
<description>Your database</description>
<res>jdbc/YOURDBNAME</res>
<res>javax.sql.XADataSource</res>
<res>Container</res>
</resource>
Ensure that the prefix jdbc/ is used in the resource reference name.
2. Add the datasource connection definition to the application server. Details vary according to the application server.
Note: if creating a connection to a MySQL database, include the parameter 'autoReconnect=true' in the JDBC URL. Failure to do this can lead to lost connections reported as SocketException errors.
3. Map the web application resource reference to the datasource definition. Details vary according to the application server.
Note that some application servers do not give you access to the xml files to allow you to complete the third step. You may need to expand and modify the supplied UFS.war file to add the resource definition in step 1 above, and then re-deploy this into your application server.
I can't find any further documentation of this.
I am using a standard ebase 4.2 setup plus MySQL 5.0.7 running on a standard WAMP server.
Help please?!