NullPointer exception in ResultSet.getString() - Mailing list pgsql-jdbc
From | gaganis |
---|---|
Subject | NullPointer exception in ResultSet.getString() |
Date | |
Msg-id | 3DA8EFBC.2020708@it.teithe.gr Whole thread Raw |
Responses |
Re: NullPointer exception in ResultSet.getString()
(Aaron Mulder <ammulder@alumni.princeton.edu>)
|
List | pgsql-jdbc |
Hello I am a new user of postrgresql and am accessing it through java(jsp). Trying to get a string from a result set I get a really weird NullPointer exception from the method org.postgresql.jdbc2.ResultSet.getString inside the jdbc driver. I am using postgresql 7.2.1 on linux 2.4.18 allong with tomcat 4.0.4 and sun's j2sdk1.4.0 the driver is jdbc2 here is my code that produces the prob String dsn = "jdbc:postgresql://localhost:5432/illigos?user=illigos&password=qwerty"; Connection conn = DriverManager.getConnection(dsn); . . . Statement st = conn.createStatement(); ResultSet rs = st.executeQuery("select * from FOITITIS where account='"+account+"';"); . . . out.println("<tr><td><i>Onoma:</i></td><td>"+rs.getString("onoma")+"</td></tr>"); this is my table description: illigos=> \d foititis Table "foititis" Column | Type | Modifiers ------------+-----------------------+----------- account | character varying(20) | not null onoma | character varying(40) | epitheto | character varying(40) | ar_mitroou | character varying(10) | examino | character varying(20) | Primary key: foititis_pkey Triggers: RI_ConstraintTrigger_16590, RI_ConstraintTrigger_16592 follows the exception report: java.lang.NullPointerException at org.postgresql.jdbc2.ResultSet.getString(ResultSet.java:168) at org.postgresql.jdbc2.ResultSet.getString(ResultSet.java:553) at org.apache.jsp.use$jsp._jspService(use$jsp.java:116) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125) at java.lang.Thread.run(Thread.java:536) Thanks in advance Gaganis Giorgos
pgsql-jdbc by date: