Re: JDBC Pool Disconnections

2011-04-08 Thread הילה
Hey, I'm using JTDS 1.2.5 It has proven to be more stable than the JDBC driver of microsoft, so we're using it. Thanks Hila 2011/4/7 Pid p...@pidster.com On 4/6/11 8:36 PM, הילה wrote: I wanted to add it, bu the company that developed the application that runs on the tomcat, says that it

Re: JDBC Pool Disconnections

2011-04-08 Thread הילה
What is RDBMS? I tried to google it, but haven't quite figure it out. as mentioned, we're using SQL server 2008, latest SP. And I will add the strings of validationQuery and validationInterval. :] Thanks Hila 2011/4/7 Christopher Schultz ch...@christopherschultz.net -BEGIN PGP SIGNED

Re: JDBC Pool Disconnections

2011-04-08 Thread André Warnier
הילה wrote: What is RDBMS? An easy one, just my level : Relational DataBase Management System. As a further exercise, here is a list of essential acronyms which one is supposed to know in order to be recognised as a Real Tomcat Programmer (RTP) : JVM, J2EE, BIO, NIO, APR, JDBC, JMX, JNDI,

RE: JDBC Pool Disconnections

2011-04-08 Thread Martin Gainty
:43 +0300 Subject: Re: JDBC Pool Disconnections To: users@tomcat.apache.org What is RDBMS? I tried to google it, but haven't quite figure it out. as mentioned, we're using SQL server 2008, latest SP. And I will add the strings of validationQuery and validationInterval. :] Thanks Hila

Re: JDBC Pool Disconnections

2011-04-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 André, On 4/8/2011 7:33 AM, André Warnier wrote: הילה wrote: What is RDBMS? An easy one, just my level : Relational DataBase Management System. As a further exercise, here is a list of essential acronyms which one is supposed to know in

Re: JDBC Pool Disconnections

2011-04-08 Thread הילה
ne pouvons accepter aucune responsabilité pour le contenu fourni. From: hilavalen...@gmail.com Date: Fri, 8 Apr 2011 13:14:43 +0300 Subject: Re: JDBC Pool Disconnections To: users@tomcat.apache.org What is RDBMS? I tried to google it, but haven't quite figure it out. as mentioned

RE: JDBC Pool Disconnections

2011-04-08 Thread Caldarale, Charles R
From: הילה [mailto:hilavalen...@gmail.com] Subject: Re: JDBC Pool Disconnections go back for a sec.. last thing we talked about is adding the strings of validation query, validation interval and test on borrow, so the pool will know if the connections had been closed by DB

Re: JDBC Pool Disconnections

2011-04-08 Thread הילה
Thanks so.. SQL server 2008 is the one I'm using. :] 2011/4/8 Caldarale, Charles R chuck.caldar...@unisys.com From: הילה [mailto:hilavalen...@gmail.com] Subject: Re: JDBC Pool Disconnections go back for a sec.. last thing we talked about is adding the strings of validation query

Re: JDBC Pool Disconnections

2011-04-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 הילה, On 4/8/2011 11:04 AM, הילה wrote: so.. SQL server 2008 is the one I'm using. :] Some quick Googling didn't lead me to any resources on a fast ping that you could use as a validation query. You could always read the documentation for your JDBC

Re: JDBC Pool Disconnections

2011-04-08 Thread הילה
I think that if the disconnections will continue, I'll read just about anything to make it stop :] Thanks ;) 2011/4/8 Christopher Schultz ch...@christopherschultz.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 הילה, On 4/8/2011 11:04 AM, הילה wrote: so.. SQL server 2008 is the one

Re: JDBC Pool Disconnections

2011-04-07 Thread Pid
On 4/6/11 8:36 PM, הילה wrote: I wanted to add it, bu the company that developed the application that runs on the tomcat, says that it affect performance and has issues. Which DB driver are you using? In my experience some of the jTDS driver variations have issues. p what do you mean

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
I wanted to add it, bu the company that developed the application that runs on the tomcat, says that it affect performance and has issues. what do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Lists devli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote:

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
validate == connection is open and working if they are worried about performance, there is a compromise that gets you best of both worlds testOnBorrow=true validationQuery=select 1 validationInterval=3 this ensures that in a high concurrency environment, the number of validations are

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
I wanted to add the last string as well, but they said to forget about it.. :] and they should know best however, if disconnections will continue (there are some right now) I'll try it anyway as for the connection validation = you said that if the DB closes a connection (why does it happen? can I

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
On 4/6/2011 1:54 PM, הילה wrote: I wanted to add the last string as well, but they said to forget about it.. :] and they should know best however, if disconnections will continue (there are some right now) I'll try it anyway as for the connection validation = you said that if the DB closes a

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
Got it. Thanks any other suggestions will be great (i'll add these string in a few days) 2011/4/6 Filip Hanik - Dev Lists devli...@hanik.com On 4/6/2011 1:54 PM, הילה wrote: I wanted to add the last string as well, but they said to forget about it.. :] and they should know best however,

Re: JDBC Pool Disconnections

2011-04-06 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 הילה, On 4/6/2011 3:36 PM, הילה wrote: I wanted to add it, bu the company that developed the application that runs on the tomcat, says that it affect performance and has issues. What is your RDBMS? If it happens to be MySQL, I know that they

JDBC Pool Disconnections

2011-04-05 Thread הילה
Hey, I have lately (with your help) switched the pool that tomcat uses , from the basic pool to the JDBC pool, with these actions- 1. under resource tag in xml configuration [conf/catalina/localhost/Appname.xml] I specified the factory name, as you can see below-