By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

error in reading columns from pidgin database

P: 1
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.PICTURE_US:
pstatement = conn
.prepareStatement("select I,O,PM,TI from uspicture");
break;
case FeatureCodes.PICTURE_INDIA:
pstatement = conn
.prepareStatement("select I,O,PM,TI from indiapicture where gu_id=?");

pstatement.setString(1, "1234");
break;
case FeatureCodes.PICTURE_KANNADA:
pstatement = conn
.prepareStatement("select I,O,PM,TI from kannadapicture");
break;
case FeatureCodes.PICTURE_TAMIL:
pstatement = conn
.prepareStatement("select I,O,PM,TI from tamilpicture");
break;
case FeatureCodes.PICTURE_TELUGU:
pstatement = conn
.prepareStatement("select I,O,PM,TI from telugupicture");
break;
}
// pstatement.setString(1, albumId);
ResultSet rs = pstatement.executeQuery();
when it comes to last line it thorwing exception ,its print stack trace is
org.postgresql.util.PSQLException: ERROR: column "i" does not exist
17:50:32,037 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.receiveEr rorResponse(QueryExecutorImpl.java:1592)
17:50:32,038 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.processRe sults(QueryExecutorImpl.java:1327)
17:50:32,039 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.execute(Q ueryExecutorImpl.java:192)
17:50:32,040 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:451)
17:50:32,041 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execut eWithFlags(AbstractJdbc2Statement.java:350)
17:50:32,042 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execut eQuery(AbstractJdbc2Statement.java:254)
17:50:32,043 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.executeQuery(WrappedPreparedStatement.java: 342)
17:50:32,044 ERROR [STDERR] at com.touchfone.premium.picture.PremiumAlbumBuilder. fetchAlbumThumbnails(PremiumAlbumBuilder.java:136)
17:50:32,045 ERROR [STDERR] at com.touchfone.premium.picture.MainPictureServices. getThumbnailPictures(MainPictureServices.java:235)
17:50:32,046 ERROR [STDERR] at com.touchfone.premium.picture.MainPictureServices. pictureServices(MainPictureServices.java:118)
17:50:32,047 ERROR [STDERR] at com.touchfone.tfj.core.TFJServlet.pictureService(T FJServlet.java:358)
17:50:32,048 ERROR [STDERR] at com.touchfone.tfj.core.TFJServlet.doPost(TFJServle t.java:251)
17:50:32,049 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet .java:637)
17:50:32,050 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
17:50:32,051 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:290)
17:50:32,052 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
17:50:32,053 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doF ilter(ReplyHeaderFilter.java:96)
17:50:32,054 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:235)
17:50:32,055 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
17:50:32,056 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:235)
17:50:32,057 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
17:50:32,058 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationV alve.invoke(SecurityAssociationValve.java:190)
17:50:32,059 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.inv oke(JaccContextValve.java:92)
17:50:32,060 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstab lishmentValve.process(SecurityContextEstablishment Valve.java:126)
17:50:32,061 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityContextEstab lishmentValve.invoke(SecurityContextEstablishmentV alve.java:70)
17:50:32,062 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127)
17:50:32,063 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:102)
17:50:32,064 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionV alve.invoke(CachedConnectionValve.java:158)
17:50:32,065 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:109)
17:50:32,066 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:330)
17:50:32,067 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:829)
17:50:32,068 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.process(Http11Protocol.java:598)
17:50:32,068 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run( JIoEndpoint.java:447)
17:50:32,069 ERROR [STDERR] at java.lang.Thread.run(Thread.java:662)
Jan 3 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.