File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Struts and MS SQL 2000

Carla carmona

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-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value=""/>

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

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
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:
subject: Struts and MS SQL 2000
It's not a secret anymore!