Out of box : Database Monitoring using ADF and JDeveloper (Version 1)

Currently i'm developing database monitoring system using ADF Technology. Therefor i need to share my  first version of DATABASE INTERACTIVE MONITORING application. But it is just screen of my application for new idea.

The following two picture are shown you how it works and looks like.

1. Database monitoring (Running : 7, Failure : 1)

Application automatically refresh connection status using ADF Poll control. Maybe next time will be use Active Data Control (server push).

2. Few minutes after some database comes up (Running : 4, Failure : 4)

Next version to be handle to database compare for replication and warehouse creation.

If you have a new idea or advice please comment here.

Thank you for your visit in my short post. :-) 

Best regards,

Erdenebayar

Linkedin: http://www.linkedin.com/in/erdenebayare

Twitter: http://twitter.com/#!/erdenebayare

My Visit in the AMIS Technology

I was visited to the AMIS Technology in November, 2011. I learned lot of things about ADF technology from Aino Andriesson and Lucas Jellema. 

Many thanks to Aino Andriesson, Lucas Jellema and AMIS Technology. http://technology.amis.nl/blog/

Best regards,

Erdenebayar

Out of box : Workflow based on ADF Hierarchy Viewer

I need to share our application design and solution based on ADF controls.

This topic shows you Workflow functionality using ADF Hierarchy Viewer control. We call this control as Visual Task Flow. Because this designed using ADF Task Flow, Fragments, Action and Hierarchy Viewer.

The following picture show you how it works our Visual Task Flow.

When we configured Task Flow in database it will show following diagram. And user can enter any of process.



Just click on ready node, and will go to related task flow or pages.


Also i attached different process using configuration.

Thank you for your visit in my short post. :-) 

Best regards,

Erdenebayar

Linkedin: http://www.linkedin.com/in/erdenebayare

Twitter: http://twitter.com/#!/erdenebayare

MySQL configuration on ADF Development

I need to share some MySQL problems. When we develop application using ADF within MySQL database, we get following issues.

Issue 1: Our af:query doesn’t work with MySQL database. We just debug that issue; it comes from pure SQL standard. Which means default mysql configuration doesn’t support PIPES.

Solve 1: We configured PIPES_AS_CONCAT in my.cnf (Linux). If you will face that problem in Windows, you configure in my.ini (Windows).

set-variable=sql-mode=PIPES_AS_CONCAT

Issue 2: Sometimes we created table name as lowercase and uppercase in database. So that case MySQL error comes from mostly at Linux. For example: table doesn’t exist. We solved following way.

Solve 2: Same configuration way in my.cnf, it is just ignore case value.

lower_case_table_names=1

Issue 3: When we started new application with ADF & MySQL, we got Unicode problem. So in this case we changed MySQL connection string in JDeveloper.

Solve 3: We entered custom JDBC URL in Database connection editor.

Maybe you have to visit juddi-oracle.blogspot.com blog. He explained very well.

http://juddi-oracle.blogspot.com/2011/08/mysql-unicode-datasource-problem.html

Issue 4: Sometimes we get MySQL connection time out problem. This case we have to change some variable and connection string. We get following error: java.net.SocketException: Broken pipe.
Solve 4: I think, There are two configuration required.
A. We can increase to connection timeout variable to appropriate value.
mysql> SHOW VARIABLES;
mysql>SET GLOBAL connect_timeout=120;
B. We can change connection string. I described some connection string changes above and i added additional property. ( autoReconnect=true )

jdbc:mysql://localhost:3306/mydb?autoReconnect=true&characterSetResults=UTF-8&characterEncoding=UTF-8&useUnicode=yes

Best Regards,

Erdenebayar

Client Side Mask using af:clientListener and inputText

I just created very simple case of client side mask using af:clientListener and inputText on ADF application. We are using that functionality for unexpected data enter of users.

We can use many other javascript frameworks for that functionality. Ex: JQuery etc…

I described step by step:

1. First I have created javascript file for mask. My application structure shows below:





2. My lazy javascript file. We can use some expression for this.






3. So now I drag and drop af:clientListener from Component Pallete. This clientListener works on keyPress.






4. Final interface shows below. Now we can type only letter and only number on each inputText.





I attached my simple application. SimpleClientSIdeMask

MySQL Stored Procedure with ADF Application

I have one situation with mysql stored procedure with ADF application, which are how to call mysql stored procedure from ADF application. Also stored procedure returns string of values (concat).

First i write stored procedure in MySQL database:

And after i call from Application Module client:

Finally we can use this client method from any side. (Task Flow etc...).

JDeveloper and ADF Satisfaction Survey - Need Your Input

Please go through -  JDeveloper and ADF Satisfaction Survey - Need Your Input.

I need open source ADF Library and certification on some open source application server.