search

softace / activerecord-tableless

Bringing together the different tableless model implementations into a single gem/plugin
Other
113 stars 41 forks source link

ActiveRecord::JDBCError: Table 'xxxxxx' doesn't exist: SHOW FIELDS FROM #1

Open ffabreti opened 11 years ago

ffabreti commented 11 years ago

Using tableless to create a model that searchs and union other models.

My tableless model works, but it keeps giving this message: ActiveRecord::JDBCError: Table 'xxxxxx' doesn't exist: SHOW FIELDS FROM I'm clueless!

My setup: Gemfile: gem 'rails', '3.2.8' gem 'activerecord-jdbcmysql-adapter' gem 'jruby-openssl' group :assets do gem 'sass-rails', '~> 3.2.3' gem 'coffee-rails', '~> 3.2.1' gem 'uglifier', '>= 1.0.3' end gem 'jquery-rails' gem 'i18n', '>= 0.6.1' gem 'brdinheiro', '>=3.3.0' gem 'brcpfcnpj', '>=3.3.0' gem 'composite_primary_keys' gem 'trinidad' gem 'authlogic' gem 'adauth' gem 'delayed_job_active_record' gem 'will_paginate' gem "activerecord-tableless", "~> 1.0.1"

Model 

class Vinc_mov_mix < ActiveRecord::Base
has_no_table
column :estab_id, :integer
column :vinc_id,  :integer
column :caged_id, :integer
column :nome, :varchar
column :pis, :varchar


has_one :vinculo,   :primary_key => :vinc_id, :foreign_key => :CN_NUMERO_SEQ
has_one :estab,     :primary_key => :estab_id, :foreign_key => :CN_NUMERO_SEQ
has_one :caged_trab,:primary_key => :caged_id, :foreign_key => :id:
VINC_TABLE  = '' + Vinculo.table_name   + ''
CAGED_TABLE = '' + CagedTrab.table_name + ''
ESTAB_TABLE = '' + Estab.table_name     + ''
PAGE_SIZE = 50


def self.search(estabs_ids, criterios={}, page=0)  #page=offset


 estabs_ids = estabs_ids.to_a
 page -= 1; page = 0 if page < 0  

 clauses = where_clauses(criterios)

 if estabs_ids.present?
    clauses[:vincs_clauses]  = ["#{ESTAB_TABLE}.cn_numero_seq IN (#{estabs_ids.join(',')})"] + clauses[:vincs_clauses]
    clauses[:cageds_clauses] = ["#{ESTAB_TABLE}.cn_numero_seq IN (#{estabs_ids.join(',')})"] + clauses[:cageds_clauses]
 end

 self.find_by_sql(
     "SELECT #{ESTAB_TABLE}.cn_numero_seq as estab_id, #{VINC_TABLE}.cn_numero_seq as vinc_id,  null as caged_id, #{VINC_TABLE}.no_partic_rais as nome, #{VINC_TABLE}.co_pis as pis
     from #{ESTAB_TABLE}
     join #{VINC_TABLE}  on  #{ESTAB_TABLE}.co_cnpj_cei = #{VINC_TABLE}.co_cnpj_cei
     where #{clauses[:vincs_clauses].join(' AND ')}
     UNION ALL
     SELECT #{ESTAB_TABLE}.cn_numero_seq as estab_id, null as vinc_id, #{CAGED_TABLE}.id as caged_id,  #{CAGED_TABLE}.nomeTrab as nome, #{CAGED_TABLE}.pis as pis
     from #{ESTAB_TABLE}
     join #{CAGED_TABLE}  ON #{ESTAB_TABLE}.co_cnpj_cei = #{CAGED_TABLE}.identificadorEstab
     where #{clauses[:cageds_clauses].join(' AND ')}
     order by nome
     limit #{page * PAGE_SIZE}, #{PAGE_SIZE}"    #limit <offset> <count>
 )


end

jarl-dk commented 11 years ago

I'll take a look at it...

jarl-dk commented 11 years ago

Does it work with JDBC when you are not using sql "that searchs and union other models"? Does it work when you are using sql "that searchs and union other models" but not JDBC?

ffabreti commented 11 years ago

@jarl-dk, No, it doesn't work when not using sql that union other models. The main reason I've made this tableless model is for putting all sql related to mixed models queries.

I've made ths: self.find_by_sql( "SELECT #{ESTAB_TABLE}.cn_numero_seq as estab_id, #{VINC_TABLE}.cn_numero_seq as vinc_id, null as caged_id, #{VINC_TABLE}.no_partic_rais as nome, #{VINC_TABLE}.co_pis as pis from #{ESTAB_TABLE} join #{VINC_TABLE} on #{ESTAB_TABLE}.co_cnpj_cei = #{VINC_TABLE}.co_cnpj_cei where #{clauses[:vincs_clauses].join(' AND ')} " ) And it still gives me: ActiveRecord::JDBCError: Table 'rais2011.vinc_mov_mixes' doesn't exist: SHOW FIELDS FROM vinc_mov_mixes but the query completes sucessfully.

I don't have a set up with non JDBC connectors.

ffabreti commented 11 years ago

Here are the logs of one request:

Started GET "/rais/estabs/pesquisa?criCBO=214915%2C322230&criFamiliaCBO=on&estabs_ids%5B%5D=12628483&estabs_ids%5B%5D=12628484&estabs_ids%5B%5D=12628485&estabs_ids%5B%5D=12628486&page=25&utf8=%E2%9C%93" for 127.0.0.1 at 2012-10-25 11:22:04 -0200
   (0.0ms)  SET SQL_AUTO_IS_NULL=0
Processing by EstabsController#pesquisa as HTML
  Parameters: {"criCBO"=>"214915,322230", "criFamiliaCBO"=>"on", "estabs_ids"=>["12628483", "12628484", "12628485", "12628486"], "page"=>"25", "utf8"=>"✓"}
  User Load (7.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1
   (1.0ms)  UPDATE `users` SET `last_request_at` = '2012-10-25 13:22:05', `updated_at` = '2012-10-25 13:22:05' WHERE `users`.`id` = 1
   (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CN_NUMERO_SEQ in ('12628483','12628484','12628485','12628486'))) subquery_for_count 
  Vinc_mov_mix Load (2.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq as estab_id, `tblEmpregados`.cn_numero_seq as vinc_id, null as caged_id, `tblEmpregados`.no_partic_rais as nome, `tblEmpregados`.co_pis as pis
 from `tblEmpresasPOSITIVAS_LEFTJOINCnae`
 join `tblEmpregados` on `tblEmpresasPOSITIVAS_LEFTJOINCnae`.co_cnpj_cei = `tblEmpregados`.co_cnpj_cei
 where `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq IN (12628483,12628484,12628485,12628486) AND `tblEmpregados`.CO_CBO_RAIS regexp '^2149|^3222'
 UNION ALL
 SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq as estab_id, null as vinc_id, `tblCAGEDTrab`.id as caged_id, `tblCAGEDTrab`.nomeTrab as nome, `tblCAGEDTrab`.pis as pis
 from `tblEmpresasPOSITIVAS_LEFTJOINCnae`
 join `tblCAGEDTrab` ON `tblEmpresasPOSITIVAS_LEFTJOINCnae`.co_cnpj_cei = `tblCAGEDTrab`.identificadorEstab
 where `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq IN (12628483,12628484,12628485,12628486) AND `tblCAGEDTrab`.cbo2002ocup regexp '^2149|^3222'
 ORDER BY nome LIMIT 50 OFFSET 1200
ActiveRecord::JDBCError: Table 'rais2011.vinc_mov_mixes' doesn't exist: SHOW FIELDS FROM `vinc_mov_mixes`
  Vinc_mov_mix Count (0.0ms)  SELECT COUNT(*) FROM (SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq as estab_id, `tblEmpregados`.cn_numero_seq as vinc_id, null as caged_id, `tblEmpregados`.no_partic_rais as nome, `tblEmpregados`.co_pis as pis
 from `tblEmpresasPOSITIVAS_LEFTJOINCnae`
 join `tblEmpregados` on `tblEmpresasPOSITIVAS_LEFTJOINCnae`.co_cnpj_cei = `tblEmpregados`.co_cnpj_cei
 where `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq IN (12628483,12628484,12628485,12628486) AND `tblEmpregados`.CO_CBO_RAIS regexp '^2149|^3222'
 UNION ALL
 SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq as estab_id, null as vinc_id, `tblCAGEDTrab`.id as caged_id, `tblCAGEDTrab`.nomeTrab as nome, `tblCAGEDTrab`.pis as pis
 from `tblEmpresasPOSITIVAS_LEFTJOINCnae`
 join `tblCAGEDTrab` ON `tblEmpresasPOSITIVAS_LEFTJOINCnae`.co_cnpj_cei = `tblCAGEDTrab`.identificadorEstab
 where `tblEmpresasPOSITIVAS_LEFTJOINCnae`.cn_numero_seq IN (12628483,12628484,12628485,12628486) AND `tblCAGEDTrab`.cbo2002ocup regexp '^2149|^3222'
 ) AS count_table
  Vinculo Load (35.0ms)  SELECT `tblEmpregados`.* FROM `tblEmpregados` WHERE `tblEmpregados`.`CN_NUMERO_SEQ` IN (57511841, 57513002, 57510678, 57509965, 57511266, 57509835, 57509828, 57512359, 57510011, 57513763, 57512692, 57513004, 57510461, 57510499, 57511110, 57509994, 57511982, 57512277, 57511044, 57512958, 57512609, 57511210, 57511643, 57511311, 57513770, 57511665, 57513457, 57511438, 57512513, 57510878, 57511957, 57512378, 57511226, 57510598, 57513676, 57512172, 57511248, 57513368, 57512501, 57513606, 57510457, 57511016, 57509876)
  CagedTrab Load (3.0ms)  SELECT `tblCAGEDTrab`.* FROM `tblCAGEDTrab` WHERE `tblCAGEDTrab`.`id` IN (9042430, 2393494, 20199411, 9042405, 9042429, 9042424, 9041143)
   (0.0ms)  SELECT CO_CNPJ_CEI FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CN_NUMERO_SEQ in ('12628483','12628484','12628485','12628486')) ORDER BY CO_CNPJ_CEI ASC
   (0.0ms)  SELECT CO_CEI_VINCULADO FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CN_NUMERO_SEQ in ('12628483','12628484','12628485','12628486')) ORDER BY CO_CNPJ_CEI ASC
  Estab Load (2.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
DEPRECATION WARNING: Calling set_table_name is deprecated. Please use `self.table_name = 'the_name'` instead. (called from Cbo at /home/fernando/RubymineProjects/rais328/app/models/cbo.rb:3)
DEPRECATION WARNING: Calling set_primary_key is deprecated. Please use `self.primary_key = 'the_name'` instead. (called from Cbo at /home/fernando/RubymineProjects/rais328/app/models/cbo.rb:4)
  Cbo Load (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
   (1.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129')) subquery_for_count 
  Estab Load (2.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129') ORDER BY CO_CNPJ_CEI DESC LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (1.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  Cbo Load (1.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (1.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129')) subquery_for_count 
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129') ORDER BY CO_CNPJ_CEI DESC LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (1.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129')) subquery_for_count 
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129') ORDER BY CO_CNPJ_CEI DESC LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129')) subquery_for_count 
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129') ORDER BY CO_CNPJ_CEI DESC LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129')) subquery_for_count 
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129') ORDER BY CO_CNPJ_CEI DESC LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129')) subquery_for_count 
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129') ORDER BY CO_CNPJ_CEI DESC LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129')) subquery_for_count 
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CO_CNPJ_CEI = '60003761000129') ORDER BY CO_CNPJ_CEI DESC LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (1.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322205' LIMIT 1
  CACHE (0.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (`tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CNPJ_CEI` = '60003761000129' AND `tblEmpresasPOSITIVAS_LEFTJOINCnae`.`CO_CEI_VINCULADO` = '000000000000') LIMIT 1
  CACHE (0.0ms)  SELECT `tblCBO_ocupacoes`.* FROM `tblCBO_ocupacoes` WHERE `tblCBO_ocupacoes`.`codigo` = '322230' LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CN_NUMERO_SEQ in ('12628483','12628484','12628485','12628486'))) subquery_for_count 
  Estab Load (3.0ms)  SELECT `tblEmpresasPOSITIVAS_LEFTJOINCnae`.* FROM `tblEmpresasPOSITIVAS_LEFTJOINCnae` WHERE (CN_NUMERO_SEQ in ('12628483','12628484','12628485','12628486')) ORDER BY CO_CNPJ_CEI ASC
  Municipio Load (1.0ms)  SELECT `tblMunicipiosIBGE`.* FROM `tblMunicipiosIBGE` WHERE `tblMunicipiosIBGE`.`CD_UF_MUNIC` = 3549805 LIMIT 1
  CnaeRais Load (0.0ms)  SELECT `tblCNAEGR`.* FROM `tblCNAEGR` WHERE `tblCNAEGR`.`subclasse` = '8610101' LIMIT 1
  CACHE (0.0ms)  SELECT `tblMunicipiosIBGE`.* FROM `tblMunicipiosIBGE` WHERE `tblMunicipiosIBGE`.`CD_UF_MUNIC` = 3549805 LIMIT 1
  CnaeRais Load (0.0ms)  SELECT `tblCNAEGR`.* FROM `tblCNAEGR` WHERE `tblCNAEGR`.`subclasse` = '8640212' LIMIT 1
  CACHE (0.0ms)  SELECT `tblMunicipiosIBGE`.* FROM `tblMunicipiosIBGE` WHERE `tblMunicipiosIBGE`.`CD_UF_MUNIC` = 3549805 LIMIT 1
  CnaeRais Load (0.0ms)  SELECT `tblCNAEGR`.* FROM `tblCNAEGR` WHERE `tblCNAEGR`.`subclasse` = '8640214' LIMIT 1
  CACHE (0.0ms)  SELECT `tblMunicipiosIBGE`.* FROM `tblMunicipiosIBGE` WHERE `tblMunicipiosIBGE`.`CD_UF_MUNIC` = 3549805 LIMIT 1
  CACHE (0.0ms)  SELECT `tblCNAEGR`.* FROM `tblCNAEGR` WHERE `tblCNAEGR`.`subclasse` = '8610101' LIMIT 1
  CagedTrab Load (2.0ms)  SELECT `tblCAGEDTrab`.* FROM `tblCAGEDTrab` ORDER BY competDecl ASC LIMIT 1
  CagedTrab Load (1.0ms)  SELECT `tblCAGEDTrab`.* FROM `tblCAGEDTrab` ORDER BY competDecl DESC LIMIT 1
  Rendered estabs/pesquisa.html.erb within layouts/application (1063.0ms)
Completed 200 OK in 5091ms (Views: 1200.0ms | ActiveRecord: 122.0ms)
jarl-dk commented 11 years ago

So it seems related to JDBC...

jarl-dk commented 11 years ago

I categorise this as an enhancement because it is actually about support for jruby/JDBC