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 🙂