I actually don't use the passed in arg, but thanks for the info. Here's the stacktrace:
NativeException - java.sql.SQLException: ORA-06550: line 1, column 5: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe : oracle/jdbc/driver/SQLStateMapping.java:70:in `newSQLException' oracle/jdbc/driver/DatabaseError.java:131:in `newSQLException' oracle/jdbc/driver/DatabaseError.java:204:in `throwSqlException' oracle/jdbc/driver/T4CTTIoer.java:455:in `processError' oracle/jdbc/driver/T4CTTIoer.java:413:in `processError' oracle/jdbc/driver/T4C8Oall.java:1034:in `receive' oracle/jdbc/driver/T4CStatement.java:183:in `doOall8' oracle/jdbc/driver/T4CStatement.java:942:in `executeForRows' oracle/jdbc/driver/OracleStatement.java:1222:in `doExecuteWithTimeout' oracle/jdbc/driver/OracleStatement.java:1770:in `executeInternal' oracle/jdbc/driver/OracleStatement.java:1739:in `execute' oracle/jdbc/driver/OracleStatementWrapper.java:299:in `execute' sun/reflect/NativeMethodAccessorImpl.java:-2:in `invoke0' sun/reflect/NativeMethodAccessorImpl.java:39:in `invoke' sun/reflect/DelegatingMethodAccessorImpl.java:25:in `invoke' java/lang/reflect/Method.java:589:in `invoke' org/jruby/javasupport/JavaMethod.java:298:in `invokeWithExceptionHandling' org/jruby/javasupport/JavaMethod.java:259:in `invoke' org/jruby/java/invokers/InstanceMethodInvoker.java:44:in `call' org/jruby/runtime/callsite/CachingCallSite.java:280:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:116:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/RescueNode.java:222:in `executeBody' org/jruby/ast/RescueNode.java:144:in `interpretWithJavaExceptions' org/jruby/ast/RescueNode.java:107:in `interpret' org/jruby/ast/EnsureNode.java:93:in `interpret' org/jruby/ast/BeginNode.java:80:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:190:in `yield' org/jruby/runtime/Block.java:133:in `yield' org/jruby/ast/YieldNode.java:95:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/RescueNode.java:222:in `executeBody' org/jruby/ast/RescueNode.java:144:in `interpretWithJavaExceptions' org/jruby/ast/RescueNode.java:107:in `interpret' org/jruby/ast/EnsureNode.java:93:in `interpret' org/jruby/ast/BeginNode.java:80:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/RescueNode.java:222:in `executeBody' org/jruby/ast/RescueNode.java:144:in `interpretWithJavaExceptions' org/jruby/ast/RescueNode.java:107:in `interpret' org/jruby/ast/BeginNode.java:80:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:267:in `call' org/jruby/runtime/callsite/CachingCallSite.java:124:in `call' org/jruby/ast/CallOneArgBlockPassNode.java:60:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:267:in `call' org/jruby/runtime/callsite/CachingCallSite.java:290:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:141:in `callIter' org/jruby/ast/FCallOneArgBlockNode.java:33:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:225:in `call' org/jruby/runtime/callsite/CachingCallSite.java:270:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:85:in `call' org/jruby/ast/CallNoArgBlockNode.java:63:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:280:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:116:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/LocalAsgnNode.java:120:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:330:in `call' org/jruby/runtime/callsite/CachingCallSite.java:320:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:198:in `call' org/jruby/ast/FCallThreeArgNode.java:40:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/IfNode.java:109:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/IfNode.java:111:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:190:in `yield' org/jruby/runtime/BlockBody.java:64:in `call' org/jruby/runtime/BlockBody.java:70:in `call' org/jruby/runtime/Block.java:116:in `call' org/jruby/RubyProc.java:205:in `call' org/jruby/internal/runtime/methods/ProcMethod.java:64:in `call' org/jruby/internal/runtime/methods/DynamicMethod.java:226:in `call' org/jruby/RubyMethod.java:106:in `call' org/jruby/org/jruby/RubyMethod$i_method_multi$RUBYINVOKER $call.gen:-1:in `call' org/jruby/internal/runtime/methods/DynamicMethod.java:203:in `call' org/jruby/runtime/callsite/CachingCallSite.java:73:in `call' org/jruby/ast/CallNoArgNode.java:61:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:190:in `yield' org/jruby/runtime/Block.java:133:in `yield' org/jruby/RubyObject.java:491:in `yieldUnder' org/jruby/RubyObject.java:313:in `specificEval' org/jruby/RubyObject.java:1206:in `instance_eval' org/jruby/org/jruby/RubyObject$i_method_multi$RUBYFRAMEDINVOKER $instance_eval.gen:-1:in `call' org/jruby/runtime/callsite/CachingCallSite.java:270:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:85:in `call' org/jruby/ast/FCallNoArgBlockPassNode.java:26:in `interpret' org/jruby/ast/FCallTwoArgNode.java:38:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:153:in `yield' org/jruby/runtime/Block.java:120:in `yield' org/jruby/RubyKernel.java:909:in `rbCatch' org/jruby/org/jruby/RubyKernel$s_method_1_0$RUBYFRAMEDINVOKER $rbCatch.gen:-1:in `call' org/jruby/runtime/callsite/CachingCallSite.java:290:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:141:in `callIter' org/jruby/ast/FCallOneArgBlockNode.java:33:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/IfNode.java:109:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:153:in `yield' org/jruby/runtime/Block.java:120:in `yield' org/jruby/RubyArray.java:1559:in `each' org/jruby/org/jruby/RubyArray$i_method_0_0$RUBYFRAMEDINVOKER $each.gen:-1:in `call' org/jruby/runtime/callsite/CachingCallSite.java:83:in `call' org/jruby/ast/CallNoArgBlockNode.java:63:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/IfNode.java:109:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:204:in `call' org/jruby/runtime/callsite/CachingCallSite.java:260:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:75:in `call' org/jruby/ast/FCallNoArgNode.java:31:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/RescueNode.java:222:in `executeBody' org/jruby/ast/RescueNode.java:144:in `interpretWithJavaExceptions' org/jruby/ast/RescueNode.java:107:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:204:in `call' org/jruby/runtime/callsite/CachingCallSite.java:260:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:75:in `call' org/jruby/ast/FCallNoArgNode.java:31:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:190:in `yield' org/jruby/runtime/Block.java:133:in `yield' org/jruby/RubyObject.java:491:in `yieldUnder' org/jruby/RubyObject.java:313:in `specificEval' org/jruby/RubyObject.java:1206:in `instance_eval' org/jruby/org/jruby/RubyObject$i_method_multi$RUBYFRAMEDINVOKER $instance_eval.gen:-1:in `call' org/jruby/runtime/callsite/CachingCallSite.java:270:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:85:in `call' org/jruby/ast/FCallNoArgBlockPassNode.java:26:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:153:in `yield' org/jruby/runtime/Block.java:120:in `yield' org/jruby/RubyKernel.java:909:in `rbCatch' org/jruby/org/jruby/RubyKernel$s_method_1_0$RUBYFRAMEDINVOKER $rbCatch.gen:-1:in `call' org/jruby/runtime/callsite/CachingCallSite.java:290:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:141:in `callIter' org/jruby/ast/FCallOneArgBlockNode.java:33:in `interpret' org/jruby/ast/LocalAsgnNode.java:120:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/RubyClass.java:353:in `finvoke' org/jruby/javasupport/util/RuntimeHelpers.java:328:in `invokeAs' org/jruby/javasupport/util/RuntimeHelpers.java:364:in `invokeSuper' org/jruby/javasupport/util/RuntimeHelpers.java:690:in `callZSuper' org/jruby/ast/ZSuperNode.java:92:in `interpret' org/jruby/ast/LocalAsgnNode.java:120:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:225:in `call' org/jruby/runtime/callsite/CachingCallSite.java:270:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:100:in `callIter' org/jruby/ast/FCallNoArgBlockNode.java:31:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:280:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:116:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:280:in `cacheAndCall' org/jruby/runtime/callsite/CachingCallSite.java:116:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:114:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/ToAryNode.java:66:in `interpret' org/jruby/ast/MultipleAsgnNode.java:113:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:114:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:114:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/RubyClass.java:353:in `finvoke' org/jruby/javasupport/util/RuntimeHelpers.java:328:in `invokeAs' org/jruby/javasupport/util/RuntimeHelpers.java:364:in `invokeSuper' org/jruby/javasupport/util/RuntimeHelpers.java:690:in `callZSuper' org/jruby/ast/ZSuperNode.java:92:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:114:in `call' org/jruby/ast/CallOneArgNode.java:57:in `interpret' org/jruby/ast/ToAryNode.java:66:in `interpret' org/jruby/ast/MultipleAsgnNode.java:113:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:288:in `call' org/jruby/runtime/callsite/CachingCallSite.java:155:in `call' org/jruby/ast/CallTwoArgNode.java:59:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:153:in `yield' org/jruby/runtime/Block.java:120:in `yield' org/jruby/RubyArray.java:1559:in `each' org/jruby/org/jruby/RubyArray$i_method_0_0$RUBYFRAMEDINVOKER $each.gen:-1:in `call' org/jruby/runtime/callsite/CachingCallSite.java:83:in `call' org/jruby/ast/CallNoArgBlockNode.java:63:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/IfNode.java:109:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/IfNode.java:109:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/WhileNode.java:128:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/ast/BlockNode.java:68:in `interpret' org/jruby/ast/RescueNode.java:222:in `executeBody' org/jruby/ast/RescueNode.java:144:in `interpretWithJavaExceptions' org/jruby/ast/RescueNode.java:107:in `interpret' org/jruby/ast/EnsureNode.java:93:in `interpret' org/jruby/ast/BeginNode.java:80:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/internal/runtime/methods/DefaultMethod.java:156:in `interpretedCall' org/jruby/internal/runtime/methods/DefaultMethod.java:133:in `call' org/jruby/internal/runtime/methods/DefaultMethod.java:246:in `call' org/jruby/runtime/callsite/CachingCallSite.java:114:in `call' org/jruby/ast/FCallOneArgNode.java:36:in `interpret' org/jruby/ast/NewlineNode.java:101:in `interpret' org/jruby/runtime/InterpretedBlock.java:202:in `evalBlockBody' org/jruby/runtime/InterpretedBlock.java:190:in `yield' org/jruby/runtime/BlockBody.java:64:in `call' org/jruby/runtime/BlockBody.java:70:in `call' org/jruby/runtime/Block.java:116:in `call' org/jruby/RubyProc.java:205:in `call' org/jruby/RubyProc.java:187:in `call' org/jruby/internal/runtime/RubyRunnable.java:90:in `run' java/lang/Thread.java:637:in `run' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sequel-2.10.0/lib/ sequel_core/connection_pool.rb:109:in `hold' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sequel-2.10.0/lib/ sequel_core/database.rb:437:in `synchronize' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sequel-2.10.0/lib/ sequel_core/adapters/jdbc.rb:200:in `transaction' ruby/updates.rb:12:in `update' ruby/programmatic_resources.rb:34:in `do_update' ruby/programmatic_resources.rb:124:in `POST /updateInstitution.php' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:611:in `route' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:371:in `instance_eval' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:371:in `route!' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:368:in `catch' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:368:in `route!' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:348:in `each' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:348:in `route!' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:433:in `dispatch!' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:315:in `call!' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:400:in `instance_eval' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:400:in `invoke' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:400:in `catch' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:400:in `invoke' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/compat.rb:122:in `invoke' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:315:in `call!' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:304:in `call' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/rack-0.9.1/lib/rack/ methodoverride.rb:24:in `call' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/rack-0.9.1/lib/rack/ commonlogger.rb:20:in `_call' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/rack-0.9.1/lib/rack/ commonlogger.rb:13:in `call' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:671:in `call' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/sinatra-0.9.0.4/lib/ sinatra/base.rb:836:in `call' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/rack-0.9.1/lib/rack/ handler/mongrel.rb:59:in `process' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/mongrel-1.1.5-java/ lib/mongrel.rb:159:in `process_client' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/mongrel-1.1.5-java/ lib/mongrel.rb:158:in `each' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/mongrel-1.1.5-java/ lib/mongrel.rb:158:in `process_client' /Users/jrogers/jruby-1.1.6/lib/ruby/gems/1.8/gems/mongrel-1.1.5-java/ lib/mongrel.rb:285:in `run' :1:in `initialize'127.0.0.1 - - [03/Mar/2009 10:58:57] "POST / updateInstitution.php HTTP/1.1" 500 22066 0.2651 On Mar 2, 11:52 am, Jeremy Evans <[email protected]> wrote: > On Mar 2, 7:01 am, Jason Rogers <[email protected]> wrote: > > > > > I'm banging my head trying to get a transaction to work against > > Oracle, using the JDBC driver. My code is: > > > DB.transaction do |db| > > models.each do |model| > > success &= model.save > > end > > end > > > It seems that the "model.save" statement is not added to the > > transaction. Here's the top of the stack trace. > > > [INFO] 2009-03-02 09:48:20 :: BEGIN > > [INFO] 2009-03-02 09:48:20 :: ROLLBACK > > NativeException - java.sql.SQLException: ORA-06550: line 1, column 5: > > PLS-00103: Encountered the symbol "end-of-file" when expecting one of > > the following: > > > begin case declare exit for goto if loop mod null pragma > > raise return select update while with <an identifier> > > <a double-quoted delimited-identifier> <a bind variable> << > > close current delete fetch lock insert open rollback > > savepoint set sql execute commit forall merge pipe > > : > > oracle/jdbc/driver/SQLStateMapping.java:70:in `newSQLException' > > > Anybody have any clues? I know I must be doing something wrong, but > > the documentation on transactions doesn't make things too clear. > > Could you post a full backtrace? I don't have any real experience > with oracle, but your ruby code looks ok. Note that DB.transaction > yields a adapter-specific connection object, not a Database object. > > Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
