Update sybase driver to pass simple unit tests with jtds and verify it works with the new dialect keyword

Test against Sybase versions 12.5.1 and 15.02. Requires database option "select into/bulk copy" enabled on the database to pass all tests.

Note this only works with jTds. Jconnect (the Sybase supplied jdbc driver) is not yet working and will require a bit more work.

I no longer work with sybase. If you need any further help from me on this, please let me know sooner rather than later, as I may not be able to down the line.

Thanks,
Leigh.

Patch applied in commit ca3e595. This was a blind commit since I don't have Sybase installed. In eyeballing the fixes the changes look like they could conceivably fix issues

Leigh, I know you said you may not be able to test down the road, but are that far down it yet? Can you make sure trunk is still working at least as well as it was before?

Maybe in a month. I don't use Sybase at work anymore and I have a new baby at home, so thats out of the question for now.

Hi.

I think there might have been a problem in applying the patch. It looks like we're missing test/sybase_jtds_simple_test.rb.

C:\code\activerecord-jdbc-adapter>jruby -S rake test_sybase_jtds
(in C:/code/activerecord-jdbc-adapter)
You really need Hoe installed to be able to package this gem
C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake/rake_test_loader.rb:5: in `load': No such file to load – test/sybase_jtds_simple_test.rb(LoadError)
from C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake/rake_test_loader.rb:5
from C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake/rake_test_loader.rb:5:in `each'
from C:/jruby-1.1.6/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake/rake_test_loader.rb:5
rake aborted!
Command failed with status (1): [C:/jruby-1.1.6/bin/../bin/jruby.bat -Ilib;...]

(See full trace by running task with --trace)

As an aside, I have access to a Sybase 12.5.3 server and I'd be happy to help out with testing the Sybase JDBC adapter. Much like Leigh, a new baby is in my near future (next 2 weeks) so I'm not so sure of my availablilty after that point.

Stuart

Assuming the additional failure report was against ar-jdbc master, I'm reopening this.

Here it is (its pretty small_ contents is:

require 'jdbc_common'
require 'db/sybase_jtds'

class SybaseJtdsSimpleTest < Test::Unit::TestCase
include SimpleTestMethods
end

Leigh, Do the tests pass once you add that file?

Added this new file in commit 106545f. Can you run tests again to verify things are running?

I don't have a sybase environment t test againts, but I will give whatever assistance I can to anyone that does.

Open too long and I think I applied the magic to fix this. If this is in fact still broken we can just open up a new issue.