-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
caetano
 Post subject: Transaction workind in Oracle and different in Mysql
PostPosted: Fri Oct 01, 2004 1:48 pm 
Newbie

Joined: Fri Oct 01, 2004 1:29 pm
Posts: 5
Location: Brasil
Hi all,

I'm using Hibernate 2.1.6 with Spring 1.1 and I'm with the following problem:

When executing a UnitTest with datasource Oracle, the session does not
persist the data, however, when executing the same test in the Mysql,
the data is correctly persisted for the database..

The only different thing is the configuration of data base in the file hibernate.properties.

The only think's in hibernate.properties are de JDBC/Cache confs...
The DAO's implement the HibernateDaoSupport of Spring and use getHibernateTemplate() to perform actions...

Somebody could help me? I'm sending below logs and configurations to assist.


Spring AppContext:
Code:
    <bean id="myNamingStrategy"
        class="br.com.csn.suporte.util.hibernate.SUPNamingStrategy"/>
    <!-- Hibernate SessionFactory -->
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
        <property name="configLocation">
            <value>hibernate.cfg.xml</value>
        </property>
        <property name="namingStrategy">
            <ref local="myNamingStrategy"/>
        </property>
    </bean>
   
    <!-- Transaction manager for a single Hibernate SessionFactory -->
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate.HibernateTransactionManager">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
   
    <!-- DAOs -->
    <bean id="anexoDao" class="br.com.csn.suporte.dao.hibernate.AnexoDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="categoriaDao" class="br.com.csn.suporte.dao.hibernate.CategoriaDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="chamadoDao" class="br.com.csn.suporte.dao.hibernate.ChamadoDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="clienteDao" class="br.com.csn.suporte.dao.hibernate.ClienteDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="colaboradorDao" class="br.com.csn.suporte.dao.hibernate.ColaboradorDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="componenteDao" class="br.com.csn.suporte.dao.hibernate.ComponenteDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="discriminadorDao" class="br.com.csn.suporte.dao.hibernate.DiscriminadorDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="historicoDao" class="br.com.csn.suporte.dao.hibernate.HistoricoDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="organizacaoDao" class="br.com.csn.suporte.dao.hibernate.OrganizacaoDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="pessoaFisicaDao" class="br.com.csn.suporte.dao.hibernate.PessoaFisicaDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="pessoaJuridicaDao" class="br.com.csn.suporte.dao.hibernate.PessoaJuridicaDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    <bean id="projetoDao" class="br.com.csn.suporte.dao.hibernate.ProjetoDaoImpl">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>


Hibernate Config:
Code:
<hibernate-configuration>
   <session-factory>
      <!-- Mapping files. -->
        <mapping resource="br/com/csn/suporte/model/PessoaFisica.hbm.xml"/>
        <mapping resource="br/com/csn/suporte/model/PessoaJuridica.hbm.xml"/>
      <mapping resource="br/com/csn/suporte/model/Categoria.hbm.xml"/>
        <mapping resource="br/com/csn/suporte/model/Projeto.hbm.xml"/>
        <mapping resource="br/com/csn/suporte/model/Componente.hbm.xml"/>
        <mapping resource="br/com/csn/suporte/model/Anexo.hbm.xml"/>
        <mapping resource="br/com/csn/suporte/model/Historico.hbm.xml"/>
        <mapping resource="br/com/csn/suporte/model/Chamado.hbm.xml"/>
        <mapping resource="br/com/csn/suporte/model/Discriminador.hbm.xml"/>
   </session-factory>
</hibernate-configuration>


My log file:
Code:
2004-10-01 17:22:53,729 INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] - Loading XML bean definitions from class path resource [applicationContext.xml]
2004-10-01 17:22:54,010 INFO [org.springframework.context.support.ClassPathXmlApplicationContext] - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=31278839]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [myNamingStrategy,sessionFactory,transactionManager,anexoDao,categoriaDao,chamadoDao,clienteDao,colaboradorDao,componenteDao,discriminadorDao,historicoDao,organizacaoDao,pessoaFisicaDao,pessoaJuridicaDao,projetoDao]; Root of BeanFactory hierarchy
2004-10-01 17:22:54,026 INFO [org.springframework.context.support.ClassPathXmlApplicationContext] - 15 beans defined in ApplicationContext [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=31278839]
2004-10-01 17:22:54,072 INFO [org.springframework.context.support.ClassPathXmlApplicationContext] - No MessageSource found for context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=31278839]: using empty default
2004-10-01 17:22:54,088 INFO [org.springframework.context.support.ClassPathXmlApplicationContext] - No ApplicationEventMulticaster found for context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=31278839]: using default
2004-10-01 17:22:54,088 INFO [org.springframework.context.support.ClassPathXmlApplicationContext] - Refreshing listeners
2004-10-01 17:22:54,088 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [myNamingStrategy,sessionFactory,transactionManager,anexoDao,categoriaDao,chamadoDao,clienteDao,colaboradorDao,componenteDao,discriminadorDao,historicoDao,organizacaoDao,pessoaFisicaDao,pessoaJuridicaDao,projetoDao]; Root of BeanFactory hierarchy]
2004-10-01 17:22:54,088 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'myNamingStrategy'
2004-10-01 17:22:54,166 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'sessionFactory'
2004-10-01 17:22:54,229 INFO [net.sf.hibernate.cfg.Environment] - Hibernate 2.1.6
2004-10-01 17:22:54,244 INFO [net.sf.hibernate.cfg.Environment] - loaded properties from resource hibernate.properties: {hibernate.cache.use_minimal_puts=false, hibernate.connection.driver_class=com.mysql.jdbc.Driver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.ehcache.hibernate.Provider, hibernate.cache.use_query_cache=false, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.username=caetano, hibernate.connection.url=jdbc:mysql://srv1.unoescjba.edu.br/suporte, hibernate.show_sql=true, hibernate.connection.password=, hibernate.connection.pool_size=1}
2004-10-01 17:22:54,244 INFO [net.sf.hibernate.cfg.Environment] - using CGLIB reflection optimizer
2004-10-01 17:22:54,260 INFO [net.sf.hibernate.cfg.Configuration] - configuring from url: file:/C:/Caetano/Work/java/suporte/build/hibernate.cfg.xml
2004-10-01 17:22:54,416 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/PessoaFisica.hbm.xml
2004-10-01 17:22:54,604 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.PessoaFisica -> SUP_PESSOA_FISICA
2004-10-01 17:22:55,166 INFO [net.sf.hibernate.cfg.Binder] - Mapping joined-subclass: br.com.csn.suporte.model.Colaborador -> SUP_PF_COLABORADOR
2004-10-01 17:22:55,182 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/PessoaJuridica.hbm.xml
2004-10-01 17:22:55,244 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.PessoaJuridica -> SUP_PESSOA_JURIDICA
2004-10-01 17:22:55,260 INFO [net.sf.hibernate.cfg.Binder] - Mapping joined-subclass: br.com.csn.suporte.model.Organizacao -> SUP_PJ_ORGANIZACAO
2004-10-01 17:22:55,260 INFO [net.sf.hibernate.cfg.Binder] - Mapping joined-subclass: br.com.csn.suporte.model.Cliente -> SUP_PJ_CLIENTE
2004-10-01 17:22:55,276 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/Categoria.hbm.xml
2004-10-01 17:22:55,322 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.Categoria -> SUP_CATEGORIA
2004-10-01 17:22:55,338 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/Projeto.hbm.xml
2004-10-01 17:22:55,385 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.Projeto -> SUP_PROJETO
2004-10-01 17:22:55,385 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/Componente.hbm.xml
2004-10-01 17:22:55,416 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.Componente -> SUP_COMPONENTE
2004-10-01 17:22:55,416 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/Anexo.hbm.xml
2004-10-01 17:22:55,447 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.Anexo -> SUP_CHM_ANEXO
2004-10-01 17:22:55,463 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/Historico.hbm.xml
2004-10-01 17:22:55,494 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.Historico -> SUP_CHM_HISTORICO
2004-10-01 17:22:55,494 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/Chamado.hbm.xml
2004-10-01 17:22:55,541 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.Chamado -> SUP_CHAMADO
2004-10-01 17:22:55,541 INFO [net.sf.hibernate.cfg.Configuration] - Mapping resource: br/com/csn/suporte/model/Discriminador.hbm.xml
2004-10-01 17:22:55,572 INFO [net.sf.hibernate.cfg.Binder] - Mapping class: br.com.csn.suporte.model.Discriminador -> SUP_DISCRIMINADOR
2004-10-01 17:22:55,572 INFO [net.sf.hibernate.cfg.Configuration] - Configured SessionFactory: null
2004-10-01 17:22:55,572 INFO [org.springframework.orm.hibernate.LocalSessionFactoryBean] - Building new Hibernate SessionFactory
2004-10-01 17:22:55,588 INFO [net.sf.hibernate.cfg.Configuration] - processing one-to-many association mappings
2004-10-01 17:22:55,588 INFO [net.sf.hibernate.cfg.Binder] - Mapping collection: br.com.csn.suporte.model.PessoaJuridica.filiais -> SUP_PESSOA_JURIDICA
2004-10-01 17:22:55,588 INFO [net.sf.hibernate.cfg.Binder] - Mapping collection: br.com.csn.suporte.model.Categoria.categoriasFilhas -> SUP_CATEGORIA
2004-10-01 17:22:55,588 INFO [net.sf.hibernate.cfg.Binder] - Mapping collection: br.com.csn.suporte.model.Categoria.projetos -> SUP_PROJETO
2004-10-01 17:22:55,588 INFO [net.sf.hibernate.cfg.Binder] - Mapping collection: br.com.csn.suporte.model.Projeto.componentes -> SUP_COMPONENTE
2004-10-01 17:22:55,588 INFO [net.sf.hibernate.cfg.Binder] - Mapping collection: br.com.csn.suporte.model.Componente.componentesFilhos -> SUP_COMPONENTE
2004-10-01 17:22:55,604 INFO [net.sf.hibernate.cfg.Configuration] - processing one-to-one association property references
2004-10-01 17:22:55,604 INFO [net.sf.hibernate.cfg.Configuration] - processing foreign key constraints
2004-10-01 17:22:55,635 INFO [net.sf.hibernate.dialect.Dialect] - Using dialect: net.sf.hibernate.dialect.MySQLDialect
2004-10-01 17:22:55,651 INFO [net.sf.hibernate.cfg.SettingsFactory] - Maximim outer join fetch depth: 2
2004-10-01 17:22:55,651 INFO [net.sf.hibernate.cfg.SettingsFactory] - Use outer join fetching: true
2004-10-01 17:22:55,651 INFO [net.sf.hibernate.connection.DriverManagerConnectionProvider] - Using Hibernate built-in connection pool (not for production use!)
2004-10-01 17:22:55,666 INFO [net.sf.hibernate.connection.DriverManagerConnectionProvider] - Hibernate connection pool size: 1
2004-10-01 17:22:55,666 INFO [net.sf.hibernate.connection.DriverManagerConnectionProvider] - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://srv1.unoescjba.edu.br/suporte
2004-10-01 17:22:55,682 INFO [net.sf.hibernate.connection.DriverManagerConnectionProvider] - connection properties: {user=caetano, password=}
2004-10-01 17:22:55,682 INFO [net.sf.hibernate.transaction.TransactionManagerLookupFactory] - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
2004-10-01 17:22:56,072 INFO [net.sf.hibernate.cfg.SettingsFactory] - Use scrollable result sets: true
2004-10-01 17:22:56,072 INFO [net.sf.hibernate.cfg.SettingsFactory] - Use JDBC3 getGeneratedKeys(): true
2004-10-01 17:22:56,072 INFO [net.sf.hibernate.cfg.SettingsFactory] - Optimize cache for minimal puts: false
2004-10-01 17:22:56,072 INFO [net.sf.hibernate.cfg.SettingsFactory] - echoing all SQL to stdout
2004-10-01 17:22:56,088 INFO [net.sf.hibernate.cfg.SettingsFactory] - Query language substitutions: {}
2004-10-01 17:22:56,088 INFO [net.sf.hibernate.cfg.SettingsFactory] - cache provider: net.sf.ehcache.hibernate.Provider
2004-10-01 17:22:56,088 INFO [net.sf.hibernate.cfg.Configuration] - instantiating and configuring caches
2004-10-01 17:22:56,151 INFO [net.sf.hibernate.impl.SessionFactoryImpl] - building session factory
2004-10-01 17:22:58,994 INFO [net.sf.hibernate.impl.SessionFactoryObjectFactory] - Not binding factory to JNDI, no JNDI name configured
2004-10-01 17:22:59,010 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'transactionManager'
2004-10-01 17:22:59,072 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'anexoDao'
2004-10-01 17:22:59,119 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'categoriaDao'
2004-10-01 17:22:59,151 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'chamadoDao'
2004-10-01 17:22:59,182 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'clienteDao'
2004-10-01 17:22:59,197 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'colaboradorDao'
2004-10-01 17:22:59,213 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'componenteDao'
2004-10-01 17:22:59,244 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'discriminadorDao'
2004-10-01 17:22:59,260 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'historicoDao'
2004-10-01 17:22:59,291 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'organizacaoDao'
2004-10-01 17:22:59,322 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'pessoaFisicaDao'
2004-10-01 17:22:59,338 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'pessoaJuridicaDao'
2004-10-01 17:22:59,385 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - Creating shared instance of singleton bean 'projetoDao'
2004-10-01 17:22:59,432 INFO [org.springframework.orm.hibernate.LocalSessionFactoryBean] - Creating database schema for Hibernate SessionFactory
2004-10-01 17:22:59,526 INFO [net.sf.hibernate.dialect.Dialect] - Using dialect: net.sf.hibernate.dialect.MySQLDialect
2004-10-01 17:22:59,526 INFO [net.sf.hibernate.cfg.Configuration] - processing one-to-many association mappings
2004-10-01 17:22:59,526 INFO [net.sf.hibernate.cfg.Configuration] - processing one-to-one association property references
2004-10-01 17:22:59,526 INFO [net.sf.hibernate.cfg.Configuration] - processing foreign key constraints
2004-10-01 17:23:02,916 INFO [br.com.csn.suporte.test.TestCase] - Iniciando teste...: br.com.csn.suporte.test.InitDataTest
2004-10-01 17:23:02,916 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade organizacao...
2004-10-01 17:23:04,307 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade cliente...
2004-10-01 17:23:04,338 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade colaborador...
2004-10-01 17:23:06,588 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade categoria...
2004-10-01 17:23:06,588 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade projeto...
2004-10-01 17:23:06,682 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade componente...
2004-10-01 17:23:06,776 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade discriminador...
2004-10-01 17:23:06,822 INFO [br.com.csn.suporte.test.TestCase] - Persistindo entidade chamado...
2004-10-01 17:23:08,604 INFO [br.com.csn.suporte.test.TestCase] - Teste terminado...: br.com.csn.suporte.test.InitDataTest


Name and version of the database you are using:
Mysql 4.0.11
Oracle 9i

The generated SQL (show_sql=true):
Code:
Testsuite: br.com.csn.suporte.test.AllTests
Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 9,219 sec
------------- Standard Output ---------------
Hibernate: insert into SUP_PESSOA_JURIDICA (VERSION, NOME_FANTASIA, RAZAO_SOCIAL, CNPJ, EMAIL, WEBSITE, END_LOGRADOURO, END_NUMERO, END_COMPLEMENTO, END_BAIRRO, END_CIDADE, END_ESTADO, END_PAIS, END_CODIGO_POSTAL, END_FONE_CONTATO_1, END_FONE_CONTATO_2, END_DATA_CRIACAO, ID_MATRIZ, DATA_CRIACAO, ATIVO) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_PJ_ORGANIZACAO (ID_PESSOA_JURIDICA) values (?)
Hibernate: insert into SUP_PESSOA_JURIDICA (VERSION, NOME_FANTASIA, RAZAO_SOCIAL, CNPJ, EMAIL, WEBSITE, END_LOGRADOURO, END_NUMERO, END_COMPLEMENTO, END_BAIRRO, END_CIDADE, END_ESTADO, END_PAIS, END_CODIGO_POSTAL, END_FONE_CONTATO_1, END_FONE_CONTATO_2, END_DATA_CRIACAO, ID_MATRIZ, DATA_CRIACAO, ATIVO) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_PJ_CLIENTE (ID_PESSOA_JURIDICA) values (?)
Hibernate: insert into SUP_PESSOA_FISICA (VERSION, NOME, CPF, SEXO, APELIDO, USR_USERNAME, USR_PASSWORD, USR_ENABLED, DATA_NASCIMENTO, EMAIL, WEBSITE, ENDERECO_CONTATO, END_RES_LOGRADOURO, END_RES_NUMERO, END_RES_COMPLEMENTO, END_RES_BAIRRO, END_RES_CIDADE, END_RES_ESTADO, END_RES_PAIS, END_RES_CODIGO_POSTAL, END_RES_FONE_CONTATO_1, END_RES_FONE_CONTATO_2, END_RES_DATA_CRIACAO, END_COM_LOGRADOURO, END_COM_NUMERO, END_COM_COMPLEMENTO, END_COM_BAIRRO, END_COM_CIDADE, END_COM_ESTADO, END_COM_PAIS, END_COM_CODIGO_POSTAL, END_COM_FONE_CONTATO_1, END_COM_FONE_CONTATO_2, END_COM_DATA_CRIACAO, DATA_CRIACAO, ATIVO) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_PF_COLABORADOR (ID_EMPRESA, ID_PESSOA_FISICA) values (?, ?)
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: insert into SUP_PESSOA_FISICA (VERSION, NOME, CPF, SEXO, APELIDO, USR_USERNAME, USR_PASSWORD, USR_ENABLED, DATA_NASCIMENTO, EMAIL, WEBSITE, ENDERECO_CONTATO, END_RES_LOGRADOURO, END_RES_NUMERO, END_RES_COMPLEMENTO, END_RES_BAIRRO, END_RES_CIDADE, END_RES_ESTADO, END_RES_PAIS, END_RES_CODIGO_POSTAL, END_RES_FONE_CONTATO_1, END_RES_FONE_CONTATO_2, END_RES_DATA_CRIACAO, END_COM_LOGRADOURO, END_COM_NUMERO, END_COM_COMPLEMENTO, END_COM_BAIRRO, END_COM_CIDADE, END_COM_ESTADO, END_COM_PAIS, END_COM_CODIGO_POSTAL, END_COM_FONE_CONTATO_1, END_COM_FONE_CONTATO_2, END_COM_DATA_CRIACAO, DATA_CRIACAO, ATIVO) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_PF_COLABORADOR (ID_EMPRESA, ID_PESSOA_FISICA) values (?, ?)
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: insert into SUP_CATEGORIA (VERSION, NOME, DESCRICAO, DATA_CRIACAO, ID_CATEGORIA_PAI) values (?, ?, ?, ?, ?)
Hibernate: insert into SUP_PROJETO (VERSION, NOME, ALIAS, ID_USUARIO, ID_CATEGORIA, URL, DESCRICAO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_CATEGORIA set VERSION=?, NOME=?, DESCRICAO=?, ID_CATEGORIA_PAI=? where ID_CATEGORIA=? and VERSION=?
Hibernate: insert into SUP_PROJETO (VERSION, NOME, ALIAS, ID_USUARIO, ID_CATEGORIA, URL, DESCRICAO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_CATEGORIA set VERSION=?, NOME=?, DESCRICAO=?, ID_CATEGORIA_PAI=? where ID_CATEGORIA=? and VERSION=?
Hibernate: insert into SUP_COMPONENTE (VERSION, NOME, ALIAS, ID_USUARIO, ID_COMPONENTE_PAI, ID_PROJETO, URL, DESCRICAO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_PROJETO set VERSION=?, NOME=?, ALIAS=?, ID_USUARIO=?, ID_CATEGORIA=?, URL=?, DESCRICAO=? where ID_PROJETO=? and VERSION=?
Hibernate: update SUP_CATEGORIA set VERSION=?, NOME=?, DESCRICAO=?, ID_CATEGORIA_PAI=? where ID_CATEGORIA=? and VERSION=?
Hibernate: insert into SUP_COMPONENTE (VERSION, NOME, ALIAS, ID_USUARIO, ID_COMPONENTE_PAI, ID_PROJETO, URL, DESCRICAO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_PROJETO set VERSION=?, NOME=?, ALIAS=?, ID_USUARIO=?, ID_CATEGORIA=?, URL=?, DESCRICAO=? where ID_PROJETO=? and VERSION=?
Hibernate: update SUP_CATEGORIA set VERSION=?, NOME=?, DESCRICAO=?, ID_CATEGORIA_PAI=? where ID_CATEGORIA=? and VERSION=?
Hibernate: insert into SUP_COMPONENTE (VERSION, NOME, ALIAS, ID_USUARIO, ID_COMPONENTE_PAI, ID_PROJETO, URL, DESCRICAO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_PROJETO set VERSION=?, NOME=?, ALIAS=?, ID_USUARIO=?, ID_CATEGORIA=?, URL=?, DESCRICAO=? where ID_PROJETO=? and VERSION=?
Hibernate: update SUP_CATEGORIA set VERSION=?, NOME=?, DESCRICAO=?, ID_CATEGORIA_PAI=? where ID_CATEGORIA=? and VERSION=?
Hibernate: insert into SUP_COMPONENTE (VERSION, NOME, ALIAS, ID_USUARIO, ID_COMPONENTE_PAI, ID_PROJETO, URL, DESCRICAO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_PROJETO set VERSION=?, NOME=?, ALIAS=?, ID_USUARIO=?, ID_CATEGORIA=?, URL=?, DESCRICAO=? where ID_PROJETO=? and VERSION=?
Hibernate: update SUP_CATEGORIA set VERSION=?, NOME=?, DESCRICAO=?, ID_CATEGORIA_PAI=? where ID_CATEGORIA=? and VERSION=?
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_DISCRIMINADOR (VERSION, NOME, DESCRICAO, ORDEM, URLICONE, BGCOLOR, TIPO, DATA_CRIACAO) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into SUP_CHAMADO (VERSION, ALIAS, ASSUNTO, DESCRICAO, AMBIENTE, ID_PROJETO, ID_COMPONENTE, ID_USUARIO_SOLICITANTE, ID_USUARIO_ATENDENTE, ID_DISCR_TIPO, ID_DISCR_PRIORIDADE, ID_DISCR_STATUS, ID_DISCR_RESOLUCAO, DATA_CRIACAO, DATA_ALTERACAO, VOTOS) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update SUP_PROJETO set VERSION=?, NOME=?, ALIAS=?, ID_USUARIO=?, ID_CATEGORIA=?, URL=?, DESCRICAO=? where ID_PROJETO=? and VERSION=?
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_CATEGORIA set VERSION=?, NOME=?, DESCRICAO=?, ID_CATEGORIA_PAI=? where ID_CATEGORIA=? and VERSION=?
Hibernate: update SUP_COMPONENTE set VERSION=?, NOME=?, ALIAS=?, ID_USUARIO=?, ID_COMPONENTE_PAI=?, ID_PROJETO=?, URL=?, DESCRICAO=? where ID_COMPONENTE=? and VERSION=?
Hibernate: update SUP_PESSOA_FISICA set VERSION=?, NOME=?, CPF=?, SEXO=?, APELIDO=?, USR_USERNAME=?, USR_PASSWORD=?, USR_ENABLED=?, DATA_NASCIMENTO=?, EMAIL=?, WEBSITE=?, ENDERECO_CONTATO=?, END_RES_LOGRADOURO=?, END_RES_NUMERO=?, END_RES_COMPLEMENTO=?, END_RES_BAIRRO=?, END_RES_CIDADE=?, END_RES_ESTADO=?, END_RES_PAIS=?, END_RES_CODIGO_POSTAL=?, END_RES_FONE_CONTATO_1=?, END_RES_FONE_CONTATO_2=?, END_RES_DATA_CRIACAO=?, END_COM_LOGRADOURO=?, END_COM_NUMERO=?, END_COM_COMPLEMENTO=?, END_COM_BAIRRO=?, END_COM_CIDADE=?, END_COM_ESTADO=?, END_COM_PAIS=?, END_COM_CODIGO_POSTAL=?, END_COM_FONE_CONTATO_1=?, END_COM_FONE_CONTATO_2=?, END_COM_DATA_CRIACAO=?, ATIVO=? where ID_PESSOA_FISICA=? and VERSION=?
Hibernate: update SUP_PF_COLABORADOR set ID_EMPRESA=? where ID_PESSOA_FISICA=?
Hibernate: update SUP_PESSOA_JURIDICA set VERSION=?, NOME_FANTASIA=?, RAZAO_SOCIAL=?, CNPJ=?, EMAIL=?, WEBSITE=?, END_LOGRADOURO=?, END_NUMERO=?, END_COMPLEMENTO=?, END_BAIRRO=?, END_CIDADE=?, END_ESTADO=?, END_PAIS=?, END_CODIGO_POSTAL=?, END_FONE_CONTATO_1=?, END_FONE_CONTATO_2=?, END_DATA_CRIACAO=?, ID_MATRIZ=?, ATIVO=? where ID_PESSOA_JURIDICA=? and VERSION=?
Hibernate: update SUP_DISCRIMINADOR set VERSION=?, NOME=?, DESCRICAO=?, ORDEM=?, URLICONE=?, BGCOLOR=?, TIPO=? where ID_DISCRIMINADOR=? and VERSION=?
Hibernate: update SUP_DISCRIMINADOR set VERSION=?, NOME=?, DESCRICAO=?, ORDEM=?, URLICONE=?, BGCOLOR=?, TIPO=? where ID_DISCRIMINADOR=? and VERSION=?
Hibernate: update SUP_DISCRIMINADOR set VERSION=?, NOME=?, DESCRICAO=?, ORDEM=?, URLICONE=?, BGCOLOR=?, TIPO=? where ID_DISCRIMINADOR=? and VERSION=?
Hibernate: update SUP_DISCRIMINADOR set VERSION=?, NOME=?, DESCRICAO=?, ORDEM=?, URLICONE=?, BGCOLOR=?, TIPO=? where ID_DISCRIMINADOR=? and VERSION=?
------------- ---------------- ---------------

Testcase: testImportData took 9,187 sec
Top
 Profile  
 
caetano
 Post subject: I've found a solution
PostPosted: Fri Oct 01, 2004 6:43 pm 
Newbie

Joined: Fri Oct 01, 2004 1:29 pm
Posts: 5
Location: Brasil
Hi,

I have configurated a manager (org.springframework.transaction.interceptor.TransactionProxyFactoryBean) in the applicationContext.xml of Spring, setting the DAO's instances and it's all ok in Oracle now.

This reference has useful: http://forum.springframework.org/viewtopic.php?t=1020

Did I not remember that mysql does not have transactions support in this version??? yeahh...

Hibernate Rocks!!
Top
 Profile  
 
eric chan
 Post subject: Transaction workind in Oracle and different in Mysql
PostPosted: Sun Oct 03, 2004 4:49 am 
Newbie

Joined: Thu Sep 30, 2004 12:33 pm
Posts: 1
Mysql doesn't support transaction when the table's type is MyISAM, if you need transaction,change the table's type to InnoDB.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.