I'm migrating a java system, to work with 2 or more databases. I created the tables for firebird using hibernate without many problems. The second bank did not succeed. The SQL Server. Why do microsoft products have to be different?
Good ... My properties in persistence.xml
<property name="hibernate.connection.username" value="touchcomp"/>
<property name="hibernate.connection.driver_class" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="hibernate.connection.password" value="touch"/>
<property name="hibernate.connection.url" value="jdbc:sqlserver://localhost:1433/mentor?lc_ctype=ISO8859_1"/>
<property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
<property name="hibernate.ejb.cfgfile" value="hibernate.mentor.xml"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialec"/>
</properties>
My local.xml file
<?xml version="1.0" encoding="UTF-8"?>
<mentorLocal>
<url.database>jdbc:sqlserver://host:porta;databaseName=mentor</url.database>
<host>localhost</host>
<porta>1433</porta>
<url.database.cep>jdbc:sqlserver://host:porta/endereco</url.database.cep>
<url.database.log>jdbc:sqlserver://host:porta/log</url.database.log>
<url.database.nfe>jdbc:sqlserver://host:porta/nfe</url.database.nfe>
<generationStrategy>update</generationStrategy>
<versao.codigo>20030</versao.codigo>
<versao.sub.codigo>23</versao.sub.codigo>
<url.database.communicator>jdbc:sqlserver://host:porta/communicator</url.database.communicator>
In our system there is still a file called hibernate.mentor.xml, where this code snippet exists.
<hibernate-configuration>
<session-factory>
<property name="dialect">org.hibernate.dialect.SQLServerDialec</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="show_sql">true</property>
<property name="use_outer_join">false</property>
<property name="format_sql">false</property>
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="jilo">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="connection.username">touchcomp</property>
<property name="hibernate.connection.username">touchcomp</property>
<property name="connection.password">touch</property>
<property name="hibernate.connection.password">touch</property>
<property name="hibernate.current_session_context_class">thread</property>
When the application is run, it looks like Hibernate tries to create the tables but does not succeed. Follow the logs.
compile:
run:
13:01:11,441 ERROR [SchemaUpdate] HHH000388: Unsuccessful: create table ENVIAR_EMAIL (ID_ENVIAR_EMAIL numeric(19,0) identity not null, DATA_ATUALIZACAO datetime, DATA_CADASTRO datetime, DESCRICAO varchar(255), MODELO varchar(255), TITULO_EMAIL varchar(255), ID_EMPRESA numeric(19,0), primary key (ID_ENVIAR_EMAIL))
13:01:11,442 ERROR [SchemaUpdate] There is already an object named 'ENVIAR_EMAIL' in the database.
13:01:11,443 ERROR [SchemaUpdate] HHH000388: Unsuccessful: create table VALOR_FIC_TEC_OS_linha_prod (ID_VR_FIC_TEC_OS_linha_prod numeric(19,0) identity not null, CHAVE varchar(80), VALOR varchar(255), valor_obrigatorio smallint, ID_FIC_TEC_OS_LINHA_PROD numeric(19,0), primary key (ID_VR_FIC_TEC_OS_linha_prod))
13:01:11,444 ERROR [SchemaUpdate] There is already an object named 'VALOR_FIC_TEC_OS_linha_prod' in the database.
13:01:11,445 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table CTE add PESO_TOTAL_NFES double precision
13:01:11,445 ERROR [SchemaUpdate] Column names in each table must be unique. Column name 'PESO_TOTAL_NFES' in table 'CTE' is specified more than once.
13:01:11,447 ERROR [SchemaUpdate] HHH000388: Unsuccessful: create table OPCOES_CONT_FISCAL (ID_OPCOES_CONT_FISCAL numeric(19,0) identity not null, DATA_ATUALIZACAO datetime, ID_GRUPO_EMPRESA numeric(19,0), primary key (ID_OPCOES_CONT_FISCAL))
13:01:11,447 ERROR [SchemaUpdate] There is already an object named 'OPCOES_CONT_FISCAL' in the database.
13:01:11,448 ERROR [SchemaUpdate] HHH000388: Unsuccessful: create table OPCOES_CONT_GNRE (ID_OPCOES_CONT_GNRE numeric(19,0) identity not null, CONTABILIZAR int, ID_OPCOES_CONT_FISCAL numeric(19,0) not null, primary key (ID_OPCOES_CONT_GNRE))
13:01:11,448 ERROR [SchemaUpdate] There is already an object named 'OPCOES_CONT_GNRE' in the database.
13:01:11,449 ERROR [SchemaUpdate] HHH000388: Unsuccessful: create table OPCOES_CONT_GNRE_UF (ID_OPCOES_CONT_GNRE_UF numeric(19,0) identity not null, ID_OPCOES_CONT_GNRE numeric(19,0), ID_PLANO_CONTA numeric(19,0), ID_UF numeric(19,0), primary key (ID_OPCOES_CONT_GNRE_UF))
13:01:11,449 ERROR [SchemaUpdate] There is already an object named 'OPCOES_CONT_GNRE_UF' in the database.
13:01:11,450 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table PERIODO_AQ_FERIAS_COLAB add ID_COLABORADOR numeric(19,0)
13:01:11,450 ERROR [SchemaUpdate] Column names in each table must be unique. Column name 'ID_COLABORADOR' in table 'PERIODO_AQ_FERIAS_COLAB' is specified more than once.
13:01:11,451 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table RECISAO add NR_RECISO_RECISAO int
13:01:11,451 ERROR [SchemaUpdate] Column names in each table must be unique. Column name 'NR_RECISO_RECISAO' in table 'RECISAO' is specified more than once.
13:01:11,452 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table ENVIAR_EMAIL add constraint FK_o6ddbfugogw2kw6xm51gfgejk foreign key ( ID_EMPRESA ) references empresa
13:01:11,452 ERROR [SchemaUpdate] There is already an object named 'FK_o6ddbfugogw2kw6xm51gfgejk' in the database.
13:01:11,453 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table VALOR_FIC_TEC_OS_linha_prod add constraint FK_d5h6orp767hudqe565qtdbdaq foreign key (ID_FIC_TEC_OS_LINHA_PROD) references FICHA_TEC_OS_PROD_linha_prod
13:01:11,453 ERROR [SchemaUpdate] There is already an object named 'FK_d5h6orp767hudqe565qtdbdaq' in the database.
13:01:11,453 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table CLIENTE_CONVENIO_CP add constraint FK_saujos4icpcxiue84m2yu0euh foreign key (ID_CLIENTE_CUPOM) references OUTRO_DEVEDOR
13:01:11,453 ERROR [SchemaUpdate] There is already an object named 'FK_saujos4icpcxiue84m2yu0euh' in the database.
13:01:11,454 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table CLIENTE_CONVENIO_CP add constraint FK_tmjc47bxcpnp30tr9hbfaghog foreign key (ID_CONVENIO_CUPOM) references convenio_cliente_cupom
13:01:11,454 ERROR [SchemaUpdate] There is already an object named 'FK_tmjc47bxcpnp30tr9hbfaghog' in the database.
13:01:11,455 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table OPCOES_CONT_FISCAL add constraint FK_2qyc6r9u6ejkf7k44cbxn3w0v foreign key (ID_GRUPO_EMPRESA) references GRUPO_EMPRESA
13:01:11,455 ERROR [SchemaUpdate] There is already an object named 'FK_2qyc6r9u6ejkf7k44cbxn3w0v' in the database.
13:01:11,456 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table OPCOES_CONT_GNRE add constraint FK_7hwy1q0ebhlfdkoirq0vplvff foreign key (ID_OPCOES_CONT_FISCAL) references OPCOES_CONT_FISCAL
13:01:11,456 ERROR [SchemaUpdate] There is already an object named 'FK_7hwy1q0ebhlfdkoirq0vplvff' in the database.
13:01:11,456 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table OPCOES_CONT_GNRE_UF add constraint FK_gelbxxgvu2w2ms8515tbrs8sn foreign key (ID_OPCOES_CONT_GNRE) references OPCOES_CONT_GNRE
13:01:11,456 ERROR [SchemaUpdate] There is already an object named 'FK_gelbxxgvu2w2ms8515tbrs8sn' in the database.
13:01:11,457 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table OPCOES_CONT_GNRE_UF add constraint FK_kj6t0l4672j2814n0la0b6c3l foreign key (ID_PLANO_CONTA) references plano_conta
13:01:11,457 ERROR [SchemaUpdate] There is already an object named 'FK_kj6t0l4672j2814n0la0b6c3l' in the database.
13:01:11,458 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table OPCOES_CONT_GNRE_UF add constraint FK_4wbbvkssvf9981oki6on9rvfi foreign key (ID_UF) references uf
13:01:11,458 ERROR [SchemaUpdate] There is already an object named 'FK_4wbbvkssvf9981oki6on9rvfi' in the database.
13:01:11,458 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table PERIODO_AQ_FERIAS_COLAB add constraint FK_o72vkmiobehojsidiria0unrk foreign key ( ID_COLABORADOR) references COLABORADOR
13:01:11,458 ERROR [SchemaUpdate] There is already an object named 'FK_o72vkmiobehojsidiria0unrk' in the database.
13:01:11,459 ERROR [SchemaUpdate] HHH000388: Unsuccessful: alter table tokens_obs_int_fisco add constraint FK_j1pi1xggfsyjcw7or2qy8h2eh foreign key (id_obs_int_fisco) references OBSERVACAO_INT_FISCAL_NF_PR
13:01:11,459 ERROR [SchemaUpdate] There is already an object named 'FK_j1pi1xggfsyjcw7or2qy8h2eh' in the database.
Hibernate: select empresa0_.ID_EMP as ID_EMP1_840_, empresa0_.aliquota_icms_simples as aliquota2_840_, empresa0_.ativo as ativo3_840_, empresa0_.id_cnae as id_cnae18_840_, empresa0_.DATA_ATUALIZACAO as DATA_ATU4_840_, empresa0_.data_cadastro as data_cad5_840_, empresa0_.id_grupo_empresa as id_grup19_840_, empresa0_.incentivador_cultural as incentiv6_840_, empresa0_.indicador_apuracao_ipi as indicado7_840_, empresa0_.id_indicador_atividade as id_indi20_840_, empresa0_.INSC_ANTT as INSC_ANT8_840_, empresa0_.INSC_BANCO_CENTRAL as INSC_BAN9_840_, empresa0_.INSC_CVM as INSC_CV10_840_, empresa0_.INSC_JUNTA_COMERCIAL as INSC_JU11_840_, empresa0_.INSC_SUSEP as INSC_SU12_840_, empresa0_.lancar_cto_custo_entrada as lancar_13_840_, empresa0_.logo_boleto as logo_bo14_840_, empresa0_.logo_relatorios as logo_re15_840_, empresa0_.MATRIZ as MATRIZ16_840_, empresa0_.ID_PERFIL_SPED_FISCAL as ID_PERF21_840_, empresa0_.permitir_estoque_negativo as permiti17_840_, empresa0_.ID_PESSOA as ID_PESS22_840_, empresa0_.id_proxy_email as id_prox23_840_, empresa0_.id_proxy_http as id_prox24_840_, empresa0_.id_regime_tributario as id_regi25_840_, empresa0_.TIPO_EMPRESA as TIPO_EM26_840_ from empresa empresa0_ cross join PESSOA pessoa1_ where empresa0_.ID_PESSOA=pessoa1_.ID_PESSOA and empresa0_.ativo=? and pessoa1_.ativo=? order by empresa0_.MATRIZ desc, pessoa1_.NOME asc
Hibernate: select this_.ID_config_log_usuarios as ID_confi1_775_15_, this_.data_atualizacao as data_atu2_775_15_, this_.id_empresa as id_empre6_775_15_, this_.gerar_log_delete as gerar_lo3_775_15_, this_.gerar_log_editar as gerar_lo4_775_15_, this_.gerar_log_insert as gerar_lo5_775_15_, conflogcla2_.id_conf_log_usuarios as id_conf_4_775_17_, conflogcla2_.ID_config_log_usuarios_clas as ID_confi1_776_17_, conflogcla2_.ID_config_log_usuarios_clas as ID_confi1_776_0_, conflogcla2_.classe as classe2_776_0_, conflogcla2_.id_conf_log_usuarios as id_conf_4_776_0_, conflogcla2_.descricao as descrica3_776_0_, empresa3_.ID_EMP as ID_EMP1_840_1_, empresa3_.aliquota_icms_simples as aliquota2_840_1_, empresa3_.ativo as ativo3_840_1_, empresa3_.id_cnae as id_cnae18_840_1_, empresa3_.DATA_ATUALIZACAO as DATA_ATU4_840_1_, empresa3_.data_cadastro as data_cad5_840_1_, empresa3_.id_grupo_empresa as id_grup19_840_1_, empresa3_.incentivador_cultural as incentiv6_840_1_, empresa3_.indicador_apuracao_ipi as indicado7_840_1_, empresa3_.id_indicador_atividade as id_indi20_840_1_, empresa3_.INSC_ANTT as INSC_ANT8_840_1_, empresa3_.INSC_BANCO_CENTRAL as INSC_BAN9_840_1_, empresa3_.INSC_CVM as INSC_CV10_840_1_, empresa3_.INSC_JUNTA_COMERCIAL as INSC_JU11_840_1_, empresa3_.INSC_SUSEP as INSC_SU12_840_1_, empresa3_.lancar_cto_custo_entrada as lancar_13_840_1_, empresa3_.logo_boleto as logo_bo14_840_1_, empresa3_.logo_relatorios as logo_re15_840_1_, empresa3_.MATRIZ as MATRIZ16_840_1_, empresa3_.ID_PERFIL_SPED_FISCAL as ID_PERF21_840_1_, empresa3_.permitir_estoque_negativo as permiti17_840_1_, empresa3_.ID_PESSOA as ID_PESS22_840_1_, empresa3_.id_proxy_email as id_prox23_840_1_, empresa3_.id_proxy_http as id_prox24_840_1_, empresa3_.id_regime_tributario as id_regi25_840_1_, empresa3_.TIPO_EMPRESA as TIPO_EM26_840_1_, cnae4_.ID_cnae as ID_cnae1_756_2_, cnae4_.codigo as codigo2_756_2_, cnae4_.descricao as descrica3_756_2_, perfilsped5_.ID_PERFIL_SPED_FISCAL as ID_PERFI1_517_3_, perfilsped5_.CODIGO as CODIGO2_517_3_, perfilsped5_.DESCRICAO as DESCRICA3_517_3_, pessoa6_.ID_PESSOA as ID_PESSO1_524_4_, pessoa6_.ativo as ativo2_524_4_, pessoa6_.id_complemento as id_compl9_524_4_, pessoa6_.data_atualizacao as data_atu3_524_4_, pessoa6_.DATA_CADASTRO as DATA_CAD4_524_4_, pessoa6_.DATA_INICIO_RELACIONAMENTO as DATA_INI5_524_4_, pessoa6_.ID_ENDERECO as ID_ENDE10_524_4_, pessoa6_.id_grupo_pessoas as id_grup11_524_4_, pessoa6_.NOME as NOME6_524_4_, pessoa6_.NOME_FANTASIA as NOME_FAN7_524_4_, pessoa6_.PESSOA_CONTATO as PESSOA_C8_524_4_, complement7_.id_complemento as id_compl1_99_5_, complement7_.ativo as ativo2_99_5_, complement7_.cel1 as cel3_99_5_, complement7_.cel2 as cel4_99_5_, complement7_.cnpj as cnpj5_99_5_, complement7_.CODIGO_IMA as CODIGO_I6_99_5_, complement7_.data_atualizacao as data_atu7_99_5_, complement7_.DATA_EMISSAO_RG as DATA_EMI8_99_5_, complement7_.data_nascimento as data_nas9_99_5_, complement7_.DATA_VALIDADE_IMA as DATA_VA10_99_5_, complement7_.fax1 as fax11_99_5_, complement7_.fax2 as fax12_99_5_, complement7_.fone1 as fone13_99_5_, complement7_.fone2 as fone14_99_5_, complement7_.habilitar_suframa as habilit15_99_5_, complement7_.inscricao_estadual as inscric16_99_5_, complement7_.inscricao_estadual_ST as inscric17_99_5_, complement7_.inscricao_municipal as inscric18_99_5_, complement7_.nit as nit19_99_5_, complement7_.orgao_emissor as orgao_e20_99_5_, complement7_.rg as rg21_99_5_, complement7_.site as site22_99_5_, complement7_.suframa as suframa23_99_5_, endereco8_.ID_ENDERECO as ID_ENDER1_844_6_, endereco8_.BAIRRO as BAIRRO2_844_6_, endereco8_.CEP as CEP3_844_6_, endereco8_.id_cidade as id_cidad7_844_6_, endereco8_.COMPLEMENTO as COMPLEME4_844_6_, endereco8_.LOGRADOURO as LOGRADOU5_844_6_, endereco8_.NUMERO as NUMERO6_844_6_, cidade9_.ID_CIDADE as ID_CIDAD1_85_7_, cidade9_.cep as cep2_85_7_, cidade9_.cod_ibge as cod_ibge3_85_7_, cidade9_.data_atualizacao as data_atu4_85_7_, cidade9_.DATA_CADASTRO as DATA_CAD5_85_7_, cidade9_.descricao as descrica6_85_7_, cidade9_.ID_UF as ID_UF7_85_7_, unidadefed10_.id_uf as id_uf1_1193_8_, unidadefed10_.cod_ibge as cod_ibge2_1193_8_, unidadefed10_.data_atualizacao as data_atu3_1193_8_, unidadefed10_.data_cadastro as data_cad4_1193_8_, unidadefed10_.descricao as descrica5_1193_8_, unidadefed10_.inscricao_estadual as inscrica6_1193_8_, unidadefed10_.inscrito_estado as inscrito7_1193_8_, unidadefed10_.ID_PAIS as ID_PAIS9_1193_8_, unidadefed10_.sigla as sigla8_1193_8_, pais11_.ID_PAIS as ID_PAIS1_508_9_, pais11_.cod_pais as cod_pais2_508_9_, pais11_.data_atualizacao as data_atu3_508_9_, pais11_.DATA_CADASTRO as DATA_CAD4_508_9_, pais11_.descricao as descrica5_508_9_, grupopesso12_.ID_GRUPO_PESSOA as ID_GRUPO1_263_10_, grupopesso12_.data_atualizacao as data_atu2_263_10_, grupopesso12_.data_cadastro as data_cad3_263_10_, grupopesso12_.id_empresa as id_empre5_263_10_, grupopesso12_.nome_grupo as nome_gru4_263_10_, empresa13_.ID_EMP as ID_EMP1_840_11_, empresa13_.aliquota_icms_simples as aliquota2_840_11_, empresa13_.ativo as ativo3_840_11_, empresa13_.id_cnae as id_cnae18_840_11_, empresa13_.DATA_ATUALIZACAO as DATA_ATU4_840_11_, empresa13_.data_cadastro as data_cad5_840_11_, empresa13_.id_grupo_empresa as id_grup19_840_11_, empresa13_.incentivador_cultural as incentiv6_840_11_, empresa13_.indicador_apuracao_ipi as indicado7_840_11_, empresa13_.id_indicador_atividade as id_indi20_840_11_, empresa13_.INSC_ANTT as INSC_ANT8_840_11_, empresa13_.INSC_BANCO_CENTRAL as INSC_BAN9_840_11_, empresa13_.INSC_CVM as INSC_CV10_840_11_, empresa13_.INSC_JUNTA_COMERCIAL as INSC_JU11_840_11_, empresa13_.INSC_SUSEP as INSC_SU12_840_11_, empresa13_.lancar_cto_custo_entrada as lancar_13_840_11_, empresa13_.logo_boleto as logo_bo14_840_11_, empresa13_.logo_relatorios as logo_re15_840_11_, empresa13_.MATRIZ as MATRIZ16_840_11_, empresa13_.ID_PERFIL_SPED_FISCAL as ID_PERF21_840_11_, empresa13_.permitir_estoque_negativo as permiti17_840_11_, empresa13_.ID_PESSOA as ID_PESS22_840_11_, empresa13_.id_proxy_email as id_prox23_840_11_, empresa13_.id_proxy_http as id_prox24_840_11_, empresa13_.id_regime_tributario as id_regi25_840_11_, empresa13_.TIPO_EMPRESA as TIPO_EM26_840_11_, proxy14_.ID_PROXY as ID_PROXY1_558_12_, proxy14_.HOST as HOST2_558_12_, proxy14_.PORT as PORT3_558_12_, proxy14_.REQUER_AUTENTICACAO as REQUER_A4_558_12_, proxy14_.SENHA as SENHA5_558_12_, proxy14_.TIPO_PROXY as TIPO_PRO6_558_12_, proxy14_.USUARIO as USUARIO7_558_12_, proxy15_.ID_PROXY as ID_PROXY1_558_13_, proxy15_.HOST as HOST2_558_13_, proxy15_.PORT as PORT3_558_13_, proxy15_.REQUER_AUTENTICACAO as REQUER_A4_558_13_, proxy15_.SENHA as SENHA5_558_13_, proxy15_.TIPO_PROXY as TIPO_PRO6_558_13_, proxy15_.USUARIO as USUARIO7_558_13_, regimetrib16_.ID_REGIME_TRIBUTARIO as ID_REGIM1_1109_14_, regimetrib16_.CODIGO as CODIGO2_1109_14_, regimetrib16_.descricao as descrica3_1109_14_ from config_log_usuarios this_ left outer join config_log_usuarios_clas conflogcla2_ on this_.ID_config_log_usuarios=conflogcla2_.id_conf_log_usuarios left outer join empresa empresa3_ on this_.id_empresa=empresa3_.ID_EMP left outer join cnae cnae4_ on empresa3_.id_cnae=cnae4_.ID_cnae left outer join PERFIL_SPED_FISCAL perfilsped5_ on empresa3_.ID_PERFIL_SPED_FISCAL=perfilsped5_.ID_PERFIL_SPED_FISCAL left outer join PESSOA pessoa6_ on empresa3_.ID_PESSOA=pessoa6_.ID_PESSOA left outer join COMPLEMENTO complement7_ on pessoa6_.id_complemento=complement7_.id_complemento left outer join endereco endereco8_ on pessoa6_.ID_ENDERECO=endereco8_.ID_ENDERECO left outer join CIDADE cidade9_ on endereco8_.id_cidade=cidade9_.ID_CIDADE left outer join uf unidadefed10_ on cidade9_.ID_UF=unidadefed10_.id_uf left outer join PAIS pais11_ on unidadefed10_.ID_PAIS=pais11_.ID_PAIS left outer join GRUPO_pessoas grupopesso12_ on pessoa6_.id_grupo_pessoas=grupopesso12_.ID_GRUPO_PESSOA left outer join empresa empresa13_ on grupopesso12_.id_empresa=empresa13_.ID_EMP left outer join PROXY proxy14_ on empresa13_.id_proxy_email=proxy14_.ID_PROXY left outer join PROXY proxy15_ on empresa13_.id_proxy_http=proxy15_.ID_PROXY left outer join regime_tributario regimetrib16_ on empresa13_.id_regime_tributario=regimetrib16_.ID_REGIME_TRIBUTARIO where this_.id_empresa=?
0