Java Error

[Exotic2012]

Maybe one of you know more about java could give me a hand. Got server all set up on CentOS 4.7 after fighting with repos and numerous other things now got this issue with Java

java.sql.SQLException: Callable statements not supported.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4683)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4631)
at application.procedure.handler.execute(handler.java:189)
at com.goldhuman.account.storage.clearOnlineRecords(storage.java:849)
at protocol.AnnounceZoneid3.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(Thread.java:619)

Anyone know what that means or how to fix it?

 

[Perryl]

Maybe one of you know more about java could give me a hand. Got server all set up on CentOS 4.7 after fighting with repos and numerous other things now got this issue with Java

java.sql.SQLException: Callable statements not supported.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4683)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:4631)
at application.procedure.handler.execute(handler.java:189)
at com.goldhuman.account.storage.clearOnlineRecords(storage.java:849)
at protocol.AnnounceZoneid3.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(Thread.java:619)

Anyone know what that means or how to fix it?

idk if this will help you but I was able to ask someone quickly

he said

"sounds like stored procedures aren't supported on the server
or buildable statements (more secure query construction) isn't supported in that java sql client probably needs to upgrade to newer mysql client library needs at least a 5.0 mysql server to support prepared statements"

He also gave me this link.

You must be registered to see links

Hope it helps

 

[Exotic2012]

Ok Ill check ty

Ok found the issue, it is because the mysql is too old bs problem is thats all the old CentOS will install so I guess Ill HAVe TO use lampp to get around it which sucks

 

[Perryl]

Ok Ill check ty

Ok found the issue, it is because the mysql is too old bs problem is thats all the old CentOS will install so I guess Ill HAVe TO use lampp to get around it which sucks

I pm'd my Skype ID to you, hopefully I can get some more help for you later tonight.

 

[Exotic2012]

it was the mysql version being incompatible with the newer java, used lampp and solve dit