应用JDBC连接SQLite

用"SQLite.JDBCDriver"作为JDBC的驱动程序类名。连接JDBC的URL格式为jdbc:sqlite:/path。这里的path为指定到SQLite数据库文件的路径，例如:
jdbc:sqlite://dirA/dirB/dbfile
jdbc:sqlite://DRIVE:/dirA/dirB/dbfile
jdbc:sqlite://COMPUTERNAME/shareA/dirB/dbfile

 

設置environment.rb:

if RUBY_PLATFORM =~ /java/
  require 'rubygems'
  gem 'activerecord-jdbcsqlite3-adapter'
  #require 'active_record/connection_adapters/jdbcsqlite3_adapter'
  require 'jdbc_adapter' 
end

 

設置database.yml:

#SQLite3
development:
  adapter: jdbcsqlite3
  url: jdbc:sqlite:db/test.db 
  
production:
  adapter: jdbcsqlite3
  url: jdbc:sqlite:db/test.db