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

[ffabreti]

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]

I'll take a look at it...

[jarl-dk]

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]

@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]

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]

So it seems related to JDBC...

[jarl-dk]

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