aspose file tools*
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
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