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

Cannot create stmt more than once

Rajeev Motiani

Joined: Dec 09, 2003
Posts: 2
Environment: Created an struts application connected to MS Access. The conection created through JDBC-ODBC bridge using the Class for name ( driver) in java.

Issue: We are able to access the database through struts form the first time through JSP, however once we refresh or request the same page again, it creates the connection but cannot create the statement ie. the error comes at point stmt =con.createStatement();

We have checked the program works if we call the method from normal jsp-java rather than struts framework. What settings are misisng?
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63844

Since this appears to be Struts-specific, I'm moving this along to the Web Frameworks forum, where the Struts dudes hang out.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Cannot create stmt more than once
It's not a secret anymore!