invalid number

marceltoma · **Posted:** Wed Aug 18, 2004 10:19 am

Looks like hibernate is trying to insert a string in a number field.

I executed the insert command in SLQPLUS and got the erro:

Code:

SQL> insert into documento (COD_CLI, COD_CLASSE, COD_INSTALACAO, COD_LIVRO_LEITURA, COD_LOCALIDADE,
  2  COD_LOTE_FATURAMENTO, COD_MOTIVO_EXC, COD_TIPO_DOC, COD_UNID_OPER, DAT_CRIACAO_FATURA,
  3  DAT_EMISSAO_FATURA, DAT_EXC, DAT_FIM_COB, DAT_INCLUSAO_REG, DAT_INI_COB, DAT_PREV_CORTE,
  4  DAT_PROC_ARQ_ORG, DAT_VENCTO_FATURA, FLG_DEB_AUT, IND_CONTENCIOSO, MES_REF_FATURA, NUM_FATURA,
  5  QTD_TENTATIVA, TOT_FATURA_AVISO_DEB, VLR_FATURA, INX_DOC) values
  6  ('2', null, null, null, null, null, null, null, null, null, null,
  7  null, null, null, null, null, null, null, null, null, null, '00012121234', null, null, '122.0',
 '1');
null, null, null, null, null, null, null, null, null, null, '00012121234', null, null, '122.0', '1')
                                                                                       *
ERRO na linha 7:
ORA-01722: invalid number

Hibernate version: 2.1.6

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class name="com.br.resource.csu.lembranca.dao.hibernate.persisted.Documento" table="documento">
<id name="inxDoc" column="INX_DOC" type="integer">
<generator class="increment"/>
</id>
<many-to-one name="codCli" column="COD_CLI"/>
<property name="codClasse" column="COD_CLASSE"/>
<property name="codInstalacao" column="COD_INSTALACAO"/>
<property name="codLivroLeitura" column="COD_LIVRO_LEITURA"/>
<property name="codLocalidade" column="COD_LOCALIDADE"/>
<property name="codLoteFaturamento" column="COD_LOTE_FATURAMENTO"/>
<property name="codMotivoExc" column="COD_MOTIVO_EXC"/>
<property name="codTipoDoc" column="COD_TIPO_DOC"/>
<property name="codUnidOper" column="COD_UNID_OPER"/>
<property name="datCriacaoFatura" column="DAT_CRIACAO_FATURA"/>
<property name="datEmissaoFatura" column="DAT_EMISSAO_FATURA"/>
<property name="datExc" column="DAT_EXC"/>
<property name="datFimCob" column="DAT_FIM_COB"/>
<property name="datInclusaoReg" column="DAT_INCLUSAO_REG"/>
<property name="datIniCob" column="DAT_INI_COB"/>
<property name="datPrevCorte" column="DAT_PREV_CORTE"/>
<property name="datProcArqOrg" column="DAT_PROC_ARQ_ORG"/>
<property name="datVenctoFatura" column="DAT_VENCTO_FATURA"/>
<property name="flgDebAut" column="FLG_DEB_AUT"/>
<property name="indContencioso" column="IND_CONTENCIOSO"/>
<property name="mesRefFatura" column="MES_REF_FATURA"/>
<property name="numFatura" column="NUM_FATURA"/>
<property name="qtdTentativa" column="QTD_TENTATIVA"/>
<property name="totFaturaAvisoDeb" column="TOT_FATURA_AVISO_DEB"/>
<property name="vlrFatura" column="VLR_FATURA" type="float"/>
</class>

</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
docCliente = new DocumentoCliente();
docCliente.setVlrDoc(docClienteFase1TO.getNumeroDocumento().trim());
docCliente.setCodDoc(docClienteFase1TO.getTipoDocumento().trim().toUpperCase());
docCliente.setCodCli(cliente);
docClienteDao.create(docCliente);

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Oracle 8.1.7

Debug level Hibernate log excerpt:
2004-08-18 11:00:55,501 INFO [STDOUT] Hibernate: insert into documento (COD_CLI, COD_CLAS
SE, COD_INSTALACAO, COD_LIVRO_LEITURA, COD_LOCALIDADE, COD_LOTE_FATURAMENTO, COD_MOTIVO_EX
C, COD_TIPO_DOC, COD_UNID_OPER, DAT_CRIACAO_FATURA, DAT_EMISSAO_FATURA, DAT_EXC, DAT_FIM_C
OB, DAT_INCLUSAO_REG, DAT_INI_COB, DAT_PREV_CORTE, DAT_PROC_ARQ_ORG, DAT_VENCTO_FATURA, FL
G_DEB_AUT, IND_CONTENCIOSO, MES_REF_FATURA, NUM_FATURA, QTD_TENTATIVA, TOT_FATURA_AVISO_DE
B, VLR_FATURA, INX_DOC) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?)
2004-08-18 11:00:55,501 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2004-08-18 11:00:55,502 DEBUG [net.sf.hibernate.persister.EntityPersister] Dehydrating entity: [com.br.resource.csu.lembranca.dao.hibernate.persisted.Documento#1]2004-08-18 11:00:55,502 DEBUG [net.sf.hibernate.type.IntegerType] binding '2' to parameter: 1
2004-08-18 11:00:55,502 DEBUG [net.sf.hibernate.type.StringType] binding '100' to parameter: 2
2004-08-18 11:00:55,502 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 3
2004-08-18 11:00:55,502 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 4
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 5
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 6
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 7
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.IntegerType] binding null to parameter: 8
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 9
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 10
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 11
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 12
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.TimestampType] binding '2004-01-19 00:00:00' to parameter: 13
2004-08-18 11:00:55,503 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 14
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.TimestampType] binding '2004-07-17 00:00:00' to parameter: 15
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 16
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 17
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 18
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.StringType] binding 'N' to parameter: 19
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter: 20
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parameter: 21
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.StringType] binding '000165067366' to parameter: 22
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.IntegerType] binding null to parameter: 23
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.IntegerType] binding null to parameter: 24
2004-08-18 11:00:55,504 DEBUG [net.sf.hibernate.type.FloatType] binding '10481.0' to parameter: 25
2004-08-18 11:00:55,505 DEBUG [net.sf.hibernate.type.IntegerType] binding '1' to parameter: 26
2004-08-18 11:00:55,505 DEBUG [net.sf.hibernate.impl.BatcherImpl] Adding to batch
2004-08-18 11:00:55,505 DEBUG [net.sf.hibernate.persister.EntityPersister] Inserting entity: [com.br.resource.csu.lembranca.dao.hibernate.persisted.EnderecoCliente#1]
2004-08-18 11:00:55,505 DEBUG [net.sf.hibernate.impl.BatcherImpl] Executing batch size: 1
2004-08-18 11:00:55,511 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.BatchUpdateException: ORA-01722: invalid number

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement
.java:3377)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:59)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at com.br.resource.csu.lembranca.dao.Dao.create(Dao.java:27)
at com.br.resource.csu.lembranca.fase1.Fase1FileProcessBean.inserirCliente(Fase1Fi
leProcessBean.java:352)
at com.br.resource.csu.lembranca.fase1.Fase1FileProcessBean.ProcessDataFase1(Fase1
FileProcessBean.java:157)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSe
ssionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedC
onnectionInterceptor.java:185)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessi
onInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.ja
va:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.jav
a:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderIn
terceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContaine
r.java:331)
at org.jboss.ejb.Container.invoke(Container.java:723)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.
java:359)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.
java:83)
at $Proxy192.ProcessDataFase1(Unknown Source)
at com.br.resource.csu.lembranca.jmx.LembrancaService.ImportFileFase1(LembrancaSer
vice.java:66)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:234)
at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOpByName(HtmlAdaptorServlet
.java:266)
at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdaptorServlet
.java:81)
at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doGet(HtmlAdaptorServlet.java:56)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil
terChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain
.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
ava:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal
ve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
ava:104)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociati
onValve.java:72)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
ava:102)
at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrReal
m.java:275)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
ava:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
ava:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
ava:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:10
9)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
ava:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnecti
on(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6
83)
at java.lang.Thread.run(Thread.java:479)
2004-08-18 11:00:55,512 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 172
2, SQLState: 42000
2004-08-18 11:00:55,512 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] ORA-01722: inv
alid number

2004-08-18 11:00:55,512 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 172
2, SQLState: 42000
2004-08-18 11:00:55,513 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] ORA-01722: inv
alid number

2004-08-18 11:00:55,513 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open Pre
paredStatements, 0 open ResultSets
2004-08-18 11:00:55,513 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
2004-08-18 11:00:55,513 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.BatchUpdateException: ORA-01722: invalid number

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement
.java:3377)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:59)
at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at com.br.resource.csu.lembranca.dao.Dao.create(Dao.java:27)
at com.br.resource.csu.lembranca.fase1.Fase1FileProcessBean.inserirCliente(Fase1Fi
leProcessBean.java:352)

Table description

Code:

SQL> desc documento
 Nome                                      Nulo?    Tipo
 ----------------------------------------- -------- ----------------------
 COD_TIPO_DOC                                       NUMBER(3)
 QTD_TENTATIVA                                      NUMBER(4)
 FLG_DEB_AUT                                        CHAR(1)
 DAT_FIM_COB                                        DATE
 DAT_INI_COB                                        DATE
 COD_CLASSE                                         CHAR(3)
 COD_LOCALIDADE                                     VARCHAR2(5)
 COD_LOTE_FATURAMENTO                               CHAR(2)
 COD_INSTALACAO                                     VARCHAR2(5)
 COD_UNID_OPER                                      VARCHAR2(5)
 COD_LIVRO_LEITURA                                  VARCHAR2(5)
 DAT_EXC                                            DATE
 COD_MOTIVO_EXC                                     CHAR(2)
 DAT_CRIACAO_FATURA                                 DATE
 VLR_FATURA                                         FLOAT(126)
 DAT_VENCTO_FATURA                                  DATE
 MES_REF_FATURA                                     DATE
 NUM_FATURA                                         VARCHAR2(12)
 DAT_INCLUSAO_REG                                   DATE
 DAT_PROC_ARQ_ORG                                   DATE
 IND_CONTENCIOSO                                    CHAR(3)
 DAT_PREV_CORTE                                     DATE
 TOT_FATURA_AVISO_DEB                               NUMBER(3)
 DAT_EMISSAO_FATURA                                 DATE
 COD_CLI                                   NOT NULL NUMBER(10)
 INX_DOC                                   NOT NULL NUMBER(38)

anthony · **Posted:** Wed Aug 18, 2004 10:24 am

and now show your pojo code

marceltoma · **Posted:** Wed Aug 18, 2004 10:29 am

Code:

package com.br.resource.csu.lembranca.dao.hibernate.persisted;

import java.util.Date;

public class Documento {
   private Integer codTipoDoc;
   private Integer qtdTentativa;
   private String flgDebAut;
   private Date datFimCob;
   private Date datIniCob;
   private String codClasse;
   private String codLocalidade;
   private String codLoteFaturamento;
   private String codInstalacao;
   private String codUnidOper;
   private String codLivroLeitura;
   private Date datExc;
   private String codMotivoExc;
   private Date datCriacaoFatura;
   private Float vlrFatura;
   private Date datVenctoFatura;
   private Date mesRefFatura;
   private String numFatura;
   private Date datInclusaoReg;
   private Date datProcArqOrg;
   private String indContencioso;
   private Date datPrevCorte;
   private Integer totFaturaAvisoDeb;
   private Date datEmissaoFatura;
   private Cliente codCli;
   private Integer inxDoc;
   
   public String getCodClasse() {
      return codClasse;
   }
   public void setCodClasse(String codClasse) {
      this.codClasse = codClasse;
   }
   public Cliente getCodCli() {
      return codCli;
   }
   public void setCodCli(Cliente codCli) {
      this.codCli = codCli;
   }
   public String getCodInstalacao() {
      return codInstalacao;
   }
   public void setCodInstalacao(String codInstalacao) {
      this.codInstalacao = codInstalacao;
   }
   public String getCodLivroLeitura() {
      return codLivroLeitura;
   }
   public void setCodLivroLeitura(String codLivroLeitura) {
      this.codLivroLeitura = codLivroLeitura;
   }
   public String getCodLocalidade() {
      return codLocalidade;
   }
   public void setCodLocalidade(String codLocalidade) {
      this.codLocalidade = codLocalidade;
   }
   public String getCodLoteFaturamento() {
      return codLoteFaturamento;
   }
   public void setCodLoteFaturamento(String codLoteFaturamento) {
      this.codLoteFaturamento = codLoteFaturamento;
   }
   public String getCodMotivoExc() {
      return codMotivoExc;
   }
   public void setCodMotivoExc(String codMotivoExc) {
      this.codMotivoExc = codMotivoExc;
   }
   public Integer getCodTipoDoc() {
      return codTipoDoc;
   }
   public void setCodTipoDoc(Integer codTipoDoc) {
      this.codTipoDoc = codTipoDoc;
   }
   public String getCodUnidOper() {
      return codUnidOper;
   }
   public void setCodUnidOper(String codUnidOper) {
      this.codUnidOper = codUnidOper;
   }
   public Date getDatCriacaoFatura() {
      return datCriacaoFatura;
   }
   public void setDatCriacaoFatura(Date datCriacaoFatura) {
      this.datCriacaoFatura = datCriacaoFatura;
   }
   public Date getDatEmissaoFatura() {
      return datEmissaoFatura;
   }
   public void setDatEmissaoFatura(Date datEmissaoFatura) {
      this.datEmissaoFatura = datEmissaoFatura;
   }
   public Date getDatExc() {
      return datExc;
   }
   public void setDatExc(Date datExc) {
      this.datExc = datExc;
   }
   public Date getDatFimCob() {
      return datFimCob;
   }
   public void setDatFimCob(Date datFimCob) {
      this.datFimCob = datFimCob;
   }
   public Date getDatInclusaoReg() {
      return datInclusaoReg;
   }
   public void setDatInclusaoReg(Date datInclusaoReg) {
      this.datInclusaoReg = datInclusaoReg;
   }
   public Date getDatIniCob() {
      return datIniCob;
   }
   public void setDatIniCob(Date datIniCob) {
      this.datIniCob = datIniCob;
   }
   public Date getDatPrevCorte() {
      return datPrevCorte;
   }
   public void setDatPrevCorte(Date datPrevCorte) {
      this.datPrevCorte = datPrevCorte;
   }
   public Date getDatProcArqOrg() {
      return datProcArqOrg;
   }
   public void setDatProcArqOrg(Date datProcArqOrg) {
      this.datProcArqOrg = datProcArqOrg;
   }
   public Date getDatVenctoFatura() {
      return datVenctoFatura;
   }
   public void setDatVenctoFatura(Date datVenctoFatura) {
      this.datVenctoFatura = datVenctoFatura;
   }
   public String getFlgDebAut() {
      return flgDebAut;
   }
   public void setFlgDebAut(String flgDebAut) {
      this.flgDebAut = flgDebAut;
   }
   public String getIndContencioso() {
      return indContencioso;
   }
   public void setIndContencioso(String indContencioso) {
      this.indContencioso = indContencioso;
   }
   public Integer getInxDoc() {
      return inxDoc;
   }
   public void setInxDoc(Integer inxDoc) {
      this.inxDoc = inxDoc;
   }
   public Date getMesRefFatura() {
      return mesRefFatura;
   }
   public void setMesRefFatura(Date mesRefFatura) {
      this.mesRefFatura = mesRefFatura;
   }
   public String getNumFatura() {
      return numFatura;
   }
   public void setNumFatura(String numFatura) {
      this.numFatura = numFatura;
   }
   public Integer getQtdTentativa() {
      return qtdTentativa;
   }
   public void setQtdTentativa(Integer qtdTentativa) {
      this.qtdTentativa = qtdTentativa;
   }
   public Integer getTotFaturaAvisoDeb() {
      return totFaturaAvisoDeb;
   }
   public void setTotFaturaAvisoDeb(Integer totFaturaAvisoDeb) {
      this.totFaturaAvisoDeb = totFaturaAvisoDeb;
   }
   public Float getVlrFatura() {
      return vlrFatura;
   }
   public void setVlrFatura(Float vlrFatura) {
      this.vlrFatura = vlrFatura;
   }
}

anthony · **Posted:** Wed Aug 18, 2004 10:36 am

what happens if you copy paste this into sql plus?
SQL> insert into documento (COD_CLI, COD_CLASSE, COD_INSTALACAO, COD_LIVRO_LEITURA, COD_LOCALIDADE,
2 COD_LOTE_FATURAMENTO, COD_MOTIVO_EXC, COD_TIPO_DOC, COD_UNID_OPER, DAT_CRIACAO_FATURA,
3 DAT_EMISSAO_FATURA, DAT_EXC, DAT_FIM_COB, DAT_INCLUSAO_REG, DAT_INI_COB, DAT_PREV_CORTE,
4 DAT_PROC_ARQ_ORG, DAT_VENCTO_FATURA, FLG_DEB_AUT, IND_CONTENCIOSO, MES_REF_FATURA, NUM_FATURA,
5 QTD_TENTATIVA, TOT_FATURA_AVISO_DEB, VLR_FATURA, INX_DOC) values
6 ('2', null, null, null, null, null, null, null, null, null, null,
7 null, null, null, null, null, null, null, null, null, null, '00012121234', null, null, '122',
'1');

marceltoma · **Posted:** Wed Aug 18, 2004 10:39 am

it runs fine.

=)

anthony · **Posted:** Wed Aug 18, 2004 10:40 am

i think the problem comes from the '.' test again with 122,0 instead of 122.0

marceltoma · **Posted:** Wed Aug 18, 2004 10:43 am

I see, the problem is that oracle uses '122,0' not '122.0'

how can I change from dot to comma in hibernate?

marceltoma · **Posted:** Wed Aug 18, 2004 2:16 pm

I've tried if null and still got the error

Code:

2004-08-18 15:18:10,934 INFO  [STDOUT] Hibernate: insert into documento (COD_CLI, COD_CLAS
SE, COD_INSTALACAO, COD_LIVRO_LEITURA, COD_LOCALIDADE, COD_LOTE_FATURAMENTO, COD_MOTIVO_EX
C, COD_TIPO_DOC, COD_UNID_OPER, DAT_CRIACAO_FATURA, DAT_EMISSAO_FATURA, DAT_EXC, DAT_FIM_C
OB, DAT_INCLUSAO_REG, DAT_INI_COB, DAT_PREV_CORTE, DAT_PROC_ARQ_ORG, DAT_VENCTO_FATURA, FL
G_DEB_AUT, IND_CONTENCIOSO, MES_REF_FATURA, NUM_FATURA, QTD_TENTATIVA, TOT_FATURA_AVISO_DE
B, VLR_FATURA, INX_DOC) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?)
2004-08-18 15:18:10,934 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2004-08-18 15:18:10,935 DEBUG [net.sf.hibernate.persister.EntityPersister] Dehydrating ent
ity: [com.br.resource.csu.lembranca.dao.hibernate.persisted.Documento#1]
2004-08-18 15:18:10,935 DEBUG [net.sf.hibernate.type.IntegerType] binding '2' to parameter
: 1
2004-08-18 15:18:10,935 DEBUG [net.sf.hibernate.type.StringType] binding '100' to paramete
r: 2
2004-08-18 15:18:10,935 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter
: 3
2004-08-18 15:18:10,935 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter
: 4
2004-08-18 15:18:10,935 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter
: 5
2004-08-18 15:18:10,935 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter
: 6
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter
: 7
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.IntegerType] binding null to paramete
r: 8
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter
: 9
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 10
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 11
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 12
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.TimestampType] binding '2004-01-19 00
:00:00' to parameter: 13
2004-08-18 15:18:10,936 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 14
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.TimestampType] binding '2004-07-17 00
:00:00' to parameter: 15
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 16
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 17
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 18
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.StringType] binding 'N' to parameter:
 19
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.StringType] binding null to parameter
: 20
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.TimestampType] binding null to parame
ter: 21
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.StringType] binding '000165067366' to
 parameter: 22
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.IntegerType] binding null to paramete
r: 23
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.IntegerType] binding null to paramete
r: 24
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.BigDecimalType] binding null to param
eter: 25
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.type.IntegerType] binding '1' to parameter
: 26
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.impl.BatcherImpl] Adding to batch
2004-08-18 15:18:10,937 DEBUG [net.sf.hibernate.persister.EntityPersister] Inserting entit
y: [com.br.resource.csu.lembranca.dao.hibernate.persisted.EnderecoCliente#1]
2004-08-18 15:18:10,938 DEBUG [net.sf.hibernate.impl.BatcherImpl] Executing batch size: 1
2004-08-18 15:18:10,940 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.BatchUpdateException: ORA-01722: invalid number

        at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement
.java:3377)
        at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
        at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
        at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:59)
        at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:56)
        at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:109)
        at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:460)
        at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
        at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

You try without quote for instance 122.2 (not '122.2' or '122,2') and map field to big_decimal, float or double

regards

marceltoma · **Posted:** Wed Aug 18, 2004 5:14 pm

I tried with BigDecimal, Float and Double.

The quotes are automatic, I didn't put it, hibernate do.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

I try insert into number column like
insert into num_tab values('122.0')

and it work

You have changed any parameter in oracle init.ora file (pfile) and it confuse hibernate - maybe You have different locale in Oracle and JVM for hibernate

regards

marceltoma · **Posted:** Wed Aug 18, 2004 6:27 pm

There was something wrong with the database, I dropped the hole DB and created it again, than it worked.

hibernate 1 x oracle 0

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

Oracle haven't problems, beleive me

You have had changed parameter or locale

There are three players (hibernate,oracle and you) - add 1 or 0 for every one

regards

marceltoma · **Posted:** Wed Aug 18, 2004 7:24 pm

I found the problem

the sql I imported has a

alter table DOCUMENTO
add check ( FLG_DEB_AUT IN( 0, 1 ));

and I was trying to insert 'N'
althought, the column is a char(1), oracle throws a invalid number exception

Sorry for all people who helped me.
If it makes you happier, I can throw the DBA thru the window for not telling me the constraints =-)
[/quote]