Metro-iBATIS Problem while deploying web service using iBatis as mapping techonlogy.

[Rizwan Patel]

Hi Ranchers,

I am currently stuck with a unique problem.

I need to deploy the MetroWebService on JBoss container, with iBATIS as object relational mapping tool on a remote server.

This is working perfectly fine with my local environment, but when I deployed the same on the remote server iBatis SQLMapClient object is not getting created its throwing the Initialization error.

Please have a look at the below stack trace.

   
21:01:37,780 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=RateStructure,endpoint=RateServiceImpl
21:01:37,817 INFO  [TomcatDeployer] deploy, ctxPath=/RateStructure, warUrl=.../tmp/deploy/RateStructure.jar4307545540090465133.war/
21:01:38,101 INFO  [STDOUT] Inside getSqlMapClient
21:01:38,109 INFO  [STDOUT] Reader retrieved
21:01:38,154 ERROR [MainDeployer] Could not start deployment: file:/opt/rateservice/jboss-4.2.3.GA/server/rfsapp/deploy/RateStructure.jar
javax.xml.ws.WebServiceException: Failed to build METRO runtime model
        at org.jboss.wsf.stack.metro.metadata.RuntimeModelDeploymentAspect.start(RuntimeModelDeploymentAspect.java:133)
        at org.jboss.wsf.framework.deployment.DeploymentAspectManagerImpl.deploy(DeploymentAspectManagerImpl.java:129)
        at org.jboss.wsf.container.jboss42.ArchiveDeployerHook.deploy(ArchiveDeployerHook.java:95)
        at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:88)
        at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
        at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
        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:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy34.start(Unknown Source)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
        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:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        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:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy9.deploy(Unknown Source)
        at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
        at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        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:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        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:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy4.start(Unknown Source)
        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
        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:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        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:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy5.deploy(Unknown Source)
        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
        at org.jboss.Main.boot(Main.java:200)
        at org.jboss.Main$1.run(Main.java:508)
        at java.lang.Thread.run(Thread.java:619)
[b]Caused by: java.lang.ExceptionInInitializerError[/b]
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.<init>(SqlMapConfigParser.java:58)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.<init>(SqlMapConfigParser.java:45)
        at com.ibatis.sqlmap.client.[b]SqlMapClientBuilder.buildSqlMapClient[/b](SqlMapClientBuilder.java:63)
        at com.webservice.utils.Utility.getSqlMapClient(Utility.java:28)
        at com.webservice.ratesservice.RateServiceImpl.<init>(RateServiceImpl.java:36)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at java.lang.Class.newInstance0(Class.java:355)
        at java.lang.Class.newInstance(Class.java:308)
        at com.sun.xml.ws.api.server.InstanceResolver.createNewInstance(InstanceResolver.java:215)
        at com.sun.xml.ws.api.server.InstanceResolver.createDefault(InstanceResolver.java:180)
        at org.jboss.wsf.stack.metro.DeploymentDescriptorParserJBWS.createInvoker(DeploymentDescriptorParserJBWS.java:59)
        at org.jboss.wsf.stack.metro.DeploymentDescriptorParserExt.parseAdapters(DeploymentDescriptorParserExt.java:293)
        at org.jboss.wsf.stack.metro.DeploymentDescriptorParserExt.parse(DeploymentDescriptorParserExt.java:171)
        at org.jboss.wsf.stack.metro.metadata.RuntimeModelDeploymentAspect.start(RuntimeModelDeploymentAspect.java:109)
        ... 77 more
Caused by: java.lang.RuntimeException: Error creating logger for class class com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.  Cause: java.lang.NullPointerException
        at com.ibatis.common.logging.LogFactory.getLog(LogFactory.java:33)
        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.<clinit>(SqlMapClientImpl.java:40)
        ... 94 more
Caused by: java.lang.NullPointerException
        at com.ibatis.common.logging.LogFactory.getLog(LogFactory.java:31)
        ... 95 more

 

Below is the code file written for reading the sqlmapconfig file and creating the sqlmapclient

   
public static SqlMapClient getSqlMapClient() throws Exception {
		try {
			System.out.println("Inside getSqlMapClient");
			
			String resource = "/utils/SqlMapConfig.xml";
			
			
			Reader reader = Resources.getResourceAsReader(resource);
			
			System.out.println("Reader retrieved");
			
			sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
			
			System.out.println("sqlMapper retrieved");
			
			reader.close();
			
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return sqlMapper;
 

Please help me to understand where the actual problem is involved.

[David Newton]

Are you sure you're deploying all the required jars?

[Rizwan Patel]

Dear David,

I have deployed below jars related to iBATIS .

 
ibatis-2.3.0.677.jar
ibatis-common-2.jar
ibatis-dao-2.jar
ibatis-db.jar
ibatis-sqlmap-2.jar   

Is there any other jar is missing? or my config xml are wrong? I am attaching config file as well.

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

<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

  <!-- Configure a built-in transaction manager.  If you're using an 
       app server, you probably want to use its transaction manager and a managed datasource -->
       
  <transactionManager type="JDBC" >
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="JDBC.ConnectionURL" value="value"/>
      <property name="JDBC.Username" value="XXXx"/>
      <property name="JDBC.Password" value="XXXXx"/>
    </dataSource>
  </transactionManager>


  <sqlMap resource="com/webservice/utils/RateRequest.xml"/> 

</sqlMapConfig>
 

And my sqlMap file is as below:

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

<!DOCTYPE sqlMap      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="RateRequest">
	<typeAlias alias="RateRequest"
		type="com.webservice.ratesservice.RateRequest" />
	<resultMap id="RateResponse"
		class="com.webservice.ratesservice.RateResponse">
		<result property="rate" column="RATE" />
		<result property="tierCode" column="TIERCODE" />
	</resultMap>

	<select id="retrieveRate"
		parameterClass="com.webservice.ratesservice.CustomRateRequest"
		resultClass="com.webservice.ratesservice.RateResponse"> 
		select Rate.RATE as rate, Product.TIERCODE as tier
		from Product , Rate
		where Product.TIERCODE = Rate.TIERCODE
		And Product.PERIOD = #period# 
		And Product.PROFILE = #profile#
		And #amount# between Rate.STARTBALANCE And Rate.ENDBALANCE
	</select>

	

Please help me.

[Rizwan Patel]

Hello,

Is there any updates on my problem. I had try again by putting both the config and sqlmap files in the classpath, but still not resolve.

Please help me to resolve.

[Rizwan Patel]

Solved.

Actually the problem is having with the version of the log4j.jar and I need to take the higher version and use the iBATIS API method for setting the logging mechanism to log4j.

Thank you very much for your valueable inputs.