wood burning stoves*
The moose likes Struts and the fly likes Struts and MS SQL 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Struts and MS SQL 2000" Watch "Struts and MS SQL 2000" New topic
Author

Struts and MS SQL 2000

Carla carmona
Greenhorn

Joined: Oct 14, 2004
Posts: 14
Has anyone ever connected successfully a Struts based application with MS SQL 2000 ? If yes can you PLEASE help me do the same ? The datasource don�t seem to work with the values I am suppose to use :

<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>

<set-property property="url" value="jdbc:microsoft:sqlserver://SERVERNAME:1433;DatabaseName=newasb;User=asbsvc;Password=asbcvs1"/>
</data-source>
</data-sources>


I�ve tried many other variants from the above code, but nothing seems to work. Tomcat says the following:

"type Status report
message Servlet action is not available
description The requested resource (Servlet action is not available) is not available."

I am desperate not knowing what to do. I have mailed countless Java professionals, forums and nobody cames up with something that works. So if you have ever connected a Struts based web app with MS SQL 2000 PLEASE listen to my plea and answer this call.

Carla Carmona
Software Developer
SCJP
Dom Lassy
Ranch Hand

Joined: May 05, 2006
Posts: 181
I usually get the message "The requested resource (Servlet action is not available) is not available." when one of my configuration files is not valid. Run validation on web.xml, and struts-config.xml. See if there is an exception being thrown on server startup.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Struts and MS SQL 2000
 
Similar Threads
getting error in connection pooling
Struts, DBCP weird problem
Connect to MSSQL Server
Cannot Connect Struts web app to remote sql database
Cant connect to MSSQL 2005