"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
Quote:
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)
Quote:
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(?,?,?,?,?)}
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.