ADF, ADF Exceptions

ADF java.lang.ClassCastException: …ViewRowImpl cannot be cast to …ViewRow ?

For example: java.lang.ClassCastException: model.DepartmentsViewRowImpl cannot be cast to model.common.DepartmentsViewRow JDeveloper, when generating View Object Row client interface sometimes goes wrong with class definition. Such error can be displayed when implementation of class is not defined. In particular error sample –  “implements DepartmentsViewRow” is missing in DepartmentsViewRowImpl class: public class DepartmentsViewRowImpl extends ViewRowImpl implements DepartmentsViewRow { … }

ADF, Database, SQL and PL/SQL

ADF method for calling DB procedures, executing other SQL statements with input and output parameters

How to call DB procedure with input and output parameters. Here I provide an example of ADF method which can be used with any number of in/pout parameters used in any order:     public void runStatement(String stt, boolean commit, ArrayList<Map<String, Object>> pars) {                  CallableStatement st = this.getDBTransaction().createCallableStatement((stt), 0);      …

Continue Reading

ADF

How to output text with line breaks in ADF ?

Problem Suppose you have multinline (i.e. af:inputText) text field. User fills form by entering some multiple lines in there. Later on you have to display this text in readonly form. You can do this for sure by just adding attribute readonly=”true” or using af:outputText component. Just one issue pops out – there is no multiple lines which user entered –…

Continue Reading

ADF

How to get LOV value instead of index when it is used in “selectOneChoice” component in the table row?

When using LOV’s, a common issue in ADF is to get selected value instead of index when LOV is used to render for example “selectOneChoice” component. I’ve faced it when “selectOneChoice” was used in table. That means every row in table can have different selection of LOV values. Thus we can’t rely on iterators current row and simply to access…

Continue Reading

ADF, ADF Exceptions

JBO-25058: Definition vc_temp_1 of type Variable is not found in …

“JBO-25058: Definition vc_temp_1 of type Variable is not found in …”. What can be the reason? ADF creates/reuses application module (AM) instance for each user request. It is passivated (saved) after each HTTP request (if configured accordingly). When in application there are used some queries with view criteria, filter variables are passivated  for according AM as well. During the next…

Continue Reading

Database

How to create XMLIndex? When its worth to use it?

How to create XML index? Very general way with all default applied as follows: create index index_name on table_name (xmltype_column) indextype is xdb.xmlindex; Check the name of PATH table select path_table_name from user_xml_indexes  where table_name = ‘table_name’ and index_name = ‘index_name’;  Check what secondary indexes are used select c.index_name, c.column_name, c.column_position, e.column_expression   from user_ind_columns c left outer join user_ind_expressions…

Continue Reading

Database, Logging, SQL and PL/SQL

How to enable tracing in Oracle DB? How to read trace files?

There are many ways to enable tracing in Oracle DB, some are legacy and deprecated. One of latest and recommended method for 11gR2 – use of DBMS_MONITOR (find out more about it in Oracle reference) package. To enable whole instance tracing: execute dbms_monitor.database_trace_enable(waits => true, binds => true,  instance_name => ‘instance_name’); To disable whole instance tracing:  execute dbms_monitor.database_trace_disable(instance_name => ‘instance_name’);…

Continue Reading