search for: preparestatement

I''m getting the following error while connecting to mysql using activerecord-jdbcmysql-adapter (1.0.2). Rails 3.0.1. ActiveRecord::JDBCError: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().: SET SQL_AUTO_IS_NULL=0 This occurs not matter what application I run it in to e.g. rake, rails console, or from my app. Here''s the trace while running it from rake: jruby -S rake db:schema:dump --trace (in /Users/MJW/Sites/test_app) ** Invoke db:schema:dump (first_time) ** Invoke en...

Hi, I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 server with little success. Has anyone been able to do this? If so, what issues did you have to overcome to get this to work? Also, is this a combination that you would recommend for a production site, or is it all too new and untested? The latest issue I''m stuck on right now is with the mysql-connector-

dose Ruby or ActiveRecord have the Java/JDBC equivalent for retrieving ResultSet meta data... PreparedStatement statement = null; try { statement = connection.prepareStatement("select * from some_table"); ResultSet rs = null; try { rs = statement.executeQuery(); ResultSetMetaData rsMetaData = rs.getMetaData(); int columnCount = rsMetaData.getColumnCount(); more stuff... -- Posted via http://www.ruby-forum.com/.

I searched the archives and found a thread about it, but I didn''t understand: are prepared statement used by ActiveRecord on those databases that could handle them (Postgresql, Mysql, Oracle etc)? In case they are not used, are they planned? Is there a roadmap about Rails I can find somewhere?