On 2002.12.26 13:11:25 -0500 Andrew wrote:
>   Sorry, but I thought that exists hierarchical relationship between
> connection/statement/resultset objects so if I close connection it frees
> related statement/resultset objects or it dosen't?

My understanding is that the jdbc spec requires this but that many jdbc
drivers do not successfully implement it.

in any case, closing a connection handle from a jboss datasource does not
close the underlying connection. I will look into what the jboss wrapper
does: as you point out it should close all the statements.

Thanks
david jencks

> 
> Thanks.
> ----- Original Message -----
> From: "David Jencks" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, December 26, 2002 4:28 PM
> Subject: Re: [JBoss-user] Error in Managed connections
> 
> 
> > JBoss version??
> >
> > I think the most popular way of getting this is to forget to close all
> your
> > connections in finally blocks:
> >
> > Connection c = ds.getConnection();
> > try {
> > PreparedStatement ps = ...
> > try {
> > ...
> > ResultSet rs = ...
> > try {
> > ...
> > } finally { rs.close(); }
> > } finally { ps.close(); }
> > } fianlly { c.close(); }
> >
> > david jencks
> >
> > On 2002.12.26 04:39:38 -0500 Thaer Hani Al-Ibaisi wrote:
> > > Please to help me in the following problem: I have been able to
> connect
> > > to
> > > SQL server 2000 (thx for all who helped me in that in this list), but
> > > when I
> > > ran my application I had this exception :
> > >
> > > "No ManagedConnections Available!; - nested throwable:
> > > (javax.resource.ResourceException: No ManagedConnections Available!)"
> > >
> > > what is the solution, thx for quick responding.
> > >
> > >
> > >
> > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > <HTML><HEAD>
> > > <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
> charset=iso-8859-1">
> > >
> > >
> > > <META content="MSHTML 6.00.2800.1126" name=GENERATOR></HEAD>
> > > <BODY>
> > > <DIV><SPAN class=625073609-26122002><FONT face=Arial size=2>Please to
> > > help me in
> > > the following problem: I have been able to connect to SQL server 2000
> > > (thx for
> > > all who helped me in that in this list), but when I ran my
> application I
> > > had
> > > this exception :</FONT></SPAN></DIV>
> > > <DIV><SPAN class=625073609-26122002><FONT face=Arial
> > > size=2></FONT></SPAN>&nbsp;</DIV>
> > > <DIV><SPAN class=625073609-26122002>"</SPAN>No ManagedConnections
> > > Available!; -
> > > nested throwable: (javax.resource.ResourceException: No
> > > ManagedConnections
> > > Available!)<SPAN class=625073609-26122002>"</SPAN></DIV>
> > > <DIV><SPAN class=625073609-26122002></SPAN>&nbsp;</DIV>
> > > <DIV><SPAN class=625073609-26122002><FONT face=Arial size=2>what is
> the
> > > solution, thx for quick responding.</FONT></SPAN></DIV>
> > > <DIV><SPAN class=625073609-26122002><FONT face=Arial
> > > size=2></FONT></SPAN>&nbsp;</DIV>
> > > <DIV><SPAN class=625073609-26122002></SPAN>&nbsp;</DIV></BODY></HTML>
> > >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to