Depends how your datasource is set up in jboss.jcml.
----- Original Message -----
From: "Russell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 12:08 AM
Subject: [JBoss-user] Connection pooling
>
> Hi all , i am using RedHat6.1 ,jdk1.3,postgresql7.0.1 and jboss2.1.
>
> I need some advice regarding the code below which in stateless session
> bean :
> My question is that if the connection below created are pooled ???
> Thanks wt.
>
>
> // code
>
> public int executeSQLStatement(String sqlstr){
>
> int key = 0;
> Connection conn = null;
> PreparedStatement ps = null;
> ResultSet rs = null;
>
> try{
>
> conn = this.getConnection() ;
> ps = conn.prepareStatement(sqlstr);
> rs = ps.executeQuery();
>
> if(rs.next()){
> key = rs.getInt("nextval");
> }
> }catch(Exception ce){
> ce.printStackTrace();
> }
> finally{
> try{
> if(rs != null) rs.close();
> if(ps != null) ps.close();
> if(conn != null) conn.close();
> }catch(SQLException se){
> se.printStackTrace();
> }
> }
>
> return key;
> }
>
> private Connection getConnection() throws SQLException{
> DataSource ds = null;
> try{
> Context ctx = new InitialContext();
> ds = (DataSource)ctx.lookup("java:comp/env/jdbc/PostgresDS");
> }
> catch(NamingException ne){
> ne.printStackTrace();
> }
> return ds.getConnection();
> }
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user