3 Replies Latest reply on Mar 17, 2017 11:13 AM by Anup Dey

    javax.naming.NameNotFoundException: oraclePool not bound

    Som K Newbie

      Hi,

       

      I am getting the following error after deploying ear and when i start Jboss 7, this is for sterling order management can anybody help me this? what needs to be done to resolve the JDBC error.

       

      Thanks for your help in advance.

       

      00:39:47,024 INFO  [STDOUT] 2017-03-16 00:39:47,024:ERROR  :main: 000310100341 UTIL.FRAME_JDBC.ERR_JDBCService_getConnection1 [JDBCService.getConnection()  [system]: [ ]: JbossVendor

      00:39:47,026 INFO  [STDOUT] 2017-03-16 00:39:47,026:ERROR  :main: [1489639187026] oraclePool not bound                         [system]: [ ]: JbossVendor

      00:39:47,029 INFO  [STDOUT] 2017-03-16 00:39:47,028:ERRORDTL:main: [1489639187026]javax.naming.NameNotFoundException: oraclePool not bound

      <Error ErrorCode="java.sql.SQLException" ErrorDescription="" ErrorRelatedMoreInfo="Not able to get a Connection for oraclePool">

        • 1. Re: javax.naming.NameNotFoundException: oraclePool not bound
          Anup Dey Expert

          Do you have the datasource connection pool enabled? Are you doing something remote lookup of datasource "oraclePool"?

           

          You should configure the ds like below:

           

          ~~~

          <datasource jndi-name="java:jboss/datasources/MyDS" pool-name="myDatasource" enabled="true">

                              <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=Test</connection-url>

                              <driver>oracle</driver>

                              <pool>

                                  <min-pool-size>0</min-pool-size>

                                  <max-pool-size>20</max-pool-size>

                              </pool>

                              <security>

                                  <user-name>***</user-name>

                                  <password>***</password>

                              </security>

                              <validation>

                                 ......

                          </datasource>

          ~~~               

           

          You should look up ds like below:

           

          ~~~

          DataSource ds=null;

          Context ctx=new InitialContext();

          ds=(DataSource)ctx.lookup("java:jboss/datasources/MyDS");

          ...
          ~~~

          • 2. Re: javax.naming.NameNotFoundException: oraclePool not bound
            Som K Newbie

            Thanks Anup for your reply, I am new to oracle and datasource can you let me know where can i find these details in Sterling OMS?

            • 3. Re: javax.naming.NameNotFoundException: oraclePool not bound
              Anup Dey Expert

              Hi,

               

              Try to configure the above provided ds configuration and follow the lookup ds way and let me the results.

               

              Regards,

              Anup