Tuesday, March 1, 2011

View Object Query Execution @ ADF

Like a read-only view object, an entity-based view object sends its SQL query straight to the database using the standard Java Database Connectivity (JDBC) API, and the database produces a result set. In contrast to its read-only counterpart, however, as the entity-based view object retrieves each row of the database result set, it partitions the row attributes based on which entity usage they relate to. This partitioning occurs by creating an entity object row of the appropriate type for each of the view object's entity usages, populating them with the relevant attributes retrieved by the query, and storing each of these entity rows in its respective entity cache. Then, rather than storing duplicate copies of the data, the view row simply points at the
entity row parts that comprise it.

The entity row that are brought into the cache using findByPrimaryKey() containes all attributes of the entity object. In contrast, an entity row created by partitioning rows from the View object query result contains values only for attributes that appear in the query. It does not include the complete set of attributes. This partially populated entity row represents an important runtime performance optimization.

Tuesday, February 8, 2011

Error@Weblogic

1) Error: Weblogic Server Exception: weblogic.application.ModuleException:
[05:05:57 AM] Caused by: weblogic.common.resourcepool.ResourceSystemException: Cannot load driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
[05:05:57 AM]   See server logs or server console for more details

Solution: Simple, i copied sqljdbc.jar in the classpath. but got error that this is not suported by java version i was using. Try sqljdbc4.jar. i did the same and it worked. :)




2) Error: unresolved application library references defined in weblogic-application.xml

Solution: deployed all the libraries that were required by the already installed libs. Another shortcut is to extend the domain with required libraries. In my case it was oracle JRF.
If its the integrated weblogic domain try to create the default domain again. If its the custom managed server, then make sure the deployed libraries are targeting to the server.

Monday, January 3, 2011

Today's Issue @ Site Studio

Hmm..Today i got an error when i started my Site Studio first time. After entering details in site connection manager when i clicked Done i got "Failed to get search result for query: Fragment".

Resolution: After following this link, i changed the SearchIndexEngineName parameter in the conf file to DATBASE.FULLTEXT and that resolved the issue :).

Side Effect: Now i am getting an alert at UCM home page "Site Studio requires the DBSearchContainsOpSupport component to be enabled when the configured search engine is in use" and i am searching for its resolution :).

I got its resolution soon. DBSearchContainsOpSupport is actually a component that needs to be enabled. It adds support of hasAsWord(Contains Word) operator to DATABASE.METADATA and DATABASE.FULLTEXT on SQL Server and Oracle.

Sunday, January 2, 2011

Today's Learning @ ADF

Got some hands over ADF metadata xml files. Followed http://download.oracle.com/docs/cd/E12839_01/web.1111/b31974/appendixa.htm

While looking at the folders created by default when creating new application, i found a JWS (Java Web Service) file. I have to go in further details on how that file is created and how WSDLs are generated using that.