SQLServer failing with activerecord_jdbc 0.9.1

I am getting an error trying to use active_record against a sqlserver
database: ActiveRecord::ActiveRecordError: The conversion from ntext to
BinaryStream is unsupported. Evidently this a new error in 0.9.1. Has
anyone seen it and have a work around?

–Chris

On Wed, Apr 1, 2009 at 9:49 AM, Chris N.
[email protected] wrote:

I am getting an error trying to use active_record against a sqlserver
database: ActiveRecord::ActiveRecordError: The conversion from ntext to
BinaryStream is unsupported. Evidently this a new error in 0.9.1. Has
anyone seen it and have a work around?

I don’t use sqlserver so unfortunately I don’t know. If you could help
us narrow down what change broke the issue, that would be great. Can
you provide more details?

/Nick


To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

Yes, I created a ticked for it: JRUBY-3544 but it looks like there was a
ticket already for it: JRUBY-3512. In 3512 it refers to a specific
commit
which caused the bug, was this commit needed for a different database
(but
broke SQLServer)

–Chris

I can confirm that changing the code in my installed gem and running
rake
java_compile fixed this issue for me. Not sure what the correct long
term
fix is.

I made an attempt at a longer term fix in
2c33f8697d85376ad7e9bb7042776507175e5b86. Try it out if you can and
give us feedback.

Thanks,
/Nick

On Wed, Apr 1, 2009 at 2:09 PM, Chris N.
[email protected] wrote:

broke SQLServer)

BinaryStream is unsupported. Evidently this a new error in 0.9.1. Has

http://xircles.codehaus.org/manage_email


To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

Nick,

This worked great. Cloned it, rake installed the gem, worked. I look
at
the commit and it was very helpful, now I understand how all the pieces
fit
together. I figured it would be a matter of adding
MsSqlRubyJdbcConnection
but wasn’t clear on how to tell it to use this class. Now it makes
sense.

–Chris