Dear All,
I have a question around SCA and Java embedded in a database. How
feasible is it to embedded SCA within say the Java VM running within an
Oracle database, either to provide a service or as a client to call a
service.
I have a scenario in mind that goes essentially like this:
1. Some database logic (e.g. PL/SQL) calls a piece of Java code
2. Java code needs to call out to an external service – for example
to access an external Work Order system to obtain a new work order id
3. Java code calls an SCA client, using (say) the Web Services
binding to access the remote service direct from within the database
4. Obtains a new id back and continues?
Obviously the Database JVM must be able to support the appropriate
version of Java etc. but what else might be required.
Potentially hosting services is more of an issue – however, in some
cases it might be useful to define a Java POJO that will invoke PL/SQL
within the database for performance issues (obviously we could create a
POJO external to the database that could call the PL/SQL / stored
procedures externally). However, I suspect that this is a rather more
problematic area. For example, depending upon the binding selected what
functionality is required in the database - how would a web service, rmi
or jms binding be supported (if indeed at all).
In terms of real world scenarios I know of numerous situations in which
the SCA client in the database scenario would be very useful. I have
less “real world” scenarios for the service in the database example.
But should the ability to at least run an SCA Client from within the
database be a supported SCA scenario? I would be very interested to know
what the SCA Dev community think about this.
Regards,
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
