Using java.lang.Character for "char" data type
От
Віталій Тимчишин
Тема
Using java.lang.Character for "char" data type
Дата
Msg-id
AANLkTinKef9bhdEhYMMzxiRLKUXtGt_cUOnIPT5sibXI@mail.gmail.com
Список
Дерево обсуждения
Using java.lang.Character for "char" data type Віталій Тимчишин <tivv00@gmail.com>
Re: Using java.lang.Character for "char" data type Kris Jurka <books@ejurka.com>
Re: Using java.lang.Character for "char" data type Craig Ringer <craig@postnewspapers.com.au>
Re: Using java.lang.Character for "char" data type Kris Jurka <books@ejurka.com>
Re: Using java.lang.Character for "char" data type Lew <noone@lewscanon.com>
Re: Using java.lang.Character for "char" data type Lew <noone@lewscanon.com>
Re: Using java.lang.Character for "char" data type Radosław Smogura <mail@smogura.eu>
Re: Using java.lang.Character for "char" data type "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Hello.
--
Best regards,
Vitalii Tymchyshyn
I've tried to use Character to fill "char" column, e.g. like in the next test:
-----
con.createStatement().execute("create table tst(tcol \"char\")");
PreparedStatement stmt = con.prepareStatement("insert into tst(tcol) values(?)");
stmt.setObject(1, 'c');
stmt.executeUpdate();
-----
and got
and got
Exception in thread "main" org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of java.lang.Character. Use setObject() with an explicit Types value to specify the type to use. at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1740)
with 8.3-603.jdbc4 driver.
May be it would be reasonable to treat Character like String of size 1?
Best regards,
Vitalii Tymchyshyn
В списке pgsql-jdbc по дате отправления
