Database Pooling Follow-up

2005-08-31 Thread Scott Purcell
Hello,


I want to say thanks for the links yesterday in regards to my pooling problem. 
After reading the docs, I have a better handle on how this will work.
I am ready to test, and I was able to get the following to work within a JSP 
page.

But I would really like to create a Singleton class that could hand out 
connections based upon something like: singleton.getHandle(jndiname); So in 
my business object I can hand in a name and let the busines object get the 
connection, etc.

Does that make sense. Only problem is, I cannot figure out how to transfer the 
JSP snippet below, to physical java code.

Anyone know?

Thanks,
Scott



### JSP that works correctly ... would like to do this in a class ###



%@ taglib uri=http://java.sun.com/jsp/jstl/sql; prefix=sql %
%@ taglib uri=http://java.sun.com/jsp/jstl/core; prefix=c %

sql:query var=rs dataSource=jdbc/TestDB
select id, foo, bar from testdata
/sql:query

html
  head
titleDB Test/title
  /head
  body

  h2Results/h2
  
c:forEach var=row items=${rs.rows}
Foo ${row.foo}br/
Bar ${row.bar}br/
/c:forEach

  /body
/html


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



Re: Database Pooling Follow-up

2005-08-31 Thread Brian Cook



I have a method call I think probably does what you want



   public static Connection getPooledConection(String JNDIName) {

Connection con = null;

DataSource ds = null;

   try {

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup(java:comp/env);

ds = (DataSource) envCtx.lookup(jdbc/+JNDIName);

con = ds.getConnection();
  }
  catch(Exception e){
System.out.println(new java.util.Date()+ Blah Blah Blah\n+
Conection was forced closed!\n+
JNDIName : +JNDIName+\n+e+\n+e.getMessage()+\n\n+
e.printStackTrace()  );

try {  con.close();   } catch(Exception d) {  }
  } // Close exception catch
return con;
}   // Close method


Scott Purcell wrote:

Hello,


I want to say thanks for the links yesterday in regards to my pooling problem. 
After reading the docs, I have a better handle on how this will work.
I am ready to test, and I was able to get the following to work within a JSP 
page.

But I would really like to create a Singleton class that could hand out connections based upon 
something like: singleton.getHandle(jndiname); So in my business object I can hand in a 
name and let the busines object get the connection, etc.

Does that make sense. Only problem is, I cannot figure out how to transfer the 
JSP snippet below, to physical java code.

Anyone know?

Thanks,
Scott



### JSP that works correctly ... would like to do this in a class ###



%@ taglib uri=http://java.sun.com/jsp/jstl/sql; prefix=sql %
%@ taglib uri=http://java.sun.com/jsp/jstl/core; prefix=c %

sql:query var=rs dataSource=jdbc/TestDB
select id, foo, bar from testdata
/sql:query

html
  head
titleDB Test/title
  /head
  body

  h2Results/h2
  
c:forEach var=row items=${rs.rows}

Foo ${row.foo}br/
Bar ${row.bar}br/
/c:forEach

  /body
/html


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





--
Brian Cook
Digital Services Analyst
Print Time Inc.
[EMAIL PROTECTED]
913.345.8900

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

Database Pooling

2005-08-30 Thread Scott Purcell
Hello,

To start off with, I hand rolled a database pooling class to handle database 
pooling for a ecommerce site I am writing. The application is web-based so of 
course I am using Tomcat 5.5 and all was going well. But in my implementation, 
I occasionally get errors when the connection has not been used for a long 
period of time. Basically mysql or tomcat may be taking themselves out of 
service and I get some java.net errors through Tomcat.

Anyway, I got frustrated and began to look through some on-line docs in regards 
to Tomcat and DatabasePooling.

Which leads me to my question:
Is pooling build-in to Tomcat 5.5?
If so, how simple is this to implement (I have read here: 
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resources-howto.html but 
I an not familiar with JNDI.
And if it does it take care of shutting down the pool when the server gets 
reloaded or gets unloaded?

Currently my pooling solution is huge, with threads to monitor if they are 
closed, etc. I figure there has to be a better implementation, or solution for 
myself in this regards

Could anyone please help out with some sample, or explanation of how this all 
fits together.

I have created business objects, so I just need to call the database from 
business objects, not directly from tomcat.

Thanks,
Scott




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



RE: Database Pooling

2005-08-30 Thread Caldarale, Charles R
 From: Scott Purcell [mailto:[EMAIL PROTECTED] 
 Subject: Database Pooling 
 
 If so, how simple is this to implement (I have read here: 
 http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resource
 s-howto.html but I an not familiar with JNDI.

Try reading the next section of the doc as well:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples
-howto.html

That should have most of the info you need.

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.

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



Re: Database Pooling

2005-08-30 Thread Parsons Technical Services

MySQL shuts down the connections after 8 hours. Ran into this myself.

Yes, Tomcat has pooling built in.
Yes, it handles all aspects of the pool.

Try this link to start with:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html

It is directed more to the database pooling. There is also lots of entries 
in the archives.


Some people have no problem setting it up but there are a few that run into 
some configuration issues that seem to baffle them.


Some tips:
Watch the naming that both case and spelling match.
Put the drivers in common/lib
Use the latest drivers.
Make sure you have only one copy of the drivers.

Doug

- Original Message - 
From: Scott Purcell [EMAIL PROTECTED]

To: tomcat-user@jakarta.apache.org
Sent: Tuesday, August 30, 2005 1:08 PM
Subject: Database Pooling


Hello,

To start off with, I hand rolled a database pooling class to handle database 
pooling for a ecommerce site I am writing. The application is web-based so 
of course I am using Tomcat 5.5 and all was going well. But in my 
implementation, I occasionally get errors when the connection has not been 
used for a long period of time. Basically mysql or tomcat may be taking 
themselves out of service and I get some java.net errors through Tomcat.


Anyway, I got frustrated and began to look through some on-line docs in 
regards to Tomcat and DatabasePooling.


Which leads me to my question:
Is pooling build-in to Tomcat 5.5?
If so, how simple is this to implement (I have read here: 
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resources-howto.html 
but I an not familiar with JNDI.
And if it does it take care of shutting down the pool when the server gets 
reloaded or gets unloaded?


Currently my pooling solution is huge, with threads to monitor if they are 
closed, etc. I figure there has to be a better implementation, or solution 
for myself in this regards


Could anyone please help out with some sample, or explanation of how this 
all fits together.


I have created business objects, so I just need to call the database from 
business objects, not directly from tomcat.


Thanks,
Scott




-
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: Database Pooling

2004-11-17 Thread Allistair Crossley
application-server-managed database pools are great, they take all the work out 
of writing your own pooling implementation, and are normally better at it too. 
furthermore you get to label the pool in a generic way so that your application 
only needs to acquire the JNDI context and pluck out the datasource (which 
returns connections). the way in which database pools are setup inside the 
application server will be app-server specific, but the major players out there 
(bea, jboss, tomcat) all have the ability to do so. it's a no-brainer for j2ee 
web applications of yuor mid-sized nature I think.

 -Original Message-
 From: Scott Purcell [mailto:[EMAIL PROTECTED]
 Sent: 16 November 2004 21:35
 To: [EMAIL PROTECTED]
 Subject: Database Pooling
 
 
 I am developing a mid-sized application, which will use JSP 
 Model 2 Architecture. Currently I have a class that does 
 Database Pooling, but I am curious about some threads I see 
 time to time.
  
 I have noticed that some developers on this list refer to 
 Tomcats Database Pooling. It looks like there are some hooks 
 into the deployment file. So I guess my question is as 
 follows. does Tomcat offer this type of pooling? and if so, 
 is it good, and is it portable? Links, references would be great.
  
 Thanks,
 Scott
  
 
 
  
 
  
 


FONT SIZE=1 FACE=VERDANA,ARIAL COLOR=BLUE 
---
QAS Ltd.
Developers of QuickAddress Software
a href=http://www.qas.com;www.qas.com/a
Registered in England: No 2582055
Registered in Australia: No 082 851 474
---
/FONT


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



Re: Database Pooling

2004-11-17 Thread Andoni
I think what you are looking for is this:

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html

This one is for Tomcat 5.x of course but varies little. Follow the links to
find ones for other Tomcats under JDBC DataSources.

Andoni.

- Original Message - 
From: Scott Purcell [EMAIL PROTECTED]
Newsgroups: gmane.comp.jakarta.tomcat.user
Sent: Tuesday, November 16, 2004 9:35 PM
Subject: Database Pooling


I am developing a mid-sized application, which will use JSP Model 2
Architecture. Currently I have a class that does Database Pooling, but I am
curious about some threads I see time to time.

I have noticed that some developers on this list refer to Tomcats Database
Pooling. It looks like there are some hooks into the deployment file. So I
guess my question is as follows. does Tomcat offer this type of pooling? and
if so, is it good, and is it portable? Links, references would be great.

Thanks,
Scott








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



Database Pooling

2004-11-16 Thread Scott Purcell
I am developing a mid-sized application, which will use JSP Model 2 
Architecture. Currently I have a class that does Database Pooling, but I am 
curious about some threads I see time to time.
 
I have noticed that some developers on this list refer to Tomcats Database 
Pooling. It looks like there are some hooks into the deployment file. So I 
guess my question is as follows. does Tomcat offer this type of pooling? and if 
so, is it good, and is it portable? Links, references would be great.
 
Thanks,
Scott
 


 

 


Re: Database Pooling

2004-11-16 Thread QM
On Tue, Nov 16, 2004 at 03:35:25PM -0600, Scott Purcell wrote:
: I am developing a mid-sized application, which will use JSP Model 2
: Architecture. Currently I have a class that does Database Pooling, but I am
: curious about some threads I see time to time.
: 
: I have noticed that some developers on this list refer to Tomcats Database
: Pooling. It looks like there are some hooks into the deployment file. So I
: guess my question is as follows. does Tomcat offer this type of pooling? and
: if so, is it good, and is it portable? Links, references would be great.

JDBC pooling is pretty standard in containers these days, Tomcat
included. ;) The code side of this picture is pretty portable: look up a
DataSource via JNDI, use that to fetch connections.  The configuration
side is container-specific.  Tomcat has excellent docs on this at the
website.

If inter-container portability is a great concern (e.g. you sell your
app to external clients), you could also manage the pool yourself using
the commons-dbcp package.

-QM

-- 

software  -- http://www.brandxdev.net
tech news -- http://www.RoarNetworX.com


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



Tomcat 4.1 not starting, how do I track error (database pooling)

2004-11-04 Thread Paul Taylor
Hi
having written an application that ran fine on Tomcat 5 I am having to 
regress it to run on Tomcat 4.1 running on Windows. part of the 
deployment involves setting up database pooling.

First of all I deployed my application war only and started Tomcat using 
catalina start this worked ok, but I then needed to configure database 
pooling to get it fully working.

In Tomcat 5.0 I had a config file /contextname.xml /under 
CATLINA_HOME/conf/catalina/localhost which worked fine, under Tomcat 4.0 
I have added the contents to  server.xml. I then ran catalina.bat start 
this starts another window but then disappears immediately before I am 
able to trap the problem, there is nothing in the log file to indicate 
the problem.

Could anybody please help with any of the following ?
1. How do I stop the window started my Catalina from disappearing so I 
can see what the problem is.
2. In Tomcat 4.0 can I have a config file for my application rather than 
adding it to server.xml
3. I am using the mysqllConnectector 3.15 driver does this work with 
Tomcat 4.0.
4. Are pooling connections configured the same in 4 as 5 or not below I 
have listed the contents of my xml file from Tomcat 5.

Context path=/kijil displayname=kijil debug=0 privileged=true
Resource name=jdbc/kijil
   auth=Container
   type=javax.sql.DataSource/
 ResourceParams name=jdbc/kijil
   parameter
 namefactory/name
 valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
   /parameter
  
   parameter
 namemaxActive/name
 value100/value
   /parameter
 
   parameter
 namemaxIdle/name
 value30/value
   /parameter
 
   parameter
 namemaxWait/name
 value1/value
   /parameter

   parameter
nameusername/name
valuekijil/value
   /parameter
  
   parameter
namepassword/name
valueflyup/value
   /parameter

   parameter
 namedriverClassName/name
 valuecom.mysql.jdbc.Driver/value 
   /parameter
  
   parameter
 nameurl/name
 valuejdbc:mysql://localhost:3306/kijil?autoReconnect=true/value
   /parameter
 /ResourceParams

/Context

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


RE: Tomcat 4.1 not starting, how do I track error (database pooling)

2004-11-04 Thread Shapira, Yoav

Hi,

1. How do I stop the window started my Catalina from disappearing so I
can see what the problem is.

Use catalina.bat run instead of startup.bat (which calls catalina.bat
start).

2. In Tomcat 4.0 can I have a config file for my application rather
than
adding it to server.xml

No.

3. I am using the mysqllConnectector 3.15 driver does this work with
Tomcat 4.0.

Yes.

4. Are pooling connections configured the same in 4 as 5 or not below I
have listed the contents of my xml file from Tomcat 5.

Mostly the same, but some attribute names are different.

Context path=/kijil displayname=kijil debug=0 privileged=true

Why is your context privileged?

parameter
 nameusername/name
 valuekijil/value
/parameter

Try changing name to user instead of username -- I believe this was
a change made in DBCP.

Yoav



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]



Re: Tomcat 4.1 not starting, how do I track error (database pooling)

2004-11-04 Thread Paul Taylor
Thanks very much all working, the problem was I had removed docbase 
paramter not hinking it was needed because the code was hosted directly 
under webapps.
BTW username is correct in TC4.

My context is privileged just because I copied it from somehwere else 
without knowing what it meant, no good reason.

Shapira, Yoav wrote:
Hi,
 

1. How do I stop the window started my Catalina from disappearing so I
can see what the problem is.
   

Use catalina.bat run instead of startup.bat (which calls catalina.bat
start).
 

2. In Tomcat 4.0 can I have a config file for my application rather
   

than
 

adding it to server.xml
   

No.
 

3. I am using the mysqllConnectector 3.15 driver does this work with
Tomcat 4.0.
   

Yes.
 

4. Are pooling connections configured the same in 4 as 5 or not below I
have listed the contents of my xml file from Tomcat 5.
   

Mostly the same, but some attribute names are different.
 

Context path=/kijil displayname=kijil debug=0 privileged=true
   

Why is your context privileged?
 

  parameter
   nameusername/name
   valuekijil/value
  /parameter
   

Try changing name to user instead of username -- I believe this was
a change made in DBCP.
Yoav

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]


Re: Help Database Pooling in Linux

2004-08-15 Thread tim
[EMAIL PROTECTED] writes: 

Hi 

I have tried a few more things including upgrading the database, but I'm 
still havig issues. I have attached a copy of the test file I have used to 
connect to the database and the context .xml file. As you can see the 
database connection information is identical. The direct link works but the 
connection pool doesn't, failing on a Null point exception error. Under 
windows both work equally well. , it is really not clear to me why they are 
failing. Any help gratefully received. 

Tim
 

Tim Barrett
Education Technology Consultants  



Tim Barrett
Education Technology Consultants 

tel: 07944 274088
e-mail: [EMAIL PROTECTED] 


?xml version='1.0' encoding='utf-8'?
Context displayName=NLN Online docBase=stagenlnonline path=/stagenlnonline


Realm className=org.apache.catalina.realm.DataSourceRealm debug=99
dataSourceName=jdbc/NLNOnline localDataSource=true digest=MD5
userTable=users userNameCol=username userCredCol=password
userRoleTable=users_roles roleNameCol=rolename/



Resource name=jdbc/NLNOnline auth=Container type=javax.sql.DataSource/
ResourceParams name=jdbc/NLNOnline
parameter
namefactory/name
valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
/parameter
parameter
nameurl/name
valuejdbc:mysql://flash/NLNOnlineDB/value
/parameter
parameter
namedriverClassName/name
valuecom.mysql.jdbc.Driver/value
/parameter
parameter
nameusername/name
valueNLNOnlineUser/value
/parameter
parameter
namepassword/name
valueNLN0/value
/parameter
parameter
namemaxWait/name
value3000/value
/parameter
parameter
namemaxIdle/name
value100/value
/parameter
parameter
namemaxActive/name
value10/value
/parameter
/ResourceParams
/Context
%@ taglib uri=/tags/jstl-sql prefix=sql %
%@ taglib uri=/tags/jstl-core prefix=c %
%@ taglib uri=/tags/jstl-format prefix=fmt %
html
head
/head
body

sql:setDataSource var=testData scope=application
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://flash/NLNOnlineDB
user=NLNOnlineUser
password=NLN0
/

sql:query
var=testDB
dataSource=${testData}
sql=SELECT * FROM users
/

c:forEach items=${testDB.rows} var=row
p
Connection Succesfull
/p
/c:forEach
/body
/head

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

Help Database Pooling in Linux

2004-08-12 Thread tim
Hi 

I am experiencing a bit of a tricky problem. I have an application developed 
under windows. The application talks to a MySQL database using connection 
pooling. The application works great hosted on Tomcat under Windows, but 
when it is placed on Linux the application cannot establish a connection to 
the database. Previously it has been able to connect under linux and no 
change has been made to the connection pool classes. 

I have checked that the database can be reached from the Linux server and it 
can, and I can connect to the database if I use a direct JSP database call. 
But the application will not establish a connection either to a local 
database or to a database hosted on another machine. I have tried pretty 
much everything I can think of and am now out of ideas so any ideas/pointers 
would be gratefully received. 

Tim Barrett
Education Technology Consultants 


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


Re: Help Database Pooling in Linux

2004-08-12 Thread QM
On Fri, Aug 13, 2004 at 01:04:38AM +0100, [EMAIL PROTECTED] wrote:
: I have checked that the database can be reached from the Linux server and 
: it can, and I can connect to the database if I use a direct JSP database 
: call. But the application will not establish a connection either to a local 
: database or to a database hosted on another machine. I have tried pretty 
: much everything I can think of and am now out of ideas so any 
: ideas/pointers would be gratefully received. 

Messages from the logs are helpful, especially stack traces.
Also, what's in your server.xml / context.xml?
-and how direct is the JSP call?  Do you specify the full JDBC URL, or
a JNDI resource name?

-QM


-- 

software  -- http://www.brandxdev.net
tech news -- http://www.RoarNetworX.com


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



Re: Help Database Pooling in Linux

2004-08-12 Thread Isen,Ciji
yup. what is the error message that you are getting?
Please paste/attach them. The ones that you get on screen as well as any 
that are getting logged in the log files.

Gig 'em
QM wrote:
On Fri, Aug 13, 2004 at 01:04:38AM +0100, [EMAIL PROTECTED] wrote:
: I have checked that the database can be reached from the Linux server and 
: it can, and I can connect to the database if I use a direct JSP database 
: call. But the application will not establish a connection either to a local 
: database or to a database hosted on another machine. I have tried pretty 
: much everything I can think of and am now out of ideas so any 
: ideas/pointers would be gratefully received. 

Messages from the logs are helpful, especially stack traces.
Also, what's in your server.xml / context.xml?
-and how direct is the JSP call?  Do you specify the full JDBC URL, or
a JNDI resource name?
-QM
 

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


Tomcat, MS Beta 2 driver, and database pooling

2002-04-23 Thread Sean LeBlanc

Does anyone have this working? If so, can you please post your server.xml, your 
(context)web.xml and your working code?

I just cannot get this to work. Any and all ideas are welcome. If it can't work, it'd 
be nice to know that, too. Thanks.

My web.xml has this entry:

resource-ref
descriptiontest jdbc/nutrosDB/description
res-ref-namejdbc/nutrosDB/res-ref-name
res-typecom.microsoft.jdbcx.sqlserver.SQLServerDataSource/res-type
res-authContainer/res-auth
res-sharing-scopeShareable/res-sharing-scope
/resource-ref

My server.xml has this entry:

Resource name=jdbc/nutrosDB auth=Container
type=javax.sql.DataSource/
ResourceParams name=jdbc/nutrosDB
parameter
namedatabase/namevaluemydb/value
/parameter
parameter

namefactory/namevaluecom.microsoft.jdbcx.sqlserver.SQLServerDataSource/value
/parameter


parameter

namedriverClassName/namevaluecom.microsoft.jdbc.sqlserver.SQLServerDriver/value
/parameter

parameter

namedriverName/namevaluejdbc:microsoft:sqlserver://192.168.9.253;user=username;Password=pwd;DatabaseName=mydb/val
ue
/parameter

parameter
nameuser/namevalueusername/value
/parameter
parameter
namepassword/namevaluepwd/value
/parameter
/ResourceParams


Here is the source code:

Context initCtx = new InitialContext();
Context envCtx = (Context)initCtx.lookup(java:comp/env);
if (envCtx == null)
{
System.out.println(Context is null!);
}

NamingEnumeration ne = envCtx.listBindings(jdbc);
while (ne.hasMoreElements())
{
System.out.println( + ne.next());
}

System.out.println( About to get ds.);
com.microsoft.jdbcx.sqlserver.SQLServerDataSource ds =
(com.microsoft.jdbcx.sqlserver.SQLServerDataSource)envCtx.lookup(jdbc/nutrosDB);
System.out.println(About to get pooledconnection.);
PooledConnection x = ds.getPooledConnection(usr,pwd);
System.out.println(About to get connection.);
Connection conDB1 = x.getConnection();

And here is the error I get (right after it prints About to get ds.):

javax.naming.NamingException: Cannot create resource instance
at 
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:167)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:299)
at org.apache.naming.NamingContext.lookup(NamingContext.java:834)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at Nutros.Beans.DatabaseBean.init(Unknown Source)
at Nutros.Beans.beanBrand.loadProduct(Unknown Source)
at org.apache.jsp.index$jsp._jspService(index$jsp.java:579)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at 
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at 
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at 

RE: Database Pooling

2002-03-12 Thread Chris Pheby

As to Excalibur, I don't yet know.

Cocoon is a web publishing framework that allows such things as on demand
transformation from XML to HTML, WAP and PDF (using Apache's formatting
objects) and XSP (XML Server Pages).

Find it at xml.apache.org.


Chris,

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of Neo Gigs
Sent: 12 March 2002 04:01
To: Tomcat Users List
Subject: Re: Database Pooling


Hi there,

Would you mind to tell me how to deploy Excalibur into my Tomcat server
running on Sun solaris?

Also what is Cocoon and where to find it?

TQ

Neo
- Original Message -
From: Chris Pheby [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 9:00 PM
Subject: RE: Database Pooling


 Hi thanks for the prompt reply, very useful. I am evaluating Excalibur,
 because I think Cocoon uses it, and I am interested in finding out more
 about Cocoon as well.

 Regards,

 Chris.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
 On Behalf Of Ralph Einfeldt
 Sent: 11 March 2002 12:09
 To: Tomcat Users List
 Subject: AW: Database Pooling


 Have a look at
 http://www2.gvsu.edu/~millerjr/ResearchPaper.html

 and

 http://jakarta.apache.org/avalon/excalibur/datasource.html



  -Ursprüngliche Nachricht-
  Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
  Gesendet: Montag, 11. März 2002 13:03
  An: [EMAIL PROTECTED]
  Betreff: Database Pooling
 
 
  Now Poolman is being declared obsolete
  (http://www.codestudio.com/PoolMan),
  I wondered if anyone can point me to any documentation on Connection
  Pooling, hopefully within Tomcat, but perhaps otherwise in
  another project
  that they are using?
 
 
  Thanks,
 
 
  Chris.
 
 
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
 

 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]




 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




Re: Database Pooling

2002-03-12 Thread Neo Gigs

But does Cocoon have anything related to DB polling?
- Original Message -
From: Chris Pheby [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 4:56 PM
Subject: RE: Database Pooling


 As to Excalibur, I don't yet know.

 Cocoon is a web publishing framework that allows such things as on demand
 transformation from XML to HTML, WAP and PDF (using Apache's formatting
 objects) and XSP (XML Server Pages).

 Find it at xml.apache.org.


 Chris,

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
 On Behalf Of Neo Gigs
 Sent: 12 March 2002 04:01
 To: Tomcat Users List
 Subject: Re: Database Pooling


 Hi there,

 Would you mind to tell me how to deploy Excalibur into my Tomcat server
 running on Sun solaris?

 Also what is Cocoon and where to find it?

 TQ

 Neo
 - Original Message -
 From: Chris Pheby [EMAIL PROTECTED]
 To: Tomcat Users List [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 9:00 PM
 Subject: RE: Database Pooling


  Hi thanks for the prompt reply, very useful. I am evaluating Excalibur,
  because I think Cocoon uses it, and I am interested in finding out more
  about Cocoon as well.
 
  Regards,
 
  Chris.
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]
  On Behalf Of Ralph Einfeldt
  Sent: 11 March 2002 12:09
  To: Tomcat Users List
  Subject: AW: Database Pooling
 
 
  Have a look at
  http://www2.gvsu.edu/~millerjr/ResearchPaper.html
 
  and
 
  http://jakarta.apache.org/avalon/excalibur/datasource.html
 
 
 
   -Ursprüngliche Nachricht-
   Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
   Gesendet: Montag, 11. März 2002 13:03
   An: [EMAIL PROTECTED]
   Betreff: Database Pooling
  
  
   Now Poolman is being declared obsolete
   (http://www.codestudio.com/PoolMan),
   I wondered if anyone can point me to any documentation on Connection
   Pooling, hopefully within Tomcat, but perhaps otherwise in
   another project
   that they are using?
  
  
   Thanks,
  
  
   Chris.
  
  
  
   --
   To unsubscribe:   mailto:[EMAIL PROTECTED]
   For additional commands: mailto:[EMAIL PROTECTED]
   Troubles with the list: mailto:[EMAIL PROTECTED]
  
  
  
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
 
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]


 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com


 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]




 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




RE: Database Pooling

2002-03-12 Thread Chris Pheby

My understanding is that Cocoon achieves connection pooling and component
pooling by using the Avalon framework (Excalibur etc). Can someone correct
me if I am wrong?


Chris.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of Neo Gigs
Sent: 12 March 2002 09:25
To: Tomcat Users List
Subject: Re: Database Pooling


But does Cocoon have anything related to DB polling?
- Original Message -
From: Chris Pheby [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 4:56 PM
Subject: RE: Database Pooling


 As to Excalibur, I don't yet know.

 Cocoon is a web publishing framework that allows such things as on demand
 transformation from XML to HTML, WAP and PDF (using Apache's formatting
 objects) and XSP (XML Server Pages).

 Find it at xml.apache.org.


 Chris,

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
 On Behalf Of Neo Gigs
 Sent: 12 March 2002 04:01
 To: Tomcat Users List
 Subject: Re: Database Pooling


 Hi there,

 Would you mind to tell me how to deploy Excalibur into my Tomcat server
 running on Sun solaris?

 Also what is Cocoon and where to find it?

 TQ

 Neo
 - Original Message -
 From: Chris Pheby [EMAIL PROTECTED]
 To: Tomcat Users List [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 9:00 PM
 Subject: RE: Database Pooling


  Hi thanks for the prompt reply, very useful. I am evaluating Excalibur,
  because I think Cocoon uses it, and I am interested in finding out more
  about Cocoon as well.
 
  Regards,
 
  Chris.
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]
  On Behalf Of Ralph Einfeldt
  Sent: 11 March 2002 12:09
  To: Tomcat Users List
  Subject: AW: Database Pooling
 
 
  Have a look at
  http://www2.gvsu.edu/~millerjr/ResearchPaper.html
 
  and
 
  http://jakarta.apache.org/avalon/excalibur/datasource.html
 
 
 
   -Ursprüngliche Nachricht-
   Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
   Gesendet: Montag, 11. März 2002 13:03
   An: [EMAIL PROTECTED]
   Betreff: Database Pooling
  
  
   Now Poolman is being declared obsolete
   (http://www.codestudio.com/PoolMan),
   I wondered if anyone can point me to any documentation on Connection
   Pooling, hopefully within Tomcat, but perhaps otherwise in
   another project
   that they are using?
  
  
   Thanks,
  
  
   Chris.
  
  
  
   --
   To unsubscribe:   mailto:[EMAIL PROTECTED]
   For additional commands: mailto:[EMAIL PROTECTED]
   Troubles with the list: mailto:[EMAIL PROTECTED]
  
  
  
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
 
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]


 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com


 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]




 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




Re: Database Pooling

2002-03-12 Thread Neo Gigs

But i do see anything related on their website... its kindna confusing up
there

- Original Message -
From: Chris Pheby [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 5:24 PM
Subject: RE: Database Pooling


 My understanding is that Cocoon achieves connection pooling and component
 pooling by using the Avalon framework (Excalibur etc). Can someone correct
 me if I am wrong?


 Chris.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
 On Behalf Of Neo Gigs
 Sent: 12 March 2002 09:25
 To: Tomcat Users List
 Subject: Re: Database Pooling


 But does Cocoon have anything related to DB polling?
 - Original Message -
 From: Chris Pheby [EMAIL PROTECTED]
 To: Tomcat Users List [EMAIL PROTECTED]
 Sent: Tuesday, March 12, 2002 4:56 PM
 Subject: RE: Database Pooling


  As to Excalibur, I don't yet know.
 
  Cocoon is a web publishing framework that allows such things as on
demand
  transformation from XML to HTML, WAP and PDF (using Apache's formatting
  objects) and XSP (XML Server Pages).
 
  Find it at xml.apache.org.
 
 
  Chris,
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]
  On Behalf Of Neo Gigs
  Sent: 12 March 2002 04:01
  To: Tomcat Users List
  Subject: Re: Database Pooling
 
 
  Hi there,
 
  Would you mind to tell me how to deploy Excalibur into my Tomcat server
  running on Sun solaris?
 
  Also what is Cocoon and where to find it?
 
  TQ
 
  Neo
  - Original Message -
  From: Chris Pheby [EMAIL PROTECTED]
  To: Tomcat Users List [EMAIL PROTECTED]
  Sent: Monday, March 11, 2002 9:00 PM
  Subject: RE: Database Pooling
 
 
   Hi thanks for the prompt reply, very useful. I am evaluating
Excalibur,
   because I think Cocoon uses it, and I am interested in finding out
more
   about Cocoon as well.
  
   Regards,
  
   Chris.
  
   -Original Message-
   From: [EMAIL PROTECTED]
  
[mailto:[EMAIL PROTECTED]]
   On Behalf Of Ralph Einfeldt
   Sent: 11 March 2002 12:09
   To: Tomcat Users List
   Subject: AW: Database Pooling
  
  
   Have a look at
   http://www2.gvsu.edu/~millerjr/ResearchPaper.html
  
   and
  
   http://jakarta.apache.org/avalon/excalibur/datasource.html
  
  
  
-Ursprüngliche Nachricht-
Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 11. März 2002 13:03
An: [EMAIL PROTECTED]
Betreff: Database Pooling
   
   
Now Poolman is being declared obsolete
(http://www.codestudio.com/PoolMan),
I wondered if anyone can point me to any documentation on Connection
Pooling, hopefully within Tomcat, but perhaps otherwise in
another project
that they are using?
   
   
Thanks,
   
   
Chris.
   
   
   
--
To unsubscribe:
mailto:[EMAIL PROTECTED]
For additional commands:
mailto:[EMAIL PROTECTED]
Troubles with the list:
mailto:[EMAIL PROTECTED]
   
   
   
  
   --
   To unsubscribe:   mailto:[EMAIL PROTECTED]
   For additional commands: mailto:[EMAIL PROTECTED]
   Troubles with the list: mailto:[EMAIL PROTECTED]
  
  
  
  
   --
   To unsubscribe:   mailto:[EMAIL PROTECTED]
   For additional commands: mailto:[EMAIL PROTECTED]
   Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
  _
  Do You Yahoo!?
  Get your free @yahoo.com address at http://mail.yahoo.com
 
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
 
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]


 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com


 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]




 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




Database Pooling

2002-03-11 Thread Chris Pheby

Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan),
I wondered if anyone can point me to any documentation on Connection
Pooling, hopefully within Tomcat, but perhaps otherwise in another project
that they are using?


Thanks,


Chris.



--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




AW: Database Pooling

2002-03-11 Thread Ralph Einfeldt

Have a look at
http://www2.gvsu.edu/~millerjr/ResearchPaper.html

and

http://jakarta.apache.org/avalon/excalibur/datasource.html



 -Ursprüngliche Nachricht-
 Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
 Gesendet: Montag, 11. März 2002 13:03
 An: [EMAIL PROTECTED]
 Betreff: Database Pooling
 
 
 Now Poolman is being declared obsolete 
 (http://www.codestudio.com/PoolMan),
 I wondered if anyone can point me to any documentation on Connection
 Pooling, hopefully within Tomcat, but perhaps otherwise in 
 another project
 that they are using?
 
 
 Thanks,
 
 
 Chris.
 
 
 
 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
 

--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




RE: Database Pooling

2002-03-11 Thread Chris Pheby

Hi thanks for the prompt reply, very useful. I am evaluating Excalibur,
because I think Cocoon uses it, and I am interested in finding out more
about Cocoon as well.

Regards,

Chris.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
On Behalf Of Ralph Einfeldt
Sent: 11 March 2002 12:09
To: Tomcat Users List
Subject: AW: Database Pooling


Have a look at
http://www2.gvsu.edu/~millerjr/ResearchPaper.html

and

http://jakarta.apache.org/avalon/excalibur/datasource.html



 -Ursprüngliche Nachricht-
 Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
 Gesendet: Montag, 11. März 2002 13:03
 An: [EMAIL PROTECTED]
 Betreff: Database Pooling


 Now Poolman is being declared obsolete
 (http://www.codestudio.com/PoolMan),
 I wondered if anyone can point me to any documentation on Connection
 Pooling, hopefully within Tomcat, but perhaps otherwise in
 another project
 that they are using?


 Thanks,


 Chris.



 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]




--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




Re: Database Pooling

2002-03-11 Thread Neo Gigs

Hi there,

Would you mind to tell me how to deploy Excalibur into my Tomcat server
running on Sun solaris?

Also what is Cocoon and where to find it?

TQ

Neo
- Original Message -
From: Chris Pheby [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 9:00 PM
Subject: RE: Database Pooling


 Hi thanks for the prompt reply, very useful. I am evaluating Excalibur,
 because I think Cocoon uses it, and I am interested in finding out more
 about Cocoon as well.

 Regards,

 Chris.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
 On Behalf Of Ralph Einfeldt
 Sent: 11 March 2002 12:09
 To: Tomcat Users List
 Subject: AW: Database Pooling


 Have a look at
 http://www2.gvsu.edu/~millerjr/ResearchPaper.html

 and

 http://jakarta.apache.org/avalon/excalibur/datasource.html



  -Ursprüngliche Nachricht-
  Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
  Gesendet: Montag, 11. März 2002 13:03
  An: [EMAIL PROTECTED]
  Betreff: Database Pooling
 
 
  Now Poolman is being declared obsolete
  (http://www.codestudio.com/PoolMan),
  I wondered if anyone can point me to any documentation on Connection
  Pooling, hopefully within Tomcat, but perhaps otherwise in
  another project
  that they are using?
 
 
  Thanks,
 
 
  Chris.
 
 
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
 

 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]




 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




Re: Database Pooling

2002-03-11 Thread Craig R. McClanahan



On Tue, 12 Mar 2002, Neo Gigs wrote:

 Date: Tue, 12 Mar 2002 12:01:18 +0800
 From: Neo Gigs [EMAIL PROTECTED]
 Reply-To: Tomcat Users List [EMAIL PROTECTED]
 To: Tomcat Users List [EMAIL PROTECTED]
 Subject: Re: Database Pooling

 Hi there,

 Would you mind to tell me how to deploy Excalibur into my Tomcat server
 running on Sun solaris?


Sounds like a good question for the Avalon users list, since it's part of
Avalon.  Subscription info at:

  http://jakarta.apache.org/site/mail.html

 Also what is Cocoon and where to find it?


Well, there's always google for questions like this -- it's only the very
first link that comes up :-)

  http://xml.apache.org/cocoon/

 TQ

 Neo

Craig


 - Original Message -
 From: Chris Pheby [EMAIL PROTECTED]
 To: Tomcat Users List [EMAIL PROTECTED]
 Sent: Monday, March 11, 2002 9:00 PM
 Subject: RE: Database Pooling


  Hi thanks for the prompt reply, very useful. I am evaluating Excalibur,
  because I think Cocoon uses it, and I am interested in finding out more
  about Cocoon as well.
 
  Regards,
 
  Chris.
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]
  On Behalf Of Ralph Einfeldt
  Sent: 11 March 2002 12:09
  To: Tomcat Users List
  Subject: AW: Database Pooling
 
 
  Have a look at
  http://www2.gvsu.edu/~millerjr/ResearchPaper.html
 
  and
 
  http://jakarta.apache.org/avalon/excalibur/datasource.html
 
 
 
   -Ursprüngliche Nachricht-
   Von: Chris Pheby [mailto:[EMAIL PROTECTED]]
   Gesendet: Montag, 11. März 2002 13:03
   An: [EMAIL PROTECTED]
   Betreff: Database Pooling
  
  
   Now Poolman is being declared obsolete
   (http://www.codestudio.com/PoolMan),
   I wondered if anyone can point me to any documentation on Connection
   Pooling, hopefully within Tomcat, but perhaps otherwise in
   another project
   that they are using?
  
  
   Thanks,
  
  
   Chris.
  
  
  
   --
   To unsubscribe:   mailto:[EMAIL PROTECTED]
   For additional commands: mailto:[EMAIL PROTECTED]
   Troubles with the list: mailto:[EMAIL PROTECTED]
  
  
  
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]
 
 
 
 
  --
  To unsubscribe:   mailto:[EMAIL PROTECTED]
  For additional commands: mailto:[EMAIL PROTECTED]
  Troubles with the list: mailto:[EMAIL PROTECTED]


 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com


 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]




--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




Re: Database Pooling

2002-02-06 Thread Patrick Lacson


 Don't know if anybody answered this yet but try PoolMan at sourceforge.net
-Patrick
  Jason Webber [EMAIL PROTECTED] wrote: Does anyone know of a database pooling 
bean or soemthing that will aloow
me to share connections among many jsp pages. Preferably something that
is free.



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



-
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!


Database Pooling

2002-02-04 Thread Jason Webber

Does anyone know of a database pooling bean or soemthing that will aloow
me to share connections among many jsp pages.  Preferably something that
is free.



--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




Connection/Database pooling

2001-05-25 Thread Mike Alba



Hi,

 I was wondering if someone can give me a 
little advice.
I am currently using Apache webserver, 
Tomcatserver,
and an Oracle database. I have created a wireless 
app
using JSPs/WML. Basically I was wondering how best 

to architect it to take full advantage of Tomcats 
connection
and database pooling? Should I be using servlets 
versus
JSPs? Sorry if this is a dumb 
question.

 Thanks for your help in 
advance!






Re: Connection/Database pooling

2001-05-25 Thread Gary Lawrence Murphy

Not a dumb question at all: DB connection pooling is not intrinsic to
Tomcat, but must be grafted on using a 3rd-party library (there are
many).  None of these will prevent you from using JSP; the connection
pool looks exactly like a normal JDBC connection.

You may want to browse through the docs for Jakarta-Turbine as an
alternative application environment that sits on top of Tomcat and
provides many services, including db connection pools.

-- 
Gary Lawrence Murphy [EMAIL PROTECTED] TeleDynamics Communications Inc
Business Innovations Through Open Source Systems: http://www.teledyn.com
Computers are useless.  They can only give you answers.(Pablo Picasso)




Re: Database Pooling

2001-03-15 Thread greyson . smith


I just set up PoolMan, which is working well so far, though it's nowhere
near production.  There are a lot of suggestions in the archives, another
one frequently suggested is jdbcpool from
http://www.bitmechanic.com/projects/jdbcpool/.  If you would like a quick
primer, let me know, it's quite easy to set up.



   
 
Johnathan Smith
 
dj_attitude_ny@To: [EMAIL PROTECTED] 
 
yahoo.com  cc: (bcc: Greyson Smith/CCMG/CVG)  
 
Subject: Database Pooling  
 
15-03-01 12:14 
 
PM 
 
Please respond 
 
to tomcat-user;
 
Please respond 
 
to john
 
   
 
   
 





I am doing some servlet programming and I would like
to setup a Database pool. Can someone please email me
back any help [EMAIL PROTECTED]

Thanks

=
If your into Body For Life, check out
http://clubs.yahoo.com/clubs/bodyforlifestatenislandny

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/



--

NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.





Re: Database Pooling

2001-03-15 Thread Brett Knights


 I am doing some servlet programming and I would like
 to setup a Database pool. Can someone please email me
 back any help [EMAIL PROTECTED]

I have been using the bitmechanic pool for a couple of years.

For an easy way to set this up I have a wrapper for it at 
http://www.knightsofthenet.com/projects/SQLPool

that lets you set up your connections in an xml file.