wood burning stoves 2.0*
The moose likes JDBC 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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection instance from a JSP to a JavaBean" Watch "Connection instance from a JSP to a JavaBean" New topic
Author

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?
Thx.
Example:
--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) {
sqle.printStackTrace();
}
W Sun
Greenhorn

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: http://aspose.com/file-tools
 
subject: Connection instance from a JSP to a JavaBean