Meaningless Drivel is fun!
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 REST with Spring (video course) this week in the Spring forum!
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!