javax.naming.NameNotFoundException: oraclePool not bound

[som_k]

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">

[andey]

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");

...
~~~

[som_k]

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?

[andey]

Hi,

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

Regards,

Anup