File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes database connection in struts 1.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "database connection in struts 1.1" Watch "database connection in struts 1.1" New topic

database connection in struts 1.1

Ra Sh

Joined: Jun 17, 2003
Posts: 10
I am totally new to struts
I want to connect to database get result set and display result on jsp
Pls send me code for that
Tx for ur co operation
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

Are you using a DataSource and Connection Pooling? Are you creating the Connections manually everytime you need them? Have you tried anything? Are you getting errors?

GenRocket - Experts at Building Test Data
Padma Prasad
Ranch Hand

Joined: Sep 16, 2002
Posts: 76
Hi Gregg,
Donno if this is kinda intrusion but I am running into errors with the same issue. need your help. I am using struts 1.1/tomcat 4.0/oracle 8.1.7. This oracle is on a remote machine. I have a login page. Entering the values in this will check the DB and produce the result(general way ) I am using DataSource. The problem is after I enter the values, and submit them, I get an error page saying " HTTP Status 503 - Servlet action is currently unavailable
type Status report
message Servlet action is currently unavailable
description The requested service (Servlet action is currently unavailable) is not currently available.
I cannot track down why I get this error. I have all the classpath set in my local machine.(pointing to struts*.jar, rt.jar etc). Is this because my DB is located remotely? Do I need to add up any parameters for this? I have the DB info stored in struts-config.xml. Also, I connect to the DB through VPN.
Please help me out.
I agree. Here's the link:
subject: database connection in struts 1.1
It's not a secret anymore!