error in reading columns from pidgin database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • spanchethan
    New Member
    • Jan 2011
    • 1

    error in reading columns from pidgin database

    actually i map jboss with pidgin database server ,when i want to fetch columns from table it throwing error message ,my actuall java code is
    switch (tml.getF()) {
    case FeatureCodes.PI CTURE_US:
    pstatement = conn
    .prepareStateme nt("select I,O,PM,TI from uspicture");
    break;
    case FeatureCodes.PI CTURE_INDIA:
    pstatement = conn
    .prepareStateme nt("select I,O,PM,TI from indiapicture where gu_id=?");

    pstatement.setS tring(1, "1234");
    break;
    case FeatureCodes.PI CTURE_KANNADA:
    pstatement = conn
    .prepareStateme nt("select I,O,PM,TI from kannadapicture" );
    break;
    case FeatureCodes.PI CTURE_TAMIL:
    pstatement = conn
    .prepareStateme nt("select I,O,PM,TI from tamilpicture");
    break;
    case FeatureCodes.PI CTURE_TELUGU:
    pstatement = conn
    .prepareStateme nt("select I,O,PM,TI from telugupicture") ;
    break;
    }
    // pstatement.setS tring(1, albumId);
    ResultSet rs = pstatement.exec uteQuery();
    when it comes to last line it thorwing exception ,its print stack trace is
    org.postgresql. util.PSQLExcept ion: ERROR: column "i" does not exist
    17:50:32,037 ERROR [STDERR] at org.postgresql. core.v3.QueryEx ecutorImpl.rece iveErrorRespons e(QueryExecutor Impl.java:1592)
    17:50:32,038 ERROR [STDERR] at org.postgresql. core.v3.QueryEx ecutorImpl.proc essResults(Quer yExecutorImpl.j ava:1327)
    17:50:32,039 ERROR [STDERR] at org.postgresql. core.v3.QueryEx ecutorImpl.exec ute(QueryExecut orImpl.java:192 )
    17:50:32,040 ERROR [STDERR] at org.postgresql. jdbc2.AbstractJ dbc2Statement.e xecute(Abstract Jdbc2Statement. java:451)
    17:50:32,041 ERROR [STDERR] at org.postgresql. jdbc2.AbstractJ dbc2Statement.e xecuteWithFlags (AbstractJdbc2S tatement.java:3 50)
    17:50:32,042 ERROR [STDERR] at org.postgresql. jdbc2.AbstractJ dbc2Statement.e xecuteQuery(Abs tractJdbc2State ment.java:254)
    17:50:32,043 ERROR [STDERR] at org.jboss.resou rce.adapter.jdb c.WrappedPrepar edStatement.exe cuteQuery(Wrapp edPreparedState ment.java:342)
    17:50:32,044 ERROR [STDERR] at com.touchfone.p remium.picture. PremiumAlbumBui lder.fetchAlbum Thumbnails(Prem iumAlbumBuilder .java:136)
    17:50:32,045 ERROR [STDERR] at com.touchfone.p remium.picture. MainPictureServ ices.getThumbna ilPictures(Main PictureServices .java:235)
    17:50:32,046 ERROR [STDERR] at com.touchfone.p remium.picture. MainPictureServ ices.pictureSer vices(MainPictu reServices.java :118)
    17:50:32,047 ERROR [STDERR] at com.touchfone.t fj.core.TFJServ let.pictureServ ice(TFJServlet. java:358)
    17:50:32,048 ERROR [STDERR] at com.touchfone.t fj.core.TFJServ let.doPost(TFJS ervlet.java:251 )
    17:50:32,049 ERROR [STDERR] at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:637)
    17:50:32,050 ERROR [STDERR] at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:717)
    17:50:32,051 ERROR [STDERR] at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:290)
    17:50:32,052 ERROR [STDERR] at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:206)
    17:50:32,053 ERROR [STDERR] at org.jboss.web.t omcat.filters.R eplyHeaderFilte r.doFilter(Repl yHeaderFilter.j ava:96)
    17:50:32,054 ERROR [STDERR] at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:235)
    17:50:32,055 ERROR [STDERR] at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:206)
    17:50:32,056 ERROR [STDERR] at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:235)
    17:50:32,057 ERROR [STDERR] at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:191)
    17:50:32,058 ERROR [STDERR] at org.jboss.web.t omcat.security. SecurityAssocia tionValve.invok e(SecurityAssoc iationValve.jav a:190)
    17:50:32,059 ERROR [STDERR] at org.jboss.web.t omcat.security. JaccContextValv e.invoke(JaccCo ntextValve.java :92)
    17:50:32,060 ERROR [STDERR] at org.jboss.web.t omcat.security. SecurityContext EstablishmentVa lve.process(Sec urityContextEst ablishmentValve .java:126)
    17:50:32,061 ERROR [STDERR] at org.jboss.web.t omcat.security. SecurityContext EstablishmentVa lve.invoke(Secu rityContextEsta blishmentValve. java:70)
    17:50:32,062 ERROR [STDERR] at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:12 7)
    17:50:32,063 ERROR [STDERR] at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:10 2)
    17:50:32,064 ERROR [STDERR] at org.jboss.web.t omcat.service.j ca.CachedConnec tionValve.invok e(CachedConnect ionValve.java:1 58)
    17:50:32,065 ERROR [STDERR] at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:109)
    17:50:32,066 ERROR [STDERR] at org.apache.cata lina.connector. CoyoteAdapter.s ervice(CoyoteAd apter.java:330)
    17:50:32,067 ERROR [STDERR] at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:829)
    17:50:32,068 ERROR [STDERR] at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.process(Htt p11Protocol.jav a:598)
    17:50:32,068 ERROR [STDERR] at org.apache.tomc at.util.net.JIo Endpoint$Worker .run(JIoEndpoin t.java:447)
    17:50:32,069 ERROR [STDERR] at java.lang.Threa d.run(Thread.ja va:662)
Working...