I have been unable to access a database as suggested in struts-example.war. I started with a working example that does not access a database, and made a single change: I added a <datasource> element to struts-config.xml. When I did that, the example at the first attempt to access the action servlet.
Here's a relevant snippet from Tomcat's localhost_log: ... 2002-04-04 13:09:59 StandardWrapper[/testapp:action]: Marking servlet action as unavailable 2002-04-04 13:09:59 StandardContext[/testapp]: Servlet /testapp threw load() exception javax.servlet.UnavailableException: Initializing application data source org.apache.struts.action.DATA_SOURCE at org.apache.struts.action.ActionServlet.initApplicationDataSources(ActionServlet.java:850) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:419) at javax.servlet.GenericServlet.init(GenericServlet.java:258) ... I've tried both versions of the <datasources> element: 1. Section 4.4 of the Users Guide <data-sources> <data-source autoCommit="false" driverClass="org.postgresql.Driver" maxCount="4" minCount="2" password="whatever" url="jdbc:postgresql:mystraw" user="postgres" /> </data-sources> 2. struts-example/WEB-INF/struts-config.xml version <data-sources> <data-source> <set-property property="autoCommit" value="false"/> <set-property property="driverClass" value="org.postgresql.Driver"/> <set-property property="maxCount" value="4"/> <set-property property="minCount" value="2"/> <set-property property="password" value="whatever"/> <set-property property="url" value="jdbc:postgresql:mystraw"/> <set-property property="user" value="postgres"/> </data-source> </data-sources> To check that my setup is OK, I wrote the following class. It runs fine. ****** import java.sql.*; import org.apache.struts.util.*; public class Pgtest2 { public static void main(String[] args) { try { // I believe this is what struts uses ... GenericDataSource gds = new GenericDataSource(); // set all the properties from <datasource> element gds.setAutoCommit(false); gds.setDriverClass("org.postgresql.Driver"); gds.setMaxCount(2); gds.setMinCount(4); gds.setPassword("whatever"); gds.setUrl("jdbc:postgresql:mystraw"); gds.setUser("postgres"); // access database table and print to see whether it all works Connection con = gds.getConnection(); Statement stm = con.createStatement(); stm.setQueryTimeout(10); ResultSet rs = stm.executeQuery("select password from users"); rs.next(); System.out.println(rs.getString(1)); con.close(); } catch (Exception e) { System.out.println("Exception!"); System.out.println(e.toString()); } } } ****** I'm using standalone Tomcat-4.0.2, Struts-1.1-b1, Postgresql-7.2.1 with pgjdbc2.jar. Any suggestions? TIA, -- Mark Johnson [EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>