StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POgetting org.hibernate.exception.SQLGrammarException:Table not found
text
Body
copied!<p>My code was working with BasicDataSource configuration. but when i have changed it to jndi-lookup (JNDI data source with JBOSS 7). i am getting below error.</p> <pre><code> 17:28:39,865 INFO [org.jboss.as.server.controller] (DeploymentScanner-threads - 2) Deployed "DocumentManager-0.0.1-SNAPSHOT.war" 17:28:50,616 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--127.0.0.1-8080-1) SQL Error: 42102, SQLState: 42S02 17:28:50,616 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--127.0.0.1-8080-1) Table "DOCUMENTS" not found; SQL statement: select document0_.id as id0_, document0_.created as created0_, document0_.description as descript3_0_, document0_.filename as filename0_, document0_.name as name0_ from DOCUMENTS document0_ [42102-145] 17:28:50,618 ERROR [stderr] (http--127.0.0.1-8080-1) org.hibernate.exception.SQLGrammarException: Table "DOCUMENTS" not found; SQL statement: 17:28:50,619 ERROR [stderr] (http--127.0.0.1-8080-1) select document0_.id as id0_, document0_.created as created0_, document0_.description as descript3_0_, document0_.filename as filename0_, document0_.name as name0_ from DOCUMENTS document0_ [42102-145] 17:28:50,622 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122) 17:28:50,622 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) 17:28:50,622 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) 17:28:50,622 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) 17:28:50,623 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146) 17:28:50,623 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) 17:28:50,624 ERROR [stderr] (http--127.0.0.1-8080-1) at com.sun.proxy.$Proxy27.prepareStatement(Unknown Source) 17:28:50,625 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147) 17:28:50,625 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166) 17:28:50,625 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145) 17:28:50,626 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1720) 17:28:50,627 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.Loader.doQuery(Loader.java:828) 17:28:50,627 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289) 17:28:50,627 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.Loader.doList(Loader.java:2447) 17:28:50,627 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.Loader.doList(Loader.java:2433) 17:28:50,627 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2263) 17:28:50,628 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.Loader.list(Loader.java:2258) 17:28:50,628 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470) 17:28:50,628 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355) 17:28:50,628 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:196) 17:28:50,628 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1161) 17:28:50,629 ERROR [stderr] (http--127.0.0.1-8080-1) at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) 17:28:50,629 ERROR [stderr] (http--127.0.0.1-8080-1) at com.ecom.data.access.dao.DocumentDAO.list(DocumentDAO.java:31) 17:28:50,629 ERROR [stderr] (http--127.0.0.1-8080-1) at com.ecom.data.access.dao.DocumentDAO$$FastClassByCGLIB$$9564c110.invoke(<generated>) 17:28:50,629 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) 17:28:50,629 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698) 17:28:50,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) 17:28:50,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) 17:28:50,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) 17:28:50,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) 17:28:50,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 17:28:50,631 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631) 17:28:50,631 ERROR [stderr] (http--127.0.0.1-8080-1) at com.ecom.data.access.dao.DocumentDAO$$EnhancerByCGLIB$$48352a12.list(<generated>) 17:28:50,631 ERROR [stderr] (http--127.0.0.1-8080-1) at com.ecom.data.access.controller.DocumentController.index(DocumentController.java:42) 17:28:50,631 ERROR [stderr] (http--127.0.0.1-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 17:28:50,631 ERROR [stderr] (http--127.0.0.1-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 17:28:50,632 ERROR [stderr] (http--127.0.0.1-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 17:28:50,632 ERROR [stderr] (http--127.0.0.1-8080-1) at java.lang.reflect.Method.invoke(Method.java:597) 17:28:50,632 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) 17:28:50,632 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440) 17:28:50,633 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428) 17:28:50,633 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) 17:28:50,633 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) 17:28:50,633 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936) 17:28:50,634 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827) 17:28:50,634 ERROR [stderr] (http--127.0.0.1-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) 17:28:50,634 ERROR [stderr] (http--127.0.0.1-8080-1) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) 17:28:50,634 ERROR [stderr] (http--127.0.0.1-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 17:28:50,634 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 17:28:50,635 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 17:28:50,635 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) 17:28:50,635 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) 17:28:50,635 ERROR [stderr] (http--127.0.0.1-8080-1) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139) 17:28:50,635 ERROR [stderr] (http--127.0.0.1-8080-1) at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) 17:28:50,636 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) 17:28:50,636 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 17:28:50,636 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 17:28:50,636 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) 17:28:50,636 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) 17:28:50,636 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) 17:28:50,637 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952) 17:28:50,637 ERROR [stderr] (http--127.0.0.1-8080-1) at java.lang.Thread.run(Thread.java:662) 17:28:50,637 ERROR [stderr] (http--127.0.0.1-8080-1) Caused by: org.h2.jdbc.JdbcSQLException: Table "DOCUMENTS" not found; SQL statement: 17:28:50,637 ERROR [stderr] (http--127.0.0.1-8080-1) select document0_.id as id0_, document0_.created as created0_, document0_.description as descript3_0_, document0_.filename as filename0_, document0_.name as name0_ from DOCUMENTS document0_ [42102-145] </code></pre> <p>Please find spring config below.</p> <pre><code> <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:lang="http://www.springframework.org/schema/lang" xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd"> <context:annotation-config /> <context:component-scan base-package="com.ecom.data.access" /> <bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/WEB-INF/views/" /> <property name="suffix" value=".jsp" /> </bean> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" p:location="/WEB-INF/jdbc.properties" /> <util:properties id="documentManagerProperties" location="classpath:jdbc.properties" /> <jee:jndi-lookup id="usermanagementDataSource" jndi-name="java:jboss/datasources/usermanagementDataSource" /> <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> <property name="dataSource" ref="usermanagementDataSource" /> <property name="configLocation"> <value>classpath:hibernate.cfg.xml</value> </property> <property name="hibernateProperties" ref="documentManagerProperties">  </property> </bean> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">  <property name="maxUploadSize" value="10000000" /> </bean> <tx:annotation-driven /> <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean> </beans> </code></pre> <p>Entity class:</p> <pre><code> package com.ecom.data.access.model; //import java.sql.Blob; import java.sql.Blob; import java.sql.Date; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Lob; //import javax.persistence.Lob; import javax.persistence.Table; @Entity @Table(name="DOCUMENTS") public class Document { @Id @GeneratedValue @Column(name="id") private Integer id; @Column(name="name") private String name; @Column(name="description") private String description; @Column(name="filename") private String filename; /* @Column(name="content") @Lob private Blob content;*/ /*public Blob getContent() { return content; } public void setContent(Blob content) { this.content = content; }*/ /*@Column(name="content_type") private String contentType;*/ @Column(name="created") private Date created; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } public String getFilename() { return filename; } public void setFilename(String filename) { this.filename = filename; } /*public String getContentType() { return contentType; } public void setContentType(String contentType) { this.contentType = contentType; }*/ public Date getCreated() { return created; } public void setCreated(Date created) { this.created = created; } } </code></pre> <p>DocumetDAO is:</p> <pre><code> package com.ecom.data.access.dao; import java.util.List; import com.ecom.data.access.model.Document; import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import org.springframework.transaction.annotation.Transactional; @Repository public class DocumentDAO { @Autowired private SessionFactory sessionFactory; @Transactional public void save(Document document) { Session session = sessionFactory.getCurrentSession(); session.save(document); } @Transactional public List<Document> list() { Session session = sessionFactory.getCurrentSession(); List<Document> documents = null; try { documents = (List<Document>)session.createQuery("from Document").list(); System.out.println("List of Document here----> "+ list().get(0)); } catch (HibernateException e) { e.printStackTrace(); } return documents; } @Transactional public Document get(Integer id) { Session session = sessionFactory.getCurrentSession(); System.out.println("id is---------------------> "+ id); return (Document)session.get(Document.class, id); } /* @Transactional public void remove(Integer id) { Session session = sessionFactory.getCurrentSession(); Document document = (Document)session.get(Document.class, id); session.delete(document); }*/ } </code></pre> <p>Table is:</p> <pre><code> CREATE TABLE `documents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `description` text NOT NULL, `filename` varchar(200), `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ); </code></pre> <p>Please help me to find out the solution. Thanks in advance </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload