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

[Luis Paolini]

Hi Sandra,

	The application we are working on is a ADF Java Desktop Application.
It uses ADF Swing.
	It can operates is two modes: Connected to a Corporate Oracle 11g
Database or Disconnected using a local Berkeley
Database.
	In the connected mode we use ADF Business Components to do the
object-relational mapping and create Entities,
Views, Associations, etc. These components are used by the ADF Swing
components in the UI, via data binding model.
	Our goal is to do the same approach using BDB with SQLite.
	The idea is to have the same datamodel in the two databases, in
order to use the same ADF Business Components already created.
	Depending on the context (connected or disconnected), we just need
to change the database connection and the application 
would just works, no matter the database is Oracle 11g or Berkeley.	
	Does it makes sense?

Regards,

Luis Paolini
		


-----Original Message-----
From: Sandra Whitman [mailto:sandra.whitman at oracle.com] 
Sent: quarta-feira, 17 de fevereiro de 2010 00:33
To: Luis Paolini
Cc: bdb-beta-feedback at oss.oracle.com; support at sleepycat.com; Kent Rollins;
Brian Fry
Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2

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


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4872 (20100216) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4873 (20100217) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com