473,395 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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.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
0 1943

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

Similar topics

2
by: Joao Santa Barbara | last post by:
Hi all i have this error reading one registry key , can anyone assist me .. please very urgent i try in one computer, and work fine, but in other computer it didn´t work and throws this error...
1
by: Duncan Allen | last post by:
I'm trying to use aspnet_setreg to encrypt user names & password used in the web.config file for use in the indentity element. When the website runs I get the message 'Error reading the password...
2
by: Kel Good | last post by:
I have a component which I want to register for COM interop. At the top of my code file I have the following lines. Imports System.Reflection <Assembly: AssemblyKeyFileAttribute("myKey.snk")>...
0
by: tmsprowl | last post by:
Greetings! I was wondering if someone could help me with a problem I'm having. My department is just one of many within my organization. My organization has control over the network domain,...
0
by: Boris9577 | last post by:
Hello everyone, I need help with reading data from database. I am working with Visual C++ and MS SQL 2005. This is the problem: I have tried to read some values from data base (on a way described...
2
by: Ben | last post by:
Hi We have setup a Strong Name for our Applications, but are having problems with the essembly throwing an error: Error creating assembly manifest: Error reading key file...
2
by: herat007 | last post by:
hi , i have developed a prog in vb to send sms , but i get an error error:8020 "Error reading from comm port" my prog for mscomm_oncomm() is Private Sub MSComm1_OnComm() Dim strMessage As...
1
by: Sebarry | last post by:
Hi, I'm trying to read the results of a database query into an XML document but it's only read so far and stopping. The XML document is as follows: <?xml version="1.0" encoding="utf-8"?> ...
2
by: =?Utf-8?B?eWtmZmM=?= | last post by:
I try to experiment deploying my Vb.net application by following the basic steps but encounter this error. I follow every step and every display agrees with what the tutorial says and the IDE...
0
Guido Geurs
by: Guido Geurs | last post by:
I'm writing a program that list the contents of a CDrom and also the contents of the ZIP files. When there is a bad Zip file on the CD, the program keeps traying to reed the file and after +- 50...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.