Problemas para persistir Data

Cara já passei por isso, colunas com o padrão CamelCase são uma verdadeira merd… no postgresql

renomeie sua coluna de dataCriacao para data_criacao ou datacriacao, sem o C em maiúsculo vai resolver seu problema.

Gostaria de agradecer ao Big E . Realmente esta resolvido. Caara nunca pensei que pudesse ser resolvido desta forma…contudo, Obrigado…

Cristofe:

Prezados Colegas , Estou com problemas para persistir uma data no banco Postgres: Meu formulário esta desta forma:

<h:column>
                            <h:outputLabel value="Data:"/>
                            <p:calendar value="#{usuarioBean.usuario.dataCriacao}" navigator="true">
                                <f:convertDateTime dateStyle="short"/>
                            </p:calendar>

Meu banco esta desta forma:

-- Table: usuario

-- DROP TABLE usuario;

CREATE TABLE usuario
(
  nome character(40),
  usuario character(10),
  passwd integer,
  email character(40),
  "dataCriacao" date,
  id integer NOT NULL,
  permissao integer,
  status boolean,
  CONSTRAINT id_usuario PRIMARY KEY (id),
  CONSTRAINT login_usuario UNIQUE (usuario)
)
WITH (
  OIDS=FALSE,
  autovacuum_enabled=true
);
ALTER TABLE usuario OWNER TO postgres;
GRANT ALL ON TABLE usuario TO public;
GRANT ALL ON TABLE usuario TO postgres;

Minha Stack Trace:

g.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.doList(Loader.java:2228)
        ... 59 more
SQL Error: 0, SQLState: null
Entrada em lote 0 insert into usuario (dataCriacao, email, nome, passwd, permissao, status, usuario, id) values (2012-05-01 -04:00:00, 22, gabriel Igor, 222222, 1, 0, gabriel, 24) foi abortada. Chame getNextException para ver a causa.
SQL Error: 0, SQLState: 42703
ERROR: column "datacriacao" of relation "usuario" does not exist
Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
        at br.ifrr.DAO.UsuarioDAOHibernate.salvar(UsuarioDAOHibernate.java:34)
        at br.ifrr.control.UsuarioRN.salvar(UsuarioRN.java:29)
        at br.ifrr.managed.UsuarioBean.salvar(UsuarioBean.java:82)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.el.parser.AstValue.invoke(AstValue.java:191)
        at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
        at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:98)
        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
        at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
        at javax.faces.component.UICommand.broadcast(UICommand.java:315)
        at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:775)
        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1267)
        at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:680)
Caused by: java.sql.BatchUpdateException: Entrada em lote 0 insert into usuario (dataCriacao, email, nome, passwd, permissao, status, usuario, id) values (2012-05-01 -04:00:00, 22, gabriel Igor, 222222, 1, 0, gabriel, 24) foi abortada. Chame getNextException para ver a causa.
        at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 41 more
[salvar] Nao foi possivel Salva o usuario

Alguem pode me ajudar?

só pra ajudar:

é o seu primeiro post do tópico que tem que ser editado, e nele você altera o título adicionando a tag [RESOLVIDO].

se adicionar no último, o pessoal olhando a lista de tópicos não vai ver.