I just had the exact same problem connecting to Oracle. I am running JBoss 4.0.4 and in the server statup it shows that it is setting the servlet to not available because the connection to the database was refused.
Now the main problem with me was connecting remotley and my Oracle TNS not configured correctly, it is corrupt locally so having real problems with that.
The way it was sorted in the end was using a connection string to directly connect to Oracle (I am sure you can do something similar in MySQL or MSSQL)
This is my struts-config datasource, the URL property is where all the action is:
Also make sure you have these classes visible to the server; I have mine in the WEB-INF/lib directory:
The last 2 are Oracle specific I think.
commons-pool-1.3.jar commons-collections-3.2.jar jdbc2_0-stdext.jar classes12.jar [ June 23, 2006: Message edited by: Martin Thorpe ]
Joined: Oct 14, 2004
Thanks Martin, I will give it a try and let you know the results
subject: Cannot Connect Struts web app to remote sql database