I am using a prepared statement to try to insert a new row into the MySQL table and if the index exists perform an update. I am fairly sure that the issue is related to the "point" field labelled "grp_hall_geoPoint". I am receiving the error "SQLException in updateGroup: 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 'SET grp_country='Australia', grp_state='New South Wales', grp_region='Sydney Nor' at line 1"
The values being passed are:
The prepared statement is:
The following are in a unique index: grp_country, grp_state, grp_region, grp_district, grp_name, grp_section, grp_sub_section
grp_hall_geoPoint is type point
I have used test data to trigger the update and insert with the same result.