Florian Weimer <fweimer@redhat.com> wrote:
> Can you use other JDBC drivers (except SQLite) to insert
> Java Strings into NUMERIC columns and Java ints into text
> columns?
The JDBC specification can be downloaded from here:
http://download.oracle.com/otndocs/jcp/jdbc-4_1-mrel-spec/index.html
Check out appendix B. According to the charts there, any of these
Java types (from table B-5):
String
java.math.BigDecimal
Boolean
Byte
Short
Integer
Long
Float
Double
should be assignable using setObject and setNull to these JDBC
target types:
TINYINT
SMALLINT
INTEGER
BIGINT
REAL
FLOAT
DOUBLE
DECIMAL
NUMERIC BIT
BOOLEAN
CHAR
VARCHAR
LONGVARCHAR
In addition (from the same table) String should be assignable to:
BINARY
VARBINARY
LONGVARBINARY
DATE
TIME
TIMESTAMP
So, it's at least partly a question of whether we want to conform
to the JDBC specification.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
