I'm not sure what problem you are experiencing, but I am pretty sure that it is not recommended that you use the GenericDataSource. I switched my last project to use Jakarta's DBCP (http://jakarta.apache.org/commons/dbcp/) and found it pretty easy to use. This was a Tomcat implementation on MySQL, but if it is helpful, I can send you a snippet from my server.xml which would be applicable to how you would do your sql server.
Mike -----Original Message----- From: dario [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:56 AM To: [EMAIL PROTECTED] Subject: sql server datasource - howto? i configured sql server datasource in struts-config <data-sources> <data-source key="SqlGordon" type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"> <set-property property="ServerName" value="Gordon"/> <set-property property="DatabaseName" value="lanaco"/> <set-property property="User" value="sa"/> <set-property property="Password" value="sa"/> </data-source> </data-sources> but when i try to instantiate DataSource object in my action ds = getDataSource(request); struts complains that it can not find GenericDataSource. (legacy package is not in the classpath) do i need GenericDatasource at all? i thought i can live without it since SQLServerDataSource implements DataSource interface. thankyou! dario --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
