java - JDBC is throwing grammar error when the query is working in php myadmin -

-

i working on java website using jdbc mysql. here simple function fetch data sql,

@override     public list fetchmusic(string _uname, string _chnl_name) throws sqlexception {          string sql = "select * `channel_songs` `uid` = " +                      " (select `id` `user` binary `uname` = ?)"+                      " , `chnl_id` = (select `id` `channel` binary `chnl_name` = ?);";          connection conn = datasource.getconnection();          preparedstatement ps = conn.preparestatement(sql);          ps.setstring(1, _uname);         ps.setstring(2, _chnl_name);          list<map<string, object>> musiclistsbychnl = jdbctemplate.queryforlist(string.valueof(ps));           return musiclistsbychnl;      }

so, when running this, getting error says,

org.springframework.jdbc.badsqlgrammarexception: statementcallback; bad sql grammar [com.mysql.jdbc.jdbc4preparedstatement@3a4eb50a: select * `channel_songs`]; nested exception com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax; check manual corresponds mysql server version right syntax use near 'com.mysql.jdbc.jdbc4preparedstatement@3a4eb50a: select * `channel_songs`' @ line 1

so, don't know wrong or is. when trying query on phpmyadmin, working , returning data. can me here?

thanx in advance. ;)

you using prepared statement wrong... preparedstatement not "convenient" device build escaped sql strings. result of string.valueof(ps) not defined valid sql command @ all. ps.tostring(), value should used debugging only. exception gave:

check manual corresponds mysql server version right syntax use near 'com.mysql.jdbc.jdbc4preparedstatement@3a4eb50a: select * channel_songs' @ line 1

you supposed this:

@override public list fetchmusic(string _uname, string _chnl_name) throws sqlexception {      string sql = "select * `channel_songs` `uid` = " +                  " (select `id` `user` binary `uname` = ?)"+                  " , `chnl_id` = (select `id` `channel` binary `chnl_name` = ?);";      connection conn = datasource.getconnection();      preparedstatement ps = conn.preparestatement(sql);      ps.setstring(1, _uname);     ps.setstring(2, _chnl_name);      // is, original code falls apart....     // list<map<string, object>> musiclistsbychnl = jdbctemplate.queryforlist(string.valueof(ps));       list<map<string,object>> answer = new arraylist<>();      try (resultset rs = ps.executequery()) {          while (rs.next()) {              // read single row of result set using             // getters of `rs` instance (rs.getstring(...),             // rs.getint(...), ...)         }     }        return musiclistsbychnl;  }

if not want write boiler plate stuff (and seem have jdbctemplate @ hand): spring's jdbctemplate has lot more convenience methods, deal assigning query parameters , like. find 1 closest needs.


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

Automatically Create Database in Entity Framework 6 with Automatic Migrations Disabled -

-
i able automatically create new database, if not exist, using code-first ef6 automatic migrations disabled. if recall correctly, before automatic migrations existed in entity framework, worked fine. however, in ef6, receive following exception: an exception of type 'system.data.entity.migrations.infrastructure.automaticmigrationsdisabledexception' occurred in entityframework.dll not handled in user code additional information: unable update database match current model because there pending changes , automatic migration disabled. either write pending model changes code-based migration or enable automatic migration. set dbmigrationsconfiguration.automaticmigrationsenabled true enable automatic migration. to verify exception not caused external factor in production project, created new test project. however, same exception. for database context, have: public class mycontext : dbcontext { public dbset<entity> entities { get; set; } ...
Read more