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 '-yourpersonalhealthcarepartner.patient_master' at line 1 Error Code: 1064 Call: SELECT pid, age, did, gender, pname FROM symcare-yourpersonalhealthcarepartner.patient_master Query: ReadAllQuery(referenceClass=PatientMaster sql="SELECT pid, age, did, gender, pname FROM symcare-yourpersonalhealthcarepartner.patient_master")


Solutions on the web

Solution icon of stackoverflow
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

Solution icon of stackoverflow
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 'key, presenca FROM presenca_keys' at line 1 Error Code: 1064 Call: SELECT id, key, presenca FROM presenca_keys Query: ReadAllQuery(referenceClass=PresencaKeys sql="SELECT id, key, presenca FROM presenca_keys")

Solution icon of stackoverflow
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

Solution icon of stackoverflow
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

Solution icon of stackoverflow
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

Solution icon of github
via GitHub by kentilini
, 1 month 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

Solution icon of stackoverflow
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 ALL (SELECT t1.id, t1.fullName FROM PatientTable t1))' at line 1 Error Code: 1064 Call: (SELECT t0.id, t0

Solution icon of stackoverflow
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

Solution icon of bugzilla
via Eclipse Bugzilla by cristi_jujea, 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 'CustomItem.count' at line 1 Error Code: 1064 Call: CustomItem.count Query: DataReadQuery(sql="CustomItem.count")

Solution icon of oraclecommunity
via Oracle Community by 938991, 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 'Change, CompanyName, Exchange, HighPrice, LastTradedPrice, LastTradedQuantity, L' at line 1 Error Code: 1064 Call

Stack trace

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 '-yourpersonalhealthcarepartner.patient_master' at line 1
Error Code: 1064
Call: SELECT pid, age, did, gender, pname FROM symcare-yourpersonalhealthcarepartner.patient_master
Query: ReadAllQuery(referenceClass=PatientMaster sql="SELECT pid, age, did, gender, pname FROM symcare-yourpersonalhealthcarepartner.patient_master")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:682)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
	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:2738)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2691)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:495)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1168)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1127)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:403)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1215)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1751)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
Caused by: 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 '-yourpersonalhealthcarepartner.patient_master' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642)
	... 22 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 1 week ago
2 times, 1 week ago
Once, 1 month ago
3 times, 2 months ago
4 times, 5 months ago
120 more bugmates