Re: [OT] Connection Pooling

2007-05-22 Thread Nuwan Chandrasoma
o: "Struts Users Mailing List" Sent: Tuesday, May 22, 2007 6:39 AM Subject: Re: [OT] Connection Pooling Thanks for helping. Sure, here are all my settings. I use MySQL 5.0.37, Tomcat 5.5.17 and Windows XP SP2 and MySQL Connector/J 5.0.5. The name of the database that I'd like to con

Re: [OT] Connection Pooling

2007-05-21 Thread Balazs Michnay
url jdbc:mysql://localhost:3306 -END OF CONTEXT.XML I have a java class, that (presumably) creates (or returns...?) my connection pool: - DBTEST.JAVA package db_helpers; import javax.naming.*; import javax.sql.*; import java.sq

Re: [OT] Connection Pooling

2007-05-21 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Balazs, Balazs Michnay wrote: > I still cannot estabilish database connection using connection pooling. > I think I made all the settings I need, but still nothing... > 1) I have a tag in my server.xml Can you show us the connection set

Connection Pooling

2007-05-21 Thread Balazs Michnay
Hi there, This post might not be struts-related, but I read so many posts on this issue, that I thought I might ask... Having read all the posts, I still cannot estabilish database connection using connection pooling. I think I made all the settings I need, but still nothing... 1) I have a tag

Re: Spam:: getting error when i m trying to make database connection

2007-05-08 Thread Musachy Barroso
No Class Definition Found Error, where the class is org.apache.commons.pool.impl.GenericObjectPool, you are probably missing commons pool, http://jakarta.apache.org/commons/pool/ musachy On 5/8/07, Shshir <[EMAIL PROTECTED]> wrote: org.apache.catalina.core.StandardContext loadOnStartup SEVER

Spam:: getting error when i m trying to make database connection

2007-05-07 Thread Shshir
org.apache.catalina.core.StandardContext loadOnStartup SEVERE: Servlet /registration threw load() exception java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericObjectPool - To unsubscribe, e-mail: [EMAIL PROTECT

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
This is one of the problem using connection pooling. This page explains it and offers a solution: http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html I hope it helps. Balazs Michnay wrote: Dear Struts users, Finally I managed to get DB-handling working, but I&#

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: Connection, pool exhausted error

2007-02-28 Thread Mon Cab
That fixed it. It's working now. Thanks Kalra. --- "Kalra, Ashwani" <[EMAIL PROTECTED]> wrote: > > No. Closing the Initial context will close the connection(not > database) > to the naming service from which you look up the datasource. > When you call ds

RE: Connection, pool exhausted error

2007-02-28 Thread Kalra, Ashwani
No. Closing the Initial context will close the connection(not database) to the naming service from which you look up the datasource. When you call ds.getConnection(), you actually get a proxy class which delegates your calls to actual vendor specific connection. When you call close on this, an

RE: Connection, pool exhausted error

2007-02-28 Thread Mon Cab
I thought that closing the connection was unnecessary when using a connection pool. I was under the impression that one would just close the context, which would return the connectin to the connection pool. Is this not the case? --- "Kalra, Ashwani" <[EMAIL PROTECTED]> wr

RE: Connection, pool exhausted error

2007-02-28 Thread Kalra, Ashwani
Where are you closing the connection? -Original Message- From: Mon Cab [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 12:23 PM To: Struts User Group Subject: Connection, pool exhausted error I am getting a connection, pool exhausted error, in the action class below. The

Connection, pool exhausted error

2007-02-28 Thread Mon Cab
I am getting a connection, pool exhausted error, in the action class below. The error happens exactly after the hundredth connection, even though I have closed all my statements, result sets and contexts. (I know that one would not normally do db access in an Action class, however, I&#

Re: [JAVA]How to get datatbase connection from lookup to datatsource name in a standalone java application

2006-08-25 Thread Scott Van Wart
Jimmy Emmanual wrote: 1. Bind datasource to a file system context try { Hashtable env = new Hashtable(); env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.fscontext.RefFSContextFactory"); env.put(Context.PROVIDER_URL, "file:/C:/temp/jndi"); Problem with that is, if

RE: [JAVA]How to get datatbase connection from lookup to datatsource name in a standalone java application

2006-08-25 Thread Jimmy Emmanual
ble env = new Hashtable(); env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.fscontext.RefFSContextFactory"); env.put(Context.PROVIDER_URL, "file:/C:/temp/jndi"); // create the context context = new InitialContext(env); // call method to

Re: [JAVA]How to get datatbase connection from lookup to datatsource name in a standalone java application

2006-08-24 Thread Scott Van Wart
Caroline Jen wrote: Context ctx = new InitialContect(); DataSource ds = (DataSource)ctx.lookup("java:com/env/jdbc/DBName"); Connection con = ds.getConnection(); Right, but that's assuming it's already bound, which is the hard part, and unless he's running it

Re: [JAVA]How to get datatbase connection from lookup to datatsource name in a standalone java application

2006-08-24 Thread Scott Van Wart
temp temp wrote: My java standalone application wants connection to database with lookup to datasource name which is configured in the oc4j app server. Please guide me with some ideas to achieve this. You need to bind it yourself, to some provider. I use the DBCP provided with Tomcat

Re: [JAVA]How to get datatbase connection from lookup to datatsource name in a standalone java application

2006-08-24 Thread Caroline Jen
Context ctx = new InitialContect(); DataSource ds = (DataSource)ctx.lookup("java:com/env/jdbc/DBName"); Connection con = ds.getConnection(); --- Scott Van Wart <[EMAIL PROTECTED]> wrote: > temp temp wrote: > > My java standalone application wants connection to &

[JAVA]How to get datatbase connection from lookup to datatsource name in a standalone java application

2006-08-24 Thread temp temp
My java standalone application wants connection to database with lookup to datasource name which is configured in the oc4j app server. Please guide me with some ideas to achieve this. - Do you Yahoo!? Everyone is

Re: Connection pool problem

2006-08-01 Thread Antonio Petrelli
Rauf Khan ha scritto: java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericObjectPool You need Jakarta Commons Pool: http://jakarta.apache.org/commons/pool/ Anyway notice that Struts DataSource support has been removed since 1.2 version (correct me if I am wrong), so you probab

Connection pool problem

2006-08-01 Thread Rauf Khan
Hi, Iam trying to connect to oracle database through struts database connection pool, also i have placed commons-dbcp.1.2.1.jar in web-inf/lib folder. It is throwing the following error: java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericObjectPool

Re: How to configure Struts connection pool

2006-04-03 Thread Tarun Reddy
Hi Craig, I'm very glad to recieve an e-mail from you. I keep following your interviews in www.theserverside.com . Well I didn't know that Struts DataSource concept has been deprecated. I've been using Weblogic from so many years and it's very easy to configure datasources and

Re: How to configure Struts connection pool

2006-04-02 Thread Craig McClanahan
On 4/2/06, Tarun Reddy <[EMAIL PROTECTED]> wrote: > > Could you please try not to configure your data source in Tomcat? Instead > try to configure your datasource only in struts-config.xml file as I've > mentioned. It should work. Please get rid of the JNDI lookup code from the > JSP and use the ge

Re: How to configure Struts connection pool

2006-04-02 Thread Martin Gainty
Tarun Reddy" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" Sent: Sunday, April 02, 2006 10:47 AM Subject: Re: How to configure Struts connection pool > Could you please try not to configure your data source in Tomcat? Instead > try to configure your datasource o

Re: How to configure Struts connection pool

2006-04-02 Thread Tarun Reddy
t worry about all the naming lookups. That method will take > > care of retrieving DataSource object . Even if you want to keep the > "key" > > attribute, then try using this, > > DataSource db= getDataSource(request,key); > > > > This should work for y

Re: How to configure Struts connection pool

2006-04-01 Thread red phoenix
t . Even if you want to keep the "key" > attribute, then try using this, > DataSource db= getDataSource(request,key); > > This should work for you. Let me know if you still face any issues. > > Thanks, > Tarun. > > > On 4/1/06, red phoenix <[EMAIL PRO

Re: How to configure Struts connection pool

2006-04-01 Thread Tarun Reddy
arun. On 4/1/06, red phoenix <[EMAIL PROTECTED]> wrote: > > I use struts-1.2.9,and want to configure a connection pool,so I configure > struts-config.xml file > > > > > > > > > > > > > Then I use this configure in a jsp file,

Why struts can't use Tomcat5 connection pool?

2006-04-01 Thread red phoenix
I configure a connection pool in Tomcat5.5.12,like follows: Then I call this connection pool in a JSP file,the JSP file is follows: <[EMAIL PROTECTED] <%@<[EMAIL PROTECTED]> import="java.sql.*"%> <[EMAIL PROTECTED] import="javax.sql.DataSo

How to configure Struts connection pool

2006-04-01 Thread red phoenix
I use struts-1.2.9,and want to configure a connection pool,so I configure struts-config.xml file Then I use this configure in a jsp file,like follows: <[EMAIL PROTECTED] import="java.sql.*"%> <[EMAIL PROTECTED] import="javax.sql.DataSou

Re: [Shale] When to create a database Connection?

2006-03-30 Thread Alexandre Poitras
d destroy is called twice if you navigate back to the same page > (postback). > > http://issues.apache.org/bugzilla/show_bug.cgi?id=38000 > > It doesn't sound like that is what is going in your case. I would look at > using the JNDI connection pooling over this method

RE: [Shale] When to create a database Connection?

2006-03-29 Thread Gary VanMatre
.cgi?id=38000 It doesn't sound like that is what is going in your case. I would look at using the JNDI connection pooling over this method if you want to use the jdbc api directly. Gary > -Original Message- > From: James Reynolds [mailto:[EMAIL PROTECTED] > Sent: Wed

SV: [Shale] When to create a database Connection?

2006-03-29 Thread Hermod Opstvedt
g- Fra: Yee, Richard K CTR DMDC [mailto:[EMAIL PROTECTED] Sendt: 29. mars 2006 22:34 Til: 'Struts Users Mailing List' Emne: RE: [Shale] When to create a database Connection? Check out iBATIS. You can use the DaoManager for a very lightweight framework. It will handle getting and cl

[OT] Re: [Shale] When to create a database Connection?

2006-03-29 Thread Dave Newton
Yee, Richard K CTR DMDC wrote: > [...] Hey... We might need a cruise missile or two; what do you think? Dave - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: [Shale] When to create a database Connection?

2006-03-29 Thread Yee, Richard K CTR DMDC
- From: James Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 29, 2006 11:16 AM To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: [Shale] When to create a database Connection? Hi Hermod, Here's my reason I'm under pressure to get this project complete so I'

SV: [Shale] When to create a database Connection?

2006-03-29 Thread Hermod Opstvedt
ld be able to grasp this, at least at a basic level fairly quick. Hermod -Opprinnelig melding- Fra: James Reynolds [mailto:[EMAIL PROTECTED] Sendt: 29. mars 2006 21:16 Til: Struts Users Mailing List; [EMAIL PROTECTED] Emne: RE: [Shale] When to create a database Connection? Hi Hermod, H

RE: [Shale] When to create a database Connection?

2006-03-29 Thread James Reynolds
. Maybe my assumption is invalid, how challenging are these technologies for new comers? Thanks -Original Message- From: Hermod Opstvedt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 29, 2006 11:45 AM To: 'Struts Users Mailing List' Subject: SV: [Shale] When to create a databas

SV: [Shale] When to create a database Connection?

2006-03-29 Thread Hermod Opstvedt
-Opprinnelig melding- Fra: James Reynolds [mailto:[EMAIL PROTECTED] Sendt: 29. mars 2006 19:33 Til: Struts Users Mailing List Emne: [Shale] When to create a database Connection? I'm getting a null pointer error in my backing bean. My grand plan was to create a Connection in the init() m

RE: [Shale] When to create a database Connection?

2006-03-29 Thread James Reynolds
Never mind, I mis-spelled the bean name in the Faces-Config. Oh the shame :( -Original Message- From: James Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 29, 2006 10:33 AM To: Struts Users Mailing List Subject: [Shale] When to create a database Connection? I'm gett

[Shale] When to create a database Connection?

2006-03-29 Thread James Reynolds
I'm getting a null pointer error in my backing bean. My grand plan was to create a Connection in the init() method extended from the AbstractViewController, so it can be used by any number of methods and getters in my bean, and then close it in destroy(). In this simple case, the only

RE: Developing and running Struts on Tomcat without an Internet Connection

2006-03-20 Thread Sunil_Sahu
ception. Moral of he story is check DOCTYPE in your xml file and match it with corresponding DTD in struts.jar file. Hope it helps.. Sunil <[EMAIL PROTECTED]> 03/17/2006 09:07 PM Please respond to "Struts Users Mailing List" To cc Subject RE: Developing and running Strut

Re: Developing and running Struts on Tomcat without an Internet Connection

2006-03-19 Thread Hey Nony Moose
Sounds like Gurpreet.S.Dhanoa is decribing the same shotgun apporach that I was saying I used (making local copies of referenced files), which I've always been sure was suboptimal but it got me out of trouble. (ie: it "works") I'll try to take in the comments given of how to fix it optimally for ne

RE: Developing and running Struts on Tomcat without an Internet Connection

2006-03-17 Thread Gurpreet.S.Dhanoa
tml"%> JSP for HelloForm form name : password : _ From: Joe Germuska [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 9:52 AM To: Dhanoa, Gurpreet S.; user@struts.apache.org Subject: RE: Developing and running Struts on Tomcat without an Internet Connection

RE: Developing and running Struts on Tomcat without an Internet Connection

2006-03-17 Thread Joe Germuska
March 16, 2006 9:28 PM To: Struts Users Mailing List Subject: Developing and running Struts on Tomcat without an Internet Connection I know this is supposed to work, but I'm getting an error starting up my Struts 1.2.8 application on Tomcat 5.5.15 when I unplug my computer from the Internet.

RE: Developing and running Struts on Tomcat without an Internet Connection

2006-03-17 Thread Gurpreet.S.Dhanoa
ect: Developing and running Struts on Tomcat without an Internet Connection I know this is supposed to work, but I'm getting an error starting up my Struts 1.2.8 application on Tomcat 5.5.15 when I unplug my computer from the Internet. The stack trace is: java.net.UnknownHostException: jakarta.ap

Re: Developing and running Struts on Tomcat without an Internet Connection

2006-03-16 Thread Joe Germuska
At 1:34 PM +1000 3/17/06, Hey Nony Moose wrote: Richard Yee wrote: I know this is supposed to work, but I'm getting an error starting up my Struts 1.2.8 application on Tomcat 5.5.15 when I unplug my computer from the Internet. The stack trace is: java.net.UnknownHostException: jakarta.apa

Re: Developing and running Struts on Tomcat without an Internet Connection

2006-03-16 Thread Paul Benedict
Try replacing your jar file. This is a long shot, but when I had these before I think the jar got corrupted. It's probably looking for the DTD on the internet because it can find them on your computer. You can always put the DTD's in the WEB-INF root, but you shouldn't since Tomcat 5 should find th

Re: Developing and running Struts on Tomcat without an Internet Connection

2006-03-16 Thread Hey Nony Moose
Richard Yee wrote: > I know this is supposed to work, but I'm getting an error starting up > my Struts 1.2.8 application on Tomcat 5.5.15 when I unplug my computer > from the Internet. > The stack trace is: > > java.net.UnknownHostException: jakarta.apache.org when i get these in this scenario i

Developing and running Struts on Tomcat without an Internet Connection

2006-03-16 Thread Richard Yee
I know this is supposed to work, but I'm getting an error starting up my Struts 1.2.8 application on Tomcat 5.5.15 when I unplug my computer from the Internet. The stack trace is: java.net.UnknownHostException: jakarta.apache.org at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:1

RE: what's wrong?? ---Connection with MySQL database

2006-03-14 Thread Zheng Wen Zhe
HaaThanks for all reply. It seems google is every thing. -Original Message- From: Dave Newton [mailto:[EMAIL PROTECTED] Sent: 14 March 2006 14:24 To: Struts Users Mailing List Subject: Re: what's wrong?? ---Connection with MySQL database Zheng Wen Zhe wrote: > Why I

[OT] Re: what's wrong?? ---Connection with MySQL database

2006-03-14 Thread Antonio Petrelli
Dave Newton ha scritto: Total time spent (not including typing this email): about 1 minute, 45 seconds. Time spent typing the email: 2 minutes. Time you'll wait to read a response on the newsgroup: 5-15 minutes. Ability to debug your own app: priceless. There are things that you cannot buy, f

Re: what's wrong?? ---Connection with MySQL database

2006-03-14 Thread Dave Newton
Zheng Wen Zhe wrote: > Why I got this error when initialize web server > Well, let's take a look: > ERROR <14-Mar-2006 13:52:17> Initializing application data source userDB > > org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of > class '' for connect URL 'jdbc:mysql:

Re: what's wrong?? ---Connection with MySQL database

2006-03-14 Thread chuanjiang lo
did you include the mysql jdbc jar in your classpath? On 3/14/06, Zheng Wen Zhe <[EMAIL PROTECTED]> wrote: > > Hi, > > Why I got this error when initialize web server > > > > ERROR <14-Mar-2006 13:52:17> Initializing application data source userDB > > org.apache.commons.dbcp.SQLNestedException

Re: what's wrong?? ---Connection with MySQL database

2006-03-14 Thread ALEX HYDE
I use Tomcat and I've only ever created datasources in web.xml. Have u tried that? Zheng Wen Zhe <[EMAIL PROTECTED]> wrote: Hi, Why I got this error when initialize web server ERROR <14-Mar-2006 13:52:17> Initializing application data source userDB org.apache.commons.dbcp.SQLNestedExc

what's wrong?? ---Connection with MySQL database

2006-03-14 Thread Zheng Wen Zhe
Hi, Why I got this error when initialize web server ERROR <14-Mar-2006 13:52:17> Initializing application data source userDB org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'jdbc:mysql://localhost:3306/struts'

Re: Regarding Struts- Mysql Connection.

2006-02-21 Thread Dharmendra Singh
Hi dear there is no need to specify in any where start MySql step 1 just paste *.jar file in lib directory. step 2 specify all elements(driverClass ,url ,no of connection , user id, password) and full path of database in struts-config.xml . Now you can connect in Action Classes directely by

Re: Regarding Struts- Mysql Connection.

2006-02-17 Thread C. Grobmeier
I am beginner for struts.now I have developed one simple application using Struts 1.24 with Mysql 4.1.I have created all the tables successfully.and Program is also correct.And I have copied the " mm.mysql-2.0.6.jar" into lib Folder.But it Shows some database exceptions. Is

[OT] Re: Regarding Struts- Mysql Connection.

2006-02-16 Thread Dave Newton
Ashok kumar wrote: > I am beginner for struts.now I have developed one simple > application using Struts 1.24 with Mysql 4.1.I have created all the tables > successfully.and Program is also correct.And I have copied the " > mm.mysql-2.0.6.jar" into lib Folder.But it Shows some database ex

Regarding Struts- Mysql Connection.

2006-02-16 Thread Ashok kumar
user@struts.apache.org sub: Regarding Struts- Mysql Connection. Hi everyone, I am beginner for struts.now I have developed one simple application using Struts 1.24 with Mysql 4.1.I have created all the tables successfully.and Program is also correct.And I have copied the " mm.

Re: Problem with Connection Pool in Action-Classes

2006-02-14 Thread starki78
ject : Re: Problem with Connection Pool in Action-Classes > starki78 wrote: > > It seems that the action is not absolutely thread safe. > > Can this be? > > > Actions should never* have instance variables. You should not have a > connection stored as an instance varia

Re: Problem with Connection Pool in Action-Classes

2006-02-14 Thread Dave Newton
starki78 wrote: > It seems that the action is not absolutely thread safe. > Can this be? > Actions should never* have instance variables. You should not have a connection stored as an instance variable; it should be retrieved within a method to a method-local variable. If this is wha

Problem with Connection Pool in Action-Classes

2006-02-14 Thread starki78
Hi, we have a connection-member variable in our super-action that is opened and closed there by the connection-pool. (it's always clossed within the finally block) Now then we call the sub-classes very often in a short period it seems the connection isn't been given back!!! It seem

Re: Plug-In sample for creating and keeping DB and Q connection.

2006-01-31 Thread digant . k . joshi
To start with I want to keep in session, Once functionality is tested ! I want to make it better by writing BaseDAO to get connection from DB /Q Dave Newton <[EMAIL PROTECTED]> 01/31/2006 11:27 AM Please respond to "Struts Users Mailing List" To: Struts Us

Re: Plug-In sample for creating and keeping DB and Q connection.

2006-01-31 Thread Dave Newton
[EMAIL PROTECTED] wrote: > Hi! > In our app we need to communicate to our application server using > DB connection and Sonic MQ. > As per one of earlier suggestion I am trying to write Plug-In for > creating DB and Q connection and keep for the session life. &

Re: Plug-In sample for creating and keeping DB and Q connection.

2006-01-31 Thread Niall Pemberton
http://wiki.apache.org/struts/StrutsPlugins Niall - Original Message - From: <[EMAIL PROTECTED]> Sent: Tuesday, January 31, 2006 4:22 PM > Hi! > In our app we need to communicate to our application server using > DB connection and Sonic MQ. > As

Plug-In sample for creating and keeping DB and Q connection.

2006-01-31 Thread digant . k . joshi
Hi! In our app we need to communicate to our application server using DB connection and Sonic MQ. As per one of earlier suggestion I am trying to write Plug-In for creating DB and Q connection and keep for the session life. So any request made by user can use same DB and

Problem with Connection Pool in Tomcat

2005-11-28 Thread Nandakishore Nekkanti
Hi     I am facing problem while configuring connection pool in tomcat.   I created one  DataSource  after logging into server as abmin.   I saw  corresponding settings in  server.xml.i am listing them below.   Then i configured web.xml .I guess  i did all  the changes as mentioned in

Re: (HELP) Struts - Oracle Database Connectivity Using DBCP connection Pooling

2005-11-08 Thread Kumar deepak
Hi Mohan, Following url will definetly solve your problem. http://www.roseindia.net/struts/strutsdatasourcemanagerontomcat5.shtml Regards Deepak Kumar "A.Mohan" <[EMAIL PROTECTED]> wrote: Hi, I want to connect Oracle thro DBCP - connection pooling by configuring the d

Re: (HELP) Struts - Oracle Database Connectivity Using DBCP connection Pooling

2005-11-08 Thread Yujun Liang
You also need configure server.xml, please check out Tomcat document for the configuration and call Data Source using JNDI from Struts. Good luck. On 11/9/05, A.Mohan <[EMAIL PROTECTED]> wrote: > > Hi, > I want to connect Oracle thro DBCP - connection pooling by > configuring

Re: (HELP) Struts - Oracle Database Connectivity Using DBCP connection Pooling

2005-11-08 Thread Murray Collingwood
Show us what you have so far and then we can help. Kind regards mc On 8 Nov 2005 at 20:49, A.Mohan wrote: > Hi, >I want to connect Oracle thro DBCP - connection pooling by > configuring the datasource in the WEB.XML file , > Im using Apache tomcat Server > > > H

(HELP) Struts - Oracle Database Connectivity Using DBCP connection Pooling

2005-11-08 Thread A.Mohan
Hi, I want to connect Oracle thro DBCP - connection pooling by configuring the datasource in the WEB.XML file , Im using Apache tomcat Server How can i acheive that - help me out , I want the following information 1. Configuration in web.xml file i.e the entries 2. Code in action

Re: how to sustain the sanity of the connection pool

2005-10-11 Thread Ronald Holshausen
DBCP has some properties to help with connection pool leaks: removeAbandoned, logAbandoned. See http://jakarta.apache.org/commons/dbcp/configuration.html On 11/10/05, emre akbas <[EMAIL PROTECTED]> wrote: > Hi, > I have some general questions about connection pooling and exceptio

Re: how to sustain the sanity of the connection pool

2005-10-11 Thread Eric Plante
>It is very usual that we open a connection to the database at the beginning >of the Action class and then close it at the end. When an >exception occurs, >an exception-handler outside of our Action class (in which >the exception is >thrown) handles the exception. Then, w

Re: how to sustain the sanity of the connection pool

2005-10-11 Thread Ronald Holshausen
Another solution is to use a proxing framework (like spring), that opens and closes the connections for you. This way you know that the connection will always be closed after the method call, regardless if there was an error or not. You can also create a base class for all your actions that has a

Re: how to sustain the sanity of the connection pool

2005-10-11 Thread Murray Collingwood
A pertinent question, had the same problem myself this afternoon. I use Tomcat DBCP and found that each connection really does need to be closed. If you don't your pool of connections is quickly depleted. >From the many code samples I have looked at (not that many really) I find many

how to sustain the sanity of the connection pool

2005-10-11 Thread emre akbas
Hi, I have some general questions about connection pooling and exception handling. Struts suggests that developers use declarative exception handling. In declarative exception handling, there are almost no "try { } catch() {}" blocks in the Action classes. Exception occuring in Action c

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
}catch(){..} * struts-config.xml: * I am getting the following error message while running the struts application: INFO: Failed to create a non-pooled connection for null at jdbc:postgresql://localhost/null?prepareThreshold=0: org

Re: Struts to Postgresql db connection refused

2005-09-08 Thread Murray Collingwood
*** > struts-config.xml: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="

Re: Struts to Postgresql db connection refused

2005-09-08 Thread Brian Bruns
* > struts-config.xml: > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://192.168.1.22:5432/omsdb" /> > > > value="postgres" /> > > > value="postgres" /> > > > > **

Struts to Postgresql db connection refused

2005-09-08 Thread R Rajendran
I am getting the following error message while running the struts application: INFO: Failed to create a non-pooled connection for null at jdbc:postgresql://localhost/null?prepareThreshold=0: org.postgresql.util.PSQLException: Connection refused. Check that the

Re: How to access a Servers connection pool with Struts?

2005-07-29 Thread Daniel Henrique Ferreira e Silva
of other stuff. Cheers, Daniel Silva. On 7/29/05, starki78 <[EMAIL PROTECTED]> wrote: > Ciao! > > Is there any best practise accessing a global connection pool with Struts? > I cannot find the benefit in defining a datasource in Struts-Config. > Can Struts give me suppor

How to access a Servers connection pool with Struts?

2005-07-28 Thread starki78
Ciao! Is there any best practise accessing a global connection pool with Struts? I cannot find the benefit in defining a datasource in Struts-Config. Can Struts give me support controlling the maximal amounts of connections on a servers connection-pool? Up to now I don't see another soluti

Re: DB Connection

2005-07-25 Thread Laurie Harper
Stéphane Zuckerman wrote: Senthilrajan VS a écrit : 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

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

Re: DB Connection

2005-07-25 Thread Senthilrajan VS
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 - Original Message - From: "Stéphane Zuckerman" <[EMAIL PROTECTED]> To: "

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

2005-07-08 Thread Access Denied
n null; > } > > You probably already know all this, it's the same old fashioned J2EE way . . . > > Erik > > > -Original Message- > From: Vijay K Anand <[EMAIL PROTECTED]> > Sent: Jul 8, 2005 3:47 AM > To: Struts Users Mailing List > Sub

Re: Database Connection

2005-07-08 Thread erikweber
d fashioned J2EE way . . . Erik -Original Message- From: Vijay K Anand <[EMAIL PROTECTED]> Sent: Jul 8, 2005 3:47 AM To: Struts Users Mailing List Subject: Database Connection Hi All I have a helper class which does creating connection and exception handling for that . How do i creat

Database Connection

2005-07-08 Thread Vijay K Anand
Hi All I have a helper class which does creating connection and exception handling for that . How do i create connection like DataSource dataSource = (DataSource)context.getAttribute(Action.DATA_SOURCE_KEY) ; objConnection = datasource.getConnection(); it says error at context and

Re: [OT] Using connection pools - security

2005-07-07 Thread Michael Rasmussen
You could also just use one pool per user role and look up the db user and the role that user is in, then pull the connection from the pool that you have for that role. If your DB doesn't support roles for users you could create a user/role table. I think it might be overkill to crea

Re: [OT] Using connection pools - security

2005-07-06 Thread Craig McClanahan
A couple of considerations are relevant here: * Is a single user ever going to really use more than one connection from the pool? If not, wouldn't it be better to create a *connection* for them, instead of a *pool*? (Note in particular that transactions don't cross connection

Re: [OT] Using connection pools - security

2005-07-06 Thread Tamas Szabo
I guess I could use any implementation of a connection pool for a simple implementation. I just need to use a connection pool for every user (of course using a smaller number of connections than usually). The connection pool object will be created only when the user logs in (if it doesn't

<    1   2   3   4   >