172014Jul

JDBCConnectionException while deploying Ear Sterling OMS

ErrorCode=”com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCConnectionException

This is the most common error we get while deploying Sterling Ear in Jboss.

So to solve this error go to following location.

<< Jboss Installation Folder >>/bin/run.bat and open run.bat in text editor.

After that find JAVA_OPTS variable and replace that variable and its value with this line.

set JAVA_OPTS=%JAVA_OPTS% -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dvendor=shell -DvendorFile=<<sterling installation folder >>/Foundation/properties/servers.properties -Dsci.naming.provider.url=jnp:localhost:<< jboss port no>> -server

After that just restart the jboss server. Keep it simple :-)


  • rahul arya

    why we are doing that.

    • bajajsahil

      System displays this error when it is unable to find the appropriate servers.properties file containing the JDBC connection parameters.
      Following JVM options such as the -Dvendor, -DvendorFile, -Dsci.naming.provider.url is not set with the correct value.
      So JVM options need to be set accordingly.

      • Prakash

        ok