On May 20, 8:10 am, GregD <[email protected]> wrote: > I finally got around to trying this with jruby and I'm having no > success. Can anyone help me please? > > In jirb, I do the following: > require 'java' > require 'rubygems' > require 'sequel' > > Now comes the interesting part: which Sybase jar file to require? > jconn3.jar or jodbc.jar > > require '<path-to-Sybase-Java-lib>/jconn3.jar' > > Now what? > > I tried all kinds of connections strings based on Jconnect format > similar to: > > jdbc:sybase:Tds:host:port? > ServiceName=database&user=user&password=password > > Does anybody have any experience doing this? Could someone please > help? > > Is jtds driver possible? > > I'd like to use all the ruby goodies to test existing java code like > rspec, machinist/factory girl, maybe cucumber with swinger. However, > I don't have a Sybase JDBC adapter for sequel. Active Record is too > hard/too painful to extract from rails. It looks like Datamapper may > not have support either. > > If I have to write an adapter myself, where do I begin? But, I really > don't feel comfortable doing that at this moment.
Sequel passes JDBC connection strings directly to JDBC. So as long as you have a valid JDBC connection string and have loaded the necessary jars, it should work with Sequel. This means that if it is not working, you probably don't have a valid JDBC connection string or have not loaded the necessary jars. If you use JTDS, Sequel will attempt to load the jdbc-jtds gem automatically, so you may want to try that. When you use JTDS, it assumes you are connecting to SQL Server, so it uses SQL Server syntax. Sequel doesn't currently have any special syntax settings for Sybase, but you don't need to worry about that until after you can connect. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
