From: | Віталій Тимчишин <tivv00(at)gmail(dot)com> |
---|---|
To: | PG-JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Using java.lang.Character for "char" data type |
Date: | 2010-05-21 12:28:28 |
Message-ID: | AANLkTinKef9bhdEhYMMzxiRLKUXtGt_cUOnIPT5sibXI@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello.
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
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2010-05-21 22:16:02 | Re: Using java.lang.Character for "char" data type |
Previous Message | Lew | 2010-05-20 13:34:27 | Re: Documentation improvements for PgJDBC |