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!

ADF: Insert Region Programatically

987779Jan 29 2013 — edited Jan 29 2013
Hello:

I'm using jdeveloper ver. 11.1.2.3.0 . I'm trying to add new RichPanelBox components, with a region inside to a page programatically. I create the RichPanelBox and place inside a RichRegion but when i use the .setValue method of the RichRegion to set the RegionModel I receive an error:
 <PropertyKey> <saveValue> Valor no serializable: oracle.adf.controller.internal.binding.DCTaskFlowBinding$InnerTaskFlowRegionModel@16f8890 para la clave: UINodePropertyKey[value,15]
I tried also with the .setValueExpression method and i'm receiving the same error.

Here is the chunk of code where i am having this problem:
        private void maximize(ActionEvent actionEvent) { 
        String id = actionEvent.getComponent().getId().replace("maximize_",""); 
        RichRegion region = new RichRegion(); 
        RegionModel regionModel = this.getRegionModelTaskFlow(id); 
        region.setId("region_"+id); 
        region.setValue(regionModel); 
         
        RichPanelBox panelBox=(RichPanelBox)JSFUtils.findComponentInRoot("maximized"); 
        panelBox.getChildren().add(region); 
         .
         .
         .
    }
What I'm trying to achieve is to add dynamically new PanelBoxes and assing to them a taskflow, all in runtime.

I saw a previous thread with likely the same problem is this (851878 in this case (2009) it was pointed that it was an ER.

Thanks

Comments

Mike Kutz

I was under the impression that the file parsing was done via ORDS code (using Apache POI), not APEX (which has to work on XE - which can't use Java)

I'm wondering: Do you need to upgrade ORDS?

I've always used SQL*Developer to adjust the EXCEL2COLLECTION settings.

Although, I prefer to use the XLS2Collection plugin.

I don't have access to a 5.1 that I can play with.  sorry

MK

Marc Sewtz-Oracle
Answer

Hi Denes,

The Excel to Collection functionality no longer works when using ORDS and APEX 5.1. In APEX 5.1 we've changed the page submission to use JSON, which does not work with the current Excel to Collection implementation in ORDS. Unfortunately we don't have an alternative or work around available at this time.

Regards,

Marc

Marked as Answer by Denes Kubicek · Sep 27 2020
Denes Kubicek

Marc,

Thanks for answering. Well, this is bad for us since a couple of applications depend on this feature. I will have to think about the workarrounds here. This is not easy now.

Regards,

Denes Kubicek

Patrick Wolf-Oracle

Hi Denes,

as a workaround, you might want to have a look at https://chrisonoracle.wordpress.com/2013/11/13/read-excel-file-in-plsql-using-java-in-the-db/

Regards

Patrick

Anton Scheffer

This - Process Type Plugin - EXCEL2COLLECTIONS  plugin is a great workaroud                      

Denes Kubicek

Anton,

Many thanks. I could get it working and can use it as an alternative solution until it works again with ORDS.

Regards,

Denes

Scott Wesley

Best PL/SQL plugin ever. (excel2collection)

Anton Scheffer

Thanks for nice words. It's a nice plugin indeed. Not the best though.
I've never used it myself. I prefer less generic plugins which insert the data into a table, not into an APEX collection.

That results into a much better performance, seconds instead of minutes for loading a file with than a few 1000 records. 

Anton

jareeq

Some time ago (i believe ords 2.x and apex 4.2) xls2collection was broken. After that was fixed to finally work with xls and xlsx (apex 5.0.2 and listener 2.0.9) and worked (not as efficient as in listener 1.x but it was complete out of the box solution)

Now in 2017 (apex 5.1 and ords 3.x) we go back to 2011 and need to use workaround to keep function live.

I'm always impressed how apex/ords new versions broke old functions without a word.

Without Anton we would have been beaten.

jareeq

After reading this Let's Wreck This Together...with Oracle Application Express!: excel2collection functionality of ORDS will not work with … 

Will Anton plugin work without ords support for excel import ?

Mike Kutz

Please start a new question.

thanks,

MK

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

Post Details

Locked on Feb 26 2013
Added on Jan 29 2013
2 comments
198 views