Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

JDeveloper and ADF


CRUD operations in ADF


I am new to ADF.I want to perform database  operations (insert,update,delete) programatically.can anyone suggest me the best place to implement these operations(i.e  in backing bean/EntityObjectImpl/ApplicationModuleImpl).It would be more helpful if an example is provided .  Thanks in Advance, Best Regards, Siva

Did you try the first tutorial on the JDeveloper home page?  John

Hi  John,  Thanks for your help.I tried the first tutorial  and built the RIA app.All the db operations are happened thru the wizards(like  updateable view objects).But I want to perform the db operations programatically i.e I want grab the input values and has to insert those values into the tables by establishing the database connection,queries programatically.   Thanks in Advance, Best Regards, Siva

user13111513 wrote: Hi  John,  Thanks for your help.I tried the first tutorial  and built the RIA app.All the db operations are happened thru the wizards(like  updateable view objects).But I want to perform the db operations programatically i.e I want grab the input values and has to insert those values into the tables by establishing the database connection,queries programatically.    Thanks in Advance, Best Regards, Siva  Then why you need ADF?  if you want to do every thing programmatically and making your life difficult   Read Fusion developer guide for all answers http://download.oracle.com/docs/cd/E14571_01/web.1111/b31974/toc.htm

Can you explain what specifically are you trying to achieve by doing this programmatically vs. letting ADF do it for you? You can overwrite and extend the ADF layer to do things differently see: http://download.oracle.com/docs/cd/E15523_01/web.1111/b31974/bcservices.htm#sm0222 and http://download.oracle.com/docs/cd/E15523_01/web.1111/b31974/appendix_mostcommon.htm#sm0398

I think Shay is right in that maybe we need to take a step back and understand what you are looking to do.  However, to address the specific question you asked; the preferred way of doing things in ADF would be to push your business logic code (accessing the database etc) in the Model and keep the UI as clean as possible - this makes it much each to reuse, for example, if you wanted to access the business service in a UI-less way, like a web service.  Regards Grant  p.s.I also agree that if you are going to use ADF then you should let it do as much as possible for you - certainly for database access, you can do a lot without having to write a single line of code.


Related Links

Sequence setup incorrectly
How to obtain total row count SELECT COUNT(*) and put it on a page?
Programatically change the value of an af:InputText
ADF Desktop Integration - Can it Support Master Detail Information
Frank Nimphius's TreeWalking workspace?
new project automatically getting created when workspace is created
Unable to find Business Rules in the JDeveloper while creating new project
XMLMenuModel: Can we have a taskflow other than adfc-config as root_menu
jdev11 table filtering bug
using a generic pageDef
Diagram Refresh Rate Slow
How do I customize the calendar control?
null bindings // debugging a taskflow contained in an adf library
In memory sorting of programmatic view object
Dynamic LOV
ClassNotFoundException while creating PLSQL web service using WSIF binding