Re: jdbc problem
От | Barry Lind |
---|---|
Тема | Re: jdbc problem |
Дата | |
Msg-id | 3EA750E7.5040503@xythos.com обсуждение исходный текст |
Ответ на | jdbc problem ("milimeter@163.com" <milimeter@163.com>) |
Ответы |
Re: jdbc problem
|
Список | pgsql-jdbc |
Mili, I don't understand your issues. Can you explain them in a bit more detail? Perhaps with code examples? thanks, --Barry milimeter@163.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 >
В списке pgsql-jdbc по дате отправления: