# Jruby + SQLServer

**URL:** <https://www.ruby-forum.com/t/jruby-sqlserver/171494>\
**Category:** Rails\
**Created:** [July 3, 2009, 2:45pm UTC](https://www.ruby-forum.com/t/jruby-sqlserver/171494 "2009-07-03T14:45:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Augustus\_C](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d9b06d/32.png) [@Augustus\_C](https://www.ruby-forum.com/u/Augustus_C)\
**Post date:** [July 3, 2009, 2:45pm UTC](https://www.ruby-forum.com/t/jruby-sqlserver/171494/1 "2009-07-03T14:45:56Z")

</div>

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  
removed\_email\_address@domain.invalid  
[http://www.sagaranatech.com](http://www.sagaranatech.com)

---

<div class="post-metadata">

**Author:** ![Augustus\_C](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d9b06d/32.png) [@Augustus\_C](https://www.ruby-forum.com/u/Augustus_C)\
**Post date:** [July 3, 2009, 10:00pm UTC](https://www.ruby-forum.com/t/jruby-sqlserver/171494/2 "2009-07-03T22:00:47Z")

</div>

On Fri, Jul 3, 2009 at 7:44 AM, Augustus C.[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
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

---

<div class="post-metadata">

**Author:** ![Augustus\_C](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d9b06d/32.png) [@Augustus\_C](https://www.ruby-forum.com/u/Augustus_C)\
**Post date:** [July 3, 2009, 10:13pm UTC](https://www.ruby-forum.com/t/jruby-sqlserver/171494/3 "2009-07-03T22:13:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Augustus\_C](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d9b06d/32.png) [@Augustus\_C](https://www.ruby-forum.com/u/Augustus_C)\
**Post date:** [July 3, 2009, 10:44pm UTC](https://www.ruby-forum.com/t/jruby-sqlserver/171494/4 "2009-07-03T22:44:01Z")

</div>

On Fri, Jul 3, 2009 at 3:12 PM, Augustus C.[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
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](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

---

<div class="post-metadata">

**Author:** ![Augustus\_C](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/d9b06d/32.png) [@Augustus\_C](https://www.ruby-forum.com/u/Augustus_C)\
**Post date:** [July 3, 2009, 10:51pm UTC](https://www.ruby-forum.com/t/jruby-sqlserver/171494/5 "2009-07-03T22:51:36Z")

</div>

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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

> > markaby (0.5)  
> > I can do all steps but rake db:create don´t work
> 
> See [http://jira.codehaus.org/browse/JRUBY-3502](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  
removed\_email\_address@domain.invalid  
[http://www.sagaranatech.com](http://www.sagaranatech.com)