Monday, June 21, 2010

Always run weblogic servers as Administrator

I spend all weekend trying to install SOA suite at home.
I have a new i7 pc with windows 7 and 4G ram.
After spending hours on installing:
-->11g database,
-->Repositories with rcu (failed the first time because of database parameters processes and open_cursors must be 500)
-->Java bridge
-->Lookback adapter.
-->Weblogic 10.3.3.
-->Application development runtime 11.1.1.2 and 11.1.1.3
-->SOA Suite 11.1.1.2 and patchset 11.1.1.3

I try to run admin server and I got many exceptions … class not found … invalid variables, deployments failed.

So I thought I did something wrong and I did the hall thing again (from the weblogic part). But still the same ??!!. Then it came to me…
I right click on Start Admin server and I choose run as Administrator… and eurica!! All went smoothly.

I used the same way to open cmd windows to run managed servers:
-->first soa_server took 20 minutes to deploy all applications
-->then bam_server
Everything worked fine now.

Yet the memory consumption of my pc went to 3GB, and everything was operating really slowly after that.

So I suggest… don’t try this at home…

Monday, June 14, 2010

Range Paging in LOVs bug #9467477

Using Range Paging in LOVs is fixed in new jdeveloper 11.1.1.3.
http://adfbugs.blogspot.com/2009/07/performance-tuning-lovs-and-range.html

Yet it still has bugs, when you use LOV criteria or on dependent LOV sometimes it shows error:

java.sql.SQLException: Missing IN or OUT parameter at index:: 1 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

I have posted an SR for this and bug was logged #9467477 SQLEXCEPTION: MISSING IN OR OUT PARAMETER AT INDEX, IN LOV WITH RANGE PAGING, that it is also fixed for next jdeveloper 11.1.1.4 release. Thanks Didier.

I decided to post it also here since this bug is not public visible in Support (not even for me that i posted the SR.

Steps to reproduce in test case are:
1. Open Departments LOV
2. Scroll down to LOV until fethcing data message apears
3. Type in criteria for departmentId value i.e.'1' and without pressing Search select a row in LOV.SQL
Error message apears:



Test Case:
http://adfbugs.googlecode.com/files/LovRangePagingBug.zip

Monday, June 7, 2010

Entity Security (jdeveloper11.1.1.3 Functionality Change)

After Migration to new jdeveloper we found out that users that had no permissions to update entities could insert and save new records!!!???

I managed to reproduced in a simple test case with 1 entity Jobs on an editable table.
I have enabled security and I have 2 roles ‘UpdateJobs’ and ‘ViewJobs’.

I have added authorisation to entity update and delete for role UpdateJobs.


When I loggin with a user that just have ViewJobs role table rows comes read only and Delete button disabled.


Yet CreateInsert button is enabled and if I press it new row is created with updatable attributes that I can also save it without a problem.

Before last patch you could still create new row but it was not updatable.
Is this a bug?

Test case:
http://adfbugs.googlecode.com/files/TestInsertSecurity.zip
password for User and Manager : welcome1

Wednesday, June 2, 2010

ADF Client Tag Libraries of weblogic 10.3.3 installation are diferent from jdeveloper11.1.1.3

Latest weblogic 10.3.3 installation and jdeveloper11.1.1.3.0 installation software
http://www.oracle.com/technology/software/products/middleware/index.html

have different adf faces component ligraries.

We found it the hard way.
We used the new feature of popups the autoCancel property.
Even though in embeded weblogic is working, when we deployed we had a jsp compilation error:

Error message: Failed to compile JSP /pages/bill/billissue/billIssue.jspxbillIssue.jspx:792:23: This attribute is not recognized. autoCancel="disabled"> ^--------^ Error type: class weblogic.servlet.jsp.CompilationException

by searching the differences we found out that
Oracle/MiddlewareR1P2/oracle_common/modules/oracle.adf.view_11.1.1/adf-richclient-impl-11.jar!/META-INF/afu.tld
in jdeveloper 11.1.1.3
is different than
wsl_middleware/oracle_common/modules/oracle.adf.view_11.1.1/adf-richclient-impl-11.jar!/META-INF/afu.tld
of the weblogic 10.3.3. installation
The weblogic afu.tld does not have the autoCancel property

We hope that by just copying the jdeveloper11.1.1.3 adf-richclient-impl-11.jar to weblogic the problem will be fixed.

Unfortunately, just copying the jar did not solve the problem

Test Case: http://adfbugs.googlecode.com/files/TestAutoCancelPopup.zip

SR posted :3-1820014361

It seems that you need to manual install on latest weblogic 10.3.3. tha latest adf runtime libraries.
You can find how to on:
Oracle Support Knowledge base Note [ID 1094153.1] Installing ADF 11.1.1.3 Runtime Into FMW 11gR1 Patchset 2
or http://theblasfrompas.blogspot.com/2010/05/installing-adf-runtime-into-fmw-11gr1.html