Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help for java

Help for java

From
Gabriel García
Date:
I need help about connections Java program to Postgres databases, I have
installed both, but I can't connect the database.



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: Help for java

From
jlemcke
Date:
There is lots of good general information available on the 'net

Check out the PostgreSQL web site at:
http://www.postgresql.org

and Sun's Java Tutorial page at :
http://java.sun.com/docs/books/tutorial/jdbc/


Have Fun,

John L.


Gabriel García wrote:
>
> I need help about connections Java program to Postgres databases, I have
> installed both, but I can't connect the database.
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

RE: null to zero?

From
"chris markiewicz"
Date:
hello.

it seems that a null value in an integer (int4) column gets converted to
zero at some point...is this accurate?  i look in the db and see null
(queried using IS NULL to make sure), but i call an rs.getObject(colName)
and get a java.lang.Integer with a value of zero...is this in jdbc or java?
an Integer can BE null, but it cannot have a value of null...

didn't see anything in the archives...

thanks
chris

RE: null to zero?

From
Peter Mount
Date:
At 10:59 06/04/01 -0400, chris markiewicz wrote:
>hello.
>
>it seems that a null value in an integer (int4) column gets converted to
>zero at some point...is this accurate?  i look in the db and see null
>(queried using IS NULL to make sure), but i call an rs.getObject(colName)
>and get a java.lang.Integer with a value of zero...is this in jdbc or java?
>an Integer can BE null, but it cannot have a value of null...

I'll check the specs. IIRC getObject on a null'ed field should return null,
but I have a feeling this question came up recently (well a few months ago).

>didn't see anything in the archives...

Whew, someone who has looked at them ;-)

Peter


>thanks
>chris
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://www.postgresql.org/search.mpl

Re: null to zero?

From
Joseph Shraibman
Date:
That is correct.  This behavior is supposed to go away in 7.1

chris markiewicz wrote:
>
> hello.
>
> it seems that a null value in an integer (int4) column gets converted to
> zero at some point...is this accurate?  i look in the db and see null
> (queried using IS NULL to make sure), but i call an rs.getObject(colName)
> and get a java.lang.Integer with a value of zero...is this in jdbc or java?
> an Integer can BE null, but it cannot have a value of null...
>
> didn't see anything in the archives...
>


--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com