I am using Struts 1.1 and Tomcat 4.1.18 and MySQL 4.0.17. In \Tomcat\common\lib I have jdbc2_0-stdext.jar and as connector I use mysql-connector-java-3.0.9-stable-bin.jar which is located in JAVA_HOME\jre\lib\ext
The user <username> is granted all rights to a test-database and mysql test - u username -p connects to this database without problems. Struts-config.xml contains the following lines: <data-sources> <data-source key="test" type="javax.sql.DataSource"> <set-property property="autoCommit" value="true"/> <set-property property="driverClass" value="com.mysql.jdbc.Driver"/> <set-property property="maxCount" value="6"/> <set-property property="minCount " value="2"/> <set-property property="user" value="username"/> <set-property property="password" value="pasword"/> <set-property property="url" value="jdbc:mysql://localhost:3306/test"/> </data-source> </data-sources> At the end of web.xml, I have added the following lines: <resource-ref> <res-ref-name>jdbc/test</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> When I reload the application, tomcat\logs\stderr.log contains the following lines: java.lang.InstantiationException: javax.sql.DataSource at java.lang.Class.newInstance0(Class.java:293) at java.lang.Class.newInstance(Class.java:261) at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:23 1) ...... and when I try to run the application, the browser displays this message: The requested service (Servlet action is currently unavailable) is not currently available. When I remove the datasource, there are no problems. How can I check why instantiating of the DataSource fails and where do I make a mistake? Ben --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]