com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ')))) OR ((t0.order_namespace = 'Friends') AND (t0.order_owner IN ()))) OR ((t0.o' at line 1 Error Code: 1064 Call: SELECT t0.order_id, t0.address, t0.created_at, t0.order_description, t0.done_at, t0.expire_in, t0.latitude, t0.longitude, t0.order_namespace, t0.reward, t0.order_status, t0.order_executor, t0.order_owner FROM orders t0 WHERE (t0.order_id IN (SELECT t1.order_id FROM orders t1 WHERE ((((((t1.latitude > (? - ?)) AND (t1.latitude < (? + ?))) AND (t1.longitude > (? - ?))) AND (t1.longitude < (? + ?))) AND ((t1.expire_in > CURRENT_TIMESTAMP) OR (t1.expire_in IS NULL))) AND (t1.order_status = ?))) AND (((((t0.order_namespace = ?) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ()))) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ()))) OR ((t0.order_namespace = ?) AND (t0.order_executor = ?))) OR (t0.order_owner = ?))) bind => [15 parameters bound] Query: ReadAllQuery(name="Order.getNearestOrdersFiltered" referenceClass=Order sql="SELECT t0.order_id, t0.address, t0.created_at, t0.order_description, t0.done_at, t0.expire_in, t0.latitude, t0.longitude, t0.order_namespace, t0.reward, t0.order_status, t0.order_executor, t0.order_owner FROM orders t0 WHERE (t0.order_id IN (SELECT t1.order_id FROM orders t1 WHERE ((((((t1.latitude > (? - ?)) AND (t1.latitude < (? + ?))) AND (t1.longitude > (? - ?))) AND (t1.longitude < (? + ?))) AND ((t1.expire_in > CURRENT_TIMESTAMP) OR (t1.expire_in IS NULL))) AND (t1.order_status = ?))) AND (((((t0.order_namespace = ?) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ?))) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ?))) OR ((t0.order_namespace = ?) AND (t0.order_executor = ?))) OR (t0.order_owner = ?)))")

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by kentilini
, 2 months ago
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 ')))) OR ((t0.order_namespace = 'Friends') AND (t0.order_owner IN ()))) OR ((t0.o' at line 1 Error Code: 1064 Call
via Stack Overflow by yahh
, 1 year ago
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 'UNION (SELECT t1.TASKID, t1.DATE, t1.NAME, t1.REGION, t1.did, t1.pid, t1.tid FRO' at line 1 Error Code: 1064 Call
via Stack Overflow by numfar
, 2 years ago
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 '.panel_id) AND (t0.target = 5)) AND (t0.panel = t1.panel_id))' at line 1 Error Code: 1064 Call: SELECT t1.panel_id
via Stack Overflow by Srdjan Ristic
, 2 years ago
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 '-projekat.korisnik WHERE ((USERNAME = 'asd') AND (PASSWORD = 'asd'))' at line 1 Error Code: 1064 Call: SELECT
via Stack Overflow by C A Anusha
, 9 months ago
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 '-yourpersonalhealthcarepartner.patient_master' at line 1 Error Code: 1064 Call: SELECT pid, age, did, gender
via Stack Overflow by Zark Salman
, 1 year ago
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-brand' at line 1 Error Code: 1064 Call: SELECT id, amps, comingA, comingB, g1, gTotal, hp, model, mr, newOrderA
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ')))) OR ((t0.order_namespace = 'Friends') AND (t0.order_owner IN ()))) OR ((t0.o' at line 1 Error Code: 1064 Call: SELECT t0.order_id, t0.address, t0.created_at, t0.order_description, t0.done_at, t0.expire_in, t0.latitude, t0.longitude, t0.order_namespace, t0.reward, t0.order_status, t0.order_executor, t0.order_owner FROM orders t0 WHERE (t0.order_id IN (SELECT t1.order_id FROM orders t1 WHERE ((((((t1.latitude > (? - ?)) AND (t1.latitude < (? + ?))) AND (t1.longitude > (? - ?))) AND (t1.longitude < (? + ?))) AND ((t1.expire_in > CURRENT_TIMESTAMP) OR (t1.expire_in IS NULL))) AND (t1.order_status = ?))) AND (((((t0.order_namespace = ?) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ()))) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ()))) OR ((t0.order_namespace = ?) AND (t0.order_executor = ?))) OR (t0.order_owner = ?))) bind => [15 parameters bound] Query: ReadAllQuery(name="Order.getNearestOrdersFiltered" referenceClass=Order sql="SELECT t0.order_id, t0.address, t0.created_at, t0.order_description, t0.done_at, t0.expire_in, t0.latitude, t0.longitude, t0.order_namespace, t0.reward, t0.order_status, t0.order_executor, t0.order_owner FROM orders t0 WHERE (t0.order_id IN (SELECT t1.order_id FROM orders t1 WHERE ((((((t1.latitude > (? - ?)) AND (t1.latitude < (? + ?))) AND (t1.longitude > (? - ?))) AND (t1.longitude < (? + ?))) AND ((t1.expire_in > CURRENT_TIMESTAMP) OR (t1.expire_in IS NULL))) AND (t1.order_status = ?))) AND (((((t0.order_namespace = ?) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ?))) OR ((t0.order_namespace = ?) AND (t0.order_owner IN ?))) OR ((t0.order_namespace = ?) AND (t0.order_executor = ?))) OR (t0.order_owner = ?)))")
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1002)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:641)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:679)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1995)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2714)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2667)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:477)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1155)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1114)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:402)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1202)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2894)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1797)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1779)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1744)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 1 month ago
2 times, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 11 months ago
123 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.