Jdbcexceptionreporter Sql Error 0 Sqlstate 42703

not work correctly without it enabled. Please turn JavaScript back on and reload this page. All Places > EJB3 > Discussions Please enter a title. You can not post a blank message. Please type your message and try again. 3 Replies Latest reply on Jul 16, 2007 7:08 AM by Michael Hönnig hibernate couldn't find column Carsten Keuch Aug 1, 2006 10:40 AM Hi there,i'm new to Hibernate, EJB3 and surrounding stuff. I'm using JBoss 4.0.4 and within delivered Hibernate engine. Database is Postgre 8.1.I've a problem with a generated query. The stack trace is (outtake):2006-08-01 16:12:53,273 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 427032006-08-01 16:12:53,273 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: column factactual0_.keydate does not exist2006-08-01 16:12:53,273 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select factactual0_.keydate as keydate291_, factactual0_.keyorga as keyorga291_, factactual0_.key as key291_, factactual0_.time as time291_, factactual0_.op_time as op6_291_, factactual0_.max as max291_, factactual0_.min as min291_, factactual0_.op_quantity as op9_291_ from fact_data_actual factactual0_ where factactual0_.keyoperation=? and (factactual0_.keyorga in (1 , 2 , 3))]org.postgresql.util.PSQLException: ERROR: column factactual0_.keydate does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)Following the bean code: private int keydate, keyorga; private float time, t

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the https://developer.jboss.org/thread/108125 company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million http://stackoverflow.com/questions/7467281/when-i-am-running-my-web-application-i-am-getting-following-error-how-to-resolve programmers, just like you, helping each other. Join them; it only takes a minute: Sign up When i am running my web application i am getting following error how to resolve this isuue [closed] up vote -1 down vote favorite When i am running my web application i am getting following error how to resolve this isuue.That is : java.lang.Exception: Myapp Web Application Starting at com.mycom.Myapp .manager.SystemServlet.contextInitialized(SystemServlet.java:31) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.in

Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.

Sign in Pricing Blog Support Search GitHub This repository Watch 82 Star 267 Fork 258 dotCMS/core Code Issues 1,547 Pull requests 2 Projects 0 Pulse Graphs New issue ERROR: column inode.theme does not exist #1402 Closed mabouza opened this Issue Oct 29, 2012 · 0 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 2 participants mabouza commented Oct 29, 2012 I updated master locally today and I got this exception when the server started up. Running master using postgres. [29/10/12 14:33:52:532 PDT] WARN util.JDBCExceptionReporter: SQL Error: 0, SQLState: 42703 [29/10/12 14:33:52:532 PDT] ERROR util.JDBCExceptionReporter: ERROR: column inode.theme does not exist Position: 529 [29/10/12 14:33:52:534 PDT] WARN util.JDBCExceptionReporter: SQL Error: 0, SQLState: 42703 [29/10/12 14:33:52:534 PDT] ERROR util.JDBCExceptionReporter: ERROR: column inode.theme does not exist Position: 529 [29/10/12 14:33:52:553 PDT] WARN db.HibernateUtil: ---------- DotHibernate: can't load- no results from query--------------- net.sf.hibernate.exception.SQLGrammarException: Could not execute query at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:58) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.dotmarketing.db.HibernateUtil.load(HibernateUtil.java:399) at com.dotmarketing.business.VersionableFactoryImpl.findLiveVersion(VersionableFactoryImpl.java:79) at com.dotmarketing.business.VersionableAPIImpl.findLiveVersion(VersionableAPIImpl.java:60) at com.dotmarketing.portlets.templates.business.TemplateAPIImpl.findLiveTemplate(TemplateAPIImpl.java:436) at com.dotmarketing.portlets.htmlpages.factories.HTMLPageFactory.getHTMLPageTemplate(HTMLPageFactory.java:123) at com.dotmarketing.services.PageServices.buildStr