## jdbc.rb
require 'java'
require 'rubygems'
require 'jtds-1.2.2.jar'
gem 'activerecord-jdbc-adapter'
require 'jdbc_adapter'
require 'active_record'

ActiveRecord::Base.establish_connection(
  :adapter => 'jdbc',
  :driver => 'net.sourceforge.jtds.jdbc.Driver',
  :url => 'jdbc:jtds:sqlserver://sql2005server:1433/jdbc_test',
  :username => 'jdbc_test',
  :password => 'jdbc_test'
)

puts ActiveRecord::Base.connection.execute "select * from schema_migrations"

## jdbc.rb out [plain text]
version20090309233017
version20090330224044
version20090527170843
version20090529192459

## database.yml
development:
  host: localhost
  adapter: jdbc
  driver: net.sourceforge.jtds.jdbc.Driver
  url: jdbc:jtds:sqlserver://sql2005server:1433/jdbc_test
  username: jdbc_test
  password: jdbc_test

## script/runner out [plain text]
$> script/runner "puts $:; Contact.count"
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/actionmailer-2.3.2/lib/action_mailer/vendor/tmail-1.2.3
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activesupport-2.3.2/lib/active_support/vendor/i18n-0.1.3/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activesupport-2.3.2/lib/active_support/vendor/tzinfo-0.3.12
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activesupport-2.3.2/lib/active_support/vendor/memcache-client-1.6.5
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activesupport-2.3.2/lib/active_support/vendor/builder-2.1.2
/Users/peterfitzgibbons/vail_systems/conf-test/app/controllers/
/Users/peterfitzgibbons/vail_systems/conf-test/app
/Users/peterfitzgibbons/vail_systems/conf-test/app/models
/Users/peterfitzgibbons/vail_systems/conf-test/app/controllers
/Users/peterfitzgibbons/vail_systems/conf-test/app/helpers
/Users/peterfitzgibbons/vail_systems/conf-test/lib
/Users/peterfitzgibbons/vail_systems/conf-test/vendor
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/rails-2.3.2/lib/../builtin/rails_info/
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/rails-2.3.2/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/rake-0.8.7/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/rake-0.8.7/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activesupport-2.3.2/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activesupport-2.3.2/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/actionpack-2.3.2/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/actionpack-2.3.2/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/actionmailer-2.3.2/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/actionmailer-2.3.2/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activeresource-2.3.2/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activeresource-2.3.2/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/rails-2.3.2/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/rack-1.0.0/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/rack-1.0.0/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/jruby-openssl-0.5.1/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/jruby-openssl-0.5.1/lib
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/bin
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib
/Users/peterfitzgibbons/.ruby/jruby-1.3.1/lib/ruby/site_ruby/1.8
/Users/peterfitzgibbons/.ruby/jruby-1.3.1/lib/ruby/site_ruby
/Users/peterfitzgibbons/.ruby/jruby-1.3.1/lib/ruby/1.8
/Users/peterfitzgibbons/.ruby/jruby-1.3.1/lib/ruby/1.8/java
lib/ruby/1.8
.
/Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:330:in `initialize': The driver encountered an error: cannot load Java class net.sourceforge.jtds.jdbc.Driver (RuntimeError)
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:457:in `initialize'
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:53:in `jdbc_connection'
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `new_connection'
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in `checkout'
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'
	from /Users/peterfitzgibbons/.ruby/jruby-1.3.1/lib/ruby/1.8/monitor.rb:191:in `mon_synchronize'
	 ... 7 levels...
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib/active_record/calculations.rb:129:in `calculate'
	from /Users/peterfitzgibbons/.gem/jruby/1.8/gems/activerecord-2.3.2/lib/active_record/calculations.rb:48:in `count'
	from (eval):1