[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2

[Sandra Whitman]

Hi Luis,



I do have some additional details regarding SQLite data types supported 
by ADF and JDBC access to the database.  However we need to understand 
which ADF platform you are using (for example ADF Faces or ADF Mobile 
Client) as that impacts what SQLite support is available.  What other 
information can you provide on how you are using or plan to use ADF and 
JDBC?  In general it is not expected that an ADF developer use the JDBC 
layer directly.  Hence the more information you can provide about your 
goals, the better we can address your specific requirements.



For ADF Mobile Client (ADFmc) a summary of the supported Oracle DB 
column types and their corresponding Java types is outlined below:



Oracle Column type     Java type(s)
=============================================

VARCHAR2        java.lang.String
NUMBER            oracle.jbo.domain.Number,
                              java.lang.Boolean,
                              java.lang.Integer, 
                              oracle.adfnmc.java.math.BigDecimal,
                              oracle.jbo.domain.DBSequence
DATE                   oracle.jbo.domain.Date
INTEGER            oracle.jbo.domain.Number
TINYINT             oracle.jbo.domain.Number
SMALLINT         oracle.jbo.domain.Number
BIGINT                oracle.jbo.domain.Number
INT                       oracle.jbo.domain.Number
REAL                   oracle.jbo.domain.Number
DOUBLE PRECISION    oracle.jbo.domain.Number
FLOAT                 oracle.jbo.domain.Number
DECIMAL            oracle.jbo.domain.Number
NUMERIC            oracle.jbo.domain.Number
BIT                        oracle.jbo.domain.Number
NVARCHAR2      java.lang.String
CHAR                    java.lang.String
VARCHAR           java.lang.String
LONG                    java.lang.String
TIMESTAMP        oracle.jbo.domain.Timestamp,
                               oracle.jbo.domain.Date,
                               oracle.adfnmc.java.sql.Timestamp
TIME                     oracle.jbo.domain.Date
DATE                    oracle.jbo.domain.Date,
                               oracle.adfnmc.java.sql.Date
DATETIME          oracle.jbo.domain.Date



Note that this list only applies to ADFmc, as ADF Faces does not 
currently support SQLite as an underlying database.



Regarding JDBC access to the database if you are interested in ADF 
Faces, a good starting point is the documentation at:

http://download.oracle.com/docs/cd/E15523_01/web.1111/b31974/toc.htm 


Additionally there is a "building on Windows" page which you might find 
useful at:
http://www.ch-werner.de/javasqlite/ajhowto.txt



Please let me know if that answers your initial questions, and if there 
is anything else I can help with.



Best Regards,
Sandra