Hi Anil,
On 2012-09-21, at 5:34 AM, Anil Bajaj wrote:
> Hi,
>
> We are trying to upgrade our DB to SQLServer 2000 to SQLServer 2012 (yeah,
> it's a huge leap), and I'm having a bit of trouble getting it going.
>
> I've installed Microsoft's jdbc driver sqljdbc4.jar in
> /Library/Java/Extensions.
>
> And setup the connection dictionary as follows:
>
> URL: jdbc:sqlserver://tracker_host:1433;databaseName=Tracker
> Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
>
> When I run the app, I get the following database exception:
>
> 1102 [main] INFO er.transaction.adaptor.Exceptions - Database Exception
> occured: java.lang.IllegalStateException: _obtainOpenChannel --
> com.webobjects.eoaccess.EODatabaseContext
> com.webobjects.eoaccess.EODatabaseContext@17bf9b45: failed to open database
> channel. Check your connection dictionary, and ensure your database is
> correctly configured.
> 1109 [main] INFO er.extensions.eof.ERXDatabaseContextDelegate - WOTracker:
> {username = "ACG"; driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
> password = "<password deleted for log>"; URL =
> "jdbc:sqlserver://tracker_host:1433;databaseName=Tracker"; }
> 1110 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Checking JDBC
> connection with information {username = "ACG"; driver =
> "com.microsoft.sqlserver.jdbc.SQLServerDriver"; password = "<password deleted
> for log>"; URL = "jdbc:sqlserver://tracker_host:1433;databaseName=Tracker"; }
Is there nothing else? That last message comes from
er.extensions.jdbc.ERXJDBCConnectionAnalyzer which should diagnose the problem
for you. If it just stops... It must be blocking on
EOObjectStoreCoordinator.defaultCoordinator().lock();
Which suggests that it is happening too late and some other thread has that
locked. You could try triggering some database access earlier in app startup
to see if you can get better information.
Has the driver name or package changed? Could it be trying to load it from an
older JDBC driver that is finding someplace? Though I would expect
/Library/Java/Extensions to win over anything else.
> Am I missing anything? Like a JDBC Driver plugin or something?
WebObjects comes with a plugin. There is an extension in Wonder:
com.webobjects.jdbcadaptor.ERXMicrosoftPlugIn
I have not tried that with SQLServer 2012 but I don't see why it would not work.
Chuck
>
> Thanks in advance,
>
> Anil
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/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
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
