Fetch Record from database
Author: ADH2COB
Publication Date: 6/13/2014 11:06
How to fetch single record from data base using record id
-
Author: teichmann - 6/13/2014 11:54
Hello,
can you describe more precisely what you want to do?
In which context do you want to get a single database record?
Do you want to get it via script or in an output channel (e.g. html)?0 -
Author: ADH2COB - 6/13/2014 12:08
I have a set of records in data base representing each and every page contents.
I have a built a fsm module.Instead of iterating whole table and find the matching record I wanna fetch single record from data base using record id or some unique value i have wioth me.I want it in java.
0 -
Author: MichaelaReydt - 6/13/2014 12:22
Hello Ajay,
perhaps this blogposting helps you: click
The section "Update" describes how to get an entity via its ID inside a script.
Best regards
Michaela
0 -
Author: teichmann - 6/26/2014 14:50
Hello,
do you need further help or did Michaela Pahl's reply already help you?
If so, it would be great if you marked her reply as "correct answer" so that other community users find the solution easily.
If you have already found a solution by yourself, it would be very kind of you, if you posted it here.
Best regards,
Jascha
0 -
Author: ADH2COB - 6/27/2014 10:11
Ya i found it below is the code snippet.I used Select class within fs-access jar,
Select select = session.createSelect("tableName");
Equal equal = new Equal("columnName","value for comparision");
select.setConstraint(equal);
EntityList entutyList = session.executeQuery(select);
Entity entity = entityList.get(0);
0
Please sign in to leave a comment.
Comments
5 comments