RE: Who uses connection pool?

2002-03-05 Thread Julio Castillo 

I checked the Exolab.org website for an updated Tyrex, and noticed in their
Change Log that the last version released was 0.9.7 which is more than a
year old. I wonder if anyone is working on the 1.0 version.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev
Assinovsky
Sent: Tuesday, March 05, 2002 6:59 AM
To: Tomcat Users List
Subject: Re: Who uses connection pool?


Hello!
I followed your link and found out that example in there is slightly
incorrect. Identifier "dataSrc" is not declared.
Besides Tyrex people acknowledged that if your database doesn't support
pooling
then all you have is tyrex EnabledDataSource class without pool support.
I personally is waiting for tyrex-1.0.

King-On Yeung wrote:

> yes, i do.
>
> follow suggestion:
> http://mikal.org/interests/java/tomcat/archive/view?mesg=41226
>
> it works for JNDI + postgesql .
> --
>
> __
> Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
>
> --
> To unsubscribe:   
> For additional commands: 
> Troubles with the list: 

--
Lev AssinovskyPeterlink Web
ProgrammerSt. Petersburg, Russia
Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
E-mail: [EMAIL PROTECTED]




--
To unsubscribe:   
For additional commands: 
Troubles with the list: 




--
To unsubscribe:   
For additional commands: 
Troubles with the list:

RE: Who uses connection pool?

2002-03-05 Thread Julio Castillo 

I just downloaded Tomcat 4.0.3 and didn't see any Tyrex jar files. Are they
bundled inside Tomcat's jar files?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev
Assinovsky
Sent: Tuesday, March 05, 2002 1:37 AM
To: Tomcat Users List
Subject: Re: Who uses connection pool?


I already looked in there.
I was confused that their pool is for GSP.
Tomcat uses Tyrex by default. How about that?

Reynir H?bner wrote:

> sure
> check out bitmechanic.com, thats a fine place to start.
>
> -hope it helps
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > Sent: 5. mars 2002 09:09
> > To: 'Tomcat Users List'
> > Subject: Who uses connection pool?
> >
> >
> > Hi!
> > Could you tell me please,
> > does anybody successfully use database connection pool?
> >
> >
> > --
> > Lev AssinovskyPeterlink Web
> > ProgrammerSt. Petersburg, Russia
> > Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Ё
> > E-mail: [EMAIL PROTECTED]
> >
> >
> >
> >
> > --
> > To unsubscribe:   
> > For additional commands: 
> > Troubles with the list: 
> >
> >

--
Lev AssinovskyPeterlink Web
ProgrammerSt. Petersburg, Russia
Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
E-mail: [EMAIL PROTECTED]




--
To unsubscribe:   
For additional commands: 
Troubles with the list: 




--
To unsubscribe:   
For additional commands: 
Troubles with the list:

RE: Who uses connection pool?

2002-03-05 Thread Julio Castillo 

Is there any connection pool implementation that uses the
ConnectionPoolDataSource provided by the latest JDBC drivers?

** julio

-Original Message-
From: Jim Urban [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 8:27 AM
To: Tomcat Users List
Subject: RE: Who uses connection pool?


Here are some code fragments from our servlet (we use a single dispatcher
servlet):

public void init(ServletConfig iConfig) throws ServletException
{
super.init(iConfig);
...
initializeDbConnectionBroker(iConfig);
...
}

private void initializeDbConnectionBroker(ServletConfig iConfig)
{
String dbDriver = getInitParameter("DB_DRIVER");
String dbName = getInitParameter("DB_NAME");
String dbUser = getInitParameter("DB_USER");
String dbPassword = getInitParameter("DB_PSWD");
String logfile = getInitParameter("DB_LOG_FILE");
int initConn = new Integer(getInitParameter("DB_INITCONN")).intValue();
int maxConn = new Integer(getInitParameter(DB_"MAXCONN")).intValue();
int connTimeOut = new
Integer(getInitParameter("DB_CONNTIMEOUT")).intValue();
double maxConnTime = new
Double(getInitParameter("DB_MAXCONNTIME")).doubleValue();
try
{
logMessage("Initializing DB connection pool.");
ConnectionPool.initialize(dbDriver, dbName, dbUser, 
dbPassword, logfile,
initConn, maxConn, connTimeOut , maxConnTime);
logMessage("DB connection pool initialized.");
}
catch (Exception e)
{
logException(e, this);
logMessage("ConnectionPool.init error:  " + e.toString());
}
}


public class ConnectionPool extends Object
{
private static DbConnectionBroker myBroker = null;
private static int connTimeOut = 0;

public static void initialize(String DBDriver, String DBName, String
DBUser, String DBPsWd,
  String Logfile, int initConn, int maxConn, int 
iConnTimeOut, double
maxConnTime)
  throws IOException
{
if (DBDriver != null && DBDriver.length() > 0)
{
myBroker = new DbConnectionBroker(DBDriver, DBName, DBUser, 
DBPsWd,
initConn,
 maxConn, Logfile, 
maxConnTime);
connTimeOut = iConnTimeOut;
}
}

public static synchronized DbConnectionBroker getBroker()
{
return myBroker;
}

public static synchronized void shutDown()
{
try
{
myBroker.destroy(connTimeOut);
}
catch(SQLException e){}
}
}


Jim



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Lev Assinovsky
> Sent: Tuesday, March 05, 2002 9:10 AM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
>
> Good! I just found out that  ConnectionPoolDataSource is not properly
> implemented in tyrex stuff (Tyrex people acknowledged that).
> Did  you hardcode pool instance creation or found a way when JNDI do that?
>
> Jim Urban wrote:
>
> > DBConnectionBroker
> http://opensource.devdaily.com/ddConnectionBroker.shtml
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > Of Lev Assinovsky
> > > Sent: Tuesday, March 05, 2002 7:47 AM
> > > To: Tomcat Users List
> > > Subject: Re: Who uses connection pool?
> > >
> > >
> > > Which one?
> > > Jim Urban wrote:
> > >
> > > > We do.
> > > >
> > > > Jim Urban
> > > > Product Manager
> > > > Netsteps Inc.
> > > > Suite 505E
> > > > 1 Pierce Pl.
> > > > Itasca, IL  60143
> > > > Voice:  (630) 250-3045 x2164
> > > > Fax:  (630) 250-3046
> > > >
> > > > > -Original Message-
> > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > > > Of Lev Assinovsky
> > > > > Sent: Tuesday, March 05, 2002 3:09 AM
> > > > > To: 'Tomcat Users List'
> > > > > Subject: Who uses connection pool?
> > > > >
> > > > >
> > > > > Hi!
> > > > > Could you tell me please,
> > > > > does anybody successfully use database connection pool?
> > > > >
> > > > >
> > > > > --
> > > > > Lev AssinovskyPeterlink Web
> > > > > ProgrammerSt. Petersburg, Russia
> > > > > Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
> > > > > E-mail: [EMAIL PROTECTED]
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe:
> 
> > > > > For additional commands:
> 
> > > >