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

pstatement.setString(1, "1234");
case FeatureCodes.PICTURE_KANNADA:
pstatement = conn
.prepareStatement("select I,O,PM,TI from kannadapicture");
case FeatureCodes.PICTURE_TAMIL:
pstatement = conn
.prepareStatement("select I,O,PM,TI from tamilpicture");
case FeatureCodes.PICTURE_TELUGU:
pstatement = conn
.prepareStatement("select I,O,PM,TI from telugupicture");
// 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(
17:50:32,038 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.processRe sults(
17:50:32,039 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.execute(Q
17:50:32,040 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(
17:50:32,041 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execut eWithFlags(
17:50:32,042 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execut eQuery(
17:50:32,043 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.executeQuery( 342)
17:50:32,044 ERROR [STDERR] at com.touchfone.premium.picture.PremiumAlbumBuilder. fetchAlbumThumbnails(
17:50:32,045 ERROR [STDERR] at com.touchfone.premium.picture.MainPictureServices. getThumbnailPictures(
17:50:32,046 ERROR [STDERR] at com.touchfone.premium.picture.MainPictureServices. pictureServices(
17:50:32,047 ERROR [STDERR] at com.touchfone.tfj.core.TFJServlet.pictureService(T
17:50:32,048 ERROR [STDERR] at com.touchfone.tfj.core.TFJServlet.doPost(TFJServle
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 ternalDoFilter(
17:50:32,052 ERROR [STDERR] at Filter(
17:50:32,053 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doF ilter(
17:50:32,054 ERROR [STDERR] at ternalDoFilter(
17:50:32,055 ERROR [STDERR] at Filter(
17:50:32,056 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invo ke(
17:50:32,057 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invo ke(
17:50:32,058 ERROR [STDERR] at alve.invoke(
17:50:32,059 ERROR [STDERR] at oke(
17:50:32,060 ERROR [STDERR] at lishmentValve.process(SecurityContextEstablishment
17:50:32,061 ERROR [STDERR] at lishmentValve.invoke(SecurityContextEstablishmentV
17:50:32,062 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(
17:50:32,063 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke (
17:50:32,064 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionV alve.invoke(
17:50:32,065 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invok e(
17:50:32,066 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.servic e(
17:50:32,067 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(H
17:50:32,068 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.process(
17:50:32,068 ERROR [STDERR] at$
17:50:32,069 ERROR [STDERR] at
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.