Skip to main content

Hands on lab materiels on using JDeveloper for building and managing enterprise grade applications

In this post I'm sharing some hands on lab materials on JDeveloper IDE which may help you to understand offerings from JDeveloper for building and managing large scale enterprise grade Java EE applications.

Wish you all a great year ahead, have fun!


Phai Vv said…
I have a problem like this.
I have three table :

1 - Country : CountryID (pk), CountryName.
2 - Province : ProvinceID (pk), ProvinceName, CountryID (fk).
3 - Employee: EmployeeID, EmployeeName, Email, ProvinceID (fk).

Now i want insert a new row into Employee table with form :
EmployeeID : ............
EmployeeName: ...........
Email: ...........
The thing is when choice Country ---> Province will show.
If selected US : Texas, Califolia..
or if selected England: Mancity, Liverpool....
we just insert ProvinceID into Employee table not CountryID at all.
I was try do this by created new View object from three table but it's not working.
Anonymous said…
Thank you.

Popular posts from this blog

Happy New Year 2018 !

We can't go back and change the beginning, but we always can start where we are and change the ending. Believe in yourself and you will be unstoppable!

Wishing you and your family a very happy new year 2018 !!!

How to set Bind Variable Values at runtime ?

In this post I'm sharing a couple of approaches for programmatically setting bind variables values at run time. This post is an attempt to explain 'When to use what ?'[ In case if you are familiar with 'Bind Variables' in ADF BC, please refer Section 5.10, Working with Bind Variables in Fusion Developer's Guide ]

1. Set the Bind Variable value using RowSet::setNamedWhereClauseParam(...)

You can use use the setNamedWhereClauseParam(...) method on the ViewObject interface (which extends oracle.jbo.RowSet) to set the value for bind variables. Please note this sets the value on default RowSet. In other words, this doesn't have any effect on the secondary RowSets that you/system generates.
ViewObject vo = am.findViewObject("EmployeesView1"); vo.setNamedWhereClauseParam("bindVarDeptId", new Number(10)); vo.executeQuery();
2. Set the Bind Variable value using ViewObject's VariableValueManager::setVariableValue(...)

VariableValueManager Ma…