Db: migrate error

Ruby JRuby
1

when run rake db:migrate error raising below error
Please help me resolving error.
D:\pmsdev>rake db:migrate --trace
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
== Setup: migrating

– create_table(:improvement_votes)
-> 0.0150s
-> 0 rows
– create_table(:reviews)
rake aborted!
An error has occurred, this and all later migrations canceled:

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)
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/connection_adapters/abstract_adapter.rb:221:in log' 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:582:inexecute’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/connection_adapters/abstract/schema_statements.rb:109:in create_table' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:352:inmethod_missing’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/migration.rb:328:in say_with_time' D:/jruby/jruby-1.5.0/lib/ruby/1.8/benchmark.rb:293:inmeasure’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/migration.rb:328:in say_with_time' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:348:inmethod_missing’
./db/migrate//20101002044907_setup.rb:87:in up' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:282:inmigrate’
D:/jruby/jruby-1.5.0/lib/ruby/1.8/benchmark.rb:293:in measure' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:282:inmigrate’
D:1:in migrate' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:491:inmigrate’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/migration.rb:565:in call' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:565:inddl_transaction’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/connection_adapters/abstract/database_statements.rb:136:in
transaction' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /transactions.rb:182:intransaction’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/migration.rb:565:in ddl_transaction' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:490:inmigrate’
D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record
/migration.rb:477:in each' D:/jruby/jruby-1.5.0/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record /migration.rb:477:inmigrate’
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

Veerendra -

Is it necessary for you to run such an ancient version of JRuby (and
Rails, if I remember correctly)?

It looks like you’re on Windows. How do you use rake instead of jruby
-S rake? Is it picking up rake from your MRI Ruby environment? If not,
I’d recommend trying jruby -S rake.

  • Keith

Keith R. Bennett

3

Keith B. wrote in post #1095543:

Veerendra -

Is it necessary for you to run such an ancient version of JRuby (and
Rails, if I remember correctly)?

It looks like you’re on Windows. How do you use rake instead of jruby
-S rake? Is it picking up rake from your MRI Ruby environment? If not,
I’d recommend trying jruby -S rake.

  • Keith

Keith R. Bennett
Keith R. Bennett - Reston, Virginia, Bennett Business Solutions Inc | about.me

Hi Keith,

Thanks for reply,

I have jruby application runnning on production environment with the
above mentioned versions,so i am using same versions ruby and source
code for setting up development environment.

so could you please advice me how i can setup the application with the
source code for newer version of Jruby.

Many Thanks
Veerendra

4

Veerendra -

That’s hard to say without knowing your server setup.

At its simplest, jruby is just a jar file. If you’re not familiar with
how it’s installed and used on your server, I’d suggest learning more
about it as a very high priority, or interacting with someone else in
your organization who knows about it.

  • Keith

Keith R. Bennett