Rake db:migrate error

Ruby JRuby
1

I am new to Ruby and trying to configure jruby development environment
on laptop using existing Jruby source code.if i run rake db:migrate
getting below error.

please help me for resolving the error.i have stucked in this since 2
weeks.

details are below

Jruby version -1.5.0
Gem 1.3.6

Rails 2.3.8

Rake 0.9.2.2

WARNING: ‘require ‘rake/rdoctask’’ is deprecated. Please use ‘require
‘rdoc/tas
k’ (in RDoc 2.4.2+)’ instead.
at
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctas
k.rb
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
The driver encountered an error:
com.microsoft.sqlserver.jdbc.SQLServerException
: The TCP/IP connection to the host has failed.
java.net.ConnectException: Conn
ection refused: connect
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.7-java
/lib/active_record/connection_adapters/jdbc_adapter.rb:344:in
initialize' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.7-java /lib/active_record/connection_adapters/jdbc_adapter.rb:476:innew’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.7-java
/lib/active_record/connection_adapters/jdbc_adapter.rb:476:in
initialize' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.7-java /lib/active_record/connection_adapters/jdbc_adapter.rb:49:innew’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.7-java
/lib/active_record/connection_adapters/jdbc_adapter.rb:49:in
jdbc_connection' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /connection_adapters/abstract/connection_pool.rb:223:innew_connection’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/connection_adapters/abstract/connection_pool.rb:245:in
checkout_new_connection ' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /connection_adapters/abstract/connection_pool.rb:188:incheckout’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/connection_adapters/abstract/connection_pool.rb:184:in loop' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /connection_adapters/abstract/connection_pool.rb:184:incheckout’
D:/jruby/jruby-1.5.0/lib/ruby/1.8/monitor.rb:191:in mon_synchronize' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /connection_adapters/abstract/connection_pool.rb:183:incheckout’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/connection_adapters/abstract/connection_pool.rb:98:in connection' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /connection_adapters/abstract/connection_pool.rb:326:inretrieve_connection’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/connection_adapters/abstract/connection_specification.rb:123:in
retrieve_conne ction' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /connection_adapters/abstract/connection_specification.rb:115:inconnection’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/migration.rb:440:in initialize' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:401:innew’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/migration.rb:401:in up' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:383:inmigrate’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/tasks/databases.rake
:112
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in
call' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:inexecute’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in
each' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:inexecute’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158:in
invoke_with_call_chain' D:/jruby/jruby-1.5.0/lib/ruby/1.8/monitor.rb:191:inmon_synchronize’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in
invoke_with_call_chain' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:ininvoke’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb
:116:in invoke_task' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb :94:intop_level’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb
:94:in each' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb :94:intop_level’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb
:133:in standard_exception_handling' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb :88:intop_level’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb
:66:in run' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb :133:instandard_exception_handling’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb
:63:in run' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:33 D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:19:inload’
D:\jruby\jruby-1.5.0\bin\rake:19
Tasks: TOP => db:migrate

2

On Thu, Jan 31, 2013 at 3:44 AM, Veerendra P. [email protected]
wrote:

I am new to Ruby and trying to configure jruby development environment
on laptop using existing Jruby source code.if i run rake db:migrate
getting below error.

please help me for resolving the error.i have stucked in this since 2
weeks.

Jruby version -1.5.0
Gem 1.3.6
Rails 2.3.8
Rake 0.9.2.2

Ouch, all pretty old, but I’ll assume you’re trying to get legacy
app going to start the upgrade :wink:

rake aborted!
The driver encountered an error:
com.microsoft.sqlserver.jdbc.SQLServerException
: The TCP/IP connection to the host has failed.
java.net.ConnectException: Connection refused: connect

Either your DB configuration info is wrong, or you have a firewall
or something blocking the DB connection.

Can you ping the DB host? Connect manually with any other tool, .
using the info from config/database.yml ?

–
Hassan S. ------------------------ [email protected]

twitter: @hassan

3

Veerendra -

The connection refused error implies that it’s a configuration error
rather than a source code or logic error.

This can be verified by using the connection information you specified
in config/database.yml to access your data base using a different client
program (is there a SQLServer client app? I don’t know).

It could be a bad user id, password, host name/address, or even a
firewall issue on your data base server. Is the db server on your local
machine, or another one? And have other applications and/or other
machines connected to it successfully?

If this doesn’t help you could post your database.yml file and maybe
something would get our attention. However, when you post more than a
few lines of code, please use a service like gist.github.com to post
your code. Including a long listing directly in a message in a public
forum is not encouraged.

Also, do you need to use old versions? JRuby’s current version is
1.7.2, rake is 10.0.3, and Rails is up to 3.2.11. Also, if you’re using
JRuby 1.5 in its default mode, then you’re using the Ruby language in
its 1.8 mode. I’d recommending updating to use 1.9 mode. This happens
automatically with recent versions such as 1.7.2 (that is, 1.9 is the
default language mode).

Regards,
Keith

Keith R. Bennett

4

Hi Keith,

Thanks for reply,

by enabling tcp/ip port for sqlserver the above issue has been
resolved.

and giving an error related to datatype like below.

“ActiveRecord::ActiveRecordError: Column, parameter, or variable #2:
Cannot find
data type date.: CREATE TABLE reviews ([id] int NOT NULL IDENTITY(1, 1)
PRIMARY
KEY, bit DEFAULT 0, [project_id] int,
[created_at] dateti
me, [updated_at] datetime)”

the schema file for the table is :
create_table “reviews”, :force => true do |t|
t.date “date”
t.boolean “tmp_freezed”, :default => false
t.integer “project_id”
t.datetime “created_at”
t.datetime “updated_at”
t.integer “mom_id”
t.string “tmp_status_backup”
t.integer “tmp_author_id”
t.integer “reviewer_id”
t.string “status”
t.text “stats”
t.integer “author_id”
end

Please help me to resolve the error from the above code.