3 Replies Latest reply: Nov 4, 2011 10:44 AM by 898136 RSS

    iStore JSP customization from JDeveloper

    602186
      Hi, I am new to iStore and i am trying to setup JDeveloper to customize JSP pages. I found a metalink note on copying files to JDeveloper for 11i (Doc Id:419887.1) but not for R12, so i tried to find the similar directory structure and copied all the classes, jsps, css and images from the App server to JDeveloper project.

      I am trying to execute a sample jsp (TestDbcConn.jsp) as suggested in the article and getting the following error while running it. I have verified the DB connection through SQL developer and it connects. Am I missing some configuration or setup here?

      ********************************************************************************************************
      JTFDBCFILE=D:\projects\customer\iStoreR12\secure\customer-dev.dbc

      oracle.apps.fnd.cache.CacheException
           at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:228)
           at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1485)
           at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:354)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1259)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1114)
           at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1083)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1050)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1037)
           at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
           at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:593)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
           at oracle.apps.fnd.common.AppsContext.(AppsContext.java:292)
           at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:1081)
           at oa_html._TestDbcConn._jspService(_TestDbcConn.java:100)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
           at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
           at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
           at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
           at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
           at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
           at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
           at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
           at java.lang.Thread.run(Thread.java:595)
      Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:833)
           at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802)
           at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4624)
           at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:216)
           ... 35 more
      Caused by: oracle.apps.jtf.base.resources.FrameworkException:
      An exception occurred in the method CacheAccess.get
      null
      The base exception is:
      Exception creating new Poolable object.
           at oracle.apps.jtf.base.resources.FrameworkException.convertException(FrameworkException.java:607)
           at oracle.apps.jtf.base.resources.FrameworkException.addException(FrameworkException.java:585)
           at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:66)
           at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:88)
           at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:202)
           at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:218)
           at oracle.apps.jtf.base.resources.FrameworkException.(FrameworkException.java:249)
           ... 39 more
      ********************************************************************************************************