Ok it seem that our old code (version 8i) is not "portable" to 9i... so i need your help with this...
If there is any documentation relating to this let me know, I've check at oracle but it's a real maze...
First, i have a BC4J that create a .jar contaning an application, a view object and so on...
I whant to write a
JSP that will connect to the aplication module and my view. Then I want to manually add a where clause to this view (in the JSP) and then render it to obtain a XML. If possible, transform it (XSLT) with a XSL. Easy enough?? Look at my old code that dosent work now:
------------------------------------------------
String strAppModule = "infogen.InfoGen_app";
String strConnection = "jdbc
racle:thin
rioq_interv/drioq@drioq_bd_cen:1521:CEN";
Hashtable env = new Hashtable(10);
env.put(Context.INITIAL_CONTEXT_FACTORY, JboContext.JBO_CONTEXT_FACTORY);
env.put(JboContext.DEPLOY_PLATFORM , JboContext.PLATFORM_LOCAL);
Context ic = new InitialContext(env);
ApplicationModuleHome home = (ApplicationModuleHome)ic.lookup(strAppModule);
ApplicationModule objAppModule = home.create();
objAppModule.getTransaction().connect(strConnection);
session.putValue("JBOApplication_infogen_InfoGen_app", objAppModule);
objViewObject = objAppModule.findViewObject("menu_view");
objViewObject.setWhereClause("Utilisateur.ID_UTILISATEUR = ?");
objViewObject.setWhereClauseParam(0, strIdUtilisateur);
<jsp:useBean id="XSLTProcesseur" class="drioq.XmlExt.XmlDataExt" scope="request">
<%
XSLTProcesseur.initialize(application, session , request, response, out, "infogen_InfoGen_app.menu_view");
XSLTProcesseur.setStylesheet("/xsl/DRIOQ2_Recherche.xsl");
XSLTProcesseur.render();
XSLTProcesseur.setReleaseApplicationResources(true);
%>
</jsp:useBean>
<%
session.removeValue("JBOApplication_infogen_InfoGen_app");
%>
------------------------------------------------
