[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2
Sandra Whitman
sandra.whitman at oracle.com
Wed Feb 17 09:21:41 PST 2010
Hi Kent,
I just spoke with Dave about the the goals and questions Luis has. Dave
suggests that they all come down to how Luis can get ADF and his
application working with BDB 11gR2 over JDBC. Basically Luis wants to
know how to build the JDBC driver and make it visible to ADF so it can
be used to interface with SQLite/BDB 11gR2. We are working on the first
step, how to build the JDBC driver and make it visible to ADF. The
second step, how to get ADF to work with a data source other than the
Oracle Database Server, specifically with the BDB SQLite datbase we
don't know.
Do you know how ADF is configured to work with something other than the
Oracle Database server, in this case with BDB SQLite? Is there a
specific set of information which we need to collect in order to be able
to answer this question? It might be better for you to respond directly
so that we make sure to get all the information we need to answer this,
but it might also be easier for me to send one email compiling
everything we have for Luis (from both sets of steps) at the end of the
day. I can do that if I have a list of what to ask.
Thanks very much,
Sandra
Sandra Whitman wrote:
> 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
>>
>>
>>
>>
>
> _______________________________________________
> BDB-BETA-FEEDBACK mailing list
> BDB-BETA-FEEDBACK at oss.oracle.com
> http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback
>
More information about the BDB-BETA-FEEDBACK
mailing list