Hi,
I have been trying for days now to get rake db:create to work for me
The following is output from jgem list
actionmailer (2.3.5)
actionpack (2.3.5)
activerecord (2.3.5)
activerecord-jdbc-adapter (0.9.5)
activerecord-jdbcmysql-adapter (0.9.5)
activeresource (2.3.5)
activesupport (2.3.5)
csspool (0.2.6)
fastercsv (1.5.3)
ffi (0.6.3)
gem_plugin (0.2.3)
haml (2.2.23)
hoe (2.6.0)
jdbc-mysql (5.0.4)
jmx4r (0.1.0)
jruby-jars (1.4.1)
jruby-openssl (0.3)
jruby-rack (0.9.7)
json-jruby (1.4.1)
json_pure (1.4.1)
memcache-client (1.8.3)
rack (1.0.1)
rails (2.3.5)
rake (0.8.7)
RedCloth (4.2.3)
rspec (1.2.9)
rubyforge (2.0.4)
rubyzip (0.9.4)
sources (0.0.1)
stomp (1.1.5)
warbler (1.0.1)
will_paginate (2.3.12)
and the following is my database.yml config
development:
adapter: jdbc
encoding: utf8
pool: 5
wait_timeout: 10
username: root
password:
driver: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/db_dev
database: db_dev
host: 127.0.0.1
The error reported is ** Invoke db:create (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute db:create
rake aborted!
The driver encountered an error: no connection available
I ran jruby script/generate jdbc.
If I create the database manually db:migrate and db:drop work fine.
Any help would be greatly appreciated.
Thanks
Sinead