Re: [OT] Memory leak when using DB connection ??

2007-04-06 Thread Laurie Harper
s jar file to my projec's lib directory and I copied taglibs-dbtags.tld to WEB-INF 2) These lines were added to web.xml: DB Connection jdbc/SZTGKR javax.sql.DataSource Container /WEB-INF/dbtags.tld /WEB-INF/taglibs-dbtag

Re: Memory leak when using DB connection ??

2007-04-06 Thread mansour77
y few resources online on how to set up database handling in Struts. Here's how I set it up (if it helps...) 1) I added mysql driver's jar file to my projec's lib directory and I copied taglibs-dbtags.tld to WEB-INF 2) These lines were added to web.xm

Memory leak when using DB connection ??

2007-04-06 Thread Balazs Michnay
d I copied taglibs-dbtags.tld to WEB-INF 2) These lines were added to web.xml: DB Connection jdbc/SZTGKR javax.sql.DataSource Container /WEB-INF/dbtags.tld /WEB-INF/taglibs-dbtags.tld 3) And I used the connection i

RE: Struts to Postgresql db connection refused

2005-09-13 Thread David G. Friedman
eptember 13, 2005 8:24 AM To: Struts Users Mailing List Subject: Re: Struts to Postgresql db connection refused On 9/13/05, David G. Friedman <[EMAIL PROTECTED]> wrote: > Raj, > > Have you double checked that you can reach it from the command line on the > server BEFORE trying it

Re: Struts to Postgresql db connection refused

2005-09-13 Thread Adrian Maier
ED] > Sent: Tuesday, September 13, 2005 8:00 AM > To: user@struts.apache.org > Subject: Struts to Postgresql db connection refused > > > Hi, > > > When I connect Struts to Postgresql 8.0 database using DataSource object I > get the following error messages: > > Sour

Re: Struts to Postgresql db connection refused

2005-09-13 Thread Bjørn T Johansen
> psql -Upostgres -d omsdb -h 192.168.1.22 -p 5432 > > Thanks > Raj > > > > From: Adrian Maier [mailto:[EMAIL PROTECTED] > Sent: Tue 9/13/2005 5:24 AM > To: Struts Users Mailing List > Subject: Re: Struts to Postgresql db connection

RE: Struts to Postgresql db connection refused

2005-09-13 Thread R Rajendran
I tried this command it works: psql -Upostgres -d omsdb -h 192.168.1.22 -p 5432 Thanks Raj From: Adrian Maier [mailto:[EMAIL PROTECTED] Sent: Tue 9/13/2005 5:24 AM To: Struts Users Mailing List Subject: Re: Struts to Postgresql db connection refused On 9

RE: Struts to Postgresql db connection refused

2005-09-13 Thread R Rajendran
It works fine with command line. I could connect to the db and query. Thanks Raj From: David G. Friedman [mailto:[EMAIL PROTECTED] Sent: Tue 9/13/2005 5:00 AM To: Struts Users Mailing List Subject: RE: Struts to Postgresql db connection refused Raj, Have

Re: Struts to Postgresql db connection refused

2005-09-13 Thread Adrian Maier
ED] > Sent: Tuesday, September 13, 2005 8:00 AM > To: user@struts.apache.org > Subject: Struts to Postgresql db connection refused > > > Hi, > > > When I connect Struts to Postgresql 8.0 database using DataSource object I > get the following error messages: > > Sour

RE: Struts to Postgresql db connection refused

2005-09-13 Thread David G. Friedman
e.org Subject: Struts to Postgresql db connection refused Hi, When I connect Struts to Postgresql 8.0 database using DataSource object I get the following error messages: Source: DataSource dataSource = null; try { dataSource = getDataSource(request); conn = dataSource.getConne

Struts to Postgresql db connection refused

2005-09-13 Thread R Rajendran
Hi, When I connect Struts to Postgresql 8.0 database using DataSource object I get the following error messages: Source: DataSource dataSource = null; try { dataSource = getDataSource(request); conn = dataSource.getConnection(); stmt = conn.createStatement(); String

Re: Struts to Postgresql db connection refused

2005-09-08 Thread Murray Collingwood
Hi Raj While I'm not using Postgresql (MySQL instead) there were a couple of things I noticed that you might need to check: 1. You have specified the data source entry in your Struts-config.xml - on my Tomcat 5.0 I need to enter this in the META-INF/context.xml (I have more on this if you

Re: Struts to Postgresql db connection refused

2005-09-08 Thread Brian Bruns
You need to add the "-i" switch to postmaster (-o -i to pg_ctl I think) to enable tcp/ip connections. Please see the PostgreSQL documentation. 2005/9/8, R Rajendran <[EMAIL PROTECTED]>: > Hi, > > When I connect Struts to Postgresql 8.0 database using DataSource object I > get the following erro

Struts to Postgresql db connection refused

2005-09-08 Thread R Rajendran
Hi, When I connect Struts to Postgresql 8.0 database using DataSource object I get the following error messages: Source: DataSource dataSource = null; try { dataSource = getDataSource(request); conn = dataSource.getConnection(); /* working Class.forName("org.po

Re: DB Connection

2005-07-25 Thread Laurie Harper
DB connections you have stored in your session. Note: personally, I'd avoid associating a DB connection with each session like this, since it will limit how far the application can scale. The number of users it can support will be limited by the number of database connections you can cope

Re: DB Connection

2005-07-25 Thread Stéphane Zuckerman
Senthilrajan VS a écrit : Hi Stéphane Zuckerman, Thanks for your response. Can u please tell me how can I close the connection if the user close the window directly because I am not maintain any session in the window These are two unrelated events : you want a client-side event to create a s

Re: DB Connection

2005-07-25 Thread Senthilrajan VS
;Struts Users Mailing List" Sent: Monday, July 25, 2005 5:34 PM Subject: Re: DB Connection Vijay K Anand a écrit : > hi > > How to share the saem db connection across user requests..without > exhausitn the connection pool. > > regards > Vijay You could create a plugin t

Re: DB Connection

2005-07-25 Thread Stéphane Zuckerman
Vijay K Anand a écrit : hi How to share the saem db connection across user requests..without exhausitn the connection pool. regards Vijay You could create a plugin that connects to the Database when launching the webapp, then put the handler in the servlet context. Then you could

DB Connection

2005-07-25 Thread Vijay K Anand
hi How to share the saem db connection across user requests..without exhausitn the connection pool. regards Vijay - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: DB Connection Best practice

2004-12-26 Thread uma.k
Hi Amit, Yes,the mail reached me. Thanks Uma -Original Message- From: Amit Gupta [mailto:[EMAIL PROTECTED] Sent: Monday, December 27, 2004 9:49 AM To: Struts Users Mailing List Subject: RE: DB Connection Best practice I sent you message in separate mail on Friday. Have you got that

RE: DB Connection Best practice

2004-12-26 Thread Amit Gupta
AM To: Struts Users Mailing List Subject: RE: DB Connection Best practice Hi Amit, Would appreciate if u can forward the same msg again to me too. As i am also a struggler i also might need it Thanks, Manisha Amit Gupta <[EMAIL PROTECTED]> wrote: Hi Uma, I use DBCP for this. Refer my m

RE: DB Connection Best practice

2004-12-25 Thread Manisha Sathe
g same to you on your personal ID. -Original Message- From: uma.k [mailto:[EMAIL PROTECTED] Sent: Friday, December 24, 2004 10:20 AM To: 'Struts Users Mailing List' Subject: DB Connection Best practice Hi, I wanted to insert a record into the database or update a record in the d

RE: DB Connection Best practice

2004-12-23 Thread Amit Gupta
7; Subject: DB Connection Best practice Hi, I wanted to insert a record into the database or update a record in the database or get a record from the database. Where do I make my database connection? Is it in the Action class? Can I make a single java class handle all of that for me? If the above

RE: DB Connection Best practice

2004-12-23 Thread uma.k
Thanks Sunny, I will do that. Uma -Original Message- From: Sunny [mailto:[EMAIL PROTECTED] Sent: Friday, December 24, 2004 10:27 AM To: Struts Users Mailing List Subject: Re: DB Connection Best practice Better practice would be delegating to a "handler" (application layer)

Re: DB Connection Best practice

2004-12-23 Thread Sunny
Better practice would be delegating to a "handler" (application layer) class and let it return data in form of some bean and use that in action. In this way you'll be isolating Controller from Business model. uma.k wrote: Hi, I wanted to insert a record into the database or update a record in th

DB Connection Best practice

2004-12-23 Thread uma.k
Hi, I wanted to insert a record into the database or update a record in the database or get a record from the database. Where do I make my database connection? Is it in the Action class? Can I make a single java class handle all of that for me? If the above are wrong. Please let me know which is