[SQLiteJDBC] Insert and retreive long values

[Manuel SELVA]

Hi there,

 

I need to keep in an SQLite database Java long.

 

For that I am creating a table as following:

 

CREATE TABLE MY TABLE (...., BIG_INT time, ...)

 

When looking at the database with a tool such as SQLIte Manager (firefox
extension) or using the SQLite command line tool I can reteive my long
values without problem. But when using SQLite JDBC (using
resultSet.getLong(timeColumnIndex)) I don't get my long value but my long
value casted into (int).

 

Am I missing something to be able to store and retrieve long values ?

 

Thanks in advance,

 

Manu