This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
Similar Threads
Cant connect to MSSQL 2005
Struts, DBCP weird problem
Connect to MSSQL Server
getting error in connection pooling
Cannot Connect Struts web app to remote sql database