3 Replies Latest reply on Nov 12, 2004 8:32 AM by David Abbey

    nukes-installer problem

    David Abbey Newbie

      Below is an excerpt from the error I get when I try to install MySql into Nukes. Waht am I doing wrong?

      21:36:57,965 INFO [STDOUT] path = /WEB-INF/setup/mysql.xml
      21:36:58,122 ERROR [STDERR] java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax near '; ' at line 1"
      21:36:58,124 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.checkErrorPacket(Mysql
      IO.java:1997)
      21:36:58,124 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.ja
      va:1167)
      21:36:58,125 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO
      .java:1278)
      21:36:58,125 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:
      1224)
      21:36:58,125 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.
      java:2244)
      21:36:58,125 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.
      java:2192)
      21:36:58,125 ERROR [STDERR] at com.mysql.jdbc.Statement.executeUpdate(Statem
      ent.java:1259)
      21:36:58,125 ERROR [STDERR] at com.mysql.jdbc.Statement.executeUpdate(Statem
      ent.java:1205)
      21:36:58,126 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedStatem
      ent.executeUpdate(WrappedStatement.java:262)
      21:36:58,126 ERROR [STDERR] at org.apache.jsp.execute_jsp.executeSQL(execute
      _jsp.java:257)
      21:36:58,126 ERROR [STDERR] at org.apache.jsp.execute_jsp.executeStatement(e
      xecute_jsp.java:242)
      21:36:58,126 ERROR [STDERR] at org.apache.jsp.execute_jsp._jspService(execut
      e_jsp.java:646)
      21:36:58,126 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service
      (HttpJspBase.java:137)
      21:36:58,126 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      21:36:58,127 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.s
      ervice(JspServletWrapper.java:210)
      21:36:58,127 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJ
      spFile(JspServlet.java:295)
      21:36:58,127 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(
      JspServlet.java:241)
      21:36:58,127 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      21:36:58,128 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterCha
      in.internalDoFilter(ApplicationFilterChain.java:247)
      21:36:58,128 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterCha
      in.doFilter(ApplicationFilterChain.java:193)
      21:36:58,128 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve
      .invoke(StandardWrapperValve.java:256)
      21:36:58,128 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      21:36:58,128 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      21:36:58,129 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      21:36:58,129 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve
      .invoke(StandardContextValve.java:191)
      21:36:58,129 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      21:36:58,129 ERROR [STDERR] at org.jboss.web.tomcat.security.JBossSecurityMg
      rRealm.invoke(JBossSecurityMgrRealm.java:220)
      21:36:58,131 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      21:36:58,131 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.
      invoke(CertificatesValve.java:246)
      21:36:58,131 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      21:36:58,131 ERROR [STDERR] at org.jboss.web.tomcat.tc4.statistics.Container
      StatsValve.invoke(ContainerStatsValve.java:76)
      21:36:58,132 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      21:36:58,132 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      21:36:58,132 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      21:36:58,132 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invo
      ke(StandardContext.java:2417)
      21:36:58,132 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.in
      voke(StandardHostValve.java:180)
      21:36:58,133 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      21:36:58,133 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherVal
      ve.invoke(ErrorDispatcherValve.java:171)
      21:36:58,133 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      21:36:58,133 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.i
      nvoke(ErrorReportValve.java:172)
      21:36:58,133 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      21:36:58,134 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssocia
      tionValve.invoke(SecurityAssociationValve.java:65)
      21:36:58,134 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      21:36:58,134 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.inv
      oke(AccessLogValve.java:577)
      21:36:58,134 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      21:36:58,135 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      21:36:58,135 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      21:36:58,135 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.
      invoke(StandardEngineValve.java:174)
      21:36:58,135 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      21:36:58,135 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      21:36:58,135 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      21:36:58,136 ERROR [STDERR] at org.apache.coyote.tomcat4.CoyoteAdapter.servi
      ce(CoyoteAdapter.java:197)
      21:36:58,136 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.proc
      ess(Http11Processor.java:781)
      21:36:58,136 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http1
      1ConnectionHandler.processConnection(Http11Protocol.java:549)
      21:36:58,136 ERROR [STDERR] at org.apache.tomcat.util.net.TcpWorkerThread.ru
      nIt(PoolTcpEndpoint.java:605)
      21:36:58,159 ERROR [STDERR] at org.apache.tomcat.util.threads.ThreadPool$Con
      trolRunnable.run(ThreadPool.java:677)
      21:36:58,159 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)

        • 1. Re: nukes-installer problem
          lcb Newbie

          What mysql version do you use?
          Mysql 3.2 has some problems with the semikolon at end of each row, but mysql 4.1 works well.

          • 2. Re: nukes-installer problem
            gator Newbie

            I had the same problem. I think mysql is not ignoring the garbage whitespace characters after the ';' on windows platforms. To fix, go into the JBOSS_HOME/server/default/deploy/nukes-installer.war/WEB-INF/setup/mysql.xml and remove all the whitespaces after the sql statement ending ';' characters.

            • 3. Re: nukes-installer problem
              David Abbey Newbie

              Here is what I did to correct the issue:

              1. I removed thee space from the .xml file after the semicolon. This appeared to fix the issue for mySQL 3. Thank you for the response and help.

              2. I then upgraded to mySQL 4 and put the old .xml file back to test it. It worked too! Thank you for the response on this as well.

              In short, thanks for the quick response and help resolving my issue. Now on to the next one! (See post about TEXT Vs BLOB data type).