Re: Using MS SQL Server with WO
Re: Using MS SQL Server with WO
- Subject: Re: Using MS SQL Server with WO
- From: Chuck Hill <email@hidden>
- Date: Thu, 19 Feb 2009 19:33:20 -0800
On Feb 19, 2009, at 4:46 AM, Dov Rosenberg wrote:
I would be interested in getting a copy of your SQLServer plugin.
I will try and post it up tomorrow.
What issues did you fix that the WO provided one didn't address?
It allows jdbc2info to be embedded into the plugin so that you can
generate SQL without a database connection. It also provides some
better support for Migrations and SQL generation.
We just came
across some issues yesterday where if we use the WO MSSQLServer
plugin we
were getting errors like fetches or updates would lock multiple rows
when
single rows were expected.
I have not hit that, but I don't lock on time stamp columns as that
(alleged) database only has 3 ms accuracy on timestamps vs the 1 in
Java.
If we didn't set the plugin and used the generic
plugin JDBCPlugin - everything worked fine. Unfortunately Project
Wonder
uses the plugin to make some conditional decisions when using the
aggregate
function qualifiers - which doesn't work if the plugin is not
specified
I don't recall hitting that yet.
Chuck
On 2/18/09 6:08 PM, "Chuck Hill" <email@hidden> wrote:
Yes, I use it. I am not thrilled about using it, but I do. I have
an
EOF plugin (that should be in Wonder but is not for reasons I don't
recall at the moment, maybe 5.3 / 5.4 compatibility). I can send you
a copy if you want.
Chuck
On Feb 18, 2009, at 12:53 PM, Gustavo Pizano wrote:
Hello, today a friend asked me if its possible to make a
WebApplication, and he told me that his data server its a MS SQL
server, I just wanted to know if its possible to connect EO's on
that Server?
Thanks
Gustavo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
.
net
This email sent to email@hidden
--
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/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden