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")

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 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 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 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
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 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 MLDS
, 2 years ago
Unknown column 'blood' in 'field list' Error Code: 1054 Call: SELECT id, blood pressure, complaint, diagnosis, height, temperature, treatment, weight, staff_apointments_appointment_id, staff_apointments_staff_id FROM itr WHERE
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 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
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)
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year 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.