Re: failed to open database channel: Openbase

2013-12-31 Thread Chuck Hill
The ConnectionAnalyzer says:

3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to create 
JDBCAdaptor...
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Successfully 
created adaptor com.webobjects.jdbcadaptor.JDBCAdaptor
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to create 
plugin...
OpenBasePlugIn is loaded...
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Created plugin 
com.webobjects.jdbcadaptor.OpenBasePKPlugIn
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to load 
JDBC driver com.openbase.jdbc.ObDriver...
3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Successfully 
loaded JDBC driver com.openbase.jdbc.ObDriver
3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - JDBC driver and 
plugin are loaded, trying to connect...
3638 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Error:
Exception thrown while connecting.
Check exception message carefully.

So the problem is not in WebObjects or what software is installed, on the class 
path, etc.   It simply can’t talk to the database server.  Is it running?  If 
so, the URL, database name, user name, or password is wrong.  Or if the 
database supports it, it is refusing connections from that machine.


--
Chuck Hill
Executive Managing Partner, VP Development and Technical Services

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

Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing 
Companies in B.C!

Global Village Consulting ranks 44th in 25th annual PROFIT 500 ranking of 
Canada’s Fastest-Growing Companies by PROFIT Magazine!

On 12/31/2013, 8:41 PM, "Shelley Eitzen" wrote:


3621 [main] WARN NSLog  - An exception occurred while trying to open a
channel: N/A
3621 [main] INFO er.transaction.adaptor.Exceptions  - Database Exception
occured: java.lang.IllegalStateException: _obtainOpenChannel --
com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
database channel.  Check your connection dictionary, and ensure your
database is correctly configured.
OpenBasePlugIn is loaded...
3634 [main] INFO er.extensions.eof.ERXDatabaseContextDelegate  - ams:
{plugin = "com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username =
"admin"; driver = "com.openbase.jdbc.ObDriver"; password = ""; URL = "jdbc:openbase://127.0.0.1/Test"; }
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Checking
JDBC connection with information {plugin =
"com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username = "admin";
driver
= "com.openbase.jdbc.ObDriver"; password = "";
URL = "jdbc:openbase://127.0.0.1/Test"; }
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
create JDBCAdaptor...
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  -
Successfully
created adaptor com.webobjects.jdbcadaptor.JDBCAdaptor
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
create plugin...
OpenBasePlugIn is loaded...
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Created
plugin com.webobjects.jdbcadaptor.OpenBasePKPlugIn
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
load JDBC driver com.openbase.jdbc.ObDriver...
3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  -
Successfully
loaded JDBC driver com.openbase.jdbc.ObDriver
3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - JDBC
driver
and plugin are loaded, trying to connect...
3638 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Error:
Exception thrown while connecting.
Check exception message carefully.
3640 [main] ERROR er.transaction.adaptor.ConnectionAnalyzer  - No
connection.
3640 [main] WARN NSLog  - A fatal exception occurred: _obtainOpenChannel
-- com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
database channel.  Check your connection dictionary, and ensure your
database is correctly configured.
[2014-1-1 14:12:26 CST]  java.lang.IllegalStateException:
_obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
database channel.  Check your connection dictionary, and ensure your
database is correctly configured.
at
com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967)
at
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054)
.
 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to a

Re: failed to open database channel: Openbase

2013-12-31 Thread Shelley Eitzen
Thanks,

It already exists in /Library/Java/Extensions and is referenced in the
"Configure Build Path" dialog

I tried downloading it again and updating it, but I still have the same
issue.

Any more suggestions?

Thanks in advance

Shelley


> did you install the openbase jdbc driver? I think this is what you want:
>
> http://www.openbase.com/index.php/products/downloads
>
> I believe the installed driver should live at (this is where I put my
> postgresql .jar):
>
> /Library/Java/Extensions
>
> On Dec 31, 2013, at 11:09 PM, Shelley Eitzen 
> wrote:
>
>> Hi All,
>>
>> I am trying to set up a new machine
>>
>> OSX 10.9
>> Openbase 12
>> Eclipse 3.8.2
>> Wonder Frameworks
>>
>> I have managed to import my existing application and it compile and
>> build
>> successfully, but when I run my application from eclipse the application
>> is unable to connect to the database with the following log excerpt:
>>
>> ...
>> 3621 [main] WARN NSLog  - An exception occurred while trying to open a
>> channel: N/A
>> 3621 [main] INFO er.transaction.adaptor.Exceptions  - Database Exception
>> occured: java.lang.IllegalStateException: _obtainOpenChannel --
>> com.webobjects.eoaccess.EODatabaseContext
>> com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
>> database channel.  Check your connection dictionary, and ensure your
>> database is correctly configured.
>> OpenBasePlugIn is loaded...
>> 3634 [main] INFO er.extensions.eof.ERXDatabaseContextDelegate  - ams:
>> {plugin = "com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username =
>> "admin"; driver = "com.openbase.jdbc.ObDriver"; password = "> deleted for log>"; URL = "jdbc:openbase://127.0.0.1/Test"; }
>> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Checking
>> JDBC connection with information {plugin =
>> "com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username = "admin";
>> driver
>> = "com.openbase.jdbc.ObDriver"; password = "";
>> URL = "jdbc:openbase://127.0.0.1/Test"; }
>> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
>> create JDBCAdaptor...
>> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  -
>> Successfully
>> created adaptor com.webobjects.jdbcadaptor.JDBCAdaptor
>> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
>> create plugin...
>> OpenBasePlugIn is loaded...
>> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Created
>> plugin com.webobjects.jdbcadaptor.OpenBasePKPlugIn
>> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
>> load JDBC driver com.openbase.jdbc.ObDriver...
>> 3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  -
>> Successfully
>> loaded JDBC driver com.openbase.jdbc.ObDriver
>> 3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - JDBC
>> driver
>> and plugin are loaded, trying to connect...
>> 3638 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Error:
>> Exception thrown while connecting.
>> Check exception message carefully.
>> 3640 [main] ERROR er.transaction.adaptor.ConnectionAnalyzer  - No
>> connection.
>> 3640 [main] WARN NSLog  - A fatal exception occurred: _obtainOpenChannel
>> -- com.webobjects.eoaccess.EODatabaseContext
>> com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
>> database channel.  Check your connection dictionary, and ensure your
>> database is correctly configured.
>> [2014-1-1 14:12:26 CST]  java.lang.IllegalStateException:
>> _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
>> com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
>> database channel.  Check your connection dictionary, and ensure your
>> database is correctly configured.
>>  at
>> com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967)
>>  at
>> com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054)
>> .
>>
>>
>> I have tried localhost and 127.0.0.1 combinations
>> I have tried both restored database and a completely new database
>> I can connect from the command line using openisql_ascii
>> I have no knowledge of jdbc, nor how to test a jdbc connection
>>
>> Can anyone offer any suggestions?
>>
>> Thanks in advance
>> Shelley
>>
>>
>> ___
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com
>>
>> This email sent to tedp...@yahoo.com
>
>

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: failed to open database channel: Openbase

2013-12-31 Thread Theodore Petrosky
did you install the openbase jdbc driver? I think this is what you want:

http://www.openbase.com/index.php/products/downloads

I believe the installed driver should live at (this is where I put my 
postgresql .jar):

/Library/Java/Extensions

On Dec 31, 2013, at 11:09 PM, Shelley Eitzen  wrote:

> Hi All,
> 
> I am trying to set up a new machine
> 
> OSX 10.9
> Openbase 12
> Eclipse 3.8.2
> Wonder Frameworks
> 
> I have managed to import my existing application and it compile and build
> successfully, but when I run my application from eclipse the application
> is unable to connect to the database with the following log excerpt:
> 
> ...
> 3621 [main] WARN NSLog  - An exception occurred while trying to open a
> channel: N/A
> 3621 [main] INFO er.transaction.adaptor.Exceptions  - Database Exception
> occured: java.lang.IllegalStateException: _obtainOpenChannel --
> com.webobjects.eoaccess.EODatabaseContext
> com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
> database channel.  Check your connection dictionary, and ensure your
> database is correctly configured.
> OpenBasePlugIn is loaded...
> 3634 [main] INFO er.extensions.eof.ERXDatabaseContextDelegate  - ams:
> {plugin = "com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username =
> "admin"; driver = "com.openbase.jdbc.ObDriver"; password = " deleted for log>"; URL = "jdbc:openbase://127.0.0.1/Test"; }
> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Checking
> JDBC connection with information {plugin =
> "com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username = "admin"; driver
> = "com.openbase.jdbc.ObDriver"; password = "";
> URL = "jdbc:openbase://127.0.0.1/Test"; }
> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
> create JDBCAdaptor...
> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Successfully
> created adaptor com.webobjects.jdbcadaptor.JDBCAdaptor
> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
> create plugin...
> OpenBasePlugIn is loaded...
> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Created
> plugin com.webobjects.jdbcadaptor.OpenBasePKPlugIn
> 3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
> load JDBC driver com.openbase.jdbc.ObDriver...
> 3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Successfully
> loaded JDBC driver com.openbase.jdbc.ObDriver
> 3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - JDBC driver
> and plugin are loaded, trying to connect...
> 3638 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Error:
> Exception thrown while connecting.
> Check exception message carefully.
> 3640 [main] ERROR er.transaction.adaptor.ConnectionAnalyzer  - No connection.
> 3640 [main] WARN NSLog  - A fatal exception occurred: _obtainOpenChannel
> -- com.webobjects.eoaccess.EODatabaseContext
> com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
> database channel.  Check your connection dictionary, and ensure your
> database is correctly configured.
> [2014-1-1 14:12:26 CST]  java.lang.IllegalStateException:
> _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
> com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
> database channel.  Check your connection dictionary, and ensure your
> database is correctly configured.
>   at
> com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967)
>   at
> com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054)
> .
> 
> 
> I have tried localhost and 127.0.0.1 combinations
> I have tried both restored database and a completely new database
> I can connect from the command line using openisql_ascii
> I have no knowledge of jdbc, nor how to test a jdbc connection
> 
> Can anyone offer any suggestions?
> 
> Thanks in advance
> Shelley
> 
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com
> 
> This email sent to tedp...@yahoo.com


 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

failed to open database channel: Openbase

2013-12-31 Thread Shelley Eitzen
Hi All,

I am trying to set up a new machine

OSX 10.9
Openbase 12
Eclipse 3.8.2
Wonder Frameworks

I have managed to import my existing application and it compile and build
successfully, but when I run my application from eclipse the application
is unable to connect to the database with the following log excerpt:

...
3621 [main] WARN NSLog  - An exception occurred while trying to open a
channel: N/A
3621 [main] INFO er.transaction.adaptor.Exceptions  - Database Exception
occured: java.lang.IllegalStateException: _obtainOpenChannel --
com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
database channel.  Check your connection dictionary, and ensure your
database is correctly configured.
OpenBasePlugIn is loaded...
3634 [main] INFO er.extensions.eof.ERXDatabaseContextDelegate  - ams:
{plugin = "com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username =
"admin"; driver = "com.openbase.jdbc.ObDriver"; password = ""; URL = "jdbc:openbase://127.0.0.1/Test"; }
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Checking
JDBC connection with information {plugin =
"com.webobjects.jdbcadaptor.OpenBasePKPlugIn"; username = "admin"; driver
= "com.openbase.jdbc.ObDriver"; password = "";
URL = "jdbc:openbase://127.0.0.1/Test"; }
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
create JDBCAdaptor...
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Successfully
created adaptor com.webobjects.jdbcadaptor.JDBCAdaptor
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
create plugin...
OpenBasePlugIn is loaded...
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Created
plugin com.webobjects.jdbcadaptor.OpenBasePKPlugIn
3635 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Trying to
load JDBC driver com.openbase.jdbc.ObDriver...
3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Successfully
loaded JDBC driver com.openbase.jdbc.ObDriver
3637 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - JDBC driver
and plugin are loaded, trying to connect...
3638 [main] INFO er.transaction.adaptor.ConnectionAnalyzer  - Error:
Exception thrown while connecting.
Check exception message carefully.
3640 [main] ERROR er.transaction.adaptor.ConnectionAnalyzer  - No connection.
3640 [main] WARN NSLog  - A fatal exception occurred: _obtainOpenChannel
-- com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
database channel.  Check your connection dictionary, and ensure your
database is correctly configured.
[2014-1-1 14:12:26 CST]  java.lang.IllegalStateException:
_obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
com.webobjects.eoaccess.EODatabaseContext@2f473a2e: failed to open
database channel.  Check your connection dictionary, and ensure your
database is correctly configured.
at
com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967)
at
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054)
.


I have tried localhost and 127.0.0.1 combinations
I have tried both restored database and a completely new database
I can connect from the command line using openisql_ascii
I have no knowledge of jdbc, nor how to test a jdbc connection

Can anyone offer any suggestions?

Thanks in advance
Shelley


 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com