2 Replies Latest reply on Aug 10, 2011 1:28 PM by niteshmehta

System Properties for the type-mapping is not being parsed in -ds.xml

niteshmehta Aug 1, 2011 8:14 AM

I have a datasource defined

<datasources>
 <local-tx-datasource>
    <jndi-name>DefaultDS</jndi-name>
    <connection-url>${myapp.database.connectionurl}</connection-url>
    <driver-class>${myapp.database.driver}</driver-class>
    <user-name>${myapp.database.username}</user-name>
    <password>${myapp.database.password}</password>
    <!-- Cache prepared SQL statements if using MS SQL and Oracle databases -->
          <prepared-statement-cache-size>100</prepared-statement-cache-size>
          <share-prepared-statements>true</share-prepared-statements>
          <!-- Uncomment following lines to cache prepared SQL statements if using MySQL database.
                    Also, comment the two line above relevant to MS SQL and Oracle -->
          <!-- 
          <connection-property name="prepStmtCacheSize">100</connection-property>
          <connection-property name="prepStmtCacheSqlLimit">1024</connection-property>
          <connection-property name="cachePrepStmts">true</connection-property>
          <connection-property name="useServerPrepStmts">true</connection-property>
           -->
          <exception-sorter-class-name>${myapp.database.exceptionsorter}</exception-sorter-class-name>
          <check-valid-connection-sql>${myapp.database.ValidConnectionQuery}</check-valid-connection-sql> 
          <metadata>
       <type-mapping>${myapp.database.typemapping}</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

All values except type-mapping is getting substituted by system variable.

When I run server I get following exception

17:43:14,321 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'

17:43:15,024 ERROR [GeneralPurposeDatabasePersistencePlugin] Cannot create timer table: java.lang.IllegalStateException: Cannot obtain type mapping from: jboss.jdbc:datasource=DefaultDS,service=metadata

at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.createTableIfNotExists(GeneralPurposeDatabasePersistencePlugin.java:137) [:6.0.0.Final]

at org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.java:104) [:6.0.0.Final]

at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:355) [:6.0.0.Final (Build SVNTag:JBoss_6.0.0.Final date: 20101228)]

at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:301) [:6.0.0.Final (Build SVNTag:JBoss_6.0.0.Final date: 20101228)]

at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) [:1.6.0_21]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [:1.6.0_21]

at java.lang.reflect.Method.invoke(Unknown Source) [:1.6.0_21]

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) [:6.0.0.GA]

at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) [:6.0.0.GA]

at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) [:6.0.0.GA]

at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:271) [:6.0.0.GA]

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:670) [:6.0.0.GA]

at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189) [:2.2.0.GA]

at $Proxy41.start(Unknown Source) at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:53) [:2.2.0.GA]

at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:41) [:2.2.0.GA]

at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:301) [:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654) [jboss-dependency.jar:2.2.0.GA]

at org.jboss.system.ServiceController.doChange(ServiceController.java:671) [:6.0.0.Final (Build SVNTag:JBoss_6.0.0.Final date: 20101228)]

at org.jboss.system.ServiceController.start(ServiceController.java:443) [:6.0.0.Final (Build SVNTag:JBoss_6.0.0.Final date: 20101228)]

at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:189) [:6.0.0.Final]

at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:102) [:6.0.0.Final]

at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:49) [:6.0.0.Final]

at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62) [:2.2.0.GA]

at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55) [:2.2.0.GA]

at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179) [:2.2.0.GA]

at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1832) [:2.2.0.GA]

at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1550) [:2.2.0.GA]

at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1571) [:2.2.0.GA]

at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1491) [:2.2.0.GA]