Re: Set up postgresql on tomcat7
With apologies for top-posting, I believe that this is now getting a bit confusing, in terms of Java and Tomcat versions, and in terms of where you want to run this on. I suggest that you start by looking at which highest version of Java you can install on your target machine, and then look at the corresponding highest Tomcat version you can install. If your target machine is the Ubuntu one, then use "apt-cache search java" and "apt-cache search tomcat" to find these out. Then refer to : http://tomcat.apache.org/whichversion.html to see which versions to install (the higher the better), and do it. Then maybe start a new thread, indicating clearly - the chosen OS - the chosen java - the chosen Tomcat version x.y.z and re-state your latest questions. I saw one response in the current thread (by Jason D. Burket) which seemed quite specific and detailed. So once you have done the above installation (and before writing again to the list), why don't you give that one a try, and come back and report your success or failure. And if it fails, paste the corresponding Tomcat log messages. On 17.08.2016 22:53, André Warnier (tomcat) wrote: On 17.08.2016 16:15, Andrew Davis wrote: Its a redhat .. i don't think tomcat 7 or later will run on this. Why shouldn't it ? As long as there is a java for it, Tomcat will run on it. Check out : http://tomcat.apache.org/whichversion.html But there is a contraduction then between the subject of the mails you have been posting, and the version/documentation which you are using. And I know that this does not answer your questions. I was just trying to point out that the closer you are to the current latest released version, the more likely you are to find more people to help you on this list. On Aug 17, 2016 9:14 AM, "André Warnier (tomcat)" wrote: On 17.08.2016 16:06, Andrew Davis wrote: Thanks for the prompt.. I have been looking at the doc s and have my .jar file for postgres in the lib folder. I do not understand where the https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource- examples-howto.html If your version is Tomcat 7, then maybe you should look at the Tomcat 7 documentation, not the v 6 one. In any case, even Tomcat 7 is somewhat old now. Can you upgrade to a later version ? That might increase your chances of getting help here. This author has not had success here... This doesn't inspire confidence here, but that's what the documentation shows... Sorry, but personally my expertise in these matters is nil, so I hope someone else here can pick this up now. Andy On Aug 17, 2016 4:43 AM, "André Warnier (tomcat)" wrote: On 17.08.2016 11:32, Andrew Davis wrote: Thanks. I can now deploy my servlets and they work ok, but.. I had hoped to just deploy one copy of the postgres jar to my server and then be able to consume it inside multiple applications, instead of having multiple copies of the jar in multiple apps. I've been through the JNDI portion of the docs on Tomcat and found it still somewhat confusing. Andy... I am far from an expert on this kind of thing, but have you looked at this : http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html Maybe that is the missing link in your understanding ? On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: Andrew, this list strips most kinds of attachments, so nobody saw your screenshots or whatever was in them. You need to copy/paste that text right into your message to the list (amd make sure that you send your message as "plain text", not HTML, otherwise it will be unreadable. On 17.08.2016 02:10, Andrew Davis wrote: Well, This has not turned out how I wanted it to . I have 'a solution' but it isnt what I wanted to do. I went back and re added the .jar file to the 'WEB-INF' folder and then deployed a new WAR file. Now things work just 'fine' BUT I suspect that this is not what a real coder would do and suspect I am still in the realms of hackery.. [image: Inline image 1] Andy. On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis wrote: I found the following in my logs.. from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton < geor...@mhsoftware.com> wrote: The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see th
Re: Set up postgresql on tomcat7
On 17.08.2016 16:15, Andrew Davis wrote: Its a redhat .. i don't think tomcat 7 or later will run on this. Why shouldn't it ? As long as there is a java for it, Tomcat will run on it. Check out : http://tomcat.apache.org/whichversion.html But there is a contraduction then between the subject of the mails you have been posting, and the version/documentation which you are using. And I know that this does not answer your questions. I was just trying to point out that the closer you are to the current latest released version, the more likely you are to find more people to help you on this list. On Aug 17, 2016 9:14 AM, "André Warnier (tomcat)" wrote: On 17.08.2016 16:06, Andrew Davis wrote: Thanks for the prompt.. I have been looking at the doc s and have my .jar file for postgres in the lib folder. I do not understand where the https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource- examples-howto.html If your version is Tomcat 7, then maybe you should look at the Tomcat 7 documentation, not the v 6 one. In any case, even Tomcat 7 is somewhat old now. Can you upgrade to a later version ? That might increase your chances of getting help here. This author has not had success here... This doesn't inspire confidence here, but that's what the documentation shows... Sorry, but personally my expertise in these matters is nil, so I hope someone else here can pick this up now. Andy On Aug 17, 2016 4:43 AM, "André Warnier (tomcat)" wrote: On 17.08.2016 11:32, Andrew Davis wrote: Thanks. I can now deploy my servlets and they work ok, but.. I had hoped to just deploy one copy of the postgres jar to my server and then be able to consume it inside multiple applications, instead of having multiple copies of the jar in multiple apps. I've been through the JNDI portion of the docs on Tomcat and found it still somewhat confusing. Andy... I am far from an expert on this kind of thing, but have you looked at this : http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html Maybe that is the missing link in your understanding ? On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: Andrew, this list strips most kinds of attachments, so nobody saw your screenshots or whatever was in them. You need to copy/paste that text right into your message to the list (amd make sure that you send your message as "plain text", not HTML, otherwise it will be unreadable. On 17.08.2016 02:10, Andrew Davis wrote: Well, This has not turned out how I wanted it to . I have 'a solution' but it isnt what I wanted to do. I went back and re added the .jar file to the 'WEB-INF' folder and then deployed a new WAR file. Now things work just 'fine' BUT I suspect that this is not what a real coder would do and suspect I am still in the realms of hackery.. [image: Inline image 1] Andy. On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis wrote: I found the following in my logs.. from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton < geor...@mhsoftware.com> wrote: The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy -- George Sexton *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
Re: Set up postgresql on tomcat7
Sorry, I got confused from yesterday and continued the question on my second machine without realizing . I have two machines. The one I started the question with is: Machine number 1. Ubuntu 14.04, Tomcat7 as my web server, I have postgreSQl 9.3 installed as my dbServer. java version 1.8.9_91 Machine number 2 RHEL 6, Tomcat6 as web server, postgreSQL 9.3 dbServer. java version 1.7.0_101 I am focusing my effort on the first machine. (Ubuntu).. Andy. On Wed, Aug 17, 2016 at 12:47 PM, Mark Eggers wrote: > Replies at the end: > > Andrew: > > On 8/17/2016 7:15 AM, Andrew Davis wrote: > > Its a redhat .. i don't think tomcat 7 or later will run on this. > > > > On Aug 17, 2016 9:14 AM, "André Warnier (tomcat)" > > wrote: > > > >> On 17.08.2016 16:06, Andrew Davis wrote: > >> > >>> Thanks for the prompt.. > >>> > >>> I have been looking at the doc s and have my .jar file for > >>> postgres in the lib folder. > >>> > >>> I do not understand where the >>> name="jdbc/postgres..." > >>> > >>> Is supposed to go. > >>> > >>> Im reading at > >>> https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource- > >>> examples-howto.html > >>> > >> > >> If your version is Tomcat 7, then maybe you should look at the > >> Tomcat 7 documentation, not the v 6 one. > >> > >> In any case, even Tomcat 7 is somewhat old now. Can you upgrade to > >> a later version ? That might increase your chances of getting help > >> here. > >> > >> > >>> This author has not had success here... > >>> > >>> This doesn't inspire confidence here, but that's what the > >>> documentation shows... > >>> > >>> > >> Sorry, but personally my expertise in these matters is nil, so I > >> hope someone else here can pick this up now. > >> > >> Andy > >>> > >>> On Aug 17, 2016 4:43 AM, "André Warnier (tomcat)" > >>> wrote: > >>> > >>> On 17.08.2016 11:32, Andrew Davis wrote: > >>> > >>> Thanks. > > I can now deploy my servlets and they work ok, but.. > > I had hoped to just deploy one copy of the postgres jar to my > server and then be able to consume it inside multiple > applications, instead of having multiple copies of the jar in > multiple apps. > > I've been through the JNDI portion of the docs on Tomcat and > found it still somewhat confusing. > > Andy... > > > >>> I am far from an expert on this kind of thing, but have you > >>> looked at this : > >>> > >>> http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html > >>> > >>> > >>> > Maybe that is the missing link in your understanding ? > >>> > >>> > >>> > >>> > >>> On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" > >>> wrote: > > Andrew, > > > this list strips most kinds of attachments, so nobody saw > > your screenshots or whatever was in them. You need to > > copy/paste that text right into your message to the list > > (amd make sure that you send your message as "plain text", > > not HTML, otherwise it will be unreadable. > > > > On 17.08.2016 02:10, Andrew Davis wrote: > > > > Well, > > > >> This has not turned out how I wanted it to . > >> > >> I have 'a solution' but it isnt what I wanted to do. I > >> went back and re added the .jar file to the 'WEB-INF' > >> folder and then deployed a new WAR file. > >> > >> Now things work just 'fine' BUT I suspect that this is not > >> what a real coder would do and suspect I am still in the > >> realms of hackery.. > >> > >> [image: Inline image 1] > >> > >> Andy. > >> > >> > >> > >> On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis > >> wrote: > >> > >> I found the following in my logs.. > >> > >> > >>> from command line in Putty... > >>> > >>> cd /var/lib/tomcat7 tail -f logs/catalina.out > >>> > >>> [image: Inline image 1] > >>> > >>> I do have the jar file located in the following location > >>> on the machine.. > >>> > >>> /usr/share/tomcat7/lib > >>> > >>> https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt > >>> > >>> > o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. > >>> at this point.. > >>> > >>> Andy.. > >>> > >>> > >>> > >>> On Tue, Aug 16, 2016 at 3:01 PM, George Sexton < > >>> geor...@mhsoftware.com> wrote: > >>> > >>> The best place to start would be to look at tomcat's logs > >>> for exceptions > >>> > >>> or errors. > > > > On 8/16/2016 12:44 PM, Andrew Davis wrote: > > Hello, > > Im working on getting java servlets to run on my > instance of Ububtu > > with tomcat7. > > > > I write my applications in Eclipse.. when i run my > > apps localhost i see everything just fine. > > > > When i export my WAR files i check the includ source > >
Re: Set up postgresql on tomcat7
Replies at the end: Andrew: On 8/17/2016 7:15 AM, Andrew Davis wrote: > Its a redhat .. i don't think tomcat 7 or later will run on this. > > On Aug 17, 2016 9:14 AM, "André Warnier (tomcat)" > wrote: > >> On 17.08.2016 16:06, Andrew Davis wrote: >> >>> Thanks for the prompt.. >>> >>> I have been looking at the doc s and have my .jar file for >>> postgres in the lib folder. >>> >>> I do not understand where the >> name="jdbc/postgres..." >>> >>> Is supposed to go. >>> >>> Im reading at >>> https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource- >>> examples-howto.html >>> >> >> If your version is Tomcat 7, then maybe you should look at the >> Tomcat 7 documentation, not the v 6 one. >> >> In any case, even Tomcat 7 is somewhat old now. Can you upgrade to >> a later version ? That might increase your chances of getting help >> here. >> >> >>> This author has not had success here... >>> >>> This doesn't inspire confidence here, but that's what the >>> documentation shows... >>> >>> >> Sorry, but personally my expertise in these matters is nil, so I >> hope someone else here can pick this up now. >> >> Andy >>> >>> On Aug 17, 2016 4:43 AM, "André Warnier (tomcat)" >>> wrote: >>> >>> On 17.08.2016 11:32, Andrew Davis wrote: >>> >>> Thanks. I can now deploy my servlets and they work ok, but.. I had hoped to just deploy one copy of the postgres jar to my server and then be able to consume it inside multiple applications, instead of having multiple copies of the jar in multiple apps. I've been through the JNDI portion of the docs on Tomcat and found it still somewhat confusing. Andy... >>> I am far from an expert on this kind of thing, but have you >>> looked at this : >>> >>> http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html >>> >>> >>> Maybe that is the missing link in your understanding ? >>> >>> >>> >>> >>> On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" >>> wrote: Andrew, > this list strips most kinds of attachments, so nobody saw > your screenshots or whatever was in them. You need to > copy/paste that text right into your message to the list > (amd make sure that you send your message as "plain text", > not HTML, otherwise it will be unreadable. > > On 17.08.2016 02:10, Andrew Davis wrote: > > Well, > >> This has not turned out how I wanted it to . >> >> I have 'a solution' but it isnt what I wanted to do. I >> went back and re added the .jar file to the 'WEB-INF' >> folder and then deployed a new WAR file. >> >> Now things work just 'fine' BUT I suspect that this is not >> what a real coder would do and suspect I am still in the >> realms of hackery.. >> >> [image: Inline image 1] >> >> Andy. >> >> >> >> On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis >> wrote: >> >> I found the following in my logs.. >> >> >>> from command line in Putty... >>> >>> cd /var/lib/tomcat7 tail -f logs/catalina.out >>> >>> [image: Inline image 1] >>> >>> I do have the jar file located in the following location >>> on the machine.. >>> >>> /usr/share/tomcat7/lib >>> >>> https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt >>> >>> o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. >>> at this point.. >>> >>> Andy.. >>> >>> >>> >>> On Tue, Aug 16, 2016 at 3:01 PM, George Sexton < >>> geor...@mhsoftware.com> wrote: >>> >>> The best place to start would be to look at tomcat's logs >>> for exceptions >>> >>> or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu > with tomcat7. > > I write my applications in Eclipse.. when i run my > apps localhost i see everything just fine. > > When i export my WAR files i check the includ source > files. > > I deploy the WAR file through tomcat manager. > > I can see the java classes which i use to insert > records into my postgresql database. However, there > is nothing happening. When i attempt to run them, > no joy. > > I have the postgresql .jar file installed on my > headless ubuntu server , but no luck. > > Aside from the .jar file is there anything else i > need to configure? > > Any advice is welcome > > Andy AD: Its a redhat .. i don't think tomcat 7 or later will run on this. From your first message, I thought that this was Ubuntu? Please note that different Linux distributions package Tomcat
Re: Set up postgresql on tomcat7
On 2016-08-17 5:32 AM, Andrew Davis wrote: Thanks. I can now deploy my servlets and they work ok, but.. I had hoped to just deploy one copy of the postgres jar to my server and then be able to consume it inside multiple applications, instead of having multiple copies of the jar in multiple apps. Try placing the postgres JDBC driver in Tomcat's lib directory. For example: C:\apache-tomcat-7.0.69\lib Then include your defining the JDBC data source in Tomcat's context.xml For example: C:\apache-tomcat-7.0.69\conf\context.xml Attribute driverClassName should reference a JDBC driver class inside the postgres jar. Attribute name is very important and must match the value of res-ref-name inside your webapp's web.xml. For example: C:\apache-tomcat-7.0.69\webapps\yourWebapp\WEB-INF\web.xml Requires named JNDI data source defined in Tomcat's context.xml jdbc/myPostgresConnection javax.sql.DataSource Container This will allow you to have one copy of the postgres jar deployed in Tomcat's lib directory, and each of your webapps can reference the named connection (i.e. jdbc/myPostgresConnection ) within their own web.xml -Jason I've been through the JNDI portion of the docs on Tomcat and found it still somewhat confusing. Andy... On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: Andrew, this list strips most kinds of attachments, so nobody saw your screenshots or whatever was in them. You need to copy/paste that text right into your message to the list (amd make sure that you send your message as "plain text", not HTML, otherwise it will be unreadable. On 17.08.2016 02:10, Andrew Davis wrote: Well, This has not turned out how I wanted it to . I have 'a solution' but it isnt what I wanted to do. I went back and re added the .jar file to the 'WEB-INF' folder and then deployed a new WAR file. Now things work just 'fine' BUT I suspect that this is not what a real coder would do and suspect I am still in the realms of hackery.. [image: Inline image 1] Andy. On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis wrote: I found the following in my logs.. from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton wrote: The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy -- George Sexton *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org smime.p7s Description: S/MIME Cryptographic Signature
Re: Set up postgresql on tomcat7
Thanks.. sorry bout the top-post. Andy On Wed, Aug 17, 2016 at 10:31 AM, Caldarale, Charles R < chuck.caldar...@unisys.com> wrote: > > From: Andrew Davis [mailto:drsockmon...@gmail.com] > > Subject: Re: Set up postgresql on tomcat7 > > > Its a redhat .. i don't think tomcat 7 or later will run on this. > > Stop top posting; read the rules here: > http://tomcat.apache.org/lists.html#tomcat-users > > The distributor of your OS is completely irrelevant. What's important is > the version of the JVM you have installed. Look at this page to see what > version of Tomcat will run with your JVM: > http://tomcat.apache.org/whichversion.html > > - Chuck > > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > MATERIAL and is thus for use only by the intended recipient. If you > received this in error, please contact the sender and delete the e-mail and > its attachments from all computers. > > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
RE: Set up postgresql on tomcat7
> From: Andrew Davis [mailto:drsockmon...@gmail.com] > Subject: Re: Set up postgresql on tomcat7 > Its a redhat .. i don't think tomcat 7 or later will run on this. Stop top posting; read the rules here: http://tomcat.apache.org/lists.html#tomcat-users The distributor of your OS is completely irrelevant. What's important is the version of the JVM you have installed. Look at this page to see what version of Tomcat will run with your JVM: http://tomcat.apache.org/whichversion.html - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Set up postgresql on tomcat7
Its a redhat .. i don't think tomcat 7 or later will run on this. On Aug 17, 2016 9:14 AM, "André Warnier (tomcat)" wrote: > On 17.08.2016 16:06, Andrew Davis wrote: > >> Thanks for the prompt.. >> >> I have been looking at the doc s and have my .jar file for postgres in the >> lib folder. >> >> I do not understand where the >> > >> Is supposed to go. >> >> Im reading at >> https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource- >> examples-howto.html >> > > If your version is Tomcat 7, then maybe you should look at the Tomcat 7 > documentation, not the v 6 one. > > In any case, even Tomcat 7 is somewhat old now. Can you upgrade to a > later version ? That might increase your chances of getting help here. > > >> This author has not had success here... >> >> This doesn't inspire confidence here, but that's what the documentation >> shows... >> >> > Sorry, but personally my expertise in these matters is nil, so I hope > someone else here can pick this up now. > > Andy >> >> On Aug 17, 2016 4:43 AM, "André Warnier (tomcat)" wrote: >> >> On 17.08.2016 11:32, Andrew Davis wrote: >> >> Thanks. >>> >>> I can now deploy my servlets and they work ok, but.. >>> >>> I had hoped to just deploy one copy of the postgres jar to my server and >>> then be able to consume it inside multiple applications, instead of >>> having >>> multiple copies of the jar in multiple apps. >>> >>> I've been through the JNDI portion of the docs on Tomcat and found it >>> still >>> somewhat confusing. >>> >>> Andy... >>> >>> >> I am far from an expert on this kind of thing, but have you looked at >> this : >> >> http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html >> >> Maybe that is the missing link in your understanding ? >> >> >> >> >> On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: >>> >>> Andrew, >>> this list strips most kinds of attachments, so nobody saw your screenshots or whatever was in them. You need to copy/paste that text right into your message to the list (amd make sure that you send your message as "plain text", not HTML, otherwise it will be unreadable. On 17.08.2016 02:10, Andrew Davis wrote: Well, > This has not turned out how I wanted it to . > > I have 'a solution' but it isnt what I wanted to do. I went back and > re > added the .jar file to the 'WEB-INF' folder and then deployed a new WAR > file. > > Now things work just 'fine' BUT I suspect that this is not what a real > coder would do and suspect I am still in the realms of hackery.. > > [image: Inline image 1] > > Andy. > > > > On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis > wrote: > > I found the following in my logs.. > > >> from command line in Putty... >> >> cd /var/lib/tomcat7 >> tail -f logs/catalina.out >> >> [image: Inline image 1] >> >> I do have the jar file located in the following location on the >> machine.. >> >> /usr/share/tomcat7/lib >> >> https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt >> o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. >> at >> this point.. >> >> Andy.. >> >> >> >> On Tue, Aug 16, 2016 at 3:01 PM, George Sexton < >> geor...@mhsoftware.com> >> wrote: >> >> The best place to start would be to look at tomcat's logs for >> exceptions >> >> or errors. >>> >>> >>> >>> On 8/16/2016 12:44 PM, Andrew Davis wrote: >>> >>> Hello, >>> >>> Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy -- George Sexton >>> *MH Software, Inc.* >>> Voice: 303 438 9585 >>> http://www.connectdaily.com >>> >>> >>> >>> >> >> > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org >>> >> ---
Re: Set up postgresql on tomcat7
On 17.08.2016 16:06, Andrew Davis wrote: Thanks for the prompt.. I have been looking at the doc s and have my .jar file for postgres in the lib folder. I do not understand where the https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html If your version is Tomcat 7, then maybe you should look at the Tomcat 7 documentation, not the v 6 one. In any case, even Tomcat 7 is somewhat old now. Can you upgrade to a later version ? That might increase your chances of getting help here. This author has not had success here... This doesn't inspire confidence here, but that's what the documentation shows... Sorry, but personally my expertise in these matters is nil, so I hope someone else here can pick this up now. Andy On Aug 17, 2016 4:43 AM, "André Warnier (tomcat)" wrote: On 17.08.2016 11:32, Andrew Davis wrote: Thanks. I can now deploy my servlets and they work ok, but.. I had hoped to just deploy one copy of the postgres jar to my server and then be able to consume it inside multiple applications, instead of having multiple copies of the jar in multiple apps. I've been through the JNDI portion of the docs on Tomcat and found it still somewhat confusing. Andy... I am far from an expert on this kind of thing, but have you looked at this : http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html Maybe that is the missing link in your understanding ? On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: Andrew, this list strips most kinds of attachments, so nobody saw your screenshots or whatever was in them. You need to copy/paste that text right into your message to the list (amd make sure that you send your message as "plain text", not HTML, otherwise it will be unreadable. On 17.08.2016 02:10, Andrew Davis wrote: Well, This has not turned out how I wanted it to . I have 'a solution' but it isnt what I wanted to do. I went back and re added the .jar file to the 'WEB-INF' folder and then deployed a new WAR file. Now things work just 'fine' BUT I suspect that this is not what a real coder would do and suspect I am still in the realms of hackery.. [image: Inline image 1] Andy. On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis wrote: I found the following in my logs.. from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton wrote: The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy -- George Sexton *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Set up postgresql on tomcat7
Thanks for the prompt.. I have been looking at the doc s and have my .jar file for postgres in the lib folder. I do not understand where the https://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html This author has not had success here... This doesn't inspire confidence here, but that's what the documentation shows... Andy On Aug 17, 2016 4:43 AM, "André Warnier (tomcat)" wrote: On 17.08.2016 11:32, Andrew Davis wrote: > Thanks. > > I can now deploy my servlets and they work ok, but.. > > I had hoped to just deploy one copy of the postgres jar to my server and > then be able to consume it inside multiple applications, instead of having > multiple copies of the jar in multiple apps. > > I've been through the JNDI portion of the docs on Tomcat and found it still > somewhat confusing. > > Andy... > I am far from an expert on this kind of thing, but have you looked at this : http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html Maybe that is the missing link in your understanding ? > On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: > > Andrew, >> this list strips most kinds of attachments, so nobody saw your screenshots >> or whatever was in them. >> You need to copy/paste that text right into your message to the list (amd >> make sure that you send your message as "plain text", not HTML, otherwise >> it will be unreadable. >> >> On 17.08.2016 02:10, Andrew Davis wrote: >> >> Well, >>> This has not turned out how I wanted it to . >>> >>> I have 'a solution' but it isnt what I wanted to do. I went back and re >>> added the .jar file to the 'WEB-INF' folder and then deployed a new WAR >>> file. >>> >>> Now things work just 'fine' BUT I suspect that this is not what a real >>> coder would do and suspect I am still in the realms of hackery.. >>> >>> [image: Inline image 1] >>> >>> Andy. >>> >>> >>> >>> On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis >>> wrote: >>> >>> I found the following in my logs.. >>> from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton wrote: The best place to start would be to look at tomcat's logs for exceptions > or errors. > > > > On 8/16/2016 12:44 PM, Andrew Davis wrote: > > Hello, > >> Im working on getting java servlets to run on my instance of Ububtu >> with >> tomcat7. >> >> I write my applications in Eclipse.. when i run my apps localhost i >> see >> everything just fine. >> >> When i export my WAR files i check the includ source files. >> >> I deploy the WAR file through tomcat manager. >> >> I can see the java classes which i use to insert records into my >> postgresql >> database. However, there is nothing happening. When i attempt to >> run >> them, no joy. >> >> I have the postgresql .jar file installed on my headless ubuntu server >> , >> but no luck. >> >> Aside from the .jar file is there anything else i need to configure? >> >> Any advice is welcome >> >> Andy >> >> >> -- >> > George Sexton > *MH Software, Inc.* > Voice: 303 438 9585 > http://www.connectdaily.com > > > >>> >> - >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> >> > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Set up postgresql on tomcat7
On 17.08.2016 11:32, Andrew Davis wrote: Thanks. I can now deploy my servlets and they work ok, but.. I had hoped to just deploy one copy of the postgres jar to my server and then be able to consume it inside multiple applications, instead of having multiple copies of the jar in multiple apps. I've been through the JNDI portion of the docs on Tomcat and found it still somewhat confusing. Andy... I am far from an expert on this kind of thing, but have you looked at this : http://tomcat.apache.org/tomcat-8.0-doc/config/globalresources.html Maybe that is the missing link in your understanding ? On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: Andrew, this list strips most kinds of attachments, so nobody saw your screenshots or whatever was in them. You need to copy/paste that text right into your message to the list (amd make sure that you send your message as "plain text", not HTML, otherwise it will be unreadable. On 17.08.2016 02:10, Andrew Davis wrote: Well, This has not turned out how I wanted it to . I have 'a solution' but it isnt what I wanted to do. I went back and re added the .jar file to the 'WEB-INF' folder and then deployed a new WAR file. Now things work just 'fine' BUT I suspect that this is not what a real coder would do and suspect I am still in the realms of hackery.. [image: Inline image 1] Andy. On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis wrote: I found the following in my logs.. from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton wrote: The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy -- George Sexton *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Set up postgresql on tomcat7
Thanks. I can now deploy my servlets and they work ok, but.. I had hoped to just deploy one copy of the postgres jar to my server and then be able to consume it inside multiple applications, instead of having multiple copies of the jar in multiple apps. I've been through the JNDI portion of the docs on Tomcat and found it still somewhat confusing. Andy... On Aug 17, 2016 4:06 AM, "André Warnier (tomcat)" wrote: > Andrew, > this list strips most kinds of attachments, so nobody saw your screenshots > or whatever was in them. > You need to copy/paste that text right into your message to the list (amd > make sure that you send your message as "plain text", not HTML, otherwise > it will be unreadable. > > On 17.08.2016 02:10, Andrew Davis wrote: > >> Well, >> This has not turned out how I wanted it to . >> >> I have 'a solution' but it isnt what I wanted to do. I went back and re >> added the .jar file to the 'WEB-INF' folder and then deployed a new WAR >> file. >> >> Now things work just 'fine' BUT I suspect that this is not what a real >> coder would do and suspect I am still in the realms of hackery.. >> >> [image: Inline image 1] >> >> Andy. >> >> >> >> On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis >> wrote: >> >> I found the following in my logs.. >>> >>> from command line in Putty... >>> >>> cd /var/lib/tomcat7 >>> tail -f logs/catalina.out >>> >>> [image: Inline image 1] >>> >>> I do have the jar file located in the following location on the machine.. >>> >>> /usr/share/tomcat7/lib >>> >>> https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt >>> o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at >>> this point.. >>> >>> Andy.. >>> >>> >>> >>> On Tue, Aug 16, 2016 at 3:01 PM, George Sexton >>> wrote: >>> >>> The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, > Im working on getting java servlets to run on my instance of Ububtu > with > tomcat7. > > I write my applications in Eclipse.. when i run my apps localhost i see > everything just fine. > > When i export my WAR files i check the includ source files. > > I deploy the WAR file through tomcat manager. > > I can see the java classes which i use to insert records into my > postgresql > database. However, there is nothing happening. When i attempt to run > them, no joy. > > I have the postgresql .jar file installed on my headless ubuntu server > , > but no luck. > > Aside from the .jar file is there anything else i need to configure? > > Any advice is welcome > > Andy > > > -- George Sexton *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com >>> >>> >> > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
Re: Set up postgresql on tomcat7
Andrew, this list strips most kinds of attachments, so nobody saw your screenshots or whatever was in them. You need to copy/paste that text right into your message to the list (amd make sure that you send your message as "plain text", not HTML, otherwise it will be unreadable. On 17.08.2016 02:10, Andrew Davis wrote: Well, This has not turned out how I wanted it to . I have 'a solution' but it isnt what I wanted to do. I went back and re added the .jar file to the 'WEB-INF' folder and then deployed a new WAR file. Now things work just 'fine' BUT I suspect that this is not what a real coder would do and suspect I am still in the realms of hackery.. [image: Inline image 1] Andy. On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis wrote: I found the following in my logs.. from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton wrote: The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy -- George Sexton *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Set up postgresql on tomcat7
Well, This has not turned out how I wanted it to . I have 'a solution' but it isnt what I wanted to do. I went back and re added the .jar file to the 'WEB-INF' folder and then deployed a new WAR file. Now things work just 'fine' BUT I suspect that this is not what a real coder would do and suspect I am still in the realms of hackery.. [image: Inline image 1] Andy. On Tue, Aug 16, 2016 at 6:53 PM, Andrew Davis wrote: > I found the following in my logs.. > > from command line in Putty... > > cd /var/lib/tomcat7 > tail -f logs/catalina.out > > [image: Inline image 1] > > I do have the jar file located in the following location on the machine.. > > /usr/share/tomcat7/lib > > https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt > o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at > this point.. > > Andy.. > > > > On Tue, Aug 16, 2016 at 3:01 PM, George Sexton > wrote: > >> The best place to start would be to look at tomcat's logs for exceptions >> or errors. >> >> >> >> On 8/16/2016 12:44 PM, Andrew Davis wrote: >> >>> Hello, >>> Im working on getting java servlets to run on my instance of Ububtu with >>> tomcat7. >>> >>> I write my applications in Eclipse.. when i run my apps localhost i see >>> everything just fine. >>> >>> When i export my WAR files i check the includ source files. >>> >>> I deploy the WAR file through tomcat manager. >>> >>> I can see the java classes which i use to insert records into my >>> postgresql >>> database. However, there is nothing happening. When i attempt to run >>> them, no joy. >>> >>> I have the postgresql .jar file installed on my headless ubuntu server , >>> but no luck. >>> >>> Aside from the .jar file is there anything else i need to configure? >>> >>> Any advice is welcome >>> >>> Andy >>> >>> >> -- >> George Sexton >> *MH Software, Inc.* >> Voice: 303 438 9585 >> http://www.connectdaily.com >> > >
Re: Set up postgresql on tomcat7
I found the following in my logs.. from command line in Putty... cd /var/lib/tomcat7 tail -f logs/catalina.out [image: Inline image 1] I do have the jar file located in the following location on the machine.. /usr/share/tomcat7/lib https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howt o.html#JDBC_Data_Sources is confusing to me. It shouldnt but it is.. at this point.. Andy.. On Tue, Aug 16, 2016 at 3:01 PM, George Sexton wrote: > The best place to start would be to look at tomcat's logs for exceptions > or errors. > > > > On 8/16/2016 12:44 PM, Andrew Davis wrote: > >> Hello, >> Im working on getting java servlets to run on my instance of Ububtu with >> tomcat7. >> >> I write my applications in Eclipse.. when i run my apps localhost i see >> everything just fine. >> >> When i export my WAR files i check the includ source files. >> >> I deploy the WAR file through tomcat manager. >> >> I can see the java classes which i use to insert records into my >> postgresql >> database. However, there is nothing happening. When i attempt to run >> them, no joy. >> >> I have the postgresql .jar file installed on my headless ubuntu server , >> but no luck. >> >> Aside from the .jar file is there anything else i need to configure? >> >> Any advice is welcome >> >> Andy >> >> > -- > George Sexton > *MH Software, Inc.* > Voice: 303 438 9585 > http://www.connectdaily.com >
Re: Set up postgresql on tomcat7
On 2016-08-16 2:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy Andy, Have you defined a JDBC data source for your connection to postgres? This may be helpful: https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html#JDBC_Data_Sources -Jason - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Set up postgresql on tomcat7
The best place to start would be to look at tomcat's logs for exceptions or errors. On 8/16/2016 12:44 PM, Andrew Davis wrote: Hello, Im working on getting java servlets to run on my instance of Ububtu with tomcat7. I write my applications in Eclipse.. when i run my apps localhost i see everything just fine. When i export my WAR files i check the includ source files. I deploy the WAR file through tomcat manager. I can see the java classes which i use to insert records into my postgresql database. However, there is nothing happening. When i attempt to run them, no joy. I have the postgresql .jar file installed on my headless ubuntu server , but no luck. Aside from the .jar file is there anything else i need to configure? Any advice is welcome Andy -- George Sexton *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com