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. 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 <[email protected]> wrote: > From: Chuck Hill <[email protected]> > Subject: Re: experience with JDBC and centos > To: "Theodore Petrosky" <[email protected]> > Cc: "Tim Worman" <[email protected]>, [email protected] > 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 <[email protected]> > >> wrote: > >>> > >>>> From: Tim Worman <[email protected]> > >>>> Subject: Re: experience with JDBC and > centos > >>>> To: "Theodore Petrosky" <[email protected]> > >>>> Cc: [email protected] > >>>> 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 > >> <[email protected]> > >>>> wrote: > >>>> > >>>>> ok that didn't do anything. > >>>>> > >>>>> --- On Fri, 6/22/12, Tim Worman <[email protected]> > >>>> wrote: > >>>>> > >>>>>> From: Tim Worman <[email protected]> > >>>>>> Subject: Re: experience with JDBC > and > >> centos > >>>>>> To: "Theodore Petrosky" <[email protected]> > >>>>>> Cc: [email protected] > >>>>>> 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 > >>>> <[email protected]> > >>>>>> 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 > >>>> ([email protected]) > >>>>>>> Help/Unsubscribe/Update your > >> Subscription: > >>>>>>> https://lists.apple.com/mailman/options/webobjects-deploy/lists%40thetimmy.com > >>>>>>> > >>>>>>> This email sent to [email protected] > >>>>>> > >>>>>> > >>>> > >>>> > >>> > >>> > _______________________________________________ > >>> Do not post admin requests to the list. They > will be > >> ignored. > >>> Webobjects-deploy mailing list > ([email protected]) > >>> Help/Unsubscribe/Update your Subscription: > >>> https://lists.apple.com/mailman/options/webobjects-deploy/chill%40global-village.net > >>> > >>> This email sent to [email protected] > >> > >> -- > >> 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 ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com This email sent to [email protected]
