You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by "K.P.Majoor" <kp...@7bulls.com> on 2001/05/14 10:07:23 UTC
pooling problem seems simple, please help ...
Hi all,
I've been using Cocoon 1.8.1 for a while, and with great satisfaction
especially the esql taglib was very useful to me.
But I'm getting a bit more demanding and I'd like to use a pool for my
database connections. (Postgresql 7.1)
What I used to do is :
<esql:connection>
<esql:driver>org.postgresql.Driver</esql:driver>
<esql:dburl>jdbc:postgresql://localhost/knowledgebase</esql:dburl>
<esql:username>user</esql:username>
<esql:password>pass</esql:password>
.....
and it works perfect. (Great I must say :-) )
But I'd like to use pooling and changed my files to :
<esql:connection>
<esql:pool>kbpool</esql:pool>
.....
Altered the cocoon.properties file like this:
processor.xsp.pool.database.kbpool.driver=org.postgresql.Driver
processor.xsp.pool.database.kbpool.url=jdbc:postgresql://localhost:5432/knowledgebase
processor.xsp.pool.database.kbpool.username=user
processor.xsp.pool.database.kbpool.password=pass
processor.xsp.pool.database.kbpool.maxConnections=3
processor.xsp.pool.database.kbpool.expiryTime=3600000
processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBMM
processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instantdb.jdbc.idbDriver
processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver
processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver
processor.xsp.pool.logfile=/var/log/dbPool.log
Now when I try to access my pages I get the following error message :
Cocoon 1.8.2
Error found handling the request.
java.lang.RuntimeException: Error opening pooled connection: kbpool:
Database type org.postgresql.Driver not implemented.
So I thought that something in my cocoon.properties was set wrong or my
classpath (since the jdbc works fine without pooling). But I simply
don't have a clue what I am doing wrong here. Is it suspicious that the
/var/log/dbPool.log file stays empty? Does anyone have an idea, cuz I
simply don't have a clue anymore. And it seems that it is something
really simple.....?!!
Thanks already in advance,
Klaas-Pieter
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: SV: pooling problem seems simple, please help ...
Posted by "K.P.Majoor" <kp...@7bulls.com>.
Tried to put them both om postgresql.Driver, and both on
org.postgresql.Driver.
The first one gives me the Not implemented error as described in my
previous
message, and the latter comes up with a kbpool: No suitable driver error.
So matching them doesn't help in my case. Should they be the same though?
Still no solution :-(
P.S: Pal, sorry for replying to your personal address. It was a mistake!
Pal Wester wrote:
> > processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
> doesn't match with
> > processor.xsp.pool.database.kbpool.driver=org.postgresql.Driver
>
> mvh: Pal Wester <ma...@never.no>
> hogskoleingenor/programmerer
>
> > -----Opprinnelig melding-----
> > Fra: kpmajoor@warszawa.7bulls.com
> > [mailto:kpmajoor@warszawa.7bulls.com]Pa vegne av K.P.Majoor
> > Sendt: 14. mai 2001 10:07
> > Til: cocoon-users@xml.apache.org
> > Emne: pooling problem seems simple, please help ...
> >
> >
> > Hi all,
> >
> > I've been using Cocoon 1.8.1 for a while, and with great satisfaction
> > especially the esql taglib was very useful to me.
> > But I'm getting a bit more demanding and I'd like to use a pool for my
> > database connections. (Postgresql 7.1)
> > What I used to do is :
> >
> > <esql:connection>
> > <esql:driver>org.postgresql.Driver</esql:driver>
> > <esql:dburl>jdbc:postgresql://localhost/knowledgebase</esql:dburl>
> > <esql:username>user</esql:username>
> > <esql:password>pass</esql:password>
> > .....
> >
> > and it works perfect. (Great I must say :-) )
> >
> > But I'd like to use pooling and changed my files to :
> >
> > <esql:connection>
> > <esql:pool>kbpool</esql:pool>
> > .....
> >
> > Altered the cocoon.properties file like this:
> >
> > processor.xsp.pool.database.kbpool.driver=org.postgresql.Driver
> > processor.xsp.pool.database.kbpool.url=jdbc:postgresql://localhost
> > :5432/knowledgebase
> >
> > processor.xsp.pool.database.kbpool.username=user
> > processor.xsp.pool.database.kbpool.password=pass
> > processor.xsp.pool.database.kbpool.maxConnections=3
> > processor.xsp.pool.database.kbpool.expiryTime=3600000
> >
> > processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantD
> > B,DBPostgres,DBSybase,DBInformix,DBMM
> >
> > processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
> >
> > processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.Or
> > acleDriver
> >
> > processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instan
> > tdb.jdbc.idbDriver
> >
> > processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
> > processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver
> >
> > processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
> > processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver
> >
> > processor.xsp.pool.logfile=/var/log/dbPool.log
> >
> > Now when I try to access my pages I get the following error message :
> >
> > Cocoon 1.8.2
> > Error found handling the request.
> > java.lang.RuntimeException: Error opening pooled connection: kbpool:
> > Database type org.postgresql.Driver not implemented.
> >
> > So I thought that something in my cocoon.properties was set wrong or my
> > classpath (since the jdbc works fine without pooling). But I simply
> > don't have a clue what I am doing wrong here. Is it suspicious that the
> > /var/log/dbPool.log file stays empty? Does anyone have an idea, cuz I
> > simply don't have a clue anymore. And it seems that it is something
> > really simple.....?!!
> >
> > Thanks already in advance,
> >
> > Klaas-Pieter
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > Please check that your question has not already been answered in the
> > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
> >
> > To unsubscribe, e-mail: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
SV: pooling problem seems simple, please help ...
Posted by Pal Wester <pa...@florence.never.no>.
> processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
doesn't match with
> processor.xsp.pool.database.kbpool.driver=org.postgresql.Driver
mvh: Pal Wester <ma...@never.no>
hogskoleingenor/programmerer
> -----Opprinnelig melding-----
> Fra: kpmajoor@warszawa.7bulls.com
> [mailto:kpmajoor@warszawa.7bulls.com]Pa vegne av K.P.Majoor
> Sendt: 14. mai 2001 10:07
> Til: cocoon-users@xml.apache.org
> Emne: pooling problem seems simple, please help ...
>
>
> Hi all,
>
> I've been using Cocoon 1.8.1 for a while, and with great satisfaction
> especially the esql taglib was very useful to me.
> But I'm getting a bit more demanding and I'd like to use a pool for my
> database connections. (Postgresql 7.1)
> What I used to do is :
>
> <esql:connection>
> <esql:driver>org.postgresql.Driver</esql:driver>
> <esql:dburl>jdbc:postgresql://localhost/knowledgebase</esql:dburl>
> <esql:username>user</esql:username>
> <esql:password>pass</esql:password>
> .....
>
> and it works perfect. (Great I must say :-) )
>
> But I'd like to use pooling and changed my files to :
>
> <esql:connection>
> <esql:pool>kbpool</esql:pool>
> .....
>
> Altered the cocoon.properties file like this:
>
> processor.xsp.pool.database.kbpool.driver=org.postgresql.Driver
> processor.xsp.pool.database.kbpool.url=jdbc:postgresql://localhost
> :5432/knowledgebase
>
> processor.xsp.pool.database.kbpool.username=user
> processor.xsp.pool.database.kbpool.password=pass
> processor.xsp.pool.database.kbpool.maxConnections=3
> processor.xsp.pool.database.kbpool.expiryTime=3600000
>
> processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantD
> B,DBPostgres,DBSybase,DBInformix,DBMM
>
> processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
>
> processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.Or
> acleDriver
>
> processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instan
> tdb.jdbc.idbDriver
>
> processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
> processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver
>
> processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
> processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver
>
> processor.xsp.pool.logfile=/var/log/dbPool.log
>
> Now when I try to access my pages I get the following error message :
>
> Cocoon 1.8.2
> Error found handling the request.
> java.lang.RuntimeException: Error opening pooled connection: kbpool:
> Database type org.postgresql.Driver not implemented.
>
> So I thought that something in my cocoon.properties was set wrong or my
> classpath (since the jdbc works fine without pooling). But I simply
> don't have a clue what I am doing wrong here. Is it suspicious that the
> /var/log/dbPool.log file stays empty? Does anyone have an idea, cuz I
> simply don't have a clue anymore. And it seems that it is something
> really simple.....?!!
>
> Thanks already in advance,
>
> Klaas-Pieter
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>