1 Reply Latest reply on Feb 23, 2015 10:42 AM by Ashok Chittela

    data source error when migrating application from Jboss 4.0.4 to Jboss 5.1.0

    Ashok Chittela Newbie

      Application works fine in Jboss 4.0.4. Is there any thing else i need to do in Jboss 5.1.0 config files to make it work?

      Any help is appreciated.

       

      09:26:31,404 FATAL [ERMJdbcTemplate] Error getting Datasource.

      javax.naming.NameNotFoundException: JTDSDSMonitoredIPPortal not bound

              at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)

              at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)

              at org.jnp.server.NamingServer.getObject(NamingServer.java:785)

              at org.jnp.server.NamingServer.lookup(NamingServer.java:443)

              at org.jnp.server.NamingServer.lookup(NamingServer.java:399)

              at org.jnp.server.NamingServer.lookup(NamingServer.java:399)

              at org.jnp.server.NamingServer.lookup(NamingServer.java:399)

              at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:726)

              at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:686)

              at javax.naming.InitialContext.lookup(InitialContext.java:392)

              at com.avendra.ipportal.dao.jdbc.ERMJdbcTemplate.<init>(ERMJdbcTemplate.java:37)

              at com.avendra.ipportal.dao.jdbc.ERMJdbcTemplate.<clinit>(ERMJdbcTemplate.java:31)

              at com.avendra.ipportal.dao.jdbc.MapReferenceDAOImpl.getReferenceDataMap(MapReferenceDAOImpl.java:44)

              at com.avendra.ipportal.business.util.ReferenceManagerImpl.loadReferenceData(ReferenceManagerImpl.java:51)

              at com.avendra.ipportal.business.util.ReferenceManagerImpl.<init>(ReferenceManagerImpl.java:35)

              at com.avendra.ipportal.business.util.ReferenceManagerImpl.getReferenceManager(ReferenceManagerImpl.java:40)

              at com.avendra.ipportal.web.controller.IpPortalContextListener.contextInitialized(IpPortalContextListener.java:24)

              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)

              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)

              at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)

              at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)

              at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)

              at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)

              at org.jboss.web.deployers.WebModule.start(WebModule.java:97)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)

              at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)

              at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)

              at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)

              at com.sun.proxy.$Proxy38.start(Unknown Source)

              at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)

              at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)

              at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)

              at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)

              at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)

              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

              at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)

              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

              at org.jboss.system.ServiceController.doChange(ServiceController.java:688)

              at org.jboss.system.ServiceController.start(ServiceController.java:460)

              at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)

              at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)

              at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)

              at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)

              at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)

              at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)

              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)

              at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)

              at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)

              at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)

              at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)

              at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)

              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

              at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)

              at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)

              at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)

              at org.jboss.Main.boot(Main.java:221)

              at org.jboss.Main$1.run(Main.java:556)

              at java.lang.Thread.run(Thread.java:662)

      09:26:31,561 ERROR [IpPortalContextListener] Couldn't create referenceManager attribute:

      java.lang.IllegalArgumentException: No DataSource specified

              at org.springframework.util.Assert.notNull(Assert.java:90)

              at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:98)

              at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)

              at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:242)

              at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:322)

              at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:326)

              at com.avendra.ipportal.dao.jdbc.MapReferenceDAOImpl.getReferenceDataMap(MapReferenceDAOImpl.java:44)

              at com.avendra.ipportal.business.util.ReferenceManagerImpl.loadReferenceData(ReferenceManagerImpl.java:51)

              at com.avendra.ipportal.business.util.ReferenceManagerImpl.<init>(ReferenceManagerImpl.java:35)

              at com.avendra.ipportal.business.util.ReferenceManagerImpl.getReferenceManager(ReferenceManagerImpl.java:40)

              at com.avendra.ipportal.web.controller.IpPortalContextListener.contextInitialized(IpPortalContextListener.java:24)

              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)

              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)

              at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)

              at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)

              at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)

              at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)

              at org.jboss.web.deployers.WebModule.start(WebModule.java:97)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)

              at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)

              at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)

              at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)

              at com.sun.proxy.$Proxy38.start(Unknown Source)

              at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)

              at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)

              at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)

              at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)

              at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)

              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

              at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)

              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

              at org.jboss.system.ServiceController.doChange(ServiceController.java:688)

              at org.jboss.system.ServiceController.start(ServiceController.java:460)

              at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)

              at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)

              at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)

              at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)

              at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)

              at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)

              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

              at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)

              at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)

              at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)

              at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)

              at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)

              at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)

              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

              at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)

              at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)

              at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)

              at org.jboss.Main.boot(Main.java:221)

              at org.jboss.Main$1.run(Main.java:556)

              at java.lang.Thread.run(Thread.java:662)

       

       

      Below is my Persistence.xml

       

      <?xml version="1.0" encoding="UTF-8"?>

      <persistence xmlns="http://java.sun.com/xml/ns/persistence"

                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                   xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"

                   version="1.0">

        <persistence-unit name='ipem'>

        <provider>com.bluecanopy.commons.datasource.DelayedDataSourcePersistenceProvider</provider>

        <jta-data-source>java:com/env/jdbc/JTDSDS</jta-data-source>

        <properties>

        <property name="jboss.entity.manager.jndi.name"

        value="java:EntityManager/ipem" />

        <property name="hibernate.dialect"

        value="org.hibernate.dialect.SQLServerDialect" />

        <!-- property name="hibernate.hbm2ddl.auto" value="update"/ -->

        <property name="hibernate.jdbc.batch_size" value="250" />

        <property name="hibernate.jdbc.batch_versioned_data"

        value="true" />

        <!-- END MRS 12-19-05 -->

        <property

        name="com.bluecanopy.commons.datasource.DelayedDataSourcePersistenceProvider.JtaDatasourceJndiName"

        value="java:com/env/jdbc/JTDSDSMonitoredIPPortal" />

        <property

        name="com.bluecanopy.commons.datasource.DelayedDataSourcePersistenceProvider.Provider"

        value="org.hibernate.ejb.HibernatePersistence" />

        </properties>

        </persistence-unit>

      </persistence>

       

       

       

      Below is my *ds.xml

       

      <?xml version="1.0" encoding="UTF-8"?>

      <!DOCTYPE datasources

          PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"

          "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">

      <datasources>

        <local-tx-datasource>

          <jndi-name>com/env/jdbc/JTDSDS</jndi-name>

          <use-java-context>true</use-java-context>

          <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

          <connection-url>jdbc:jtds:sqlserver://AVEHQDB4:1433/eRMProductionED;tds=8.0;lastupdatecount=true</connection-url>

          <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

          <!-- Add specific authentication credentials to login-config.xml under this security domain -->

          <!-- see sample-login-config.xml for an example) -->

          <security-domain>IpPortalErmDSPassword</security-domain>

          <prepared-statement-cache-size>50</prepared-statement-cache-size>

          <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>   

          <min-pool-size>1</min-pool-size>

          <max-pool-size>30</max-pool-size>

          <blocking-timeout-millis>5000</blocking-timeout-millis>

          <idle-timeout-minutes>15</idle-timeout-minutes>

          <track-statements>true</track-statements>

          <query-timeout>500</query-timeout>

          <share-prepared-statements>true</share-prepared-statements>

          <metadata>

            <type-mapping>MS SQLSERVER2005</type-mapping>

          </metadata>

        </local-tx-datasource>

       

        <local-tx-datasource>

          <jndi-name>MSSQLDS</jndi-name>

          <connection-url>jdbc:jtds:sqlserver://AVEHQDB4:1433/eRMProductionED;tds=8.0;lastupdatecount=true</connection-url>

          <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

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

          <password>******</password> 

          <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>   

          </local-tx-datasource>

      </datasources>