MySQL query not working in Java -
string sqlinsertbeacon = "insert `beacon` (zone_id, location) value ('(select id zone geographicalid = '" + geometry3 + "')', point(" + x_coordinate + "," + y_coordinate + "))"; system.out.println("the sql query is: " + sqlinsertbeacon); // echo debugging int countinserted3 = stmt.executeupdate(sqlinsertbeacon); system.out.println(countinserted3 + " records inserted.\n");
when run above code, build successful program stops when reaches execute line. entering using sql query insert data mysql database. not sure error in query? can suggest alternative way or find mistake?
the output of program this, can see program, stops running after second line:
the sql query is: insert table (zone_id, location) values ((select id zone geographicalid = '6311599'), point(-121.9453802,37.3256131) ) ; build successful (total time: 6 seconds)
for additional information incase helps:
the stmt, created this:
try ( // step 1: allocate database 'connection' object connection conn = drivermanager.getconnection( "jdbc:mysql://localhost:3306/adhwere2?usessl=false", "root", "your_new_password"); // mysql // step 2: allocate 'statement' object in connection statement stmt = conn.createstatement();) {
and catch exception :
} catch (sqlexception ex) { }
try this:
string sqlinsertbeacon = "insert `beacon` (zone_id, location)" + " values ( (select id zone geographicalid = '" + geometry3 + "'), point(" + x_coordinate + "," + y_coordinate + "))";
just removed apostrophes aroung inner select
, replaced value
values
...
Comments
Post a Comment