[ISSUES] Closed: (JLCP-215) Exception creating root category of files

Message:

   The following issue has been closed.

   Resolver: Matthew Schmidt
       Date: Mon, 16 Jun 2003 4:31 PM

That was due to me having no local.properties file.  It was trying to use postgres somewhere.
---------------------------------------------------------------------
View the issue:

  http://jira.jlcp.org/secure/ViewIssue.jspa?key=JLCP-215


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: JLCP-215
    Summary: Exception creating root category of files
       Type: Bug

     Status: Closed
   Priority: Blocker
 Resolution: FIXED

 Time Spent: Unknown
   Estimate: 0 minutes

    Project: Javalobby Community Platform
 Components: 
             File Center
   Fix Fors:
             0.9.0 (Jupiter)
   Versions:
             0.9.0 (Jupiter)

   Assignee: Matthew Schmidt
   Reporter: Matthew Schmidt

    Created: Sat, 14 Jun 2003 7:00 PM
    Updated: Mon, 16 Jun 2003 4:31 PM

Description:
This one is weird.  It looks just like the Links stuff which works fine.  IT appears that hibernate is generating something bad around its sequencing:

SEVERE: Syntax error or access violation,  message from server: "You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '('hibernate_sequence')' at line 1"
Jun 14, 2003 6:55:59 PM net.sf.hibernate.JDBCException <init>
SEVERE: Could not save object
java.sql.SQLException: Syntax error or access violation,  message from server: "You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '('hibernate_sequence')' at line 1"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1613)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:880)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:939)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:1780)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1439)
        at com.evermind._hpb.executeQuery(.:269)
        at com.evermind._hpb.executeQuery(.:269)
        at com.evermind._hpb.executeQuery(.:269)
        at net.sf.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:61)
        at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:611)
        at org.jlcp.infrastructure.persistence.hibernate.HibernateSession.save(HibernateSession.java:108)
        at org.jlcp.module.filecenter.provider.hibernate.dao.FilesDAO.getRootCategory(FilesDAO.java:212)
        at org.jlcp.module.filecenter.provider.hibernate.dao.FilesDAO.<init>(FilesDAO.java:55)
        at org.jlcp.module.filecenter.factory.FilesDAOFactory.getFilesDAO(FilesDAOFactory.java:68)
        at org.jlcp.module.filecenter.FileCenterManager.<init>(FileCenterManager.java:63)
        at org.jlcp.module.filecenter.FileCenterManager.getInstance(FileCenterManager.java:73)
        at org.jlcp.module.filecenter.web.taglib.category.RootFileCategoryTag.doStartTag(RootFileCategoryTag.java:53)
        at __jspPage0_modules_filecenter_index_jsp._jspService(__jspPage0_modules_filecenter_index_jsp.java:173)
        at com.orionserver.http.OrionHttpJspPage.service(.:68)
        at com.evermind._ct._cxd(.:5703)
        at com.evermind.server.http.JSPServlet.service(.:31)
        at com.evermind._it.doFilter(.:59)
        at org.jlcp.infrastructure.persistence.hibernate.web.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:62)
        at com.evermind._efb._plc(.:384)
        at com.evermind._efb.include(.:90)
        at com.evermind.server.http.EvermindPageContext.include(.:285)
        at org.jlcp.layout.web.taglib.ColumnTag.doEndTag(ColumnTag.java:93)
        at __jspPage0_layouts_rootLayout_jsp._jspService(__jspPage0_layouts_rootLayout_jsp.java:355)
        at com.orionserver.http.OrionHttpJspPage.service(.:68)
        at com.evermind._ct._cxd(.:5703)
        at com.evermind.server.http.JSPServlet.service(.:31)
        at com.evermind._it.doFilter(.:59)
        at org.jlcp.infrastructure.persistence.hibernate.web.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:62)
        at com.evermind._efb._plc(.:384)
        at com.evermind._efb._adc(.:174)
        at com.evermind._efb.forward(.:144)
        at org.jlcp.layout.RequestProcessor.doForward(RequestProcessor.java:453)
        at org.jlcp.layout.RequestProcessor.processInherits(RequestProcessor.java:346)
        at org.jlcp.layout.RequestProcessor.process(RequestProcessor.java:155)
        at org.jlcp.layout.web.LayoutServlet.process(LayoutServlet.java:219)
        at org.jlcp.layout.web.LayoutServlet.doGet(LayoutServlet.java:146)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:195)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
        at com.evermind._it.doFilter(.:59)
        at org.jlcp.infrastructure.persistence.hibernate.web.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:62)
        at com.evermind._efb._plc(.:384)
        at com.evermind._efb._adc(.:174)
        at com.evermind._cs._yqb(.:614)
        at com.evermind._cs._yrb(.:189)
        at com.evermind._bx.run(.:62)



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://jira.jlcp.org/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira