Re: [sqlite] Does SQLite support user-defined data-types ?

2007-02-01 Thread John Stanton
If you are implementing JDBC to Sqlite then you just need to write a class. You could use an existing JDBC class as a template. Jerome CORRENOZ wrote: I'm implementing the SQLData interface. Is it the right one ? John Stanton wrote: You need to revise your Java interface or maybe find

Re: [sqlite] Does SQLite support user-defined data-types ?

2007-02-01 Thread Jerome CORRENOZ
I'm implementing the SQLData interface. Is it the right one ? John Stanton wrote: You need to revise your Java interface or maybe find another. What are you using? Jerome CORRENOZ wrote: Now, I can use user-dfined types by declaring them with SQL create tables. Fine ! But when I try to

Re: [sqlite] Does SQLite support user-defined data-types ?

2007-01-31 Thread John Stanton
You need to revise your Java interface or maybe find another. What are you using? Jerome CORRENOZ wrote: Now, I can use user-dfined types by declaring them with SQL create tables. Fine ! But when I try to use the following code to get an object, I get a ClassCastException: Statement

Re: [sqlite] Does SQLite support user-defined data-types ?

2007-01-31 Thread Jerome CORRENOZ
Now, I can use user-dfined types by declaring them with SQL create tables. Fine ! But when I try to use the following code to get an object, I get a ClassCastException: Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery( "SELECT * FROM EMP"); while

Re: [sqlite] Does SQLite support user-defined data-types ?

2007-01-30 Thread John Stanton
Sqlite is flexible in typing. You can create user defined types just by declaring them in your SQL which creates tables. Thereafter the API will return the declared type and the actual type so that you can process it appropriately. Jerome CORRENOZ wrote: Hi, I'm starting with SQLite and I

[sqlite] Does SQLite support user-defined data-types ?

2007-01-30 Thread Jerome CORRENOZ
Hi, I'm starting with SQLite and I would like to know if it is possible to create user-defined data-types through the following SQL command: create type MyType ... ? In fact, I need it to map a database with an object-oriented model, so that I could manage the objects in a ResultSet like it