mysql - Before start of result set -

-

i want display data 2 tables in single jsp page. getting following error. can please explain error.

java.sql.sqlexception: before start of result set @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1058) @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:972) @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:958) @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:903) @ com.mysql.jdbc.resultsetimpl.checkrowpos(resultsetimpl.java:854) @ com.mysql.jdbc.resultsetimpl.getstringinternal(resultsetimpl.java:5772) @ com.mysql.jdbc.resultsetimpl.getstring(resultsetimpl.java:5692) @ com.mysql.jdbc.resultsetimpl.getstring(resultsetimpl.java:5732) @ jsp_servlet.__userhome._jspservice(__userhome.java:149) @ weblogic.servlet.jsp.jspbase.service(jspbase.java:35) @   weblogic.servlet.internal.stubsecurityhelper$servletserviceaction.run(stubsecurityhelper.java:280) @ weblogic.servlet.internal.stubsecurityhelper$servletserviceaction.run(stubsecurityhelper.java:254) @ weblogic.servlet.internal.stubsecurityhelper.invokeservlet(stubsecurityhelper.java:136) @ weblogic.servlet.internal.servletstubimpl.execute(servletstubimpl.java:346) @ weblogic.servlet.internal.servletstubimpl.execute(servletstubimpl.java:243) @ weblogic.servlet.internal.webappservletcontext$servletinvocationaction.wraprun(webappservletcontext.java:3432) @ weblogic.servlet.internal.webappservletcontext$servletinvocationaction.run(webappservletcontext.java:3402) @ weblogic.security.acl.internal.authenticatedsubject.doas(authenticatedsubject.java:321) @ weblogic.security.service.securitymanager.runas(securitymanager.java:120) @ weblogic.servlet.provider.wlssubjecthandle.run(wlssubjecthandle.java:57) @ weblogic.servlet.internal.webappservletcontext.dosecuredexecute(webappservletcontext.java:2285) @ weblogic.servlet.internal.webappservletcontext.securedexecute(webappservletcontext.java:2201) @ weblogic.servlet.internal.webappservletcontext.execute(webappservletcontext.java:2179) @ weblogic.servlet.internal.servletrequestimpl.run(servletrequestimpl.java:1572) @ weblogic.servlet.provider.containersupportproviderimpl$wlsrequestexecutor.run(containersupportproviderimpl.java:255) @ weblogic.work.executethread.execute(executethread.java:311) @ weblogic.work.executethread.run(executethread.java:263)

update: code, causing error

     preparedstatement pstm = null;      string sql = "select * owner";      pstm = con.preparestatement(sql);      resultset rs = pstm.executequery();      resultset firstrs=rs;      string tname=rs.getstring("tablename");      string sql1="select * "+tname;      statement stmt=con.createstatement();      resultset rs1=stmt.executequery(sql1);      resultsetmetadata rsmd=rs1.getmetadata(); 

preparedstatement pstm = null; string sql = "select * owner"; pstm = con.preparestatement(sql); resultset rs = pstm.executequery(); resultset firstrs=rs; string tname=""; while(rs.next())//you have write resultset because if result set empty gaves error {     tname=rs.getstring("tablename");     tname+=","; } if(!tname.equal("")) {     string sql1="select * "+tname;///it select multiple tables results     statement stmt=con.createstatement();     resultset rs1=stmt.executequery(sql1);     resultsetmetadata rsmd=rs1.getmetadata(); }

Comments

Post a Comment

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

-
i using activeadmin , have file doing this: activeadmin.register role something--- end however, server gives me error: runtimeerror: circular dependency detected while autoloading constant role /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:461:in `load_missing_constant' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:184:in `const_missing' ~/desktop/boxfox/app/admin/role.rb:1:in `<top (required)>' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `load' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `block in load_file' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:616:in `new_constants_in' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:423:in `load_file' /library/ruby/gems/2.0.0/gems/activesuppor
Read more

c++ - OpenMP unpredictable overhead -

-
i have simple openmp code runs 4 empty threads , reports time: #include "omp.h" #include <sys/time.h> #include <cstdio> double start_time; void process_thread() { } int main(){ struct timeval tv; gettimeofday(&tv, null); start_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("beginning time: %.3fms ",start_time-start_time); #pragma omp parallel schedule(static,1) for(int i=0;i<4;i++) process_thread(); gettimeofday(&tv, null); double cur_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("finishing time: %.3fms\n\n",cur_time-start_time); } without openmp running time small , consistent: beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.050ms beginnin
Read more

javascript - Wordpress slider, not displayed 100% width -

-
so im making first wordpress theme scratch going fine got problem. want slider on homepage 1 thing wrong. im setting width of image 100% !important doesnt go 100% width. makes image wider not 100%. example here: http://bit.ly/11ouebg see image doesnt contain whole width. can see background-color. really weird, im using meteor slides. i hope can me out :d
Read more