You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by bu...@apache.org on 2001/07/19 19:36:12 UTC
[Bug 2190] - unable to use connection pooling in esql
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=2190
*** shadow/2190 Thu Jun 14 15:25:45 2001
--- shadow/2190.tmp.5202 Thu Jul 19 10:36:12 2001
***************
*** 74,76 ****
--- 74,80 ----
------- Additional Comments From karl_hallowell@hp.com 2001-06-14 15:25 -------
Created an attachment (id=227)
last 1300 lines of cocoon.log. Exceptions start occuring near begining.
+
+
+ ------- Additional Comments From karl_hallowell@hp.com 2001-07-19 10:36 -------
+ This problem isn't appearing when the database driver is set to HSQL.
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: NEW FAQ ENTRY--Re: [Bug 2190] - unable to use connection pooling
in esql
Posted by Sylvain Wallez <sy...@anyware-tech.com>.
Berin Loritsch a écrit :
>
> Davanum Srinivas wrote:
> >
<snip/>
> > >
> > > What about allowing to optionally specify the driver class name in the
> > > datasource configuration ?
> >
> > +1. How about post Beta2?
>
> Actually, that requires a change to Avalon Excalibur--I can commit it to
> CVS now. The new configuration element will be <driver>.
>
> <jdbc name="personnel">
> <driver>oracle.jdbc.driver.OracleDriver</driver>
> <dburl>jdbc:oracle:thin:@host:1521:ORCL</dburl>
> </jdbc>
Great ! +1.
--
Sylvain Wallez
Anyware Technologies - http://www.anyware-tech.com
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: [C2][Beta2] Does Avalon Excalibur in CVS honor entry for
JDBC?
Posted by Berin Loritsch <bl...@apache.org>.
Davanum Srinivas wrote:
>
> Berin,
>
> Is this already in?
Not unless someone built Avalon Excalibur any time soon.
>
> Thanks,
> dims
>
> --- Berin Loritsch <bl...@apache.org> wrote:
> > Davanum Srinivas wrote:
> > >
> > > > > The most common reason for this exception is that the driver was not loaded.
> > > > > Cocoon uses an initial parameter in the "web.xml" file to automatically load
> > > > > classes on startup. This way, the class is loaded only once and the
> > > > > server's
> > > > > time is spent doing more productive things. Make sure the following entry
> > > > > is in your "web.xml" file:
> > > > >
> > > > > <init-param>
> > > > > <param-name>load-class</param-name>
> > > > > <param-value>
> > > > > <!-- comma or whitespace separated list of fully qualified class names
> > > > > to load on startup.
> > > > > -->
> > > > > oracle.jdbc.driver.OracleDriver
> > > > > </param-value>
> > > > > </init-param>
> > > > >
> > > > > If the class is loaded correctly, and you are still getting this error,
> > > > > then there
> > > > > is probably an error in your connection information. The SQLException
> > > > > above is thrown when there are no open connections to the database.
> > > > >
> > > >
> > > > Even if placing JDBC drivers in the load-class param can be justified
> > > > from a design point of view (it's loaded only once, it's a deployment
> > > > parameter, etc), it appears that it is confusing users. This is mainly
> > > > because nearly all tools that rely on a JDBC connection (including C1)
> > > > ask for the JDBC url and driver class at the same time or place.
> > > >
> > > > What about allowing to optionally specify the driver class name in the
> > > > datasource configuration ?
> > >
> > > +1. How about post Beta2?
> >
> > Actually, that requires a change to Avalon Excalibur--I can commit it to
> > CVS now. The new configuration element will be <driver>.
> >
> > <jdbc name="personnel">
> > <driver>oracle.jdbc.driver.OracleDriver</driver>
> > <dburl>jdbc:oracle:thin:@host:1521:ORCL</dburl>
> > </jdbc>
>
> > ATTACHMENT part 2 application/x-pkcs7-signature name=smime.p7s
>
> =====
> Davanum Srinivas, JNI-FAQ Manager
> http://www.jGuru.com/faq/JNI
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org
[C2][Beta2] Does Avalon Excalibur in CVS honor entry for JDBC?
Posted by Davanum Srinivas <di...@yahoo.com>.
Berin,
Is this already in?
Thanks,
dims
--- Berin Loritsch <bl...@apache.org> wrote:
> Davanum Srinivas wrote:
> >
> > > > The most common reason for this exception is that the driver was not loaded.
> > > > Cocoon uses an initial parameter in the "web.xml" file to automatically load
> > > > classes on startup. This way, the class is loaded only once and the
> > > > server's
> > > > time is spent doing more productive things. Make sure the following entry
> > > > is in your "web.xml" file:
> > > >
> > > > <init-param>
> > > > <param-name>load-class</param-name>
> > > > <param-value>
> > > > <!-- comma or whitespace separated list of fully qualified class names
> > > > to load on startup.
> > > > -->
> > > > oracle.jdbc.driver.OracleDriver
> > > > </param-value>
> > > > </init-param>
> > > >
> > > > If the class is loaded correctly, and you are still getting this error,
> > > > then there
> > > > is probably an error in your connection information. The SQLException
> > > > above is thrown when there are no open connections to the database.
> > > >
> > >
> > > Even if placing JDBC drivers in the load-class param can be justified
> > > from a design point of view (it's loaded only once, it's a deployment
> > > parameter, etc), it appears that it is confusing users. This is mainly
> > > because nearly all tools that rely on a JDBC connection (including C1)
> > > ask for the JDBC url and driver class at the same time or place.
> > >
> > > What about allowing to optionally specify the driver class name in the
> > > datasource configuration ?
> >
> > +1. How about post Beta2?
>
> Actually, that requires a change to Avalon Excalibur--I can commit it to
> CVS now. The new configuration element will be <driver>.
>
> <jdbc name="personnel">
> <driver>oracle.jdbc.driver.OracleDriver</driver>
> <dburl>jdbc:oracle:thin:@host:1521:ORCL</dburl>
> </jdbc>
> ATTACHMENT part 2 application/x-pkcs7-signature name=smime.p7s
=====
Davanum Srinivas, JNI-FAQ Manager
http://www.jGuru.com/faq/JNI
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: NEW FAQ ENTRY--Re: [Bug 2190] - unable to use connection pooling
in esql
Posted by Berin Loritsch <bl...@apache.org>.
Davanum Srinivas wrote:
>
> > > The most common reason for this exception is that the driver was not loaded.
> > > Cocoon uses an initial parameter in the "web.xml" file to automatically load
> > > classes on startup. This way, the class is loaded only once and the
> > > server's
> > > time is spent doing more productive things. Make sure the following entry
> > > is in your "web.xml" file:
> > >
> > > <init-param>
> > > <param-name>load-class</param-name>
> > > <param-value>
> > > <!-- comma or whitespace separated list of fully qualified class names
> > > to load on startup.
> > > -->
> > > oracle.jdbc.driver.OracleDriver
> > > </param-value>
> > > </init-param>
> > >
> > > If the class is loaded correctly, and you are still getting this error,
> > > then there
> > > is probably an error in your connection information. The SQLException
> > > above is thrown when there are no open connections to the database.
> > >
> >
> > Even if placing JDBC drivers in the load-class param can be justified
> > from a design point of view (it's loaded only once, it's a deployment
> > parameter, etc), it appears that it is confusing users. This is mainly
> > because nearly all tools that rely on a JDBC connection (including C1)
> > ask for the JDBC url and driver class at the same time or place.
> >
> > What about allowing to optionally specify the driver class name in the
> > datasource configuration ?
>
> +1. How about post Beta2?
Actually, that requires a change to Avalon Excalibur--I can commit it to
CVS now. The new configuration element will be <driver>.
<jdbc name="personnel">
<driver>oracle.jdbc.driver.OracleDriver</driver>
<dburl>jdbc:oracle:thin:@host:1521:ORCL</dburl>
</jdbc>
Re: NEW FAQ ENTRY--Re: [Bug 2190] - unable to use connection pooling in esql
Posted by Davanum Srinivas <di...@yahoo.com>.
> > The most common reason for this exception is that the driver was not loaded.
> > Cocoon uses an initial parameter in the "web.xml" file to automatically load
> > classes on startup. This way, the class is loaded only once and the
> > server's
> > time is spent doing more productive things. Make sure the following entry
> > is in your "web.xml" file:
> >
> > <init-param>
> > <param-name>load-class</param-name>
> > <param-value>
> > <!-- comma or whitespace separated list of fully qualified class names
> > to load on startup.
> > -->
> > oracle.jdbc.driver.OracleDriver
> > </param-value>
> > </init-param>
> >
> > If the class is loaded correctly, and you are still getting this error,
> > then there
> > is probably an error in your connection information. The SQLException
> > above is thrown when there are no open connections to the database.
> >
>
> Even if placing JDBC drivers in the load-class param can be justified
> from a design point of view (it's loaded only once, it's a deployment
> parameter, etc), it appears that it is confusing users. This is mainly
> because nearly all tools that rely on a JDBC connection (including C1)
> ask for the JDBC url and driver class at the same time or place.
>
> What about allowing to optionally specify the driver class name in the
> datasource configuration ?
+1. How about post Beta2?
Thanks,
dims
=====
Davanum Srinivas, JNI-FAQ Manager
http://www.jGuru.com/faq/JNI
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: NEW FAQ ENTRY--Re: [Bug 2190] - unable to use connection pooling in
esql
Posted by Sylvain Wallez <sy...@anyware-tech.com>.
Berin Loritsch a écrit :
>
> Question:
>
> When I try to use the Connection pooling code, I get the following
> exception:
>
> Could not get the datasource java.sql.SQLException: You cannot
> get a Poolable before the pool is initialized
>
> What's going on?
>
> Answer:
>
> The most common reason for this exception is that the driver was not loaded.
> Cocoon uses an initial parameter in the "web.xml" file to automatically load
> classes on startup. This way, the class is loaded only once and the
> server's
> time is spent doing more productive things. Make sure the following entry
> is in your "web.xml" file:
>
> <init-param>
> <param-name>load-class</param-name>
> <param-value>
> <!-- comma or whitespace separated list of fully qualified class names
> to load on startup.
> -->
> oracle.jdbc.driver.OracleDriver
> </param-value>
> </init-param>
>
> If the class is loaded correctly, and you are still getting this error,
> then there
> is probably an error in your connection information. The SQLException
> above is thrown when there are no open connections to the database.
>
Even if placing JDBC drivers in the load-class param can be justified
from a design point of view (it's loaded only once, it's a deployment
parameter, etc), it appears that it is confusing users. This is mainly
because nearly all tools that rely on a JDBC connection (including C1)
ask for the JDBC url and driver class at the same time or place.
What about allowing to optionally specify the driver class name in the
datasource configuration ?
--
Sylvain Wallez
Anyware Technologies - http://www.anyware-tech.com
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
NEW FAQ ENTRY--Re: [Bug 2190] - unable to use connection pooling in esql
Posted by Berin Loritsch <bl...@apache.org>.
Question:
When I try to use the Connection pooling code, I get the following
exception:
Could not get the datasource java.sql.SQLException: You cannot
get a Poolable before the pool is initialized
What's going on?
Answer:
The most common reason for this exception is that the driver was not loaded.
Cocoon uses an initial parameter in the "web.xml" file to automatically load
classes on startup. This way, the class is loaded only once and the
server's
time is spent doing more productive things. Make sure the following entry
is in your "web.xml" file:
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- comma or whitespace separated list of fully qualified class names
to load on startup.
-->
oracle.jdbc.driver.OracleDriver
</param-value>
</init-param>
If the class is loaded correctly, and you are still getting this error,
then there
is probably an error in your connection information. The SQLException
above is thrown when there are no open connections to the database.
------------------------------------------------------------------------------
bugzilla@apache.org wrote:
>http://nagoya.apache.org/bugzilla/show_bug.cgi?id=2190
>
>*** shadow/2190 Thu Jun 14 15:25:45 2001
>--- shadow/2190.tmp.5202 Thu Jul 19 10:36:12 2001
>***************
>*** 74,76 ****
>--- 74,80 ----
> ------- Additional Comments From karl_hallowell@hp.com 2001-06-14 15:25 -------
> Created an attachment (id=227)
> last 1300 lines of cocoon.log. Exceptions start occuring near begining.
>+
>+
>+ ------- Additional Comments From karl_hallowell@hp.com 2001-07-19 10:36 -------
>+ This problem isn't appearing when the database driver is set to HSQL.
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
>For additional commands, email: cocoon-dev-help@xml.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org