Friday, March 31, 2006

Routing around the WS-* vendor stacks (Loud Thinking)

This is a link to an intresting article, quotes includes:

"The gulf between Web Services™ and web services have been widening as of late. HTTP awareness is on the rise, atompub is shining a light for best-practice REST, and the complexity of the WS-* stack is reaching astronautical heights.>>A comment in to the post states: >>So SOAP feels more like the doorknob to the gates of hell. In itself, a doorknob is hardly evil. But once you turn... :)"

Read more at www.loudthinking.com/ar...

Sphere: Related Content

Friday, March 24, 2006

Oracle BPEL PM and Biztalk interop

See this link for a Biztalk - and Oracle BPEL PM & Security WS example:
http://weblogs.asp.net/gsusx/archive/2006/03/22/440881.aspx

Also:
1. See this microsoft technote on Application Interoperability: Microsoft .NET and J2EE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/JDNI.asp

2. For MSMQ interop see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/jdni_ch05.asp

3. BizTalk Adapters for JMS,
http://www.topxml.com/biztalkutilities/biztalk2004.asp

4. iWAY MSMQ adapter
http://www.iwaysoftware.com/messaging.html

5. Custom .NET code to access an Oracle Streams AQ
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=e97ee3ed-71c0-4fe2-995b-f00418ac7e0b
http://www.codeproject.com/cs/database/aqlib.asp
http://www.oracle.com/technology/sample_code/tech/dataint/index.html

Sphere: Related Content

Wednesday, March 22, 2006

APPS: Finding Flexfields per table

This SQL gave me a nice report on Oracle Apps flexfields used in a set of tables:

select distinct
fdf.APPLICATION_TABLE_NAME,
fcu.APPLICATION_COLUMN_NAME,
fcu.descriptive_flex_context_code,
fcu.END_USER_COLUMN_NAME,
fcu.ENABLED_FLAG,fcu.REQUIRED_FLAG,fcu.DISPLAY_FLAG,fcu.DISPLAY_SIZE, fcu.FLEX_VALUE_SET_ID
,fvs.FLEX_VALUE_SET_NAME, fvs.DESCRIPTION VALUESETDESC, fvs.VALIDATION_TYPE
from APPLSYS.FND_DESCRIPTIVE_FLEXS fdf
left outer join APPLSYS.FND_DESCR_FLEX_COLUMN_USAGES fcu
on fdf.application_id = fcu.application_id
and fdf.descriptive_flexfield_name = fcu.descriptive_flexfield_name
left outer join APPLSYS.FND_FLEX_VALUE_SETS fvs
on fcu.FLEX_VALUE_SET_ID = fvs.FLEX_VALUE_SET_ID
where fdf.application_table_name in (....list_of_tables...)
order by 1,2,3

Sphere: Related Content

Saturday, March 11, 2006

DVM in Oracle BPEL PM

There is a couple of options for Domain value mapping (DVM) in Oracle BPEL PM

A) The XSLT Mapper provides the following database functions for DVM .

1. execute-query() Execute a database query and obtain a result set
2. lookup-table() - Look up a DB table and get a value back

B) Database Adapter

C) Use one of the above to create a BPEL PM Service to do the DVM you need

Sphere: Related Content

AOSD tools for SOA?

Aspect-oriented software development (AOSD) is a holistic approach to developing applications with tools (eg AspectJ, Spring AOP) that uses tools that help abstract concern that crosscuts between different domains/objects.

The definition of AOSD is as follows:

AOSD is an emerging paradigm that provides explicit abstractions for concerns that tend to crosscut over multiple system components and result in tangling in individual components. By representing crosscutting concerns or aspects as first-class abstractions, and by providing new composition techniques for combining aspects and components, the modularity of the system can be improved leading to a reduced complexity of the system and easier maintainability.

AOSD is mostly about single systems and SOA is about interaction between systems or enterprise architectures. But I still think that there are AOSD tools that can help when you design your enterprise systems.

One of this tools is presented in the book "Aspect-Oriented Software Development with Use-Cases" Ivar Jacobson and Pan-Wei NG gives us a AOSD extention to the well known and mature use-case-driven approach.

Sphere: Related Content

Thursday, March 09, 2006

glassfish: About GlassFish

"GlassFish is the name for the open source development project for bulding a Java EE 5 application server. It is based on the source code for Sun Java System Application Server PE 9 donated by Sun Microsystems and TopLink persistence code donated by Oracle. " or ... "who needs JBOSS and hibernate..."

Read more at glassfish.dev.java.net/...

Sphere: Related Content

Tuesday, March 07, 2006

HowTo: Reinstall/Secure EM DBconsole in 10.2

This is the commands to drop and reinstall the EM DBconsole repository and setup TLS security to secure your "SYS" passwords on the network. (If you only want to secure, start at step 3.)

1. emca -deconfig dbcontrol db -repos drop
2. emca -config dbcontrol db -repos create
3. emctl stop dbconsole
5. emctl secure dbconsole
6. emctl start dbconsole

Note that the emca syntax has changed in 10.2. (In 10.1 the commands are emca -x and emca -r ... I think.)

Sphere: Related Content