RES: Tomcat Conn Pooling in 4.0.4 - Very Slow?

[Jose Euclides da Silva Junior - DATAPREVRJ]

I guess that DBCP would be the better choice, since it is db platform
independency. I use it in 4.1.18 and its nice to me.
Eculides.

-Mensagem original-
De: Andoni [mailto:[EMAIL PROTECTED]
Enviada em: quarta-feira, 6 de agosto de 2003 14:51
Para: Tomcat Users List
Assunto: 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 [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
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
  namefactory/name
  valueorg.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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: RES: Tomcat Conn Pooling in 4.0.4 - Very Slow?

[Roman \Blade\ Velichko]

JEdSJD I guess that DBCP would be the better choice, since it is db platform
JEdSJD independency. I use it in 4.1.18 and its nice to me.
JEdSJD Eculides.
But DBCP throw an UnsupportedException when I try to
execute this portion if code:

try
{
   initCtx=new InitialContext();
   jndiDataSource=(DataSource) initCtx.lookup(java:comp/env/jdbc/gray/hr);
   Connection conn=jndiDataSource.getConnection(username,userpassword);
   // in this section conn is ALLWAYS NULL
}
catch(NamingException nameExcept)
{
   System.out.println(nameExcept.getMessage());
}


With best wishes
Roman Blade Velichko [mailto:[EMAIL PROTECTED]

Chance favour to prepared mind


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]