Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Table refresh after insert shows empty cells

xDestinatioNxNov 10 2015 — edited Nov 10 2015

Hello experts,

I'm trying to insert custom values from some input fields into a table displayed on my page. The table comes from an Entity based VO with a sequence number and some Constraints.

The sequence number stacks automatically handled by the database.

The input fields are binded to a managed bean to get the value with "getValue()" and then I build a String for the input. The String gets afterwards splitted in the VO as some Attributes with the following SQL calculation for example:

REGEXP_SUBSTR(Attribute3, '[^,]+', 1, 5)

But this is on the Database/ViewObject Layer.

Following I invoke the method from the VO Impl to create the new row like this:

Managed Bean:

OperationBinding operationBinding = bindings.getOperationBinding("addRow");

operationBinding.getParamsMap().put("value1", someInt);

operationBinding.getParamsMap().put("value2", someIntToo);

operationBinding.getParamsMap().put("value3", someString);

operationBinding.execute();

VO Impl:

public void addRow(Integer value1, Integer value2, String value3) {

ViewObject vo = this;

Row newRow = vo.createRow();

newRow.setAttribute("Attribute1", value1);

newRow.setAttribute("Attribute2", value2);

newRow.setAttribute("Attribute3", value3);

vo.insertRow(newRow);

this.getDBTransaction().commit();

}

I'm catching no exceptions yet, but when I insert everything correctly and trigger the managed bean code via a button action, the table will show the new row with correct Integers, but the String splitted by the SQL calculation from above only shows as empty cells. After searching with the table filter and removing the filter search again, the Strings show up correctly.

For example, after insert:

table1.PNG

Then after "refreshing" with the filter:

table2.PNG

What can I do about this? I can't really insert the data via InsertWithParams, 'cause I need to build the String with some Java Code.

It only dont show the data after inserting, PartialTrigger(s) also wont work.

This post has been answered by kdario on Nov 10 2015
Jump to Answer

Comments

RajenB

Thanks !

Nice way to start Python.

sp200064

Thanks, this is really helpful.

James G K

Good stuff, thank you!!

RajeshKhanna

A good way to start! nice job

RAL281_CL

Thanks,very way to start.

Where is Part 5 ??

Best Regards

Ricardo

3000272

Please share the Part 5 Videos

unknown-1040115

Please share the Part 5 Videos

Part 5 is up!

Enjoy!

LKR

3696832

So Good to see this..Shaft meets sharp head.

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 8 2015
Added on Nov 10 2015
2 comments
507 views