DBAdapter called by EJB in WLS
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");
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");
0