5 Replies Latest reply on Jul 25, 2013 4:39 AM by 1026065

    Getting error while connecting to AS400 DB through Jdeveloper

    1026065

      I am using Jdeveloper 11.1.2.4.0 and Connecting AS400 DB using the Driver com.ibm.as400.access.AS400JDBCDriver and I put the jt400.jar in classpath : :\JDeveloper\system11.1.2.4.39.64.36.1\DefaultDomain\lib\jt400.jar.

      Now I am able to test the connection through IDE and it is connected successfuly. But the Issue is I am not able to run the Business Component thtough Application Module and Run the UI pages.

      I am getting the following Error:

       

      [1112] DBTransactionImpl.initTransaction: Login failed
      [1113] java.sql.SQLException: No suitable driver found for jdbc:as400://host/database

      at java.sql.DriverManager.getConnection(DriverManager.java:602)
      at java.sql.DriverManager.getConnection(DriverManager.java:185)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:187)
      at oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
      at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:195)
      at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:166)
      at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:580)
      at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:313)
      at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:102)
      at oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
      at oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:172)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:45)
      at oracle.jbo.server.ConnectionPoolDataSource.getConnection(ConnectionPoolDataSource.java:72)
      at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:964)
      at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1147)
      at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6838)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:298)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:329)
      at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:600)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:417)
      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9053)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4606)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2536)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2346)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3245)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:571)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:504)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:499)
      at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:517)
      at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:867)
      at oracle.jbo.jbotester.binding.TesterBinding.getConnectionInfo(TesterBinding.java:222)
      at oracle.jbo.jbotester.MainFrame.initializeDataControl(MainFrame.java:945)
      at oracle.jbo.jbotester.MainFrame.loadConfiguration(MainFrame.java:646)
      at oracle.jbo.jbotester.MainFrame.processArgs(MainFrame.java:612)
      at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:446)

      [1114] A dead application module instance was detected
      [1115] The application module instance was removed from the pool
      [1116] ApplicationPoolImpl.resourceStateChanged wasn't release related. No notify invoked.
      [1122] oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection.
      at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:207)
      at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:166)
      at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:580)
      at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:313)
      at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:102)
      at oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
      at oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:172)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:45)
      at oracle.jbo.server.ConnectionPoolDataSource.getConnection(ConnectionPoolDataSource.java:72)
      at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:964)
      at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1147)
      at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6838)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:298)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:329)
      at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:600)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:417)
      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9053)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4606)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2536)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2346)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3245)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:571)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:504)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:499)
      at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:517)
      at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:867)
      at oracle.jbo.jbotester.binding.TesterBinding.getConnectionInfo(TesterBinding.java:222)
      at oracle.jbo.jbotester.MainFrame.initializeDataControl(MainFrame.java:945)
      at oracle.jbo.jbotester.MainFrame.loadConfiguration(MainFrame.java:646)
      at oracle.jbo.jbotester.MainFrame.processArgs(MainFrame.java:612)
      at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:446)
      Caused by: java.sql.SQLException: No suitable driver found for jdbc:as400://host/database

      at java.sql.DriverManager.getConnection(DriverManager.java:602)
      at java.sql.DriverManager.getConnection(DriverManager.java:185)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:187)
      at oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
      at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:195)
      ... 32 more
      ## Detail 0 ##
      java.sql.SQLException: No suitable driver found for jdbc:as400://host/database

      at java.sql.DriverManager.getConnection(DriverManager.java:602)
      at java.sql.DriverManager.getConnection(DriverManager.java:185)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:187)
      at oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
      at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:195)
      at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:166)
      at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:580)
      at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:313)
      at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:102)
      at oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
      at oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:172)
      at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:45)
      at oracle.jbo.server.ConnectionPoolDataSource.getConnection(ConnectionPoolDataSource.java:72)
      at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:964)
      at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1147)
      at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6838)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:298)
      at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:329)
      at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:600)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:417)
      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9053)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4606)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2536)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2346)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3245)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:571)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:504)
      at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:499)
      at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:517)
      at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:867)
      at oracle.jbo.jbotester.binding.TesterBinding.getConnectionInfo(TesterBinding.java:222)
      at oracle.jbo.jbotester.MainFrame.initializeDataControl(MainFrame.java:945)
      at oracle.jbo.jbotester.MainFrame.loadConfiguration(MainFrame.java:646)
      at oracle.jbo.jbotester.MainFrame.processArgs(MainFrame.java:612)
      at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:446)

      [1123] JUErrorHandlerDlg.reportException(oracle.jbo.jbotester.ErrorHandler$ExceptionWrapper)
      [1124] UIMessageBundle (language base) being initialized
      18-Jul-2013 10:12:44 oracle.jbo.jbotester.MainFrame exit
      INFO: BC4J Tester exit code(-3)
      Process exited with exit code -3.

       

      Please explain me why I am getting this error: java.sql.SQLException: No suitable driver found for jdbc:as400://host/database

      Do we really able to connect to As400 through this driver? Please tell me if i am doing wrong configuration like Classpath and wrong jar usage and need some more jar... ?

      This is very very urgent issue..pls reply me asap.

        • 1. Re: Getting error while connecting to AS400 DB through Jdeveloper
          Vijaya_OCP_Moderator-Oracle

          The error clearly indicates that driver not found.

           

          Were you able to test the database connection from Jdeveloper?

          Can you cross the jdbc url string configured to check if it is appropriate?

           

          Thanks,

          Vijaya

          • 2. Re: Getting error while connecting to AS400 DB through Jdeveloper
            1026065

            I am able to connect to database while I try to create a ADF Business Components. There I have created this new connection with proper JDBC URL - jdbc:as400://<hostname>/<SID>

            I am  able to create EO and VO. But I am not able to run/test that either in Business component tester or in browser after creating a ui page.

             

            (oracle.jbo.DMLException) JBO-26061: Error while opening JDBC connection.

            ----- Level 1: Detail 0 -----

            (java.sql.SQLException) No suitable driver found for jdbc:as400://<hostname>/<SID>

             

            I have added the Jt400.jar in D:\JDeveloper\system11.1.2.4.39.64.36.1\DefaultDomain\lib   and added the same path as classpath to jdeveloper project properties library.

            Please suggest me, do we really run my BC and UI using as400 with jt400.jar or do I need to download some other jar too and the path I am missing or what?

            • 3. Re: Getting error while connecting to AS400 DB through Jdeveloper
              1026065

              Hi Vijaya,

               

              Thanks for your quick reply. After I change my JDBC URL with  : instead of /  jdbc:as400://<hostname>:<Database>

              I am able to run the page and getting the UI in browser. But I am not getting the Databindings ui like table/ form with data.

               

              <20-Jul-2013 15:41:47 o'clock GST> <Notice> <Diagnostics> <BEA-320068> <Watch 'UncheckedException' with severity 'Notice' on server 'DefaultServer' has triggered at 20-Jul-2013 15:41:47 o'clock GST. Notification details:

              WatchRuleType: Log

              WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))

              WatchData: DATE = 20-Jul-2013 15:41:47 o'clock GST SERVER = DefaultServer MESSAGE = [ServletContext@24114406[app:CasthouseInspectionPOC module:CasthouseInspectionPOC-ViewController-context-root path:/CasthouseInspectionPOC-ViewController-context-root spec-version:2.5]] Servlet failed with Exception

              oracle.jbo.JboException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-29000. Error message parameters are {0=java.lang.NoClassDefFoundError, 1=com/ibm/as400/access/AS400JDBCDatabaseMetaData}

              at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4739)

               

              Caused By: java.lang.ClassNotFoundException: com.ibm.as400.access.AS400JDBCDatabaseMetaData

              at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:297)

              at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:270)

              at java.lang.ClassLoader.loadClass(ClassLoader.java:305)

              at java.lang.ClassLoader.loadClass(ClassLoader.java:246)

              at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:179)

              at weblogic.jdbc.wrapper.DatabaseMetaData_com_ibm_as400_access_AS400JDBCDatabaseMetaData.getDatabaseProductVersion(Unknown Source)

              at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1198)

              at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6838)

              at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:298)

              at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:329)

              at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)

              at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:600)

              at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:417)

              at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9053)

              at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4606)

              at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2536)

              at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2346)

              at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3245)

              at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:571)

              at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:234)

              at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:504)

              at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:499)

              at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:517)

              at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:867)

              at oracle.adf.model.binding.DCDataControl.setErrorHandler(DCDataControl.java:487)

              at oracle.jbo.uicli.binding.JUApplication.setErrorHandler(JUApplication.java:261)

              at oracle.adf.model.BindingContext.put(BindingContext.java:1318)

              at oracle.adf.model.binding.DCDataControlReference.getDataControl(DCDataControlReference.java:247)

              at oracle.adf.model.BindingContext.instantiateDataControl(BindingContext.java:1020)

              at oracle.adf.model.dcframe.DataControlFrameImpl.doFindDataControl(DataControlFrameImpl.java:1645)

              at oracle.adf.model.dcframe.DataControlFrameImpl.internalFindDataControl(DataControlFrameImpl.java:1514)

              at oracle.adf.model.dcframe.DataControlFrameImpl.findDataControl(DataControlFrameImpl.java:1474)

              at oracle.adf.model.BindingContext.internalFindDataControl(BindingContext.java:1150)

              at oracle.adf.model.BindingContext.get(BindingContext.java:1103)

              at oracle.adf.model.binding.DCParameter.evaluateValue(DCParameter.java:82)

              at oracle.adf.model.binding.DCParameter.getValue(DCParameter.java:111)

              at oracle.adf.model.binding.DCBindingContainer.getChildByName(DCBindingContainer.java:2743)

              at oracle.adf.model.binding.DCBindingContainer.internalGet(DCBindingContainer.java:2791)

              at oracle.adf.model.binding.DCExecutableBinding.get(DCExecutableBinding.java:115)

              at oracle.adf.model.binding.DCUtil.findSpelObject(DCUtil.java:329)

              at oracle.adf.model.binding.DCBindingContainer.evaluateParameterWithElCheck(DCBindingContainer.java:1473)

              at oracle.adf.model.binding.DCBindingContainer.findDataControl(DCBindingContainer.java:1603)

              at oracle.adf.model.binding.DCIteratorBinding.initDataControl(DCIteratorBinding.java:2542)

              at oracle.adf.model.binding.DCIteratorBinding.getDataControl(DCIteratorBinding.java:2477)

              at oracle.adf.model.binding.DCIteratorBinding.getAttributeDefs(DCIteratorBinding.java:3319)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding.fetchAttrDefs(JUCtrlValueBinding.java:514)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding.getAttributeDefs(JUCtrlValueBinding.java:465)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding.getAttributeDef(JUCtrlValueBinding.java:541)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding.getAttributeDef(JUCtrlValueBinding.java:531)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding$1JUAttributeDefHintsMap.<init>(JUCtrlValueBinding.java:4104)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding.getAttributeHintsMap(JUCtrlValueBinding.java:4211)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding.getHints(JUCtrlValueBinding.java:2564)

              at oracle.jbo.uicli.binding.JUCtrlValueBinding.internalGet(JUCtrlValueBinding.java:2389)

              at oracle.adfinternal.view.faces.model.binding.FacesCtrlAttrsBinding.internalGet(FacesCtrlAttrsBinding.java:329)

              at oracle.adf.model.binding.DCControlBinding.get(DCControlBinding.java:749)

              at javax.el.MapELResolver.getValue(MapELResolver.java:164)

              at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)

              at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)

              at com.sun.el.parser.AstValue.getValue(Unknown Source)

              at com.sun.el.ValueExpressionImpl.getValue(Unknown Source)

              at org.apache.myfaces.trinidad.bean.FacesBeanImpl.getProperty(FacesBeanImpl.java:73)

              at oracle.adfinternal.view.faces.renderkit.rich.LabelLayoutRenderer.getLabel(LabelLayoutRenderer.java:929)

              at oracle.adfinternal.view.faces.renderkit.rich.LabelLayoutRenderer.encodeAll(LabelLayoutRenderer.java:213)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelLabelAndMessageRenderer.encodeAll(PanelLabelAndMessageRenderer.java:96)

              at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)

              at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)

              at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:624)

              at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:3201)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer._encodeFormItem(PanelFormLayoutRenderer.java:1088)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer.access$100(PanelFormLayoutRenderer.java:50)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer$FormColumnEncoder.processComponent(PanelFormLayoutRenderer.java:1604)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer$FormColumnEncoder.processComponent(PanelFormLayoutRenderer.java:1523)

              at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:187)

              at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:318)

              at org.apache.myfaces.trinidad.component.UIXComponent.encodeFlattenedChildren(UIXComponent.java:283)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer._encodeChildren(PanelFormLayoutRenderer.java:420)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer.encodeAll(PanelFormLayoutRenderer.java:208)

              at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)

              at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)

              at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:624)

              at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:3201)

              at oracle.adf.view.rich.render.RichRenderer.encodeStretchedChild(RichRenderer.java:2194)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelSplitterRenderer._renderPane(PanelSplitterRenderer.java:1599)

              at oracle.adfinternal.view.faces.renderkit.rich.PanelSplitterRenderer.encodeAll(PanelSplitterRenderer.java:263)

              at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)

              at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)

              at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:624)

              at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:3201)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:641)

              at oracle.adf.view.rich.render.RichRenderer.encodeAllChildrenInContext(RichRenderer.java:3062)

              at oracle.adfinternal.view.faces.renderkit.rich.FormRenderer.encodeAll(FormRenderer.java:274)

              at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)

              at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)

              at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:624)

              at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:3201)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:641)

              at oracle.adf.view.rich.render.RichRenderer.encodeAllChildrenInContext(RichRenderer.java:3062)

              at oracle.adfinternal.view.faces.renderkit.rich.DocumentRenderer.encodeAll(DocumentRenderer.java:1275)

              at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1452)

              at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:511)

              at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:923)

              at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1681)

              at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1677)

              at oracle.adfinternal.view.faces.component.AdfViewRoot.encodeAll(AdfViewRoot.java:91)

              at com.sun.faces.application.view.JspViewHandlingStrategy.doRenderView(JspViewHandlingStrategy.java:431)

              at com.sun.faces.application.view.JspViewHandlingStrategy.renderView(JspViewHandlingStrategy.java:233)

              at org.apache.myfaces.trinidadinternal.application.ViewDeclarationLanguageFactoryImpl$ChangeApplyingVDLWrapper.renderView(ViewDeclarationLanguageFactoryImpl.java:350)

              at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)

              at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:273)

              at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:165)

              at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:1035)

              at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:342)

              at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:236)

              at javax.faces.webapp.FacesServlet.service(FacesServlet.java:509)

              at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

              at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

              at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

              at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:173)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:125)

              at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)

              at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

              at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:468)

              at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:293)

              at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:199)

              at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

              at java.security.AccessController.doPrivileged(Native Method)

              at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

              at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)

              at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

              at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

              at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)

              at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

              at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

              at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)

              at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)

              at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)

              at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

              at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

              SUBSYSTEM = HTTP USERID = <WLS Kernel> SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)' MSGID = BEA-101020 MACHINE = WS51403 TXID =  CONTEXTID = b895c2ee669b5f03:200689b7:13ffbe1b109:-8000-0000000000000036 TIMESTAMP = 1374320507333 

              WatchAlarmType: AutomaticReset

              WatchAlarmResetPeriod: 30000

              >

              <20-Jul-2013 15:41:50 o'clock GST> <Alert> <Diagnostics> <BEA-320016> <Creating diagnostic image in d:\jdeveloper\system11.1.2.4.39.64.36.1\defaultdomain\servers\defaultserver\adr\diag\ofm\defaultdomain\defaultserver\incident\incdir_5 with a lockout minute period of 1.>

              <20-Jul-2013 15:42:57 o'clock GST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "As400POCDB" failed with exception: "java.sql.SQLException: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>.".>

              <20-Jul-2013 15:43:26 o'clock GST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "AS400DBConn" failed with exception: "java.sql.SQLException: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>.".>

               

              Could you please update me what is going wrong here. Please update me any of you come across the same issue?

              This is stopping my entire work and please give me the solution.

              Thanks,

              Raj

              • 4. Re: Getting error while connecting to AS400 DB through Jdeveloper
                Joe Weinstein-Oracle

                You may do best to talk to IBM about their driver classes. You need the com.ibm.as400.access.AS400JDBCDatabaseMetaData class in your classpath, and apparently that doesn't come in the driver jar you're using...

                • 5. Re: Getting error while connecting to AS400 DB through Jdeveloper
                  1026065

                  Thanks Joe and all, I am able to resolve the issue by usibg jt400Native.jar and placed that under <jdk install>/jre/lib/ext.

                  I set the classpath D:\JDeveloper\system11.1.2.4.39.64.36.1\DefaultDomain\lib;C:\Oracle\Middleware\wlserver_10.3\server\lib; and placed the jt400Native in all those path.