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

Brian Fry brian.fry at oracle.com
Fri Mar 5 14:06:00 PST 2010


ADF Swing doesn't talk directly to the database. ADF Swing goes through 
the ADF databinding layer, which in turn talks to the business services 
which do the actual database access. So, it's not a question of whether 
ADF Swing supports SQLite, it's a question of whether the business 
service you are binding to supports it. In the case of this customer, 
they are using ADF BC as the business service, which does not currently 
certify against SQLite, but it is generically supported as a 3rd party 
SQL92-compliant database. I've responded to the other thread on that 
topic as well.

-- Brian


On 2/17/2010 9:33 AM, Kent Rollins wrote:
> That's a 4th usage scenario that I had not considered.  I know that there is an effort underway to make JDeveloper work with SQLite (separate team from mine, don't know details), but I have no idea if there is any effort underway to make ADF Swing work with SQLite.  This is possibly a new requirement for that group.
>
> Brian, do you know who to talk to about adding SQLite support to ADF Swing?
>
>
> Kent
>
>
> -----Original Message-----
> From: Sandra Whitman
> Sent: Wednesday, February 17, 2010 10:42 AM
> To: Kent Rollins; Dave Segleau
> Cc: bdb-beta-feedback at oss.oracle.com; support at sleepycat.com; Brian Fry; Greg Burd
> Subject: Re: [BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
>
> Hi Kent, Dave,
>
>
>   From the description the application has two modes:
> 1. connected: where ADF is working with an Oracle 11g database.
> 2. disconnected: where ADF is using a BDB db.
>
>
> It sounds like the goal is to replace the Oracle 11g database with BDB
> with SQLite so the database model in the connected and disconnected case
> is the same.
>
>
> If that is the correct, does this additional information allow us to
> give more specific feedback regarding ADF/JDBC usage?
>
>
> I imagine the BDB db is built from the BDB Core product.  From the
> previous question on je-3.3.87.jar, Luis has used the Berkeley DB JE
> product as well, but perhaps in a different application.  I will check
> on that when I get back to him.
>
>
> Thank you,
> Sandra
>
> Luis Paolini wrote:
>    
>> 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
>>
>>
>>
>>      



More information about the BDB-BETA-FEEDBACK mailing list