Re: Problem with PostgreSQL data source

2004-10-03 Thread Vic Cekvenich
// driverName="org.postgresql.Driver" connectionURL="jdbc:postgresql://localhost:5432/bp?autoReconnect=true" connectionName="bpuser" connectionPassword="changeme" userTable ="usr" userNameCol="real_email_id" userCredCol="passwrd"

RE: Problem with PostgreSQL data source

2004-10-02 Thread David G. Friedman
clutter-reducing Eclipse trick "User Library". :) -Original Message- From: Kyle Korndoerfer [mailto:[EMAIL PROTECTED] Sent: Saturday, October 02, 2004 2:01 PM To: Struts Users Mailing List Subject: RE: Problem with PostgreSQL data source David, Thanks for the quick response... &g

RE: Problem with PostgreSQL data source

2004-10-02 Thread Kyle Korndoerfer
#x27; or 'org.apache.commons.dbcp.BasicDataSourceFactory' in Tomcat, or building the connection manually in code (not configured in an App Server). How would I use Vic's suggesstion and use the pooled connection source from the PostgreSQL JDBC drivers? Thanks for the help giving my brain

RE: Problem with PostgreSQL data source

2004-10-02 Thread David G. Friedman
27;d have to list that jar, if it wasn't in a relevant Tomcat directory, under windows -> preferences -> Tomcat -> JVM Settings. Right? Regards, David -Original Message- From: Kyle Korndoerfer [mailto:[EMAIL PROTECTED] Sent: Saturday, October 02, 2004 11:20 AM To: Struts U

Re: Problem with PostgreSQL data source

2004-10-02 Thread Kyle Korndoerfer
> 1. You should use the Container (Tomat and not Struts) data source > and not use connection pool, rather the DataSourcePool that comes with > JDBC drivers. Connections are more for clients and PooledDataSource > is for servers, so use that part of any JDBC driver. OK, can you show me what the c

Re: Problem with PostgreSQL data source

2004-09-28 Thread Vic Cekvenich
1. You should use the Container (Tomat and not Struts) data source and not use connection pool, rather the DataSourcePool that comes with JDBC drivers. Connections are more for clients and PooledDataSource is for servers, so use that part of any JDBC driver. 2. You should write a helo world ser

Re: Problem with PostgreSQL data source

2004-09-28 Thread Kyle Korndoerfer
I am not running PostgreSQL on my Windows box. The connection string in the Data Source config section is pointing to the SuSE box. I am using pgAdmin III on my Windows box to manage the database without error, so I can connect to my SuSE box and PostgreSQL without issue. I launch Tomcat from with

Re: Problem with PostgreSQL data source

2004-09-27 Thread Paul Woods
On Mon, 2004-09-27 at 20:57, Kyle Korndoerfer wrote: > OK, so my idea (recently upgraded Tomcat to 5.0.28 thinking the problem > could be thier and forgot to update my $CATALINA_HOME to take that into > account), but that didn't help... > > Still stumped. Anyone? Bueler? > > Thanks for any help/s

Re: Problem with PostgreSQL data source

2004-09-27 Thread Kyle Korndoerfer
OK, so my idea (recently upgraded Tomcat to 5.0.28 thinking the problem could be thier and forgot to update my $CATALINA_HOME to take that into account), but that didn't help... Still stumped. Anyone? Bueler? Thanks for any help/suggestions. I've been starring at it so long, I know it must be som

RE: Problem with PostgreSQL data source

2004-09-27 Thread David G. Friedman
: Monday, September 27, 2004 11:06 AM To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: Re: Problem with PostgreSQL data source Sorry for not being clear... PostgreSQL is running on the SuSE box (where the website will eventually be running, fonrted by Apache). I am developing on my Windows