Handling null values in char fields from JDBC

From: "Sean Duffy" <sean(dot)duffy(at)programmer(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Handling null values in char fields from JDBC
Date: 2002-01-22 14:21:42
Message-ID: 20020122142142.4536.qmail@mail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


I am running Postgresql 7.1.3 and using the 7.1-1.2 jar jdbc driver. I noticed that when I used a ResultSet.getString("charfield") call to fetch null data from the char field I get a null pointer exception error. My question is two fold..
1) Is this normal behavior for the jdbc driver?
2) Is there a recommended way of trapping for a null value in a char field (besides just going into the db with psql and setting all null values to '')?

I have looked thru two different Postgresql manuals but have not been able to find anything referring to null value handling at the jdbc level.

If anyone can pt me in the right direction I
would really appreciate it.

Thanks!
--

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

1 cent a minute calls anywhere in the U.S.!

http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJ&url=http://www.getpennytalk.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paulo Merson 2002-01-22 14:46:44 Re: Handling null values in char fields from JDBC
Previous Message Dave Cramer 2002-01-22 03:22:31 Re: error calling function - jdbc driver limitation?