jQuery in Action, 3rd edition
The moose likes Struts and the fly likes Database Pooling in Struts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Database Pooling in Struts" Watch "Database Pooling in Struts" New topic

Database Pooling in Struts

Jose Esteban
Ranch Hand

Joined: Nov 28, 2004
Posts: 102
I'm following the tutorial from the book "Jakarta Struts Live� and I have problems connecting to my database (Struts 1.1):

This is the code inside the Action class:
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {

UserRegistrationForm userForm = (UserRegistrationForm) form;
DataSource dataSource = getDataSource(request, "userDB"); // *** ERROR: GETS A NULL ***
Connection conn = dataSource.getConnection();
The data-sources in struts-config.xml:
<data-source type="org.apache.commons.dbcp.BasicDataSource" key="userDB">
<set-property property="driverClassName" value="sun.jdbc.odbc.JdbcOdbcDriver" />
<set-property property="url" value="jdbc dbc atosStruts" />
<set-property property="username" value="jose" />
<set-property property="password" value="jose" />
The init-param in web.xml:

The problem seems to be that the code in the Action class (above)

DataSource dataSource = getDataSource(request, "userDB");

returns a null.

I've debugged the application and I've realized that, inside the Struts getDataSource method, the ServletContext doesn't contain the "userDB" attribute.

Any help?

Jose Esteban
Ranch Hand

Joined: Nov 28, 2004
Posts: 102
Never mind, everything was correct. It was my IDE which deleted the <data-source>.
I agree. Here's the link: http://aspose.com/file-tools
subject: Database Pooling in Struts
It's not a secret anymore!