sqlite error ActiveRecord::ActiveRecordError: statement is not executing:
SELECT * FROM widgets on tomcat5
----------------------------------------------------------------------------------------------------------
Key: JRUBY-3553
URL: http://jira.codehaus.org/browse/JRUBY-3553
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Affects Versions: ActiveRecord-JDBC-0.9.1
Environment: linux fedora 10 kernel 2.6.27.21-170
jruby 1.1.5
ruby 1.8.6 (2008-08-11 patchlevel 287) [i386-linux]
activerecord (2.3.2)
activerecord-jdbc-adapter (0.9.1)
activerecord-jdbcmysql-adapter (0.9.1)
activerecord-jdbcsqlite3-adapter (0.9.1)
rails 2.3.2
Apache Tomcat/5.5.27
JVM 1.6.0_0-b14
warbler (0.9.12)
Reporter: Bruno Gardin
Setting a very simple projects with one table and one field with jruby on
rails. I apply all the tricks to get the session logged in the db
Everything works fine when launching my application with webrick
Now using warble to create a war file and deploy it on tomcat5 i got the
following error (top of the stack). It works fine with mysql and it worked fine
with my previous versions (but i can't remember all the components versions as
i did a lot of tests).
ActiveRecord::ActiveRecordError: statement is not executing: SELECT * FROM
widgets
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract_adapter.rb:212:in
`log'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in
`select_all_with_query_cache'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in
`cache_sql'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in
`select_all_with_query_cache'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/base.rb:661:in
`find_by_sql'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/base.rb:1553:in
`find_every'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/base.rb:615:in
`find'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/base.rb:635:in
`all'
/var/lib/tomcat5/webapps/runner/WEB-INF/app/controllers/widgets_controller.rb:5:in
`index'
The statement is very basic, the database has 2 records. If i try a new
commands i got the stack:
statement is not executing
/usr/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/jdbc_adapter/jdbc_sqlite3.rb:280:in
`columns'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/base.rb:1276:in
`columns'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/base.rb:3008:in
`attributes_from_column_definition'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/locking/optimistic.rb:66:in
`attributes_from_column_definition_with_lock'
/usr/share/tomcat5/webapps/runner/WEB-INF/gems/gems/activerecord-2.3.2/lib/active_record/base.rb:2435:in
`initialize'
/var/lib/tomcat5/webapps/runner/WEB-INF/app/controllers/widgets_controller.rb:27:in
`new'
There should be an obvious reason but i am stuck on trying to debug this.
If someone can help me it will be welcome as my previous applications are all
failing the same way.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
