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)
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)