Re: Connection pool and MessageRessources

2003-10-31 Thread Ovidiu EFTIMIE
Hi James, I've studied your solution, and I've noticed that you use a different connection to the database and not the one that should be availble in an struts application, and I think that could be a point of failure. That is why I'm trying tu use the same connection pool as the rest

Re: Connection pool and MessageRessources

2003-10-31 Thread Ovidiu EFTIMIE
I think I've found a solution. I'll make an object (eventualy a struts PlugIn), DBMessage which receivies a connection from my connection pool and retrives the error messages from the database, and this object will not extend MessageRessources. Then in my actions I'll have : DbMessage dbmesg

RE: Connection pool and MessageRessources

2003-10-31 Thread James Mitchell
) AIM:jmitchtx -Original Message- From: Ovidiu EFTIMIE [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 7:23 AM To: Struts Users Mailing List Subject: Re: Connection pool and MessageRessources I think I've found a solution. I'll make an object (eventualy a struts PlugIn

RE: Connection pool and MessageRessources

2003-10-31 Thread James Mitchell
-Original Message- From: Ovidiu EFTIMIE [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 5:34 AM To: Struts Users Mailing List Subject: Re: Connection pool and MessageRessources Hi James, I've studied your solution, and I've noticed that you use a different connection

Re: Connection pool and MessageRessources

2003-10-31 Thread Ovidiu EFTIMIE
PROTECTED] Sent: Friday, October 31, 2003 4:13 PM Subject: RE: Connection pool and MessageRessources -Original Message- From: Ovidiu EFTIMIE [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 5:34 AM To: Struts Users Mailing List Subject: Re: Connection pool

Re: Connection pool and MessageRessources

2003-10-31 Thread Ovidiu EFTIMIE
time Ovidiu - Original Message - From: James Mitchell [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED] Sent: Friday, October 31, 2003 4:13 PM Subject: RE: Connection pool and MessageRessources You might not be realizing just how deeply the MesageResources

RE: Connection pool and MessageRessources

2003-10-31 Thread James Mitchell
678.910.8017 (c) 770.822.3359 (h) AIM:jmitchtx -Original Message- From: Ovidiu EFTIMIE [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 11:30 AM To: Struts Users Mailing List Subject: Re: Connection pool and MessageRessources Yes I know it is very tighly integrated

Connection pool and MessageRessources

2003-10-30 Thread Ovidiu EFTIMIE
two aproaches : ## One ##: I have written a Struts plugin which builds the connection pool, and I've extended MessageRessourceFactory and MessageRessources with my own classes DBRessourceFactory and DBRessource to have my own mechanism for message retrivial. My problem is now how can I get

RE: Connection pool and MessageRessources

2003-10-30 Thread James Mitchell
Software Engineer / Struts Evangelist http://www.struts-atlanta.org 678.910.8017 (c) 770.822.3359 (h) AIM:jmitchtx -Original Message- From: Ovidiu EFTIMIE [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 1:07 PM To: [EMAIL PROTECTED] Subject: Connection pool

Re: Connection Pool: JPetStore Database Layer

2003-06-26 Thread FrenzyGNX
So maybe you can help me with the problem? I have posted the problem in Commons list and here, but have got no answer so far. Thanks. And to be precise, the error is not closed connection, but broken pipe. --- Adam Hardy [EMAIL PROTECTED] wrote: I just checked the Apache bugzilla and couldn't

Re: Connection Pool: JPetStore Database Layer

2003-06-26 Thread Adam Hardy
love to help but how? I searched for a bug in the Commons bugzilla and didn't find one - your best bet would be to establish a test case for the problem and post it in bugzilla - you don't need to be an Apache developer to search or add bugs to their bugzilla. FrenzyGNX wrote: So maybe you can

Re: Connection Pool: JPetStore Database Layer

2003-06-26 Thread FrenzyGNX
Thanks. I have submitted a bug report. --- Adam Hardy [EMAIL PROTECTED] wrote: love to help but how? I searched for a bug in the Commons bugzilla and didn't find one - your best bet would be to establish a test case for the problem and post it in bugzilla - you don't need to be an Apache

Re: Connection Pool: JPetStore Database Layer

2003-06-25 Thread Adam Hardy
FrenzyGNX wrote: My personal experience with DBCP is not good. I would avoid it in my next project. From what point of view were you disappointed? Adam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: Connection Pool: JPetStore Database Layer

2003-06-25 Thread FrenzyGNX
There is a bug in DBCP that will return closed connections, even if the validation query is set. http://www.mail-archive.com/[EMAIL PROTECTED]/msg66565.html Also due to the very fact that it is removed from Struts 1.1rc2, and there were some discussions regarding it in this list earlier on.

Re: Connection Pool: JPetStore Database Layer

2003-06-25 Thread Adam Hardy
I just checked the Apache bugzilla and couldn't find any bugs on this (I queried using closed or connection and got 23 hits). There are 2 bugs about closed connections, but they are both resolved - http://issues.apache.org/bugzilla/show_bug.cgi?id=9073

Connection Pool: JPetStore Database Layer

2003-06-24 Thread Yansheng Lin
Ok, for my next personal project(an online language translator that displays multiple results), I decided to go with ibatis database layer(from JPetStore) for db access. And I expect that a lot of people are going to use my state-of-art system:). So I need (a) connection pool(s) so

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread Yansheng Lin
Found it. But as expected, there is only one real connection. Maybe I can use commons-dbcp package. -Original Message- From: Yansheng Lin [mailto:[EMAIL PROTECTED] Sent: June 24, 2003 1:24 PM To: 'Struts Users Mailing List' Subject: Connection Pool: JPetStore Database Layer

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread Kumar, Kiran
-Original Message- From: Yansheng Lin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:23 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool: JPetStore Database Layer Found it. But as expected, there is only one real connection. Maybe I can use commons-dbcp package

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread Kumar, Kiran
I need the jar files urgently Thanks KiranKumar (Raj) ext 7203 -Original Message- From: Yansheng Lin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:23 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool: JPetStore Database Layer Found it. But as expected

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread Kumar, Kiran
Thanks KiranKumar (Raj) ext 7203 -Original Message- From: Yansheng Lin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:23 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool: JPetStore Database Layer Found it. But as expected, there is only one real connection

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread Steve Raeburn
I'll get right on that then :-( Steve -Original Message- From: Kumar, Kiran [mailto:[EMAIL PROTECTED] Sent: June 24, 2003 1:42 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool: JPetStore Database Layer I need the jar files urgently Thanks KiranKumar (Raj

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread Kumar, Kiran
:-)) Thanks KiranKumar (Raj) ext 7203 -Original Message- From: Steve Raeburn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 5:03 PM To: Struts Users Mailing List Subject: RE: Connection Pool: JPetStore Database Layer I'll get right on that then :-( Steve -Original

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread Yansheng Lin
framework. -Original Message- From: Kumar, Kiran [mailto:[EMAIL PROTECTED] Sent: June 24, 2003 2:39 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool: JPetStore Database Layer can some body give me the 1.complete list of instructions for running a sample struts application

RE: Connection Pool: JPetStore Database Layer

2003-06-24 Thread FrenzyGNX
:[EMAIL PROTECTED] Sent: June 24, 2003 1:24 PM To: 'Struts Users Mailing List' Subject: Connection Pool: JPetStore Database Layer Ok, for my next personal project(an online language translator that displays multiple results), I decided to go with ibatis database layer(from JPetStore

Bitmechanic JDBC Connection Pool or Struts Connection Pool

2003-03-29 Thread niksa_os
I search the [EMAIL PROTECTED] but I didn't find anything on how to setup Bitmechanic JDBC Connection Pool. http://www.bitmechanic.com/projects/jdbcpool/ Does someone can explain me how to setup Bitmechanic in struts-config.xml, web.xml and how to get connection in Action? I use MySQL

Re: Bitmechanic JDBC Connection Pool or Struts Connection Pool

2003-03-29 Thread Dan Tran
http://jakarta.apache.org/struts/faqs/database.html -D - Original Message - From: niksa_os [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 29, 2003 2:28 AM Subject: Bitmechanic JDBC Connection Pool or Struts Connection Pool I search the [EMAIL PROTECTED] but I didn't find

RE: Connection Pool

2003-03-20 Thread Jimmy Emmanual
- From: Lee, Dennis [mailto:[EMAIL PROTECTED] Sent: March 19, 2003 10:01 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool Hi, Sorry, it's a property of data-source, not data-sources Best Regards, Dennis Lee -Original Message- From: Lee, Dennis [mailto:[EMAIL PROTECTED] Sent

Re: Connection Pool

2003-03-20 Thread Stephen Smithstone
Heres how i do it and it works with struts 1.1rc1 in the struts-config i have data-sources data-source key=SystemsLog set-property value=jdbc:mysql://localhost/SystemsLog property=url / set-property value=org.gjt.mm.mysql.Driver property=driverClass / set-property

Connection Pool

2003-03-19 Thread Jimmy Emmanual
How do you access a DataSource from an action class via its key? I have multiple DataSources defined in the struts-config.xml file each have the key property set. I need to access these based on this key. - To unsubscribe,

Re: Connection Pool

2003-03-19 Thread David Graham
Struts stores the DataSources in the ServletContext under the key you defined. David From: Jimmy Emmanual [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: Connection Pool Date: Wed, 19 Mar 2003 19:18:11 -0500 How do you

RE: Connection Pool

2003-03-19 Thread Jimmy Emmanual
: Wednesday, March 19, 2003 7:23 PM To: [EMAIL PROTECTED] Subject: Re: Connection Pool Struts stores the DataSources in the ServletContext under the key you defined. David From: Jimmy Emmanual [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL

RE: Connection Pool

2003-03-19 Thread David Graham
Are you using modules? Why don't you print out the contents of ServletContext to see if it's in there? David From: Jimmy Emmanual [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: 'Struts Users Mailing List' [EMAIL PROTECTED] Subject: RE: Connection Pool Date: Wed

RE: Connection Pool

2003-03-19 Thread Jimmy Emmanual
defined. I've searched other lists and archives, and nobody seems to be able to get it to work... -Original Message- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 7:29 PM To: [EMAIL PROTECTED] Subject: RE: Connection Pool Are you using modules? Why don't you

RE: Connection Pool

2003-03-19 Thread Jimmy Emmanual
Also, it seems when you have a list of datasources, the only one that is recognized is the last one... -Original Message- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 7:29 PM To: [EMAIL PROTECTED] Subject: RE: Connection Pool Are you using modules? Why

RE: Connection Pool

2003-03-19 Thread Lee, Dennis
- From: Jimmy Emmanual [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:59 AM To: 'Struts Users Mailing List' Subject: RE: Connection Pool Also, it seems when you have a list of datasources, the only one that is recognized is the last one... -Original Message- From: David Graham

RE: Connection Pool

2003-03-19 Thread Jimmy Emmanual
Dennis, Thank you very much. However, what do you declare desconfig as? -Original Message- From: Lee, Dennis [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:24 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool Hi, Here is my code snippet

RE: Connection Pool

2003-03-19 Thread Lee, Dennis
as well. Best Regards, Dennis Lee -Original Message- From: Jimmy Emmanual [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 10:28 AM To: 'Struts Users Mailing List' Subject: RE: Connection Pool Dennis, Thank you very much. However, what do you declare desconfig as? -Original

RE: Connection Pool

2003-03-19 Thread Jimmy Emmanual
property=user value=TST / set-property property=password value=TST / /data-source /data-sources -Original Message- From: Lee, Dennis [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:36 PM To: 'Struts Users Mailing List' Subject: RE: Connection Pool

RE: Connection Pool

2003-03-19 Thread David Graham
Users Mailing List' [EMAIL PROTECTED] Subject: RE: Connection Pool Date: Wed, 19 Mar 2003 21:41:32 -0500 This is the definition in the struts-config.xml file. data-sources !-- PRODUCTION/dataexport -- data-source set-property property=key value=prdDataexport

RE: Connection Pool

2003-03-19 Thread Jimmy Emmanual
Action.DATA_SOURCE_KEY... Also, i'm using struts 1.0.2. -Original Message- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:49 PM To: [EMAIL PROTECTED] Subject: RE: Connection Pool The set-property element calls a setter on the DataSource java bean. Use the key

RE: Connection Pool

2003-03-19 Thread Lee, Dennis
, Dennis Lee -Original Message- From: Jimmy Emmanual [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 10:42 AM To: 'Struts Users Mailing List' Subject: RE: Connection Pool This is the definition in the struts-config.xml file. data-sources !-- PRODUCTION/dataexport

RE: Connection Pool

2003-03-19 Thread Lee, Dennis
Hi, Sorry, it's a property of data-source, not data-sources Best Regards, Dennis Lee -Original Message- From: Lee, Dennis [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 10:55 AM To: 'Struts Users Mailing List' Subject: RE: Connection Pool Hi, You can check the DTD, the key

DB Connection pool (how)?

2003-02-19 Thread Swish
Hi, Please excuse my ignorance, but does struts have a libraries that implement a connection pool and if so, how does one configure and use this pool? Are there any examples? Any help will be greatly appreciated! Thanks in advance

Re: DB Connection pool (how)?

2003-02-19 Thread David Graham
http://jakarta.apache.org/struts/userGuide/configuration.html#data-source_config David From: Swish [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Subject: DB Connection pool (how)? Date: Wed, 19 Feb 2003 11:32:15 -0500

RE: DB Connection pool (how)?

2003-02-19 Thread James Mitchell
- From: Swish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 11:32 AM To: Struts Users Mailing List Subject: DB Connection pool (how)? Hi, Please excuse my ignorance, but does struts have a libraries that implement a connection pool and if so, how does one configure and use

Re: DB Connection pool (how)?

2003-02-19 Thread asatrasala
that implement a connection pool and if so, how does one configure and use this pool? Are there any examples? Any help will be greatly appreciated! Thanks in advance! __ Post your free ad now! http://personals.yahoo.ca

RE: DB Connection pool (how)?

2003-02-19 Thread Swish
the man who cannot read them. - Mark Twain (1835-1910) -Original Message- From: Swish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 11:32 AM To: Struts Users Mailing List Subject: DB Connection pool (how)? Hi, Please excuse my

DBCP could not obtain an idle db connection pool exhausted

2003-02-19 Thread Scott Power
Hi folks, Here's my situation, I am using tomcat(latest version) and mysql,jdbc(mysql ..connector..jar) and struts for an application with connection pooling. I can not figure out why my connection stay around once I close them, they are not sent back to the pool. I create a connection then I

RE: DBCP could not obtain an idle db connection pool exhausted

2003-02-19 Thread Brandon Goodin
and Multimedia PO Box 85 Whitefish MT 59937 P (406) 862-2245 F (406) 862-0354 [EMAIL PROTECTED] http://www.phase.ws -Original Message- From: Scott Power [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 11:11 AM To: [EMAIL PROTECTED] Subject: DBCP could not obtain an idle db connection

RE: DB Connection pool (how)?

2003-02-19 Thread James Mitchell
) -Original Message- From: Swish [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 12:28 PM To: Struts Users Mailing List Subject: RE: DB Connection pool (how)? Thanks!! Wow, struts is an awesome framework! --- James Mitchell [EMAIL PROTECTED] wrote: http

RE: DBCP could not obtain an idle db connection pool exhausted

2003-02-19 Thread Jarnot Voytek Contr AU HQ/SC
List Subject: RE: DBCP could not obtain an idle db connection pool exhausted try making your getDbConnection method static. It might be holding a reference to your utilclass that you have instantiated. It might be taking longer to gc the class. This is just a guess. Example

RE: DBCP could not obtain an idle db connection pool exhausted

2003-02-19 Thread Brandon Goodin
: DBCP could not obtain an idle db connection pool exhausted It would also be a good idea to only do the DataSource lookup one time, and cache it... -- Voytek Jarnot Quidquid latine dictum sit, altum viditur. -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED]] Sent

[OT] RE: DBCP could not obtain an idle db connection pool exhausted

2003-02-19 Thread Jarnot Voytek Contr AU HQ/SC
PM To: Struts Users Mailing List Subject: RE: DBCP could not obtain an idle db connection pool exhausted How much advantage is caching the datasource lookup? Isn't that the whole idea of a ConnectionPool and the jndi lookup. Isn't the registry just pointing to a persistent object

insert problem with struts connection pool

2003-01-24 Thread Erhan Sen
Hi, I am using DB2 7.2 for win,struts 1.1 beta2 ver. I can use connection pool in select statements,and I have no problem.On the other hand when I tried insert statements I got no exceptions, but no data is inserted. But when I only change the connection from : dataSource = (DataSource

RE: db connection pool question [solved]

2003-01-23 Thread Raible, Matt
Using the following in my DBCP Connection Pool solved my problem: parameter namedriverClassName/name valueoracle.jdbc.pool.OracleConnectionPoolDataSource/value /parameter However, for the JDBCRealm, I still have to use: driverName

RE: db connection pool question [solved]

2003-01-23 Thread pqin
Users Mailing List' Cc: Immel, Richard Subject: RE: db connection pool question [solved] Using the following in my DBCP Connection Pool solved my problem: parameter namedriverClassName/name valueoracle.jdbc.pool.OracleConnectionPoolDataSource/value

RE: db connection pool question

2003-01-22 Thread Raible, Matt
After waiting 24 hours, I'm still experiencing the same problem with Oracle and a connection pool (DBCP) in Tomcat. I guess I'll try configuring Oracle's connection pool?? Matt -Original Message- From: Raible, Matt Sent: Tuesday, January 21, 2003 8:22 AM To: 'Struts Users Mailing

RE: db connection pool question

2003-01-22 Thread Durham David Cntr 805CSS/SCBE
) { System.err.print(e.getMessage()); } } /** * gets a connection from the connection pool * @return a connection from the connection pool */ public static java.sql.Connection getConnection() throws

RE: db connection pool question

2003-01-22 Thread mech
I can't tell for Oracle, but for MySQL and the Struts Connection Pool you have to set some kind of autoReconnect=true for your connection url setup. Otherwise your connection pool will contain only stale connections after a certain timeout. MySQL kicked me out after 8 hours of inactivity

RE: db connection pool question

2003-01-22 Thread David Graham
: RE: db connection pool question Date: Wed, 22 Jan 2003 20:09:55 +0100 I can't tell for Oracle, but for MySQL and the Struts Connection Pool you have to set some kind of autoReconnect=true for your connection url setup. Otherwise your connection pool will contain only stale connections after

RE: db connection pool question

2003-01-22 Thread mech
specific. Michael -Original Message- From: David Graham [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 22. Januar 2003 20:40 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: db connection pool question What is tricky about setting up a datasource in struts-config for deployment

RE: db connection pool question

2003-01-22 Thread Raible, Matt
-driver to $CATALINA_HOME/common/lib and my-app.xml to $CATALINA_HOME/webapps and tomcat is ready to go! Matt -Original Message- From: mech [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 1:33 PM To: 'Struts Users Mailing List' Subject: RE: db connection pool question It's

db connection pool question

2003-01-21 Thread david chan
Hi, I am using a connection pool from org.apache.commons.dbcp.BasicDataSourceFactory and the driver is oracle.jdbc.driver.OracleDriver. It works great until if the server idle for a few days, then the connection object seems broken with this error: begin error mesg === java.sql.SQLException

RE: db connection pool question

2003-01-21 Thread Pani, Gourav
please look at the thread with subject Problem with JDBC Struts Connection Pool (possible to recon nect?). Matt Raible had a solution to that by setting autoReconnect=true -Original Message- From: david chan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 9:56 AM To: Struts

Re: db connection pool question

2003-01-21 Thread Rick Reumann
On Tuesday, January 21, 2003, 9:56:09 AM, david wrote: dc Hi, I am using a connection pool from dc org.apache.commons.dbcp.BasicDataSourceFactory and the driver is dc oracle.jdbc.driver.OracleDriver. It works great until if the dc server idle for a few days, then the connection object seems dc

RE: db connection pool question

2003-01-21 Thread Raible, Matt
valueSELECT 'CRAP' FROM DUAL/value /parameter Thanks, Matt -Original Message- From: Pani, Gourav [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 7:58 AM To: 'Struts Users Mailing List' Subject: RE: db connection pool question please look at the thread with subject Problem

Re: db connection pool question

2003-01-21 Thread Bradley G Smith
select 1 from dual is the standard way to ping oracle for a valid connection. I would also recommend using Oracle's connection pool. It will do this in the background. We have several tomcat and struts applications running for weeks without problems. Even with Oracle going off line

RE: db connection pool question

2003-01-21 Thread Raible, Matt
Users Mailing List Cc: david chan; Struts Users Mailing List Subject: Re: db connection pool question select 1 from dual is the standard way to ping oracle for a valid connection. I would also recommend using Oracle's connection pool. It will do this in the background. We have several

Re: db connection pool question

2003-01-21 Thread Mike Deegan
chan [EMAIL PROTECTED]; Struts Users Mailing List [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 9:29 AM Subject: Re: db connection pool question select 1 from dual is the standard way to ping oracle for a valid connection. I would also recommend using Oracle's connection pool. It will do

RE: db connection pool question

2003-01-21 Thread Thorsten Schäfer
Hi, I can supply and example struts configuration using Oracle's driver connection pool driver. Or check the archives for this mailing list, as I have posted it here. Search using my name or Oracle. Could you please post the example? I tried to search in the mailing lists but I'm getting

RE: db connection pool question

2003-01-21 Thread david chan
PROTECTED]] Sent: Tuesday, January 21, 2003 9:29 AM To: Struts Users Mailing List Cc: david chan; Struts Users Mailing List Subject: Re: db connection pool question select 1 from dual is the standard way to ping oracle for a valid connection. I would also recommend using Oracle's

RE: db connection pool question

2003-01-21 Thread Bradley G Smith
Users Mailing List [EMAIL PROTECTED] hoo.com cc: Subject: RE: db connection pool question

Re: db connection pool question

2003-01-21 Thread NoSect
tnsping sid/servicename ...is the actual way you test for a valid connection. if you can do a select, you already have a connection. select 1 from dual is the standard way to ping oracle for a valid connection. I would also recommend using Oracle's connection pool. It will do

RE: db connection pool question

2003-01-21 Thread Bradley G Smith
/ set-property property=user value=userid / set-property property=description value=Oracle DataSource w/ Connection Pool / set-property property=URL value=jdbc:oracle:thin:@ip_or_hostname:1521:ddb

RE: db connection pool question

2003-01-21 Thread Bradley G Smith
Subject: RE: db connection pool question 21-01-03 09:34

RE: db connection pool question

2003-01-21 Thread david chan
: Subject: RE: db connection pool question 21-01-03 09:13 Please respond

RE: db connection pool question

2003-01-21 Thread Wendy Smoak
3) In general, I would like to ask what's the better pratice to do web application initialization when using Struts framework. i.e. init datasource, log4j etc... So that I don't need to customize config for tomcat, webshpere etc.. I can't claim better as I haven't tried anything else, but I

RE: db connection pool question

2003-01-21 Thread Bradley G Smith
I believe you can define data sources in server.xml for tomcat at least, and make them available for multiple applications. But I have not done that yet (using Oracle connection pool classes). Brad

Problem with JDBC Struts Connection Pool (possible to reconnect?)

2003-01-17 Thread mech
. (A solution I could live with, although I have now idea why the connection was cut while it should be idle overnight) Unfortunatelly my struts connection pool that I use in my application's data access classes doesn't get reinitialized after such a SocketException (see below). The only solution so far

FW: Problem with JDBC Struts Connection Pool (possible to reconnect?) : Solution/Fix: J/Connector kills unused connections after 8 hours

2003-01-17 Thread mech
overnight. Resolution: MySQL closes connections after 8 hours of inactivity. You either need to use a connection pool that handles stale connections or use the autoReconnect parameter (see USAGE AND INSTALLATION). [...] I guess (from my bad experience) that the Struts

RE: Problem with JDBC Struts Connection Pool (possible torecon nect?)

2003-01-17 Thread Raible, Matt
with JDBC Struts Connection Pool (possible to reconnect?) Hi, I'm running Tomcat 4.1.18 on Solaris 9 with a local MySQL 3.23.54-max (InnoDB) database on port 3307 using started with mysqld (not safemysld...difference btw?). After not using any connection over night for let's say 12 hours or more

Re: struts 1.1-b2 connection Pool

2002-11-26 Thread Bradley G Smith
] che.org cc: Subject: Re: struts 1.1-b2 connection Pool 25-11-02

struts 1.1-b2 connection Pool

2002-11-25 Thread Jithendra_Kengerichikkanna
Hi all, We are using struts 1.1-b2 version. Pls somebody throw some light on connection pool. 1)connection pool in struts 1.1-b2 version is stable? 2)If database is restarted, web application is to be restarted to avoid the socket exceptions? If yes pls suggest some alternate solution to rectify

Re: struts 1.1-b2 connection Pool

2002-11-25 Thread Craig R. McClanahan
On Tue, 26 Nov 2002, Jithendra_Kengerichikkanna wrote: Date: Tue, 26 Nov 2002 08:33:10 +0530 From: Jithendra_Kengerichikkanna [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Subject: struts 1.1-b2 connection Pool Hi

Re: [OT] WAS Connection Pool

2002-11-18 Thread Adolfo Miguelez
[EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Subject: Re: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 14:27:32 -0400 All you can do with WLS is define the driver class. You can't define a data source class to replace

RE: Connection Pool for EJBs

2002-11-05 Thread Zeltser, Mark
Andrew, Read Chuck's chapter on EJB+Struts at http://www.theserverside.com/resources/strutsreview.jsp Mark. -Original Message- From: Andrew Lubalin [mailto:alubalin;csc.com] Sent: Monday, November 04, 2002 4:09 PM To: [EMAIL PROTECTED] Subject: Connection Pool for EJBs I am planning

Re: Connection Pool for EJBs

2002-11-05 Thread V. Cekvenich
: Andrew Lubalin [mailto:alubalin;csc.com] Sent: Monday, November 04, 2002 4:09 PM To: [EMAIL PROTECTED] Subject: Connection Pool for EJBs I am planning on using EJBs for my business tier in my application. If I configure a datasource and create a connection pool using Struts, will this pool be global

Connection Pool for EJBs

2002-11-04 Thread Andrew Lubalin
I am planning on using EJBs for my business tier in my application. If I configure a datasource and create a connection pool using Struts, will this pool be global? Will it be container managed or should I create my connection pool independent of Struts and use it conjunction with the framework

Re: Connection Pool for EJBs

2002-11-04 Thread Kevin . Bedell
: Kevin Bedell/Systems/USHO/SunLife) Subject:Connection Pool for EJBs I am planning on using EJBs for my business tier in my application. If I configure a datasource and create a connection pool using Struts, will this pool be global? Will it be container managed or should I create my

Re: Connection Pool for EJBs

2002-11-04 Thread John Owen
- Original Message - From: [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Monday, November 04, 2002 3:35 PM Subject: Re: Connection Pool for EJBs If you use EJB's, the best approach is to allow the EJB container to manage all your database connections and then access all

Re: [OT] WAS Connection Pool

2002-10-16 Thread Adolfo Miguelez
] Subject: Re: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 09:45:06 -0700 (PDT) On Tue, 15 Oct 2002, Adolfo Miguelez wrote: Date: Tue, 15 Oct 2002 16:21:24 + From: Adolfo Miguelez [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: [OT] WAS Connection Pool

2002-10-15 Thread Kris Schneider
-To: Struts Users Mailing List [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Subject: Re: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 11:48:37 -0400 If it works anything like WLS, you'll get an instance of a class that implements Connection, but it won't be an instance

[OT] WAS Connection Pool

2002-10-15 Thread David Graham
to achieve is an easy to configure and highly efficient db connection pool that is available to all my action classes. Stef. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED

Re: [OT] WAS Connection Pool

2002-10-15 Thread Adolfo Miguelez
] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 09:02:29 -0600 What database driver class are you using? It seems like you should be able to tell WAS to use the oracle db driver which would return

RE: [OT] WAS Connection Pool

2002-10-15 Thread Stefan.Landro
I think there is support for jdbc 2.0 in Oracle 9i - including pooling -Original Message- From: Adolfo Miguelez [mailto:[EMAIL PROTECTED]] Sent: Dienstag, 15. Oktober 2002 17:23 To: [EMAIL PROTECTED] Subject: Re: [OT] WAS Connection Pool Thin classes12.zip. Perhaps you are right. Do

Re: [OT] WAS Connection Pool

2002-10-15 Thread David Graham
] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 15:23:13 + Thin classes12.zip. Perhaps you are right. Do you know how to do it? I do not want to use the DriverManager directly since it does not uses

Re: [OT] WAS Connection Pool

2002-10-15 Thread Kris Schneider
-specific solution. That's not always a big issue, but just something to be aware of. Another option is to just create and configure an instance of OracleConnectionCacheImpl within your app, bind it as a JNDI resource, and just use that as your connection pool. Quoting David Graham [EMAIL

Re: [OT] WAS Connection Pool

2002-10-15 Thread Adolfo Miguelez
Graham [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 09:34:05 -0600 I'm not familiar with the WAS pool but I thought that connection pooling was accomplished via the DataSource interface

RE: [OT] WAS Connection Pool

2002-10-15 Thread Adolfo Miguelez
. Adolfo From: [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 17:25:40 +0200 I think there is support for jdbc 2.0 in Oracle 9i - including pooling -Original Message- From: Adolfo

Re: [OT] WAS Connection Pool

2002-10-15 Thread Adolfo Miguelez
Schneider [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Subject: Re: [OT] WAS Connection Pool Date: Tue, 15 Oct 2002 11:48:37 -0400 If it works anything like WLS, you'll get an instance of a class that implements Connection

  1   2   3   >