I'm using the internal connection pool and the Tx Data Source of bea
weblogic 7.
At the moment I configured 4 connections at a maximum. And it is only me who
accesses the application at the moment. After opening 4 tables, weblogic
throws that exception:
Nested Exception: java.sql.SQLException: Pool connect failed:
weblogic.common.ResourceException: None available
Using Oracle DBA Studio, I see 4 inactive connections (you can even the
select strings which were executed on the tables which I opened with my
browser).
When debugging my application and dbforms, I can see that all connections
are closed during the request. Seems not to be a dbforms problem. It is
annoying anyway.
Anyone any ideas?
Regards,
Jan.
> No, there is no missing close(). Connection stays open until
> - you refetch page
> - you have got all data
> - you get an session time out.
>
> Which connection pool do you use?
> How many pages do you open simutaniously?
>
> Cheers
> Henner
>
>
> > Could it be possible that there is missing a
> > finally {
> > close();
> > }
> > in DataSource.getCurrent();
> >
> > I ask because I run out of connections when using the
> > connection pool on bea weblogic 7. Don't know if that is the reason.
> >
> > Regards,
> > Jan.
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: IBM Linux Tutorials
> > Free Linux tutorial presented by Daniel Robbins, President
> > and CEO of GenToo technologies. Learn everything from
> > fundamentals to system
> > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> > _______________________________________________
> > DbForms Mailing List
> >
> http://www.wap-force.net/dbforms
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> DbForms Mailing List
>
> http://www.wap-force.net/dbforms
>
--
+++ NEU bei GMX und erstmalig in Deutschland: T�V-gepr�fter Virenschutz +++
100% Virenerkennung nach Wildlist. Infos: http://www.gmx.net/virenschutz
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms