Title: [988] trunk/activerecord-jdbc: Tweaks to get oracle tests running for me
Revision
988
Author
nicksieger
Date
2008-05-13 16:41:41 -0400 (Tue, 13 May 2008)

Log Message

Tweaks to get oracle tests running for me

- updated rakefile to include bootclasspath (jruby trunk change)
- close active connections after each test

Modified Paths

Diff

Modified: trunk/activerecord-jdbc/Rakefile (987 => 988)


--- trunk/activerecord-jdbc/Rakefile	2008-05-01 02:48:44 UTC (rev 987)
+++ trunk/activerecord-jdbc/Rakefile	2008-05-13 20:41:41 UTC (rev 988)
@@ -5,7 +5,9 @@
 
 def java_classpath_arg # myriad of ways to discover JRuby classpath
   begin
-    jruby_cpath = Java::java.lang.System.getProperty('java.class.path')
+    cpath  = Java::java.lang.System.getProperty('java.class.path').split(File::PATH_SEPARATOR)
+    cpath += Java::java.lang.System.getProperty('sun.boot.class.path').split(File::PATH_SEPARATOR)
+    jruby_cpath = cpath.compact.join(File::PATH_SEPARATOR)
   rescue => e
   end
   unless jruby_cpath

Modified: trunk/activerecord-jdbc/test/db/oracle.rb (987 => 988)


--- trunk/activerecord-jdbc/test/db/oracle.rb	2008-05-01 02:48:44 UTC (rev 987)
+++ trunk/activerecord-jdbc/test/db/oracle.rb	2008-05-13 20:41:41 UTC (rev 988)
@@ -1,9 +1,29 @@
 config = {
   :username => 'blog',
-  :password => '',
+  :password => 'blog',
   :adapter  => 'oracle',
   :host => ENV["ORACLE_HOST"] || 'localhost',
-  :database => ENV["ORACLE_SID"] || 'weblog_development'
+  :database => ENV["ORACLE_SID"] || 'XE' # XE is the default SID for oracle xe
 }
 
 ActiveRecord::Base.establish_connection(config)
+
+# Here are some notes of things I had to do to get running on Oracle
+# XE.
+#
+#   create tablespace weblog_development
+#     datafile '/usr/lib/oracle/xe/oradata/XE/weblog_development.dbf';
+#   create user blog identified by blog
+#     default tablespace weblog_development;
+#   grant all privileges to blog;
+#
+# You might need to up the number of processes and restart the
+# listener. (In my case, I had to reboot.) See
+# http://it.newinstance.it/2007/06/01/ora-12519-tnsno-appropriate-service-handler-found/
+#
+#   alter system set PROCESSES=150 scope=SPFILE;
+#
+# These might be helpful too (numbers are rather arbitrary...)
+#
+#   alter system set TRANSACTIONS=126 scope=SPFILE;
+#   alter system set SESSIONS=115 scope=SPFILE;

Modified: trunk/activerecord-jdbc/test/simple.rb (987 => 988)


--- trunk/activerecord-jdbc/test/simple.rb	2008-05-01 02:48:44 UTC (rev 987)
+++ trunk/activerecord-jdbc/test/simple.rb	2008-05-13 20:41:41 UTC (rev 988)
@@ -11,6 +11,7 @@
   def teardown
     CreateEntries.down
     CreateAutoIds.down
+    ActiveRecord::Base.clear_active_connections!
   end
 end
 
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Reply via email to