"FUNCTION dbo.dateadd does not exist" in Llnux mysql server

Results 1 to 2 of 2
  1. #1
    Apprentice netfrog is offline
    MemberRank
    Dec 2006 Join Date
    5Posts

    "FUNCTION dbo.dateadd does not exist" in Llnux mysql server

    Old thread has been deleted, I can't find any solution,anyone can help?

    maybe the "dateadd" and "datediff" functions in MSSQL are not compatible with mysql

    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION dbo.dateadd does not exist
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
    at application.query.handler.executeQuery(Unknown Source)
    at application.query.select.handler.execute(Unknown Source)
    at application.query.select.handler.execute(Unknown Source)
    at com.goldhuman.account.storage.getUseCashNow(storage.java:977)
    at protocol.GAuthServer$1.run(Unknown Source)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
    Sending query to acquire password
    Prepare procedure call:{call acquireuserpasswd(?,?,?)}
    Received acquired password
    Returning acquired password
    Prepare procedure call:{call deleteTimeoutForbid(?)}
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Incorrect parameter count in the call to native function 'datediff'
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
    at application.query.handler.executeQuery(Unknown Source)
    at application.query.select.handler.execute(Unknown Source)
    at com.goldhuman.account.storage.acquireForbid(storage.java:784)
    at protocol.MatrixPasswd.Server(Unknown Source)
    at com.goldhuman.IO.Protocol.Rpc.Process(Unknown Source)
    at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
    at com.goldhuman.Common.ThreadPool.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    Prepare procedure call:{call recordonline(?,?,?,?,?)}


  2. #2
    Apprentice netfrog is offline
    MemberRank
    Dec 2006 Join Date
    5Posts

    Re: "FUNCTION dbo.dateadd does not exist" in Llnux mysql server

    solved,forgot to replace the modified "table.xml" there are "dateadd" and "datediff" functions for mssql not for mysql.



Advertisement