What database are you running on your Windows box? The new PostgreSQL for Windows beta? This question is to establish that you ARE connecting to that database software in at least one location.
Regards, David -----Original Message----- From: Kyle Korndoerfer [mailto:[EMAIL PROTECTED] Sent: 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 box since it has much more RAM for running Eclipse along with Tomcat, etc. I have not tested the application on the SuSE box, but judging from the nature of the error message, I should still have the same problem ('org.postgresql.Driver' not found). I just had an idea about what could be causing a problem that I will check tonight when I get home. I'll post if that fixes it or not, but in the meantime if anyone else has any clues/insites, please let me know. It's the little things that kill you. :) -={ Kyle }=- --- Paul Woods <[EMAIL PROTECTED]> wrote: > On Sun, 2004-09-26 at 15:47, Kyle Korndoerfer wrote: > > I'm using Tomcat v5.0.28, Struts v1.1 & PostgreSQL v7.3.4 running > on > > SuSE Linux Pro 9.0. > > > > I'm building my application in Eclipse v3.0.1 on Windows (and > testing > > there), butwhen I launch Tomcat, I get the following error: > > Is this the Tomcat on both boxes, or just Windows, with Postgres > being > on Suse? > > > <data-sources> > > <data-source type="org.apache.commons.dbcp.BasicDataSource"> > > <set-property property="driverClassName" > > value="org.postgresql.Driver" /> > > <set-property property="url" > > value="jdbc:postgresql://192.168.200.10/mydb" /> > > <set-property property="username" value="username" /> > > <set-property property="password" value="password" /> > > > > <set-property property="maxActive" value="20" /> > > <set-property property="maxIdle" value="10" /> > > <set-property property="maxWait" value="-1" /> > > > > <set-property property="removeAbandonded" value="true" /> > > <set-property property="removeAbandondedTimeout" > value="300" /> > > <set-property property="defaultAutoCommit" value="false" /> > > <set-property property="defaultReadOnly" value="false" /> > > </data-source> > > </data-sources> > > ===== data sources snippet from struts-config.xml ========== > > > > First though; I've not tried it without, but is a port number > required > on the connection url? For instance, > > value="jdbc:postgresql://192.168.200.10:5432/mydb" > > Dumb question I know, but I also assume that the values you have > above > for username and password are just for the purposes of posting here > :) > > > My WAR file has the 'pg73b1jdbc3.jar' file in the WEB-INF/lib > > directory, but it appears that Tomcat/Struts is not finding it? > > You can go to http://jdbc.postgresql.org/download.html to download a > more recent jar (is the above beta?). I'm using pg73jdbc2.jar w/o > problem. For jdbc3 they also have pg73jdbc3.jar. Most likely not > your > issue, but might alleviate some down the road. > > > > > This has been driving me nuts for the past few days. I've even > tried > > removing the 'pg73b1jdbc3.jar' file from the WAR and putting it > into > > Tomcat's 'common/lib', 'shared/lib', or anywhere else I could think > of. > > Mine is in $CATALINA_HOME/common/lib, and works great w/o me having > to > put it into each web app I work on. This page here, > http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how to.html > has some specific notes. Among them, if you put your .jar into the > common/lib directory, do not put it anywhere else that it will be > found > (ie. in your classpath), it will cause problems. > > > > Am I just missing something simple? Thanks for the help. > > > > -={ Kyle }=- > > Don't know. Hope something here has helped though :) > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
