Oracle Weblogic Server (MOSC)

MOSC Banner

DBAdapter called by EJB in WLS

edited Jan 6, 2011 3:10AM in Oracle Weblogic Server (MOSC) 1 commentAnswered ✓
 Hello,
I'm trying to call DBAdapter used by OSB 10gR3 in WLS by a SLSB.

1) I get connection factory:
# Context ic = new InitialContext();
# cf = (DBConnectionFactory) ic.lookup("eis/DB/logdb");

2) read interaction specs supported:
# ResourceAdapterMetaData metaData = cf.getMetaData();
... and see oracle.tip.adapter.db.DBStoredProcedureInt
eractionSpec is supported

3) get connection:
# con = cf.getConnection();

4) initialize interaction:
# DBInteraction ix = (DBInteraction) con.createInteraction();
# DBStoredProcedureInteractionSpec dbSpec = new DBStoredProcedureInteractionSpec();
# dbSpec.setConnectionFactory(cf);

5) read OSB project XML schema describing data structure and th rest of specs parts:
...
# XMLSchema schema = (XMLSchema) xsdBuilder.build(url);
# dbSpec.setNXSDSchema(schema);
# dbSpec.setSchemaName("MW");
# dbSpec.setPackageName("MW_API_PCKG");
# dbSpec.setProcedureName("INSERTLOGFEREQUEST");

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center