Jruby + SQLServer

Rails
1

Hi, I´m using jruby and sqladapter.jar to conect in my sql server.
but this integration dont work well yet.
my database.yml config:

host: localhost
adapter: jdbc
username: sasa
password: senha
driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
url: jdbc:sqlserver://localhost;databaseName=rails_teste

something wrong with this??

i need change my enviroment.rb?

please help

–
Horus Augustus C. C. Lima

Sagarana Tech
Mobile +55(85)8842.4402
Desk +55(85)3304.6530
[email protected]
http://www.sagaranatech.com

2

On Fri, Jul 3, 2009 at 7:44 AM, Augustus C.[email protected]
wrote:

something wrong with this??

What error do you get? Did you include sqladapter.jar on the
classpath? Do you have the activerecord-jdbc-adapter gem installed?
What versions of all these (JRuby, activerecord-jdbc-adapter, Rails)?

/Nick

3

Thanks for your hellping.

Sql server 2005

  • jruby-1.3.1

*gem list *

actionmailer (2.3.2)
actionpack (2.3.2)
activerecord (2.3.2)
ActiveRecord-JDBC (0.5)
activerecord-jdbc-adapter (0.9.1)
activeresource (2.3.2)
activesupport (2.3.2)
builder (2.1.2)
camping (1.5.180)
jruby-openssl (0.5.1)
markaby (0.5)
metaid (1.0)
rails (2.3.2)
rake (0.8.7)
rspec (1.2.6)
sources (0.0.1)

I alredy try with jars:
sqljdbc.jar
jtds-1.2.jar

I can do all steps but rake db:create don´t work
nothing happening
don´t show erros
don´t create db

I have to create a easily intall app and i need rake db:create

4

On Fri, Jul 3, 2009 at 3:12 PM, Augustus C.[email protected]
wrote:

activerecord (2.3.2)
rake (0.8.7)
rspec (1.2.6)
sources (0.0.1)

I alredy try with jars:
sqljdbc.jar
jtds-1.2.jar

I can do all steps but rake db:create don´t work

See http://jira.codehaus.org/browse/JRUBY-3502. I’d suggest for now,
opening up the SqlServer console and creating the databases there
until we’re able to sort out the db:create stuff.

/Nick

5

Ok. But I really need to create a “magic” way to install for this app;
Any ideia?
Anithing can help;
2009/7/3 Nick S. [email protected]

markaby (0.5)
I can do all steps but rake db:create don´t work

See http://jira.codehaus.org/browse/JRUBY-3502. I’d suggest for now,
opening up the SqlServer console and creating the databases there
until we’re able to sort out the db:create stuff.

/Nick

–
Horus Augustus C. C. Lima

Sagarana Tech
Mobile +55(85)8842.4402
Desk +55(85)3304.6530
[email protected]
http://www.sagaranatech.com