Java Development Tools

Hi team

     I am developing an ADF application and deployed into JCS(Java Cloud Service Saas Extension) . While getting value from query through Appmodule,Once the query executed properly,while changing the lov value we faced exception like

Caused by: javax.el.ELException: oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection.

  at javax.el.BeanELResolver.getValue(BeanELResolver.java:298)

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

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

  at com.sun.el.parser.AstValue.getValue(AstValue.java:138)

  at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206)

  at javax.faces.component.UISelectItems.getValue(UISelectItems.java:141)

  ... 97 more

Caused by: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool database to allocate to applications, please increase the size of the pool and retry..

  at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:252)

  at weblogic.jdbc.pool.Driver.connect(Driver.java:142)

  at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)

  at weblogic.jdbc.jts.Driver.connect(Driver.java:127)

  at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:550)

  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:515)

  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:508)

  at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:1021)

  ... 127 more

MY Backing bean code like

    public void methodlovview(ValueChangeEvent valueChangeEvent) {

        // Add event code here...

        String check1=""+it2.getValue();

       String check=""+valueChangeEvent.getNewValue();

        it3.setValue(check);

        AdfFacesContext.getCurrentInstance().addPartialTarget(it3);

    }

    public List<SelectItem> getCustomList() {

            String amDef = "model.AppModule";

                 String config = "AppModuleLocal";

                ApplicationModule ami =Configuration.createRootApplicationModule(amDef, config);

            AppModuleImpl am = (AppModuleImpl)ami;

            String lovpoval=""+it2.getValue();

            String reglov ="" + am.executeQuery("SELECT COUNT(*) FROM LG_BANKGURANTEE"+" WHERE PONUMBER='"+lovpoval+"'");

            am.getTransaction().commit();

            int lgnolov=Integer.parseInt(reglov);

            if (customList == null) {

                customList = new ArrayList<SelectItem>();

                for(int i=0;lgnolov>i;i++)

                {

                    String is=""+i;

                customList.add(new SelectItem(is,is));

                }

        }

            return customList;

        }

JSPX like

   <af:inputText value="#{bindings.epono.inputValue}"

                        label="#{bindings.epono.hints.label}"

                        required="#{bindings.epono.hints.mandatory}"

                        columns="#{bindings.epono.hints.displayWidth}"

                        maximumLength="#{bindings.epono.hints.precision}"

                        shortDesc="#{bindings.epono.hints.tooltip}"

                        binding="#{backingBeanScope.backing_untitled3.it2}"

                        id="it2">

            <f:validator binding="#{bindings.epono.validator}"/>

          </af:inputText>

          <af:selectOneChoice label="ref" autoSubmit="true" partialTriggers="it3"

                              binding="#{backingBeanScope.backing_untitled3.soc1}"

                              id="soc1" valueChangeListener="#{backingBeanScope.backing_untitled3.methodlovview}">

            <f:selectItems value="#{backingBeanScope.backing_untitled3.customList}"

                           binding="#{backingBeanScope.backing_untitled3.si1}"

                           id="si1"/>

          </af:selectOneChoice>

          <af:inputText value="#{bindings.elovref.inputValue}"

                        label="#{bindings.elovref.hints.label}"

                        required="#{bindings.elovref.hints.mandatory}"

                        columns="#{bindings.elovref.hints.displayWidth}"

                        maximumLength="#{bindings.elovref.hints.precision}"

                        shortDesc="#{bindings.elovref.hints.tooltip}"

                        binding="#{backingBeanScope.backing_untitled3.it3}"

                        id="it3">

            <f:validator binding="#{bindings.elovref.validator}"/>

          </af:inputText>

          <af:commandButton actionListener="#{bindings.ExecuteWithParams.execute}"

                            text="ExecuteWithParams"

                            disabled="#{!bindings.ExecuteWithParams.enabled}"

                            binding="#{backingBeanScope.backing_untitled3.cb1}"

                            id="cb1"/>

          <af:panelFormLayout binding="#{backingBeanScope.backing_untitled3.pfl1}"

                              id="pfl1">

            <af:inputText value="#{bindings.LgNumber.inputValue}"

                          label="#{bindings.LgNumber.hints.label}"

                          required="#{bindings.LgNumber.hints.mandatory}"

                          columns="#{bindings.LgNumber.hints.displayWidth}"

                          maximumLength="#{bindings.LgNumber.hints.precision}"

                          shortDesc="#{bindings.LgNumber.hints.tooltip}"

                          binding="#{backingBeanScope.backing_untitled3.it4}"

                          id="it4">

              <f:validator binding="#{bindings.LgNumber.validator}"/>

            </af:inputText>

            <af:inputText value="#{bindings.Suppliername.inputValue}"

                          label="#{bindings.Suppliername.hints.label}"

                          required="#{bindings.Suppliername.hints.mandatory}"

                          columns="#{bindings.Suppliername.hints.displayWidth}"

                          maximumLength="#{bindings.Suppliername.hints.precision}"

                          shortDesc="#{bindings.Suppliername.hints.tooltip}"

                          binding="#{backingBeanScope.backing_untitled3.it5}"

                          id="it5">

              <f:validator binding="#{bindings.Suppliername.validator}"/>

            </af:inputText>

            <af:inputText value="#{bindings.Supplierno.inputValue}"

                          label="#{bindings.Supplierno.hints.label}"

                          required="#{bindings.Supplierno.hints.mandatory}"

                          columns="#{bindings.Supplierno.hints.displayWidth}"

                          maximumLength="#{bindings.Supplierno.hints.precision}"

                          shortDesc="#{bindings.Supplierno.hints.tooltip}"

                          binding="#{backingBeanScope.backing_untitled3.it6}"

                          id="it6">

              <f:validator binding="#{bindings.Supplierno.validator}"/>

            </af:inputText>

            <af:inputText value="#{bindings.Suppliersite.inputValue}"

                          label="#{bindings.Suppliersite.hints.label}"

                          required="#{bindings.Suppliersite.hints.mandatory}"

                          columns="#{bindings.Suppliersite.hints.displayWidth}"

                          maximumLength="#{bindings.Suppliersite.hints.precision}"

                          shortDesc="#{bindings.Suppliersite.hints.tooltip}"

                          binding="#{backingBeanScope.backing_untitled3.it7}"

                          id="it7">

              <f:validator binding="#{bindings.Suppliersite.validator}"/>

            </af:inputText>

  </af:panelFormLayout>

        </af:panelGroupLayout>