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 something simple.
-={ Kyle }=-
--- Kyle Korndoerfer <[EMAIL PROTECTED]> wrote:
> 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-howto.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]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
