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

Reply via email to