Hibernate Community • View topic - Incorrect syntax near the keyword 'from'.

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Incorrect syntax near the keyword 'from'.

Page 1 of 1

[ 9 posts ]

Previous topic | Next topic

Author

Message

zufenghuang

Post subject: Incorrect syntax near the keyword 'from'.

Posted: Wed Sep 14, 2005 5:11 am

Newbie

Joined: Wed Sep 14, 2005 4:57 am
Posts: 5

Hi, all

I am suffering a HQL error, error massage:

Quote:

16:56:31,281 ERROR [JDBCExceptionReporter] Incorrect syntax near the keyword 'from'.

16:56:31,281 WARN [JDBCExceptionReporter] SQL Error: 156, SQLState: ZZZZZ
16:56:31,281 ERROR [JDBCExceptionReporter] Incorrect syntax near the keyword 'from'.

16:56:31,331 ERROR [STDERR] net.sf.hibernate.exception.GenericJDBCException: Cou
ld not execute query at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificExcept
ion(SQLStateConverter.java:80)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverte
r.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionH
elper.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.sungoal.km.dao.knowledge.KnowledgeBaseDAO.getKnowledgeBasesByHql(
KnowledgeBaseDAO.java:73)
.....................

Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near the keyw
ord 'from'.

at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:3069)
at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2373)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(SybStatement.java:1705)
at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(SybStatement.java:169
0)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(SybPreparedSt
atement.java:97)

The environment is: windows2k+sybase12.5+hibernate2+jconn3.

The HQL is:

Code:

select knowledgeBases from com.sungoal.km.po.KnowledgeBase as knowledgeBases left outer join knowledgeBases.mapNodes as mapNodes where mapNodes.id = 18 and knowledgeBases.isRejected = false and knowledgeBases.isDeleted = false and knowledgeBases.isReleased = true order by knowledgeBases.creationTime desc

The method call this HQL:

Code:

      Session session = null;
      Transaction transaction = null;
      try{
         session = (Session)HibernateBase.getCurrentSession();
         transaction = HibernateBase.getTransaction(session);
         String queryString = hql;
         Query query = session.createQuery(queryString);
         query.setFirstResult(0);
         query.setMaxResults(50);

         List list = query.list();         
         transaction.commit();
         HibernateBase.closeTransaction();
         HibernateBase.closeSession();

Many other methods on this table using alike HQL are working, but this won't, and i can't figure the problem.

Anybody can help?

Top

gavin

Post subject:

Posted: Wed Sep 14, 2005 5:17 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

You must show the generated SQL.

http://www.hibernate.org/ForumMailingli ... AskForHelp

Top

ErikFK

Post subject:

Posted: Wed Sep 14, 2005 5:20 am

Pro

Joined: Fri Sep 02, 2005 4:21 am
Posts: 206
Location: Vienna

Hi,

Have you turned Hibernate's SQL trace on? Seeing the SQL it generates may help understand what goes wrong.

Erik

Top

zufenghuang

Post subject:

Posted: Wed Sep 14, 2005 5:45 am

Newbie

Joined: Wed Sep 14, 2005 4:57 am
Posts: 5

See the following lines.

Quote:

.............
2005-09-14 17:37:53,330 INFO [STDOUT] Hibernate: select mapnodes0_.knowledge_base_id as knowledg1___, mapnodes0_.map_node_id as map_node2___, mapnode1_.map_node_id as map_node1_0_, mapnode1_.name as name0_, mapnode1_.displayname as displayn4_0_, mapnode1_.description as descript5_0_, mapnode1_.isDeleted as isDeleted0_, mapnode1_.map_type_id as map_type7_0_, mapnode1_.parent_map_node_id as parent_m8_0_ from KnowledgeBases_MapNodes mapnodes0_ inner join MapNodes mapnode1_ on mapnodes0_.map_node_id=mapnode1_.map_node_id where mapnodes0_.knowledge_base_id=?
2005-09-14 17:37:53,350 INFO [STDOUT] Hibernate: select mapnodes0_.knowledge_base_id as knowledg1___, mapnodes0_.map_node_id as map_node2___, mapnode1_.map_node_id as map_node1_0_, mapnode1_.name as name0_, mapnode1_.displayname as displayn4_0_, mapnode1_.description as descript5_0_, mapnode1_.isDeleted as isDeleted0_, mapnode1_.map_type_id as map_type7_0_, mapnode1_.parent_map_node_id as parent_m8_0_ from KnowledgeBases_MapNodes mapnodes0_ inner join MapNodes mapnode1_ on mapnodes0_.map_node_id=mapnode1_.map_node_id where mapnodes0_.knowledge_base_id=?
2005-09-14 17:37:53,430 INFO [STDOUT] Hibernate: select from
2005-09-14 17:37:53,430 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 156, SQLState: ZZZZZ
2005-09-14 17:37:53,430 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Incorrect syntax near the keyword 'from'.

2005-09-14 17:37:53,430 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 156, SQLState: ZZZZZ
2005-09-14 17:37:53,430 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Incorrect syntax near the keyword 'from'.

2005-09-14 17:37:53,480 ERROR [STDERR] net.sf.hibernate.exception.GenericJDBCException: Could not execute query
at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
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.sungoal.km.dao.knowledge.KnowledgeBaseDAO.getKnowledgeBasesByHql(KnowledgeBaseDAO.java:107)
at com.sungoal.brim.action.docmanagement.TopindexAction.execute(TopindexAction.java:248)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at com.sungoal.brim.ChineseActionServlet.process(ChineseActionServlet.java:38)

..........

There are many lines before, but i don't think that's the error HQL generated.

And I can't understand this the last line before error message occures.

Quote:

"2005-09-14 17:37:53,430 INFO [STDOUT] Hibernate: select from"

What's the problem?

Top

ErikFK

Post subject:

Posted: Wed Sep 14, 2005 6:22 am

Pro

Joined: Fri Sep 02, 2005 4:21 am
Posts: 206
Location: Vienna

Did you notice the line

zufenghuang wrote:

Code:

2005-09-14 17:37:53,430 INFO [STDOUT] Hibernate: select from

It indicates that Hibernates produces an empty SELECT FROM statement - which Sybase of course doesn't accept.

With the code you sent I really can't think of any reason why this could happen... A bit weird I must say

Erik

Top

gavin

Post subject:

Posted: Wed Sep 14, 2005 12:02 pm

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

The other thing we would need is the whole stack trace.

Top

zufenghuang

Post subject:

Posted: Wed Sep 14, 2005 9:23 pm

Newbie

Joined: Wed Sep 14, 2005 4:57 am
Posts: 5

Hope this help you to analysis.

Quote:

2005-09-14 18:16:02,732 INFO [STDOUT] Hibernate: select maptype0_.map_type_id as map_type1_0_, maptype0_.name as name0_, maptype0_.displayname as displayn3_0_, maptype0_.description as descript4_0_ from MapTypes maptype0_ where maptype0_.map_type_id=?
2005-09-14 18:16:02,742 INFO [STDOUT] Hibernate: select mapnode0_.map_node_id as map_node1_1_, mapnode0_.name as name1_, mapnode0_.displayname as displayn4_1_, mapnode0_.description as descript5_1_, mapnode0_.isDeleted as isDeleted1_, mapnode0_.map_type_id as map_type7_1_, mapnode0_.parent_map_node_id as parent_m8_1_, maptype1_.map_type_id as map_type1_0_, maptype1_.name as name0_, maptype1_.displayname as displayn3_0_, maptype1_.description as descript4_0_ from MapNodes mapnode0_ left outer join MapTypes maptype1_ on mapnode0_.map_type_id=maptype1_.map_type_id where mapnode0_.map_node_id=?
2005-09-14 18:16:02,762 INFO [STDOUT] Hibernate: select childrenma0_.parent_map_node_id as parent_m8___, childrenma0_.map_node_id as map_node1___, childrenma0_.map_node_id as map_node1_1_, childrenma0_.name as name1_, childrenma0_.displayname as displayn4_1_, childrenma0_.description as descript5_1_, childrenma0_.isDeleted as isDeleted1_, childrenma0_.map_type_id as map_type7_1_, childrenma0_.parent_map_node_id as parent_m8_1_, maptype1_.map_type_id as map_type1_0_, maptype1_.name as name0_, maptype1_.displayname as displayn3_0_, maptype1_.description as descript4_0_ from MapNodes childrenma0_ left outer join MapTypes maptype1_ on childrenma0_.map_type_id=maptype1_.map_type_id where childrenma0_.parent_map_node_id=?
2005-09-14 18:16:02,782 INFO [STDOUT] Hibernate: select childrenma0_.parent_map_node_id as parent_m8___, childrenma0_.map_node_id as map_node1___, childrenma0_.map_node_id as map_node1_1_, childrenma0_.name as name1_, childrenma0_.displayname as displayn4_1_, childrenma0_.description as descript5_1_, childrenma0_.isDeleted as isDeleted1_, childrenma0_.map_type_id as map_type7_1_, childrenma0_.parent_map_node_id as parent_m8_1_, maptype1_.map_type_id as map_type1_0_, maptype1_.name as name0_, maptype1_.displayname as displayn3_0_, maptype1_.description as descript4_0_ from MapNodes childrenma0_ left outer join MapTypes maptype1_ on childrenma0_.map_type_id=maptype1_.map_type_id where childrenma0_.parent_map_node_id=?
2005-09-14 18:16:02,802 INFO [STDOUT] Hibernate: select childrenma0_.parent_map_node_id as parent_m8___, childrenma0_.map_node_id as map_node1___, childrenma0_.map_node_id as map_node1_1_, childrenma0_.name as name1_, childrenma0_.displayname as displayn4_1_, childrenma0_.description as descript5_1_, childrenma0_.isDeleted as isDeleted1_, childrenma0_.map_type_id as map_type7_1_, childrenma0_.parent_map_node_id as parent_m8_1_, maptype1_.map_type_id as map_type1_0_, maptype1_.name as name0_, maptype1_.displayname as displayn3_0_, maptype1_.description as descript4_0_ from MapNodes childrenma0_ left outer join MapTypes maptype1_ on childrenma0_.map_type_id=maptype1_.map_type_id where childrenma0_.parent_map_node_id=?
2005-09-14 18:16:02,812 INFO [STDOUT] Hibernate: select mapnodes0_.knowledge_base_id as knowledg1___, mapnodes0_.map_node_id as map_node2___, mapnode1_.map_node_id as map_node1_0_, mapnode1_.name as name0_, mapnode1_.displayname as displayn4_0_, mapnode1_.description as descript5_0_, mapnode1_.isDeleted as isDeleted0_, mapnode1_.map_type_id as map_type7_0_, mapnode1_.parent_map_node_id as parent_m8_0_ from KnowledgeBases_MapNodes mapnodes0_ inner join MapNodes mapnode1_ on mapnodes0_.map_node_id=mapnode1_.map_node_id where mapnodes0_.knowledge_base_id=?
2005-09-14 18:16:02,832 INFO [STDOUT] Hibernate: select mapnodes0_.knowledge_base_id as knowledg1___, mapnodes0_.map_node_id as map_node2___, mapnode1_.map_node_id as map_node1_0_, mapnode1_.name as name0_, mapnode1_.displayname as displayn4_0_, mapnode1_.description as descript5_0_, mapnode1_.isDeleted as isDeleted0_, mapnode1_.map_type_id as map_type7_0_, mapnode1_.parent_map_node_id as parent_m8_0_ from KnowledgeBases_MapNodes mapnodes0_ inner join MapNodes mapnode1_ on mapnodes0_.map_node_id=mapnode1_.map_node_id where mapnodes0_.knowledge_base_id=?
2005-09-14 18:16:02,912 INFO [STDOUT] Hibernate: select from
2005-09-14 18:16:02,912 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 156, SQLState: ZZZZZ
2005-09-14 18:16:02,922 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Incorrect syntax near the keyword 'from'.

2005-09-14 18:16:02,922 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 156, SQLState: ZZZZZ
2005-09-14 18:16:02,922 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Incorrect syntax near the keyword 'from'.

2005-09-14 18:16:02,962 ERROR [STDERR] net.sf.hibernate.exception.GenericJDBCException: Could not execute query
at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
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.sungoal.km.dao.knowledge.KnowledgeBaseDAO.getKnowledgeBasesByHql(KnowledgeBaseDAO.java:107)
at com.sungoal.brim.action.docmanagement.TopindexAction.execute(TopindexAction.java:248)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at com.sungoal.brim.ChineseActionServlet.process(ChineseActionServlet.java:38)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.sungoal.brim.PermissionMonitorFilter.doFilter(PermissionMonitorFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.jboss.web.catalina.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:227)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near the keyword 'from'.

at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:3069)
at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2373)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(SybStatement.java:1705)
at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(SybStatement.java:1690)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:97)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
... 48 more
2005-09-14 18:16:03,112 INFO [STDOUT] net.sf.hibernate.exception.GenericJDBCException: Could not execute query
2005-09-14 18:16:03,132 ERROR [STDERR] net.sf.hibernate.HibernateException: net.sf.hibernate.exception.GenericJDBCException: Could not execute query
at com.sungoal.km.dao.knowledge.KnowledgeBaseDAO.getKnowledgeBasesByHql(KnowledgeBaseDAO.java:172)
at com.sungoal.brim.action.docmanagement.TopindexAction.execute(TopindexAction.java:248)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at com.sungoal.brim.ChineseActionServlet.process(ChineseActionServlet.java:38)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.sungoal.brim.PermissionMonitorFilter.doFilter(PermissionMonitorFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.jboss.web.catalina.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:227)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
Caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute query
at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
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.sungoal.km.dao.knowledge.KnowledgeBaseDAO.getKnowledgeBasesByHql(KnowledgeBaseDAO.java:107)
... 46 more
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near the keyword 'from'.

at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:3069)
at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2373)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(SybStatement.java:1705)
at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(SybStatement.java:1690)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:97)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
... 48 more

Top

zufenghuang

Post subject:

Posted: Wed Sep 14, 2005 9:25 pm

Newbie

Joined: Wed Sep 14, 2005 4:57 am
Posts: 5

KnowledgeBase.hbm.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping package="com.sungoal.km.po">
   <class name="KnowledgeBase" table="KnowledgeBases">

        <id name="id" type="long" >
            <column name="knowledge_base_id"/>
            <generator class="native"/>
        </id>
        
      <discriminator type="string"/>
      
      
        <property column="name" insert="true" name="name" not-null="true" type="string" update="true"/>
        
        <property column="displayname" insert="true" name="displayname" type="string" update="true"/>
        <property column="subject" insert="true" name="subject" type="string" update="true"/>
        <property column="internal_code" insert="true" name="internalCode" type="string" update="true"/>
        <property column="abstract" insert="true" name="abs" type="string" update="true" />
        <property column="description" insert="true" length="2048" name="description" type="string" update="true"/>
        <property column="author" insert="true" name="author" type="string" update="true"/>
        <property column="author_description" insert="true" name="authorDescription" type="string" update="true"/>
        <property column="difficulty_level" insert="true" name="difficultyLevel" type="string" update="true"/>
        <property column="keywords" insert="true" name="keywords" type="string" update="true"/>        
        <property column="contentLength" insert="true" name="contentLength" type="long" update="true"/>
        <property column="creaton_time" insert="true" name="creationTime" not-null="true" type="timestamp" update="true"/>
        <property column="release_time" insert="true" name="releaseTime" type="timestamp" update="true"/>
        <property column="lastModified" insert="true" name="lastModified" type="timestamp" update="true"/>
        <property column="uri" insert="true" name="uri" not-null="true" type="string" update="true"/>
        <property column="total_click" insert="true" name="totalClick" type="long" update="true"/>
        <property column="average_rate" insert="true" name="averageRate" type="double" update="true"/>
        <property column="is_virtual" insert="true" name="isVirtual" not-null="true" type="boolean" update="true"/>
        <property column="is_version" insert="true" name="isVersion" not-null="true" type="boolean" update="true"/>
        <property column="is_released" insert="true" name="isReleased" not-null="true" type="boolean" update="true"/>
        <property column="is_rejected" insert="true" name="isRejected" not-null="true" type="boolean" update="true"/>
        <property column="is_deleted" insert="true" name="isDeleted" not-null="true" type="boolean" update="true"/>
        <property column="contents" insert="true" length="2048" name="contents" not-null="false" type="string" update="true"/>
        <property column="creator" insert="true" name="creator" not-null="false" type="long" update="true"/>
        <property column="department_id" insert="true" name="department" not-null="false" type="long" update="true"/>
        
        <property column="current_version" insert="true" name="currentVersion" not-null="true" type="string" update="true"/>
      <property  column="total_rate" insert="true" name="totalRate" type="double" update="true"/>
      <property  column="rate_number" insert="true" name="rateNumber" type="double" update="true"/>
      
      
      <property column="submitInfo" insert="true" name="submitInfo" type="string" length="2048" update="true"/>
      <property column="rejectInfo" insert="true" name="rejectInfo" type="string" length="2048" update="true"/>

<!-- Add by tony-->
      <property column="writer" insert="true" name="writer" type="string" update="true"/>   
      <property column="source" insert="true" name="source" type="string" update="true"/>   
      <property column="recommend" insert="true" name="recommend" type="string" update="true"/>
      <property column="collector" insert="true" name="collector" type="string" update="true"/>
      <property column="editor" insert="true" name="editor" type="string" update="true"/>
<!--      
      <many-to-one class="KnowledgeType" column="knowledge_type_id" name="knowledgeType"/>
-->
      <set cascade="all" inverse="true" lazy="true" name="kmFiles">         
            <key column="knowledge_base_id"/>
            <one-to-many class="KMFile"/>
      </set>
            
      <set cascade="all" inverse="false" lazy="false" name="mapNodes" table="KnowledgeBases_MapNodes">
            <key column="knowledge_base_id"/>
            <many-to-many class="MapNode" column="map_node_id" outer-join="auto"/>
      </set>      
<!--
      <set cascade="all" inverse="true" lazy="true" name="knowledgeExts">         
            <key column="knowledge_base_id"/>
            <one-to-many class="KnowledgeExt"/>
      </set>
-->      
      <set cascade="all" inverse="true" lazy="true" name="knowledgeGrades">         
            <key column="knowledge_base_id"/>
            <one-to-many class="KnowledgeGrade"/>
      </set>
      
      <set cascade="all" inverse="true" lazy="true" name="knowledgeClicks">         
            <key column="knowledge_base_id"/>
            <one-to-many class="KnowledgeClick"/>
      </set>
      
      <set cascade="all" inverse="true" lazy="true" name="knowledgeComments">         
            <key column="knowledge_base_id"/>
            <one-to-many class="KnowledgeComment"/>
      </set>
      
      
      <set cascade="all" inverse="true" lazy="true" name="collectionNodes">
            <key column="knowledge_base_id"/>
            <one-to-many class="CollectionNode"/>
      </set>   
      
      <many-to-one class="SecurityLevel" column="level_id" name="level" not-null="true"/>   

   </class>   
</hibernate-mapping>

Top

zufenghuang

Post subject:

Posted: Wed Sep 14, 2005 9:26 pm

Newbie

Joined: Wed Sep 14, 2005 4:57 am
Posts: 5

MapNode.hbm.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping package="com.sungoal.km.po">
   <class name="MapNode" table="MapNodes">

        <id name="id" type="long" >
            <column  name="map_node_id"/>
            <generator class="native"/>
        </id>
        
      <discriminator type="string"/>
      
      
        <property column="name" insert="true" name="name" not-null="true" type="string" update="true"/>
        
        <property column="displayname" insert="true" name="displayname" type="string" update="true"/>

        <property column="description" insert="true" name="description" type="string" update="true"/>
      
      <property column="isDeleted" insert="true" name="isDeleted" type="boolean" update="true"/>
      
      <many-to-one column="map_type_id" name="mapType" not-null="true"/>        
      
      <set cascade="all" lazy="true" name="knowledgeBases" table="KnowledgeBases_MapNodes" inverse="true">
            <key column="map_node_id" />
            <many-to-many class="KnowledgeBase" column="knowledge_base_id" outer-join="auto"/>
      </set>
            
      <set cascade="all" inverse="true" lazy="false" name="childrenMapNodes">         
            <key column="parent_map_node_id"/>
            <one-to-many class="MapNode"/>
      </set>
      
      <many-to-one column="parent_map_node_id" name="parentMapNode" />
        
   </class>   
</hibernate-mapping>

Top

Page 1 of 1

[ 9 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum