File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connection instance from a JSP to a JavaBean 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 » Databases » JDBC and Relational Databases
Bookmark "Connection instance from a JSP to a JavaBean" Watch "Connection instance from a JSP to a JavaBean" New topic

Connection instance from a JSP to a JavaBean

Ulvi Cetin
Ranch Hand

Joined: Mar 03, 2003
Posts: 39
I have a Connection instance (that I got from a JDBCPool) in my JSP. Can I pass this instance to a JavaBean in the constructor of the bean (from my JSP) and have the bean use this connection (instead of creating its own connection instance)? May the below code cause any errors down the road where there are several connections to the database?
--JSP Code--
DBAccess dba = new DBAccess();
Connection con = null;
try {
con = dba.getConnection();
} catch (SQLException sqle) {
OrderedThreads ot = new OrderedThreads(con);
--JavaBean Constructor--
public Connection con = null;
public OrderedThreads(Connection cn) {
con = cn;
try {
stmt = con.createStatement();
} catch (SQLException sqle) {
W Sun

Joined: Apr 24, 2003
Posts: 6
When you load a bean to be used in a JSP page, you use jsp:useBean to do it. The bean class should be a class that has a zero-argument(empty) constructor and you use such a constructor to load the bean. So you can't use this constructor to load the bean: OrderedThreads(Connection cn) since it has parameter.
But you can do it this way (in your jsp file):
<jsp:useBean id="OrderedThreads" class="testPKG.OrderedThreads" scope="page"/>
OrderedThreads.setConnection(con); //setConnection(Connection con) is a method of OrderedThreads to set connection variable in OrderedThreads as the parameter;
I agree. Here's the link:
subject: Connection instance from a JSP to a JavaBean
It's not a secret anymore!