Re: jdbc problem

Mili,

I don't understand your issues. Can you explain them in a bit more
detail? Perhaps with code examples?

thanks,
--Barry

milimeter(at)163(dot)com wrote:
> Hi, all
>
> I have a table: CREATE TABLE person (age char(4))
> After executing "select age from person" with jdbc, I extract the value
> with:
> getInt("age")
> Now is the problem, the same code can succeed on oracle, but on
> postgresql, because of not triming space automaticlly, it cause an error.
>
> So, I hope the newest jdbc driver for postgresql can automaticlly trim
> space just like oracle. The same problem also exists when execute insert:
> Provided "age" is an integer, then "insert into person values ('30')" can
> be executed correctly, but "insert into person values ('')" can not. On
> oracle, a default value will be added. So jdbc driver for postgresql should
> also do it.
>
> Yours,
> mili
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>