java - Running javacode with MySQL connectivity does not fetch proper results -

-

iam new java , wrote below code fetch mysql workbench table using java code:

           package filereader;            import java.sql.*;                 public class dbconnection {               public static void main(string[] args)      {     connection con = null;     statement st = null;      try     {        class.forname("com.mysql.jdbc.driver");      con  = drivermanager.getconnection("jdbc:mysql://localhost:3306/world","root","password");      st = con.createstatement();     string sql = "select * city id = 1;";     resultset rs = st.executequery(sql);     while(rs.next())     {         int id = rs.getint("id");         string name = rs.getstring("name");         string countrycode = rs.getstring("countrycode");         string district = rs.getstring("district");         int population = rs.getint("population");                    system.out.println(id);         system.out.println(name);         system.out.println(countrycode);         system.out.println(district);         system.out.println(population);              }     rs.close();     st.close();     con.close();     }catch(exception e) {     e.printstacktrace();         }finally {     try{          if(st!=null)             st.close();       }catch(sqlexception se2){       }       try{          if(con!=null)             con.close();       }catch(sqlexception se){          se.printstacktrace();       }    }    system.out.println("goodbye!"); }

}

on running it, connection made results not fetched properly. 1st row fetched first column missing.

logs/statements seen:

 sat mar 28 21:34:36 ist 2015 trace: <--  buffer.java:292         com.mysql.jdbc.buffer.readint(..) returning 2  sat mar 28 21:34:36 ist 2015 trace: <--  mysqlio.java:2247 com.mysql.jdbc.mysqlio.readserverstatusforresultsets(..) returning null  sat mar 28 21:34:36 ist 2015 trace: --> connection.java:5895 com.mysql.jdbc.connection.versionmeetsminimum(5, 0, 2)  sat mar 28 21:34:36 ist 2015 trace: --> connection.java:1903 com.mysql.jdbc.connection.checkclosed()

....and on

what doing wrong here?


Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more