take a look a the log file localhost_log.txt perhaps there is a startup failure when reading out the struts-config.xml file which prevents struts from loading the db correctly. verify also the classpath settings for the db jar files (mm.mysql-2.0.4-bin.jar and jdbc2_0-stdext.jar ) -----Ursprüngliche Nachricht----- Von: Bradley Cowen [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 21. August 2001 01:36 An: [EMAIL PROTECTED] Betreff: RE: cannot find the datasource in struts? I can show you an example of what i'm using (MySQL): In struts-config.xml: <data-sources> <data-source> <set-property property="autoCommit" value="false"/> <set-property property="description" value="MySQL"/> <set-property property="driverClass" value="org.gjt.mm.mysql.Driver"/> <set-property property="maxCount" value="4"/> <set-property property="minCount" value="2"/> <set-property property="password" value="pass"/> <set-property property="url" value="jdbc:mysql://localhost:3306/test"/> <set-property property="user" value="servlet"/> </data-source> </data-sources> Then, you can set up a TestAction.java action class with a perform method like this: public final class TestAction extends Action { public ActionForward perform(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { Connection connection = null; DataSource dataSource = null; Statement statement = null; ResultSet resultSet = null; try { dataSource = servlet.findDataSource(null); connection = dataSource.getConnection(); statement = connection.createStatement(); resultSet = statement.executeQuery("SELECT FirstName,LastName FROM People " + "ORDER BY LastName,FirstName"); resultSet.close(); // just a test } catch (SQLException sqle) { getServlet().log("Connection.process", sqle); } finally { //always close connection try { connection.close(); } catch (SQLException e) { getServlet().log("Connection.close", e); } } // Forward control to the specified success URI return (mapping.findForward("success")); } } // end TestAction HTH, -Brad -----Original Message----- From: Manish Pandya [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 3:06 PM To: [EMAIL PROTECTED] Subject: cannot find the datasource in struts? a newbie in using struts... kindly let me know what i should be doing to define a datasource.. i have the struts-config.xml file where i defined the datasource parameters... and now i m trying to run the example provided in the struts.... but it is throwing error javax.sql.DataSource not found... is there anything that i m missing? let me know please...