Thread: Postmaster not dropping connections on tomcat restart.
Dear List, I've finally managed to get connection pooling going in tomcat. I've noticed that when i reload my web app the postmaster will not drop any of the connections. Basically the order of things is I start Tomcat, check out my servlet and there's a connection that shows up to the postmaster. Now while I've been doing some development I notice that when i reload my web app that the connection stays around. And after enough connections are just sitting there, it doesn't allow me to make anymore. It gives a JDBC error about not being able to make any more connections without superuser status. I'm not even sure if this would be a problem in production, but right now I'm finding it quite annoying to have to restart tomcat on a regular basis. Before I get flamed, I just want to note that I'm only asking here because I don't even know if this is a postgresql problem or a tomcat one. So I'm asking on both mailing lists. Thanks, Paul Davis. *Insert witty quote*
Paul, which pooling implementation are you using and are you explicitly shutting it down on the servlet destroy method? Dave On Wed, 2004-03-17 at 02:59, Paul Davis wrote: > Dear List, > > I've finally managed to get connection pooling going in tomcat. I've > noticed that when i reload my web app the postmaster will not drop any > of the connections. > > Basically the order of things is I start Tomcat, check out my servlet > and there's a connection that shows up to the postmaster. Now while > I've been doing some development I notice that when i reload my web app > that the connection stays around. And after enough connections are > just sitting there, it doesn't allow me to make anymore. It gives a > JDBC error about not being able to make any more connections without > superuser status. > > I'm not even sure if this would be a problem in production, but right > now I'm finding it quite annoying to have to restart tomcat on a > regular basis. > > Before I get flamed, I just want to note that I'm only asking here > because I don't even know if this is a postgresql problem or a tomcat > one. So I'm asking on both mailing lists. > > Thanks, > Paul Davis. > > *Insert witty quote* > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- Dave Cramer 519 939 0336 ICQ # 14675561
On 17/03/2004 07:59 Paul Davis wrote: > Dear List, > > I've finally managed to get connection pooling going in tomcat. I've > noticed that when i reload my web app the postmaster will not drop any > of the connections. > > Basically the order of things is I start Tomcat, check out my servlet > and there's a connection that shows up to the postmaster. Now while > I've been doing some development I notice that when i reload my web app > that the connection stays around. And after enough connections are just > sitting there, it doesn't allow me to make anymore. It gives a JDBC > error about not being able to make any more connections without > superuser status. > > I'm not even sure if this would be a problem in production, but right > now I'm finding it quite annoying to have to restart tomcat on a regular > basis. > > Before I get flamed, I just want to note that I'm only asking here > because I don't even know if this is a postgresql problem or a tomcat > one. So I'm asking on both mailing lists. Is the connection pool defined within you web app's context? -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
Even i have the same problem what Paul Davis said with respect to connection, >>Is the connection pool defined within you web app's >>context? yes i have defined the pool in the server.xml file and reference in the web.xml file. pls provide us a solution. thanks dinakar --- Paul Thomas <paul@tmsl.demon.co.uk> wrote: > > On 17/03/2004 07:59 Paul Davis wrote: > > Dear List, > > > > I've finally managed to get connection pooling > going in tomcat. I've > > noticed that when i reload my web app the > postmaster will not drop any > > of the connections. > > > > Basically the order of things is I start Tomcat, > check out my servlet > > and there's a connection that shows up to the > postmaster. Now while > > I've been doing some development I notice that > when i reload my web app > > that the connection stays around. And after > enough connections are just > > sitting there, it doesn't allow me to make > anymore. It gives a JDBC > > error about not being able to make any more > connections without > > superuser status. > > > > I'm not even sure if this would be a problem in > production, but right > > now I'm finding it quite annoying to have to > restart tomcat on a regular > > basis. > > > > Before I get flamed, I just want to note that I'm > only asking here > > because I don't even know if this is a postgresql > problem or a tomcat > > one. So I'm asking on both mailing lists. > > Is the connection pool defined within you web app's > context? > > -- > Paul Thomas > +------------------------------+---------------------------------------------+ > | Thomas Micro Systems Limited | Software Solutions > for > Business | > | Computer Consultants | > http://www.thomas-micro-systems-ltd.co.uk | > +------------------------------+---------------------------------------------+ > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html
On 22/03/2004 16:15 dinakar wrote: > > Even i have the same problem what Paul Davis said with > respect to connection, > > >>Is the connection pool defined within you web app's > >>context? > yes i have defined the pool in the server.xml file and > reference in the web.xml file. That's not what I meant. Refer to the Tomcat docs and you'll see that you can declare resources in various places. I declare my connection pool stuff with my apps <Context></Context> block. I do this primarily because I can then put all of this in a seperate XML file named myapp.xml and just drop this file into Tomcat 4.1's webapps directory (again, refer to Tomcat's docs for this). As I'm sure you know, Tomcat gives each web app its own class loader so that when I stop my app, the connection pool also gets closed down and PostgreSQL cleans up its connections. But if you declare your connection pool outside of any context, I doubt that it would be closed down except when you stop Tomcat itself. > pls provide us a solution. I don't have a solution. I _never_ get the problem. All I can suggest is that you try it my way and see if helps. Other than that, you need to get support from the Tomcat lists. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
Hi Paul How have you set up connection pooling? (Did you follow the Tomcat How-to?) Also, what version of Tomcat are you running? Tell us more (copy and past your code fragments) about how you set it all up and we might be able to help you. > when i reload my web app that > the connection stays around... If you set up the connection pooling as a global JNDI resource, then I can imagine that reloading a particular web app would NOT cause that connection pool to stop and start. Setting up the DataSource as a context resource may be preferable. > after enough connections are > just sitting there, it doesn't > allow me to make anymore... How many connections is that? Are you taking care to *always* close your connections within 'finally' blocks? That is essential, to prevent connection leaks, which is what you might be suffering from. Regards Harry Mantheakis London, UK > Dear List, > > I've finally managed to get connection pooling going in tomcat. I've > noticed that when i reload my web app the postmaster will not drop any > of the connections. > > Basically the order of things is I start Tomcat, check out my servlet > and there's a connection that shows up to the postmaster. Now while > I've been doing some development I notice that when i reload my web app > that the connection stays around. And after enough connections are > just sitting there, it doesn't allow me to make anymore. It gives a > JDBC error about not being able to make any more connections without > superuser status. > > I'm not even sure if this would be a problem in production, but right > now I'm finding it quite annoying to have to restart tomcat on a > regular basis. > > Before I get flamed, I just want to note that I'm only asking here > because I don't even know if this is a postgresql problem or a tomcat > one. So I'm asking on both mailing lists. > > Thanks, > Paul Davis. > > *Insert witty quote* > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend
Please look a the docs at http://doc.postgresintl.com/jdbc/ch11s04.html I set his up and tested it, it works! Dave On Mon, 2004-03-22 at 13:09, Paul Thomas wrote: > On 22/03/2004 16:15 dinakar wrote: > > > > Even i have the same problem what Paul Davis said with > > respect to connection, > > > > >>Is the connection pool defined within you web app's > > >>context? > > yes i have defined the pool in the server.xml file and > > reference in the web.xml file. > > That's not what I meant. Refer to the Tomcat docs and you'll see that you > can declare resources in various places. I declare my connection pool > stuff with my apps <Context></Context> block. I do this primarily because > I can then put all of this in a seperate XML file named myapp.xml and just > drop this file into Tomcat 4.1's webapps directory (again, refer to > Tomcat's docs for this). As I'm sure you know, Tomcat gives each web app > its own class loader so that when I stop my app, the connection pool also > gets closed down and PostgreSQL cleans up its connections. But if you > declare your connection pool outside of any context, I doubt that it would > be closed down except when you stop Tomcat itself. > > > pls provide us a solution. > > I don't have a solution. I _never_ get the problem. All I can suggest is > that you try it my way and see if helps. Other than that, you need to get > support from the Tomcat lists. -- Dave Cramer 519 939 0336 ICQ # 14675561
On 22/03/2004 20:36 Dave Cramer wrote: > Please look a the docs at > http://doc.postgresintl.com/jdbc/ch11s04.html > > I set his up and tested it, it works! Virtually identical to how I do it. Maybe Paul and dinakar will take the hint ;) -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
Hi All, Even i have implement the same for my aplication. sometime i am getting "unexpected EOF on client connection" in the postgres log file. any idea ? pls advise. Thanks, dinakar --- Paul Thomas <paul@tmsl.demon.co.uk> wrote: > On 22/03/2004 20:36 Dave Cramer wrote: > > Please look a the docs at > > http://doc.postgresintl.com/jdbc/ch11s04.html > > > > I set his up and tested it, it works! > > Virtually identical to how I do it. Maybe Paul and > dinakar will take the > hint ;) > > -- > Paul Thomas > +------------------------------+---------------------------------------------+ > | Thomas Micro Systems Limited | Software Solutions > for > Business | > | Computer Consultants | > http://www.thomas-micro-systems-ltd.co.uk | > +------------------------------+---------------------------------------------+ > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to > majordomo@postgresql.org so that your > message can get through to the mailing list cleanly __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html
On 24/03/2004 04:57 dinakar wrote: > Hi All, > > Even i have implement the same for my aplication. > > sometime i am getting > > "unexpected EOF on client connection" > > in the postgres log file. > > any idea ? pls advise. Maybe malformed SQL being sent to back-end? Try turning on statement logging. That may show you what postgres is complaining about. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
Dinakar, This is a result of the client quitting, not the backend. Dave On Tue, 2004-03-23 at 23:57, dinakar wrote: > Hi All, > > Even i have implement the same for my aplication. > > sometime i am getting > > "unexpected EOF on client connection" > > in the postgres log file. > > any idea ? pls advise. > > Thanks, > dinakar > > > > --- Paul Thomas <paul@tmsl.demon.co.uk> wrote: > > On 22/03/2004 20:36 Dave Cramer wrote: > > > Please look a the docs at > > > http://doc.postgresintl.com/jdbc/ch11s04.html > > > > > > I set his up and tested it, it works! > > > > Virtually identical to how I do it. Maybe Paul and > > dinakar will take the > > hint ;) > > > > -- > > Paul Thomas > > > +------------------------------+---------------------------------------------+ > > | Thomas Micro Systems Limited | Software Solutions > > for > > Business | > > | Computer Consultants | > > http://www.thomas-micro-systems-ltd.co.uk | > > > +------------------------------+---------------------------------------------+ > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please > > send an appropriate > > subscribe-nomail command to > > majordomo@postgresql.org so that your > > message can get through to the mailing list > cleanly > > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > -- Dave Cramer 519 939 0336 ICQ # 14675561
Hi Dave, thanks dave, will this affect the application performance. ? Thanks, Dinakar --- Dave Cramer <pg@fastcrypt.com> wrote: > Dinakar, > > This is a result of the client quitting, not the > backend. > > Dave > On Tue, 2004-03-23 at 23:57, dinakar wrote: > > Hi All, > > > > Even i have implement the same for my aplication. > > > > sometime i am getting > > > > "unexpected EOF on client connection" > > > > in the postgres log file. > > > > any idea ? pls advise. > > > > Thanks, > > dinakar > > > > > > > > --- Paul Thomas <paul@tmsl.demon.co.uk> wrote: > > > On 22/03/2004 20:36 Dave Cramer wrote: > > > > Please look a the docs at > > > > http://doc.postgresintl.com/jdbc/ch11s04.html > > > > > > > > I set his up and tested it, it works! > > > > > > Virtually identical to how I do it. Maybe Paul > and > > > dinakar will take the > > > hint ;) > > > > > > -- > > > Paul Thomas > > > > > > +------------------------------+---------------------------------------------+ > > > | Thomas Micro Systems Limited | Software > Solutions > > > for > > > Business | > > > | Computer Consultants | > > > http://www.thomas-micro-systems-ltd.co.uk | > > > > > > +------------------------------+---------------------------------------------+ > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > TIP 3: if posting/reading through Usenet, please > > > send an appropriate > > > subscribe-nomail command to > > > majordomo@postgresql.org so that your > > > message can get through to the mailing > list > > cleanly > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Finance Tax Center - File online. File on > time. > > http://taxes.yahoo.com/filing.html > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 9: the planner will ignore your desire to > choose an index scan if your > > joining column's datatypes do not match > > > -- > Dave Cramer > 519 939 0336 > ICQ # 14675561 > __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html
It won't affect performance directly, but I'd like to know why your client is failing. Dave On Wed, 2004-03-24 at 07:25, dinakar wrote: > Hi Dave, > > thanks dave, will this affect the application > performance. ? > > Thanks, > Dinakar > > --- Dave Cramer <pg@fastcrypt.com> wrote: > > Dinakar, > > > > This is a result of the client quitting, not the > > backend. > > > > Dave > > On Tue, 2004-03-23 at 23:57, dinakar wrote: > > > Hi All, > > > > > > Even i have implement the same for my aplication. > > > > > > sometime i am getting > > > > > > "unexpected EOF on client connection" > > > > > > in the postgres log file. > > > > > > any idea ? pls advise. > > > > > > Thanks, > > > dinakar > > > > > > > > > > > > --- Paul Thomas <paul@tmsl.demon.co.uk> wrote: > > > > On 22/03/2004 20:36 Dave Cramer wrote: > > > > > Please look a the docs at > > > > > http://doc.postgresintl.com/jdbc/ch11s04.html > > > > > > > > > > I set his up and tested it, it works! > > > > > > > > Virtually identical to how I do it. Maybe Paul > > and > > > > dinakar will take the > > > > hint ;) > > > > > > > > -- > > > > Paul Thomas > > > > > > > > > > +------------------------------+---------------------------------------------+ > > > > | Thomas Micro Systems Limited | Software > > Solutions > > > > for > > > > Business | > > > > | Computer Consultants | > > > > http://www.thomas-micro-systems-ltd.co.uk | > > > > > > > > > > +------------------------------+---------------------------------------------+ > > > > > > > > ---------------------------(end of > > > > broadcast)--------------------------- > > > > TIP 3: if posting/reading through Usenet, please > > > > send an appropriate > > > > subscribe-nomail command to > > > > majordomo@postgresql.org so that your > > > > message can get through to the mailing > > list > > > cleanly > > > > > > > > > __________________________________ > > > Do you Yahoo!? > > > Yahoo! Finance Tax Center - File online. File on > > time. > > > http://taxes.yahoo.com/filing.html > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > TIP 9: the planner will ignore your desire to > > choose an index scan if your > > > joining column's datatypes do not match > > > > > -- > > Dave Cramer > > 519 939 0336 > > ICQ # 14675561 > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html > -- Dave Cramer 519 939 0336 ICQ # 14675561
can you pls let me know how to check that why the client fails... --- Dave Cramer <pg@fastcrypt.com> wrote: > It won't affect performance directly, but I'd like > to know why your > client is failing. > > Dave > On Wed, 2004-03-24 at 07:25, dinakar wrote: > > Hi Dave, > > > > thanks dave, will this affect the application > > performance. ? > > > > Thanks, > > Dinakar > > > > --- Dave Cramer <pg@fastcrypt.com> wrote: > > > Dinakar, > > > > > > This is a result of the client quitting, not the > > > backend. > > > > > > Dave > > > On Tue, 2004-03-23 at 23:57, dinakar wrote: > > > > Hi All, > > > > > > > > Even i have implement the same for my > aplication. > > > > > > > > sometime i am getting > > > > > > > > "unexpected EOF on client connection" > > > > > > > > in the postgres log file. > > > > > > > > any idea ? pls advise. > > > > > > > > Thanks, > > > > dinakar > > > > > > > > > > > > > > > > --- Paul Thomas <paul@tmsl.demon.co.uk> wrote: > > > > > On 22/03/2004 20:36 Dave Cramer wrote: > > > > > > Please look a the docs at > > > > > > > http://doc.postgresintl.com/jdbc/ch11s04.html > > > > > > > > > > > > I set his up and tested it, it works! > > > > > > > > > > Virtually identical to how I do it. Maybe > Paul > > > and > > > > > dinakar will take the > > > > > hint ;) > > > > > > > > > > -- > > > > > Paul Thomas > > > > > > > > > > > > > > > +------------------------------+---------------------------------------------+ > > > > > | Thomas Micro Systems Limited | Software > > > Solutions > > > > > for > > > > > Business | > > > > > | Computer Consultants | > > > > > http://www.thomas-micro-systems-ltd.co.uk > | > > > > > > > > > > > > > > > +------------------------------+---------------------------------------------+ > > > > > > > > > > ---------------------------(end of > > > > > broadcast)--------------------------- > > > > > TIP 3: if posting/reading through Usenet, > please > > > > > send an appropriate > > > > > subscribe-nomail command to > > > > > majordomo@postgresql.org so that your > > > > > message can get through to the mailing > > > list > > > > cleanly > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > Yahoo! Finance Tax Center - File online. File > on > > > time. > > > > http://taxes.yahoo.com/filing.html > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > > TIP 9: the planner will ignore your desire to > > > choose an index scan if your > > > > joining column's datatypes do not match > > > > > > > -- > > > Dave Cramer > > > 519 939 0336 > > > ICQ # 14675561 > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Finance Tax Center - File online. File on > time. > > http://taxes.yahoo.com/filing.html > > > -- > Dave Cramer > 519 939 0336 > ICQ # 14675561 > > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html
Dinakar I would turn logging on, and log pids to see which pid is failing and what it did just before it fails. Dave On Wed, 2004-03-24 at 08:58, dinakar wrote: > can you pls let me know how to check that why the > client fails... > > --- Dave Cramer <pg@fastcrypt.com> wrote: > > It won't affect performance directly, but I'd like > > to know why your > > client is failing. > > > > Dave > > On Wed, 2004-03-24 at 07:25, dinakar wrote: > > > Hi Dave, > > > > > > thanks dave, will this affect the application > > > performance. ? > > > > > > Thanks, > > > Dinakar > > > > > > --- Dave Cramer <pg@fastcrypt.com> wrote: > > > > Dinakar, > > > > > > > > This is a result of the client quitting, not the > > > > backend. > > > > > > > > Dave > > > > On Tue, 2004-03-23 at 23:57, dinakar wrote: > > > > > Hi All, > > > > > > > > > > Even i have implement the same for my > > aplication. > > > > > > > > > > sometime i am getting > > > > > > > > > > "unexpected EOF on client connection" > > > > > > > > > > in the postgres log file. > > > > > > > > > > any idea ? pls advise. > > > > > > > > > > Thanks, > > > > > dinakar > > > > > > > > > > > > > > > > > > > > --- Paul Thomas <paul@tmsl.demon.co.uk> wrote: > > > > > > On 22/03/2004 20:36 Dave Cramer wrote: > > > > > > > Please look a the docs at > > > > > > > > > http://doc.postgresintl.com/jdbc/ch11s04.html > > > > > > > > > > > > > > I set his up and tested it, it works! > > > > > > > > > > > > Virtually identical to how I do it. Maybe > > Paul > > > > and > > > > > > dinakar will take the > > > > > > hint ;) > > > > > > > > > > > > -- > > > > > > Paul Thomas > > > > > > > > > > > > > > > > > > > > > +------------------------------+---------------------------------------------+ > > > > > > | Thomas Micro Systems Limited | Software > > > > Solutions > > > > > > for > > > > > > Business | > > > > > > | Computer Consultants | > > > > > > http://www.thomas-micro-systems-ltd.co.uk > > | > > > > > > > > > > > > > > > > > > > > > +------------------------------+---------------------------------------------+ > > > > > > > > > > > > ---------------------------(end of > > > > > > broadcast)--------------------------- > > > > > > TIP 3: if posting/reading through Usenet, > > please > > > > > > send an appropriate > > > > > > subscribe-nomail command to > > > > > > majordomo@postgresql.org so that your > > > > > > message can get through to the mailing > > > > list > > > > > cleanly > > > > > > > > > > > > > > > __________________________________ > > > > > Do you Yahoo!? > > > > > Yahoo! Finance Tax Center - File online. File > > on > > > > time. > > > > > http://taxes.yahoo.com/filing.html > > > > > > > > > > ---------------------------(end of > > > > broadcast)--------------------------- > > > > > TIP 9: the planner will ignore your desire to > > > > choose an index scan if your > > > > > joining column's datatypes do not match > > > > > > > > > -- > > > > Dave Cramer > > > > 519 939 0336 > > > > ICQ # 14675561 > > > > > > > > > > > > > __________________________________ > > > Do you Yahoo!? > > > Yahoo! Finance Tax Center - File online. File on > > time. > > > http://taxes.yahoo.com/filing.html > > > > > -- > > Dave Cramer > > 519 939 0336 > > ICQ # 14675561 > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map > settings > > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html > -- Dave Cramer 519 939 0336 ICQ # 14675561
More specifically this error is generated when a client doesn't properly close the connection to the database. In jdbc that means the close method was never called on the connection object. This most commonly occurs when a client app simply exits (i.e. the jvm shuts down) without any finalizers/etc running to properly shutdown. Or this can be caused by bad code that fails to close a connection in all cases. --Barry dinakar wrote: > can you pls let me know how to check that why the > client fails... > > --- Dave Cramer <pg@fastcrypt.com> wrote: > >>It won't affect performance directly, but I'd like >>to know why your >>client is failing. >> >>Dave >>On Wed, 2004-03-24 at 07:25, dinakar wrote: >> >>>Hi Dave, >>> >>> thanks dave, will this affect the application >>>performance. ? >>> >>>Thanks, >>>Dinakar >>> >>>--- Dave Cramer <pg@fastcrypt.com> wrote: >>> >>>>Dinakar, >>>> >>>>This is a result of the client quitting, not the >>>>backend. >>>> >>>>Dave >>>>On Tue, 2004-03-23 at 23:57, dinakar wrote: >>>> >>>>>Hi All, >>>>> >>>>>Even i have implement the same for my >> >>aplication. >> >>>>>sometime i am getting >>>>> >>>>>"unexpected EOF on client connection" >>>>> >>>>>in the postgres log file. >>>>> >>>>>any idea ? pls advise. >>>>> >>>>>Thanks, >>>>>dinakar >>>>> >>>>> >>>>> >>>>>--- Paul Thomas <paul@tmsl.demon.co.uk> wrote: >>>>> >>>>>>On 22/03/2004 20:36 Dave Cramer wrote: >>>>>> >>>>>>>Please look a the docs at >>>>>>> >> >>http://doc.postgresintl.com/jdbc/ch11s04.html >> >>>>>>>I set his up and tested it, it works! >>>>>> >>>>>>Virtually identical to how I do it. Maybe >> >>Paul >> >>>>and >>>> >>>>>>dinakar will take the >>>>>>hint ;) >>>>>> >>>>>>-- >>>>>>Paul Thomas >>>>>> >>>>> > +------------------------------+---------------------------------------------+ > >>>>>>| Thomas Micro Systems Limited | Software >>>> >>>>Solutions >>>> >>>>>>for >>>>>>Business | >>>>>>| Computer Consultants | >>>>>>http://www.thomas-micro-systems-ltd.co.uk >> >>| >> > +------------------------------+---------------------------------------------+ > >>>>>>---------------------------(end of >>>>>>broadcast)--------------------------- >>>>>>TIP 3: if posting/reading through Usenet, >> >>please >> >>>>>>send an appropriate >>>>>> subscribe-nomail command to >>>>>>majordomo@postgresql.org so that your >>>>>> message can get through to the mailing >>>> >>>>list >>>> >>>>>cleanly >>>>> >>>>> >>>>>__________________________________ >>>>>Do you Yahoo!? >>>>>Yahoo! Finance Tax Center - File online. File >> >>on >> >>>>time. >>>> >>>>>http://taxes.yahoo.com/filing.html >>>>> >>>>>---------------------------(end of >>>> >>>>broadcast)--------------------------- >>>> >>>>>TIP 9: the planner will ignore your desire to >>>> >>>>choose an index scan if your >>>> >>>>> joining column's datatypes do not match >>>>> >>>> >>>>-- >>>>Dave Cramer >>>>519 939 0336 >>>>ICQ # 14675561 >>>> >>> >>> >>>__________________________________ >>>Do you Yahoo!? >>>Yahoo! Finance Tax Center - File online. File on >> >>time. >> >>>http://taxes.yahoo.com/filing.html >>> >> >>-- >>Dave Cramer >>519 939 0336 >>ICQ # 14675561 >> >> >>---------------------------(end of >>broadcast)--------------------------- >>TIP 7: don't forget to increase your free space map > > settings > > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend