On 2012-06-23, at 12:14 PM, Theodore Petrosky wrote: > i noticed in the logs: > > Jun 23 19:04:03 asbriefs[2002] INFO > er.transaction.adaptor.ConnectionAnalyzer - The JRE extension directories > being used are: > Jun 23 19:04:03 asbriefs[2002] INFO > er.transaction.adaptor.ConnectionAnalyzer - > /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/ext:/usr/java/packages/lib/ext > > i noticed the :/usr/java/packages/lib/ext > > I created the directory and put the postgresql jar there.
That will work, but deployments are easier if you include them as part of the deployment bundle. > now: > > Check exception message carefully. > Jun 23 19:08:00 asbriefs[2002] ERROR > er.transaction.adaptor.ConnectionAnalyzer - Connection refused. Check that > the hostname and port are correct and that the postmaster is accepting TCP/IP > connections. > Jun 23 19:08:00 asbriefs[2002] ERROR er.extensions.appserver.ERXApplication > - asbriefs failed to start. > JDBCAdaptorException: Connection refused. Check that the hostname and port > are correct and that the postmaster is accepting TCP/IP connections. > > this is reasonable. it is trying to connect. this I can deal with. > > Thanks for the help. > > Ted > > --- On Sat, 6/23/12, Chuck Hill <ch...@global-village.net> wrote: > >> From: Chuck Hill <ch...@global-village.net> >> Subject: Re: experience with JDBC and centos >> To: "Theodore Petrosky" <tedp...@yahoo.com> >> Cc: "Tim Worman" <li...@thetimmy.com>, webobjects-deploy@lists.apple.com >> Date: Saturday, June 23, 2012, 2:53 PM >> External jars are just that, >> external. They are not added to deployment. Copy >> it into the Libraries directory in the project. Then >> add it from there. Add Jars... >> >> >> Chuck >> >> On 2012-06-23, at 11:46 AM, Theodore Petrosky wrote: >> >>> >>> >>>> Did you add it to the Java Build Path >>>> in the application? Otherwise, it won't get >> on the >>>> classpath. >>> >>> I right click on my app (in Eclipse) >>> >>> build path > configure build path in the >> Libraries tab I clicked the Add External Jars button and >> navigate to the postgresql java jar. >>> >>> 1. is this right? or >>> b. do I need to do more? >>> >>> Ted >>> >>> (i think its funny the 1. and b. just me being silly >> because I am frustrated) >>> >>>> >>>> >>>> On 2012-06-23, at 9:48 AM, Theodore Petrosky >> wrote: >>>> >>>>> yes, I also added the >> postgresql-9.1-902.jdbc3.jar jar >>>> to both my app and my custom framework. >>>>> >>>>> Still no joy. I will keep plugging along and >> try other >>>> things. >>>>> >>>>> Ted >>>>> >>>>> --- On Fri, 6/22/12, Tim Worman <li...@thetimmy.com> >>>> wrote: >>>>> >>>>>> From: Tim Worman <li...@thetimmy.com> >>>>>> Subject: Re: experience with JDBC and >> centos >>>>>> To: "Theodore Petrosky" <tedp...@yahoo.com> >>>>>> Cc: webobjects-deploy@lists.apple.com >>>>>> Date: Friday, June 22, 2012, 6:08 PM >>>>>> Ted: >>>>>> >>>>>> In Eclipse, what actions did you take (step >> by >>>> step), to >>>>>> include the drivers in your project? You >> should >>>> have done >>>>>> this: >>>>>> >>>>>> http://wiki.wocommunity.org/display/WOL/Add+a+Jar+Dependency >>>>>> >>>>>> Tim >>>>>> >>>>>> On Jun 22, 2012, at 2:10 PM, Theodore >> Petrosky >>>> <tedp...@yahoo.com> >>>>>> wrote: >>>>>> >>>>>>> ok that didn't do anything. >>>>>>> >>>>>>> --- On Fri, 6/22/12, Tim Worman <li...@thetimmy.com> >>>>>> wrote: >>>>>>> >>>>>>>> From: Tim Worman <li...@thetimmy.com> >>>>>>>> Subject: Re: experience with JDBC >> and >>>> centos >>>>>>>> To: "Theodore Petrosky" <tedp...@yahoo.com> >>>>>>>> Cc: webobjects-deploy@lists.apple.com >>>>>>>> Date: Friday, June 22, 2012, 3:23 >> PM >>>>>>>> Ted: >>>>>>>> >>>>>>>> Did you include the jar file for >> your >>>> postgresql >>>>>> JDBC driver >>>>>>>> in the build path for your >> project? >>>>>>>> >>>>>>>> T >>>>>>>> >>>>>>>> On Jun 22, 2012, at 11:41 AM, >> Theodore >>>> Petrosky >>>>>> <tedp...@yahoo.com> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Is there someone with >> experience with >>>> Centos >>>>>> and >>>>>>>> postgresql JDBC that could help >> me. >>>>>>>>> >>>>>>>>> I have a backspace Virtual >> Server >>>> (Centos). I >>>>>> have >>>>>>>> installed all the webobjects stuff, >> wonder >>>> stuff, >>>>>>>> postgresql. >>>>>>>>> >>>>>>>>> I can access the Wonder >> JavaMonitor >>>> through >>>>>> apache: >>>>>>>>> >>>>>>>>> http://198.101.209.238/cgi-bin/WebObjects/jm >>>>>>>>> >>>>>>>>> I can access postgresql from >> the CLI >>>> with psql >>>>>>>> template1 and create and drop >> databases. >>>>>>>>> >>>>>>>>> I can not seem to get >> webobjects to see >>>> the >>>>>> postgresql >>>>>>>> JDBC adapter. >>>>>>>>> >>>>>>>>> I am not giving up but I don't >>>> understand why >>>>>> this >>>>>>>> centos install is not seeing the >> postgresql >>>> JDBC >>>>>>>>> >>>>>>>>> - >>>>>> >> file:/opt/Local/Library/WebObjects/Extensions/ >>>>>>>>> Jun 22 16:56:03 asbriefs[2002] >> INFO >>>>>>>> >>>> er.transaction.adaptor.ConnectionAnalyzer - >>>>>> The JRE >>>>>>>> extension directories being used >> are: >>>>>>>>> Jun 22 16:56:03 asbriefs[2002] >> INFO >>>>>>>> >>>> er.transaction.adaptor.ConnectionAnalyzer - >>>>>>>> >>>>>> >>>> >> /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/ext:/usr/java/packages/lib/ext >>>>>>>>> Jun 22 16:56:03 asbriefs[2002] >> ERROR >>>>>>>> >>>> er.transaction.adaptor.ConnectionAnalyzer - >>>>>> JDBC >>>>>>>> Connection Analysis: Cannot load >> JDBC >>>> driver. >>>>>>>> org.postgresql.Driver. >>>>>>>>> Jun 22 16:56:03 asbriefs[2002] >> ERROR >>>>>>>> >>>> er.extensions.appserver.ERXApplication - >>>>>> asbriefs >>>>>>>> failed to start. >>>>>>>>> JDBCAdaptorException: JDBC >> connection >>>> failed >>>>>> for driver >>>>>>>> :'org.postgresql.Driver'. Driver >> not found >>>> in Java >>>>>> Runtime! >>>>>>>> Please verify your CLASSPATH >> environment >>>> variable. >>>>>> The >>>>>>>> current CLASSPATH for your >> application is >>>> : >>>>>> WOBootstrap.jar >>>>>>>>> at >>>>>>>> >>>>>> >>>> >> com.webobjects.jdbcadaptor.JDBCContext.connect(JDBCContext.java:222) >>>>>>>>> >>>>>>>>> and: >>>>>>>>> >>>>>>>>> java -version >>>>>>>>> java version "1.6.0_24" >>>>>>>>> OpenJDK Runtime Environment >> (IcedTea6 >>>> 1.11.3) >>>>>>>> (rhel-1.48.1.11.3.el6_2-x86_64) >>>>>>>>> OpenJDK 64-Bit Server VM >> (build >>>> 20.0-b12, mixed >>>>>> mode) >>>>>>>>> >>>>>>>>> Is there a property for this? >>>>>>>>> >>>>>>>>> Ted >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>> >> _______________________________________________ >>>>>>>>> Do not post admin requests to >> the list. >>>> They >>>>>> will be >>>>>>>> ignored. >>>>>>>>> Webobjects-deploy mailing >>>> list >>>>>> (Webobjects-deploy@lists.apple.com) >>>>>>>>> Help/Unsubscribe/Update your >>>> Subscription: >>>>>>>>> https://lists.apple.com/mailman/options/webobjects-deploy/lists%40thetimmy.com >>>>>>>>> >>>>>>>>> This email sent to li...@thetimmy.com >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>> >>>>> >> _______________________________________________ >>>>> Do not post admin requests to the list. They >> will be >>>> ignored. >>>>> Webobjects-deploy mailing list >> (Webobjects-deploy@lists.apple.com) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> https://lists.apple.com/mailman/options/webobjects-deploy/chill%40global-village.net >>>>> >>>>> This email sent to ch...@global-village.net >>>> >>>> -- >>>> Chuck Hill >>>> Senior Consultant / VP Development >>>> >>>> Practical WebObjects - for developers who want to >> increase >>>> their overall knowledge of WebObjects or who are >> trying to >>>> solve specific problems. >>>> http://www.global-village.net/gvc/practical_webobjects >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >> >> -- >> Chuck Hill >> Senior Consultant / VP Development >> >> Practical WebObjects - for developers who want to increase >> their overall knowledge of WebObjects or who are trying to >> solve specific problems. >> http://www.global-village.net/gvc/practical_webobjects >> >> >> >> >> >> >> >> >> -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/gvc/practical_webobjects _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-deploy mailing list (Webobjects-deploy@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com This email sent to arch...@mail-archive.com