SQLGrammarException? Erro muito doido

Hibernate version: Hibernate 3.2.CR2

Name and version of the database you are using: Postgresql 8.1

The generated SQL (show_sql=true): Sim

Hibernate.cfg.xml:

<?xml version=‘1.0’ encoding=‘utf-8’?>
<!DOCTYPE hibernate-configuration PUBLIC “-//Hibernate/Hibernate Configuration DTD 3.0//EN”
“http://localhost:8084/LeituraWeb/hibernate-configuration-3_0_dtd.dtd”>

<hibernate-configuration>
<session-factory>

<property name=“connection.driver_class”>org.postgresql.Driver</property>
<property name=“connection.url”>jdbc:postgresql://localhost/LeituraBD?charSet=ASCII</property>
<property name=“connection.username”>postgres</property>
<property name=“connection.password”>vector</property>

<property name=“dialect”>org.hibernate.dialect.PostgreSQLDialect</property>

<property name=“show_sql”>true</property>

fornecedor.hbm.xml:

<?xml version=“1.0” encoding=“UTF-8”?>
<!DOCTYPE hibernate-mapping PUBLIC “-//Hibernate/Hibernate Mapping DTD 3.0//EN”
“http://localhost:8084/LeituraWeb/hibernate-mapping-3_0_dtd.dtd”>
<!–
Document : Grupo.xml
Created on : 25 de Maio de 2006, 10:42
Author : Genuino Teixeira
Description:
Purpose of the document follows.
–>

<hibernate-mapping>

<class name=“br.com.leitura.core.Fornecedor” table=“tbl_fornecedor”>

<id name=“codFornecedor” >

<column name=“CNPJ” length=“30” not-null=“true”/>

<generator class=“assigned”/>

</id>

<property name=“nome”>

<column name=“NOME” not-null=“true”/>

</property>

<property name=“numero”>

<column name=“NUMERO” not-null=“true”/>

</property>

<property name=“complemento”>

<column name=“COMPLEMENTO”/>

</property>

<property name=“email”>

<column name=“E_MAIL” not-null=“true”/>

</property>

<property name=“contato”>

<column name=“CONTATO” not-null=“true”/>

</property>

<property name=“descontos” type=“java.lang.Double”>

<column name=“descontos” not-null=“true”/>

</property>

<property name=“dataAtualizacao”>

<column name=“DATA_ATUALIZACAO” not-null=“true”/>

</property>

<property name=“horaAtualizacao”>

<column name=“HORA_ATUALIZACAO” not-null=“true”/>

</property>

<property name=“dataCadastro”>

<column name=“DATA_CADASTRO” not-null=“true”/>

</property>

<many-to-one name=“cidade” column="COD_CIDADE"

class=“br.com.leitura.core.Cidades” cascade=“all”/>

<many-to-one name=“bairro” column="COD_BAIRRO"

class=“br.com.leitura.core.Bairro” cascade=“save-update”/>

<set name=“telefones” table=“tbl_tel_fornecedor” cascade=“all”>

<key column=“cod_fornecedor”/>

<element column=“telefone” type=“string”/>

</set>

</class>

</hibernate-mapping>

cidade.hbm.xml:

<hibernate-mapping>

<class name=“br.com.leitura.core.Cidades” table=“tbl_cidades”>

<id name=“codigo” column=“CODIGO”>

<generator class=“sequence”>

<param name=“sequence”>tbl_cidades_codigo_seq</param>

</generator>

</id>

<property name=“cidade”>

<column name=“CIDADE” not-null=“true”/>

</property>

<property name=“estado”>

<column name=“ESTADO” not-null=“true”/>

</property>

<property name=“pais”>

<column name=“PAIS” not-null=“true”/>

</property>

<property name=“prazoEntrega”>

<column name=“PRAZO_ENTREGA” />

</property>

<set name=“fornecedores” lazy=“true” inverse=“true” cascade=“all”>

<key column=“cod_cidade”/>

<one-to-many class=“br.com.leitura.core.Fornecedor”/>

</set>

</class>

</hibernate-mapping>

bairro:
<?xml version=“1.0” encoding=“UTF-8”?>
<!DOCTYPE hibernate-mapping PUBLIC “-//Hibernate/Hibernate Mapping DTD 3.0//EN”
“http://localhost:8084/LeituraWeb/hibernate-mapping-3_0_dtd.dtd”>
<!–
Document : Grupo.xml
Created on : 25 de Maio de 2006, 10:42
Author : Genuino Teixeira
Description:
Purpose of the document follows.
–>

<hibernate-mapping>

<class name=“br.com.leitura.core.Bairro” table=“tbl_bairros”>

<id name=“codigo” column=“CODIGO”>

<generator class=“sequence”>

<param name=“sequence”>tbl_bairros_codigo_seq</param>

</generator>

</id>

<property name=“bairro”>

<column name=“BAIRRO” not-null=“true”/>

</property>

<property name=“rua”>

<column name=“RUA” not-null=“true”/>

</property>

<set name=“fornecedores” lazy=“true” inverse=“true” cascade=“save-update”>

<key column=“cod_bairro”/>

<one-to-many class=“br.com.leitura.core.Fornecedor”/>

</set>

</class>

</hibernate-mapping>

Código:

…
Bairro bairro = new Bairro();

bairro.setCodigo(‘1’);

bairro.setBairro(“bairro”);

bairro.setRua(“rua”);

Cidades cidade = new Cidades();

cidade.setCodigo(‘2’);

cidade.setCidade(“cidade”);

cidade.setEstado(“estado”);

cidade.setPais(“BR”);

Fornecedor fornecedor = new Fornecedor();

fornecedor.setDescontos(0.0);

…

fornecedor.setBairro(bairro);
fornecedor.setCidade(cidade);

bairro.getFornecedores.add(fornecedor);
cidade.getFornecedores.add(fornecedor);

session.saveOrUpdate(fornecedor);

Assumindo que “bairro” e “cidade” estão cadastrados no BD.

A exceção:

rg.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)

at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)

at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)

at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)

at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)

at br.com.leitura.dao.LeituraHB.cadastrarFornecedor(LeituraHB.java:378)

at br.com.leitura.core.TrataLeitura.cadastrarFornecedor(TrataLeitura.java:453)

at br.com.leitura.core.TrataLeitura.qualMetodo(TrataLeitura.java:101)

at br.com.leitura.core.TrataLeitura.doGet(TrataLeitura.java:119)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.BatchUpdateException: Entrada em lote 0 insert into tbl_fornecedor (NOME, NUMERO, COMPLEMENTO, E_MAIL, CONTATO, descontos, DATA_ATUALIZACAO, HORA_ATUALIZACAO, DATA_CADASTRO, COD_CIDADE, COD_BAIRRO, CNPJ) values (Brasport, 23, NULL, <a href="mailto:[email removido]">[email removido]</a>, José, 0.0, 2006/06/23, 16:05:05, 2006/06/23, 2, 1, 1) foi abortada. Chame getNextException para ver a causa. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2435)

at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:397)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1280)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:345)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2497)

at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)

… 30 more

Alguém tem alguma sugestão???

Vlw d+ msmo.

Topicos relacionados