- This topic has 8 replies, 5 voices, and was last updated 18 years, 3 months ago by Haris Peco.
-
AuthorPosts
-
RussMemberDoes MyEclipse has a problem with generating Hibernate mapping files? I am using MySQL 5.0. IS this a known problem?
The Generated Hibnerate Mapping File: Catalog.hbm.xml
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- Mapping file autogenerated by MyEclipse - Hibernate Tools --> <hibernate-mapping> <class name="com.rrcorp.hibernate.Catalog" table="catalog" catalog="test"> <id name="catalogId" type="integer"> <column name="CatalogId" /> <generator class="native" /> </id> <property name="journal" type="string"> <column name="Journal" length="25" /> </property> <property name="publisher" type="string"> <column name="Publisher" length="25" /> </property> <property name="date" type="string"> <column name="Date" length="25" /> </property> <property name="title" type="string"> <column name="Title" length="45" /> </property> <property name="author" type="string"> <column name="Author" length="25" /> </property> </class> </hibernate-mapping>
The error running the application with this making
[20:25:29,093] [WARN ] [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 [20:25:29,093] [ERROR] [JDBCExceptionReporter] Table 'test.test__catalog' doesn't exist [20:25:29,109] [ERROR] [[jsp]] Servlet.service() for servlet jsp threw exception org.hibernate.exception.SQLGrammarException: could not execute query using iterate at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:432) at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:281) at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:935) at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41) at com.rrcorp.hibernate.CatalogService.getCatalogList(CatalogService.java:33) at org.apache.jsp.AddJournal_jsp._jspService(org.apache.jsp.AddJournal_jsp:126) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 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.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) 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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Table 'test.test__catalog' doesn't exist at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2978) at com.mysql.jdbc.Connection.execSQL(Connection.java:2902) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120) at org.hibernate.loader.Loader.getResultSet(Loader.java:1272) at org.hibernate.loader.Loader.getResultSet(Loader.java:1252) at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:411) ... 30 more
The corrected mapping file that works: Catalog.hbm.xml
** Note the catalog attribute is gone for the class element<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- Mapping file autogenerated by MyEclipse - Hibernate Tools --> <hibernate-mapping> <class name="com.rrcorp.hibernate.Catalog" table="catalog"> <id name="catalogId" type="integer"> <column name="CatalogId" /> <generator class="native"></generator> </id> <property name="journal" type="string"> <column name="Journal" length="25" /> </property> <property name="publisher" type="string"> <column name="Publisher" length="25" /> </property> <property name="date" type="string"> <column name="Date" length="25" /> </property> <property name="title" type="string"> <column name="Title" length="45" /> </property> <property name="author" type="string"> <column name="Author" length="25" /> </property> </class> </hibernate-mapping>
Haris PecoMemberrussray,
Please, send us schema script (create table command) for test
Thanks
RussMemberThis is not a complicated database.
create table `test`.`catalog`( `CatalogId` int(11) PRIMARY KEY default '0' not null, `Journal` varchar(25), `Publisher` varchar(25), `Date` varchar(25), `Title` varchar(45), `Author` varchar(25))
Haris PecoMemberrussray,
You are correct.This is bug.It will be resolved in 4.1.1 (I hope)
Thanks for your feedback
timmysMemberfuck
julioeduardoMember@support-snpe wrote:
russray,
You are correct.This is bug.It will be resolved in 4.1.1 (I hope)
Thanks for your feedback
I use the version 4.1.1. The problem persists. What I do?
Haris PecoMemberThis message has not been recovered.
Ken NelsonMemberThis message has not been recovered.
Haris PecoMemberThis message has not been recovered.
-
AuthorPosts