You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Andoni <an...@indigo.ie> on 2003/08/06 20:51:31 UTC
Re: Tomcat Conn Pooling in 4.0.4 - Last queston...!
One last question:
Do you all use:
<Resource name="jdbc/animo" auth="Container"
type="javax.sql.DataSource"/>
Or do you call a different "type". Such as javax.sql.PooledDataSource
Andoni.
----- Original Message -----
From: "Shapira, Yoav" <Yo...@mpi.com>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Wednesday, August 06, 2003 7:28 PM
Subject: RE: Tomcat Conn Pooling in 4.0.4 - Very Slow?
Howdy,
<doh> Sorry about that, I was assuming tomcat 4.1.
Maybe you can use DBCP with 4.0.x.
Yoav Shapira
Millennium ChemInformatics
>-----Original Message-----
>From: Andoni [mailto:andoni@indigo.ie]
>Sent: Wednesday, August 06, 2003 1:51 PM
>To: Tomcat Users List
>Subject: Re: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>
>I am afraid Tomcat 4.0.4 does not have DBCP.
>
>It uses Tyrex instead.
>I have found from: http://tyrex.sourceforge.com/tomcat.html that I
should
>be using:
>tyrex.resource.jdbc.xa.EnabledDataSource
>
>But my .jar file for Tyrex only seems to have:
>tyrex.jdbc.xa.EnabledDataSource
>so I am using this instead.
>
>I also have a class in my oracle driver's .jar archive called:
>oracle/jdbc/pool/OracleDataSource.class
>and another called:
>oracle/jdbc/pool/OracleConnectionPoolDataSource.class
>
>So I might try these also.
>
>I think I have a pdf manual for that Oracle JDBC driver somewhere I'll
look
>that up.
>
>Have you any thoughts? Should I install commons DBCP?
>
>Andoni.
>
>
>----- Original Message -----
>From: "Shapira, Yoav" <Yo...@mpi.com>
>To: "Tomcat Users List" <to...@jakarta.apache.org>
>Sent: Wednesday, August 06, 2003 6:27 PM
>Subject: RE: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>
>
>
>Howdy,
>
>>Factory? What is a factory? What does it look like?
>
>It's a class implementing the GoF Factory pattern.
>
>>I thought what I had below WAS a factory? is having DataSource there
>not
>>good enough?
>
>No.
>
>>What's below is exactly what my Tomcat book has!!
>
>Your book could be out of date or incorrect.
>
>>Can you please help?
>
>Add this parameter to your server.xml:
>
><parameter>
> <name>factory</name>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
></parameter>
>
>And read the JNDI DataSource HOW-TO in the tomcat docs.
>
>Yoav Shapira
>
>
>
>This e-mail, including any attachments, is a confidential business
>communication, and may contain information that is confidential,
>proprietary
>and/or privileged. This e-mail is intended only for the individual(s)
to
>whom it is addressed, and may not be saved, copied, printed, disclosed
or
>used by anyone else. If you are not the(an) intended recipient, please
>immediately delete this e-mail from your computer system and notify the
>sender. Thank you.
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential, proprietary
and/or privileged. This e-mail is intended only for the individual(s) to
whom it is addressed, and may not be saved, copied, printed, disclosed or
used by anyone else. If you are not the(an) intended recipient, please
immediately delete this e-mail from your computer system and notify the
sender. Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Tomcat Conn Pooling in 4.0.4 - My thanks...!
Posted by Andoni <an...@indigo.ie>.
Kwok Peng Tuck
Yoav Shapira
Jose Euclides da Silva Junior
Thank you all so much. My project was on the brink of being set back by a
month if the connection pooling feature had to be removed and you saved me.
With some of the straightest answers I have ever received on this list.
Thanks and regards,
Andoni.
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Tomcat Conn Pooling in 4.0.4 - My thanks...!
Posted by Andoni <an...@indigo.ie>.
Kwok Peng Tuck
Yoav Shapira
Jose Euclides da Silva Junior
Thank you all so much. My project was on the brink of being set back by a
month if the connection pooling feature had to be removed and you saved me.
With some of the straightest answers I have ever received on this list.
Thanks and regards,
Andoni.
Re: Tomcat Conn Pooling in 4.0.4 - Last queston...!
Posted by Kwok Peng Tuck <pe...@makmal.net>.
I think it has to be javax.sql.DataSource
Andoni wrote:
>One last question:
>
>Do you all use:
>
> <Resource name="jdbc/animo" auth="Container"
>type="javax.sql.DataSource"/>
>
>Or do you call a different "type". Such as javax.sql.PooledDataSource
>
>Andoni.
>
>
>----- Original Message -----
>From: "Shapira, Yoav" <Yo...@mpi.com>
>To: "Tomcat Users List" <to...@jakarta.apache.org>
>Sent: Wednesday, August 06, 2003 7:28 PM
>Subject: RE: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>
>
>
>Howdy,
><doh> Sorry about that, I was assuming tomcat 4.1.
>
>Maybe you can use DBCP with 4.0.x.
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
>
>
>>-----Original Message-----
>>From: Andoni [mailto:andoni@indigo.ie]
>>Sent: Wednesday, August 06, 2003 1:51 PM
>>To: Tomcat Users List
>>Subject: Re: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>>
>>I am afraid Tomcat 4.0.4 does not have DBCP.
>>
>>It uses Tyrex instead.
>>I have found from: http://tyrex.sourceforge.com/tomcat.html that I
>>
>>
>should
>
>
>>be using:
>>tyrex.resource.jdbc.xa.EnabledDataSource
>>
>>But my .jar file for Tyrex only seems to have:
>>tyrex.jdbc.xa.EnabledDataSource
>>so I am using this instead.
>>
>>I also have a class in my oracle driver's .jar archive called:
>>oracle/jdbc/pool/OracleDataSource.class
>>and another called:
>>oracle/jdbc/pool/OracleConnectionPoolDataSource.class
>>
>>So I might try these also.
>>
>>I think I have a pdf manual for that Oracle JDBC driver somewhere I'll
>>
>>
>look
>
>
>>that up.
>>
>>Have you any thoughts? Should I install commons DBCP?
>>
>>Andoni.
>>
>>
>>----- Original Message -----
>>From: "Shapira, Yoav" <Yo...@mpi.com>
>>To: "Tomcat Users List" <to...@jakarta.apache.org>
>>Sent: Wednesday, August 06, 2003 6:27 PM
>>Subject: RE: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>>
>>
>>
>>Howdy,
>>
>>
>>
>>>Factory? What is a factory? What does it look like?
>>>
>>>
>>It's a class implementing the GoF Factory pattern.
>>
>>
>>
>>>I thought what I had below WAS a factory? is having DataSource there
>>>
>>>
>>not
>>
>>
>>>good enough?
>>>
>>>
>>No.
>>
>>
>>
>>>What's below is exactly what my Tomcat book has!!
>>>
>>>
>>Your book could be out of date or incorrect.
>>
>>
>>
>>>Can you please help?
>>>
>>>
>>Add this parameter to your server.xml:
>>
>><parameter>
>> <name>factory</name>
>> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>></parameter>
>>
>>And read the JNDI DataSource HOW-TO in the tomcat docs.
>>
>>Yoav Shapira
>>
>>
>>
>>This e-mail, including any attachments, is a confidential business
>>communication, and may contain information that is confidential,
>>proprietary
>>and/or privileged. This e-mail is intended only for the individual(s)
>>
>>
>to
>
>
>>whom it is addressed, and may not be saved, copied, printed, disclosed
>>
>>
>or
>
>
>>used by anyone else. If you are not the(an) intended recipient, please
>>immediately delete this e-mail from your computer system and notify the
>>sender. Thank you.
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>
>
>
>
>This e-mail, including any attachments, is a confidential business
>communication, and may contain information that is confidential, proprietary
>and/or privileged. This e-mail is intended only for the individual(s) to
>whom it is addressed, and may not be saved, copied, printed, disclosed or
>used by anyone else. If you are not the(an) intended recipient, please
>immediately delete this e-mail from your computer system and notify the
>sender. Thank you.
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>
>
Re: Tomcat Conn Pooling in 4.0.4 - Last queston...!
Posted by Kwok Peng Tuck <pe...@makmal.net>.
I think it has to be javax.sql.DataSource
Andoni wrote:
>One last question:
>
>Do you all use:
>
> <Resource name="jdbc/animo" auth="Container"
>type="javax.sql.DataSource"/>
>
>Or do you call a different "type". Such as javax.sql.PooledDataSource
>
>Andoni.
>
>
>----- Original Message -----
>From: "Shapira, Yoav" <Yo...@mpi.com>
>To: "Tomcat Users List" <to...@jakarta.apache.org>
>Sent: Wednesday, August 06, 2003 7:28 PM
>Subject: RE: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>
>
>
>Howdy,
><doh> Sorry about that, I was assuming tomcat 4.1.
>
>Maybe you can use DBCP with 4.0.x.
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
>
>
>>-----Original Message-----
>>From: Andoni [mailto:andoni@indigo.ie]
>>Sent: Wednesday, August 06, 2003 1:51 PM
>>To: Tomcat Users List
>>Subject: Re: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>>
>>I am afraid Tomcat 4.0.4 does not have DBCP.
>>
>>It uses Tyrex instead.
>>I have found from: http://tyrex.sourceforge.com/tomcat.html that I
>>
>>
>should
>
>
>>be using:
>>tyrex.resource.jdbc.xa.EnabledDataSource
>>
>>But my .jar file for Tyrex only seems to have:
>>tyrex.jdbc.xa.EnabledDataSource
>>so I am using this instead.
>>
>>I also have a class in my oracle driver's .jar archive called:
>>oracle/jdbc/pool/OracleDataSource.class
>>and another called:
>>oracle/jdbc/pool/OracleConnectionPoolDataSource.class
>>
>>So I might try these also.
>>
>>I think I have a pdf manual for that Oracle JDBC driver somewhere I'll
>>
>>
>look
>
>
>>that up.
>>
>>Have you any thoughts? Should I install commons DBCP?
>>
>>Andoni.
>>
>>
>>----- Original Message -----
>>From: "Shapira, Yoav" <Yo...@mpi.com>
>>To: "Tomcat Users List" <to...@jakarta.apache.org>
>>Sent: Wednesday, August 06, 2003 6:27 PM
>>Subject: RE: Tomcat Conn Pooling in 4.0.4 - Very Slow?
>>
>>
>>
>>Howdy,
>>
>>
>>
>>>Factory? What is a factory? What does it look like?
>>>
>>>
>>It's a class implementing the GoF Factory pattern.
>>
>>
>>
>>>I thought what I had below WAS a factory? is having DataSource there
>>>
>>>
>>not
>>
>>
>>>good enough?
>>>
>>>
>>No.
>>
>>
>>
>>>What's below is exactly what my Tomcat book has!!
>>>
>>>
>>Your book could be out of date or incorrect.
>>
>>
>>
>>>Can you please help?
>>>
>>>
>>Add this parameter to your server.xml:
>>
>><parameter>
>> <name>factory</name>
>> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>></parameter>
>>
>>And read the JNDI DataSource HOW-TO in the tomcat docs.
>>
>>Yoav Shapira
>>
>>
>>
>>This e-mail, including any attachments, is a confidential business
>>communication, and may contain information that is confidential,
>>proprietary
>>and/or privileged. This e-mail is intended only for the individual(s)
>>
>>
>to
>
>
>>whom it is addressed, and may not be saved, copied, printed, disclosed
>>
>>
>or
>
>
>>used by anyone else. If you are not the(an) intended recipient, please
>>immediately delete this e-mail from your computer system and notify the
>>sender. Thank you.
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>
>
>
>
>This e-mail, including any attachments, is a confidential business
>communication, and may contain information that is confidential, proprietary
>and/or privileged. This e-mail is intended only for the individual(s) to
>whom it is addressed, and may not be saved, copied, printed, disclosed or
>used by anyone else. If you are not the(an) intended recipient, please
>immediately delete this e-mail from your computer system and notify the
>sender. Thank you.
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org