Jboss - mysql - Syntax error

From: Philipp Neuhaus (cletus_at_despammed.com)
Date: 01/10/05

  • Next message: Chuck: "Portable way to pass array parameter to a stored proc?" 
    Date: Mon, 10 Jan 2005 22:40:52 +0100

    Hi,
    I've got a problem with my JBoss:
    22:32:54,176 ERROR [DatabasePersistencePolicy] Starting failed
    jboss.ejb:persistencePolicy=database,service=EJBTimerService
    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
    'INTERVAL bigint,
               INSTANCEPK other,
               INFO o"
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at
            com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at
            com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at
            com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at
            com.mysql.jdbc.Connection.execSQL(Connection.java:2248)

    I'm using mySQL-max 4.0.18 on a Linux machine, Jboss 4.0.0.

    It seems to work with Jboss 4.0.0 and mySQL 4.0.20d on WinXP.

    Does anybody has an idea to solve the problem?

    thanks
    Philipp

  • Next message: Chuck: "Portable way to pass array parameter to a stored proc?"

    Relevant Pages

    • Re: Problem with bind_param using DBD::mysql
      ... >>>placeholders in the server, via CVS (or I can package it and send it ... syntax; check the manual that corresponds to your MySQL server version ... FAILED tests 73-351 ...
      (perl.dbi.users)
    • JBoss Websphere Admin
      ... JBoss Websphere Admin ... Installation and patches to the JVM 1.5 ... Extensions management Security Management of real server resource use ... this person must be able to install and configure Java ...
      (comp.lang.java.beans)
    • Maybe this is good for VMS, maybe not
      ... JBoss Alliance In Anti-IBM Move ... announce broad-based support for the popular MySQL database and JBoss ... open-source model and profitability need not be mutually exclusive. ... database and the JBoss open-source application server on its servers, ...
      (comp.os.vms)
    • Re: New notation
      ... develop an application some customers will want to ... that anybody would be willing to pay for me to develop. ... application on Jboss 3.0 application server. ...
      (comp.lang.lisp)
    • Re: Differnce between Java Bean and Enterprise Java Bean
      ... > server components. ... Enterprise Java Bean was probably not the best name ... > the enterprise applications then JBoss is good choise. ... pre-wired version with Tomcat or Jetty as the servlet container). ...
      (comp.lang.java.programmer)