On Sep 21, 2012, at 8:39 PM, Chuck Hill <[email protected]> wrote:
> 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.
I was able to resolve it after configuring it to use the ERXMicrosoftPlugIn.
Although I was not able to find this in Wonder, I found a copy of it in the
MicrosoftPlugIn.framework which I was able to find on the web. Seems to be
missing in the Wonder distribution.
Thanks for all your help,
Anil
>
>
> 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]
