Re: JDBC Connection - Mailing list pgsql-jdbc
From | Max Larsson |
---|---|
Subject | Re: JDBC Connection |
Date | |
Msg-id | 000c01c16b45$1e7a46d0$0c64140a@gmservice.de Whole thread Raw |
In response to | Re: JDBC Connection ("Nick Fankhauser" <nickf@ontko.com>) |
List | pgsql-jdbc |
Hi, if you want that Tomcat should find the jdbc jar you have two places to it: 1. $TOMCAT_HOME/lib or for TOMACT 4 $CATALINA_HOME/common/lib or 2. in your web application folder under WEB-INF/lib e.g if your web applictaion is anmed myapp : $TOMCAT_HOME/webapps/myapp/WEB-INF/lib or for Tomcat 4 $CATALINA_HOME/webapps/myapp/WEB-INF/lib HTH Max > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Nick Fankhauser > Sent: Samstag, 10. November 2001 13:49 > To: Guido; pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] JDBC Connection > > > Guido- > > I probably didn't say this clearly enough, or perhaps > "environment" is the > wrong word, so I'll try to explain what I meant with an example: > > In the project I'm working on, we're using Tomcat, so I > develop using my > user account, but run as Tomcat's user. > > When I'm actually writing & compiling the code, I'm working > from my own user > account (nickf), so in the .profile for nickf I add the path > to the jdbc jar > like so: "export > CLASSPATH=$CLASSPATH:/usr/share/java/jdbc7.1-1.2.jar". This > works great for compiling and running any "main" test classes > at the command > line, but my purpose is to produce code that Tomcat will run, > and therein > lies the twist... > > The Tomcat processes are started as detached processes by the > "www-data" > user account on our system, so the change that I made to the CLASSPATH > environment variable for "nickf" doesn't help. In order to > make the classes > work under this user, I have to do one of three things: > > 1)Add the classpath line that I used for "nickf" to the .profile for > "www-data" > > 2)Add the jar file to the classpath in the shell script that starts up > Tomcat > > 3)As Dave suggested, put it in the standard java extensions > directory for > the system, so it is available to any user account by default. > > I may be totally off base here, but it sounds very much like > this is the > problem that is plaguing you with Forte- If a different user > account is > running the code after you get it out of Forte, then you may lose the > CLASSPATH that you set. > > The other thing that may be happening is that the CLASSPATH > variable may not > be used by your JRE. It might help to look under the hood at the shell > script that invokes the JRE to see what is happening- the > command to invoke > the JRE has a switch to set the classpath on it, and by > convention, most > systems just equate this to CLASSPATH, but they don't have > to. See if you > can locate the shell file (or .bat file) that invokes your > JRE- it should > have a line that looks something like this: > > java -cp $CLASSPATH <class file> > > The problem of course, would be if the "CLASSPATH" variable > either isn't > being used, or is being changed before this line is run. The > only way I can > thin of to check this would be to find the shell script in > question. Maybe > if you tell us what platform you're running on, someone who > is familiar with > it can help. > > Sorry- this response got rather long-winded- Hope it helps. > > -Nick > > > > > -----Original Message----- > > From: pgsql-jdbc-owner@postgresql.org > > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Guido > > Sent: Friday, November 09, 2001 11:42 AM > > To: pgsql-jdbc@postgresql.org > > Subject: Re: [JDBC] JDBC Connection > > > > > > First of all I'd like to thank everybody for the "pronto" help. > > But the problem is that > > 1. My shell doesn't have an enviroment variable called CLASSPATH; > > 2. I, then, tried to edit my .profile file, by adding the > variable to it, > > i.e. > > CLASSPATH=/usr/java/jdk1.3.1_01/lib/jdbc7.1-1.2.jar > > export PATH CLASSPATH > > but, still doesn't work. > > 3. When I run the application in the Forte 3 enviroment, it works > > perfectly, but that becuase the IDE requires to copy the > driver to the > > IDE's directory. > > 4. I use the same enviroment for developing and running the > application. > > Thanks again. > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
pgsql-jdbc by date: