ADF Essentials and Trinidad ?

[Luc Bors]

Hi,

 

There is a document on OTN containing on overview of ADF Framework Components Allowed with
ADF Essentials License: http://www.oracle.com/technetwork/developer-tools/adf/overview/components-1844931.html

 

In this overview it says that I cannot use ADF Mobile Browser / Trinidad with an "essentials" license.

I don't see a reason why it cannot be used with an "essentials" license.

 

So I'm curious what it is that cannot be used (and why) and what can be used with ADF essentials ?

 

Can anybody explain this ?

 

Luc

[Brian Fry]

Yes, Jernej, that's the issue. Trinidad is not part of ADF Essentials because it is its own product and separately downloadable and licensed. We have also not done specific certification testing with Trinidad on GlassFish. The upshot is that Oracle Support will not support Trinidad on GlassFish under the ADF Essentials support contract. But, nothing prevents you from trying it out!

 -- Brian

On Tue, Sep 25, 2012 at 1:27 AM, Jernej Kaše <jerne...@gmail.com> wrote:

I understand the decision for this, but it's an interesting situation as trinidad was donated to Apache and is an independent product with its own license.

--
You received this message because you are subscribed to the ADF Enterprise Methodology Group (http://groups.google.com/group/adf-methodology). To unsubscribe send email to adf-methodolo...@googlegroups.com
 
All content to the ADF EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the ADF EMG with a link to the Google Group (http://groups.google.com/group/adf-methodology).

[Luc Bors]

Hi Brian,
The overview at the link in my initial email states that it is not allowed to use trinidad with ADF essential license.
Nothing prevents me from trying, but I still wonder what exactly is not allowed, and why ?

Op 25 sep. 2012 23:05 schreef "Brian Fry" <bfry...@gmail.com> het volgende:

[Brian Fry]

Maybe we can address the phrasing or add a note to make this clearer in the document you pointed to. Trinidad is not covered by the ADF Essentials license terms (perhaps "covered" or "included" is better than "allowed" in this document?), and is not covered under the ADF Essentials support contract.

-- Brian

[Mark Robinson]

That's an interesting question because you can't import javascript in ADF without using the Trinidad tags.

Mark

[Duncan Mills]

What about af;resource? You don't *have* to use a tr tag

Regards

Duncan Mills

Oracle Application Development Tools

[Luc Bors]

That is exactly my point.com

Op 26 sep. 2012 16:08 schreef "Hyangelo" <hyan...@gmail.com> het volgende:

Right now, when people look at that document, it seems like we are disallowed(or prohibited) to use Trinidad with ADF Essentials which doesn't make sense since Trinidad has been OpenSourced.  

[bfry...@gmail.com]

I changed the verbiage on the page to say "Included with ADF Essentials". Hopefully that's clearer. It's still the case that Trinidad is not covered under the ADF Essentials license (it has it's own OS license), nor under the ADF Essentials support contract.

-- Brian

[Evert-Jan de Bruin]

Hi all,

I read the news about ADF Essentials on my mobile phone while in bed... had some trouble getting asleep of the excitement! I just switched jobs to work for a small foundation (with limited budget) so ADF seemed miles away... now it is no longer.

However, how is support for MySQL?

Now that ADF is becoming an option for the small businesses and foundations alike, the support for MySQL becomes much more important. I can imagine many developers being interested in a Linux - Glassfish - MySQL - ADF Essentials (LGMA) setup. Officially, MySQL 5.1 is "certified" with JDev and "supported" with ADF (see http://www.oracle.com/technetwork/developer-tools/jdev/jdev11gr2-cert-405181.html). One can even find a few installation guides and how-to blogs on the internet on ADF & MySQL but there it pretty much seems to end.

However, I ran my own little sample project and stumbled upon the fact that ADF does not seem to know how to handle the TIMESTAMP column type (it cannot read the data when the viewobject tries to execute the SQL!). This made me wonder how "supported" MySQL really is.

The question is therefore: Does anyone have any experiences and best-practices with MySQL in combination with ADF?

Right now the choice is between MySQL and Oracle XE as the two "free" options. However, I don't like the restrictions on XE, so I'd prefer MySQL if possible at all.

Thanks!
Evert-Jan de Bruin

--

Evert-Jan de Bruin de Bruin Consultancy

Oracle ADF & JHeadstart | Consultancy & Teaching
Tel: +31 (0)6 2849 3563 | ever...@debruinconsultancy.nl

[Edwin Biemond]

Hi EJ,

MySQL with ADF is working fine , I already did it with 11gR1 PS2 and mysql cluster.
but you need to do the following.

jpa works perfectly.
with adf bc  use java types, override entity create -> no rowid and for id ( autonum) and FK  do select last_id .. , set the right database parameters for time etc. Use file persistence instead of ps_txn table
And I had to override the where clause for the query panel ( add where clause outside , else full table scan ) . cause oracle optimizer is more clever.

with PS5 also Mysql is supported for MDS

good luck.

[Birol Bora]

I try small project with mySQL .

MySQL is not SQL-92 compatible, 

MySQL with ADF incompatible. 

MySQL doesn't support sequence generator,

I think MySQL is supported only JDBC level, not ADF BC level.

2012/10/2 Evert-Jan de Bruin <ever...@debruinconsultancy.nl>

--

[Jeevan G Joseph]

Getting MySQL to work should be possible, I've tried SQL Server, and have had reasonable success with small scale projects and POCs.
I see the point of Primary key generation raised in the thread, and did not see a reference to this document, so here goes :

http://www.oracle.com/technetwork/developer-tools/jdev/multidatabaseapp-085183.html

This explains a some of the steps needed to get a rudimentary PK generation support in ADFBC on non Oracle DBs.

Also check this thread in the OTN forums for a bit more info (again I'm assuming these steps that worked for SQL Server might be relevant for MySQL) :
https://forums.oracle.com/forums/thread.jspa?messageID=10307749&#10307749

Thanks,
Jeevan

--
please do not print this e-mail unless you really need to

[Erdenebayar Erdenebileg]

Hello,

Very late reply for that discussion. But i need to share MySQL and ADF development things.

I think, MySQL is compatible with ADF development. Because we developed, implemented ADF (11.1.1.4.0) with MySQL.

There are some configuration on MySQL side.

http://erdenebayare.blogspot.com/2012/02/mysql-configuration-on-adf-development.html

For the sequence id generation, we are using following methods:

    protected void create(AttributeList attributeList) {

        super.create(attributeList);

        setId(InteractiveUIDGeneration.getUID());

    }

...

    protected void doDML(int operation, TransactionEvent e) {

        super.doDML(operation, e);

        if (operation == DML_INSERT) {

            setAttribute("Id", getId());

        }

    }

Regards,

Erdenebayar

[Duncan Mills]

Running with MySQL is certainly possible, in fact I happen to know that at least one shipping Oracle Product uses this exact combination. 

The secret here is to produce a customized mapping file (The data type map you see when you first configure ADFBC in a project)  which will map the JDBC datatypes that you get from your SQL source to the types / domains that you have in ADFBC. 

This should allow the framework to automatically handle the conversions for you. 

Unfortunately although you can plug in your own type map, the methodology for doing so is not actually documented. 

This is on my long list of blog-articles-I-need-to-write

Duncan 

[Jean-Marc Desvaux]

Duncan,

Sometime I have the feeling (not sure if intuitive or just in my dreams) that there are many valuable ADF secrets that deserve not only some blog articles but a proper documentation of those undocumented secrets..

Am I right or is it just my wishful think, adding to ADF a mystic dimension ? :)

Jean-Marc

------------------

[Jan Vervecken]

hi Duncan

If such a MySQL type map is currently not in JDeveloper, any specific reason why it could not become part of JDeveloper by default?

thanks
Jan Vervecken

[Duncan Mills]

I think that this particular case is simply a matter of up until now it's not been important and there are better things to spend documentation time on than a feature that is used by less than 1/10th of 1 percent of the community.  The framework is so huge, and there are so many hook points that it's impossible to document every single one at level we might like. 

As things have changed with ADF Essentials and we see more folks using MySQL with the stack it makes sense to beef this area up and give it more priority.  In the short term though I can blog about it :-)  

Duncan   

[Duncan Mills]

No, no reason It just needs to be fully developed, tested and documented.  My version of the typemap is currently incomplete, I only implemented the stuff that we actually needed for that project and I'm sure with MySQL there is a bunch more that I've not covered. It's on the eternal to-do list

Duncan