7 Replies Latest reply on Mar 25, 2010 7:15 PM by jkonieczny

How do you set a boolean property in an XA datasource?

apill Feb 6, 2007 5:35 AM

I'm using Jboss 5 Beta1.

I have an XA datasource to DB2 on an AS400. I need to set a property on the datasource called translate binary, to the boolean value true.

Previously the <local-tx-datasource> specified this in the connection URL. i.e.

<local-tx-datasource>
 <connection-url>jdbc:as400://mydbhost.net;translate binary=true;</connection-url>
 <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
 <user-name>guest</user-name>
 <password>guest</password>
</local-tx-datasource>

I expect to set this in the XA datasource as follows.

<xa-datasource>
 <xa-datasource-class>com.ibm.as400.access.AS400JDBCXADataSource</xa-datasource-class>
 <xa-datasource-property name="User">guest</xa-datasource-property>
 <xa-datasource-property name="Password">guest</xa-datasource-property>
 <xa-datasource-property name="ServerName">mydbhost.net</xa-datasource-property>
 <xa-datasource-property name="TranslateBinary">true</xa-datasource-property>
 <isSameRM-override-value>false</isSameRM-override-value>
 <track-connection-by-tx/>
 <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
 <metadata>
 <type-mapping>DB2/400</type-mapping>
 </metadata>
</xa-datasource>

When JBoss starts up I get the error...

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String)))
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:162)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:579)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:247)
 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:563)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
 at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:351)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:394)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)
 at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:44)
 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)
 at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:691)
 at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
 at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:237)
 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:589)
 at org.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:55)
 at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:108)
 at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
 at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchJoinPoint(KernelControllerContextAction.java:71)
 at org.jboss.kernel.plugins.dependency.LifecycleAction.installAction(LifecycleAction.java:147)
 at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.install(KernelControllerContextAction.java:96)
 at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
 at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:226)
 at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:709)
 at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:429)
 at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:538)
 at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:472)
 at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:274)
 at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:177)
 at org.jboss.kernel.plugins.dependency.AbstractKernelController.install(AbstractKernelController.java:83)
 at org.jboss.kernel.plugins.dependency.AbstractKernelController.install(AbstractKernelController.java:77)
 at org.jboss.ejb3.MCKernelAbstraction.install(MCKernelAbstraction.java:141)
 at org.jboss.ejb3.Ejb3Deployment.startPersistenceUnits(Ejb3Deployment.java:473)
 at org.jboss.ejb3.Ejb3Deployment.start(Ejb3Deployment.java:324)
 at org.jboss.ejb3.deployers.EJBStage2Deployer.deploy(EJBStage2Deployer.java:48)
 at org.jboss.deployers.plugins.deployer.AbstractSimpleDeployer.commitDeploy(AbstractSimpleDeployer.java:52)
 at org.jboss.deployers.plugins.deployer.DeployerWrapper.commitDeploy(DeployerWrapper.java:145)
 at org.jboss.deployers.plugins.deployment.MainDeployerImpl.commitDeploy(MainDeployerImpl.java:440)
 at org.jboss.deployers.plugins.deployment.MainDeployerImpl.process(MainDeployerImpl.java:381)
 at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:366)
 at org.jboss.system.server.profileservice.ProfileServiceBootstrap.bootstrap(ProfileServiceBootstrap.java:246)
 at org.jboss.kernel.plugins.bootstrap.AbstractBootstrap.run(AbstractBootstrap.java:89)
 at org.jboss.system.server.profileservice.ServerImpl.doStart(ServerImpl.java:401)
 at org.jboss.system.server.profileservice.ServerImpl.start(ServerImpl.java:340)
 at org.jboss.Main.boot(Main.java:210)
 at org.jboss.Main$1.run(Main.java:508)
 at java.lang.Thread.run(Thread.java:626)
Caused by: org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String))
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:289)
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:154)
 ... 51 more
Caused by: java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String)
 at java.lang.Class.getMethod(Class.java:1594)
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:259)
 ... 52 more
10:29:58,417 WARN [SettingsFactory] Could not obtain connection metadata
org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String))); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String))))
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:109)
 at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:44)
 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)
 at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:691)
 at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
 at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:237)
 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:589)
 at org.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:55)
 at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:108)
 at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
 at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchJoinPoint(KernelControllerContextAction.java:71)
 at org.jboss.kernel.plugins.dependency.LifecycleAction.installAction(LifecycleAction.java:147)
 at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.install(KernelControllerContextAction.java:96)
 at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
 at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:226)
 at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:709)
 at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:429)
 at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:538)
 at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:472)
 at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:274)
 at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:177)
 at org.jboss.kernel.plugins.dependency.AbstractKernelController.install(AbstractKernelController.java:83)
 at org.jboss.kernel.plugins.dependency.AbstractKernelController.install(AbstractKernelController.java:77)
 at org.jboss.ejb3.MCKernelAbstraction.install(MCKernelAbstraction.java:141)
 at org.jboss.ejb3.Ejb3Deployment.startPersistenceUnits(Ejb3Deployment.java:473)
 at org.jboss.ejb3.Ejb3Deployment.start(Ejb3Deployment.java:324)
 at org.jboss.ejb3.deployers.EJBStage2Deployer.deploy(EJBStage2Deployer.java:48)
 at org.jboss.deployers.plugins.deployer.AbstractSimpleDeployer.commitDeploy(AbstractSimpleDeployer.java:52)
 at org.jboss.deployers.plugins.deployer.DeployerWrapper.commitDeploy(DeployerWrapper.java:145)
 at org.jboss.deployers.plugins.deployment.MainDeployerImpl.commitDeploy(MainDeployerImpl.java:440)
 at org.jboss.deployers.plugins.deployment.MainDeployerImpl.process(MainDeployerImpl.java:381)
 at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:366)
 at org.jboss.system.server.profileservice.ProfileServiceBootstrap.bootstrap(ProfileServiceBootstrap.java:246)
 at org.jboss.kernel.plugins.bootstrap.AbstractBootstrap.run(AbstractBootstrap.java:89)
 at org.jboss.system.server.profileservice.ServerImpl.doStart(ServerImpl.java:401)
 at org.jboss.system.server.profileservice.ServerImpl.start(ServerImpl.java:340)
 at org.jboss.Main.boot(Main.java:210)
 at org.jboss.Main$1.run(Main.java:508)
 at java.lang.Thread.run(Thread.java:626)
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String)))
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:162)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:579)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:247)
 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:563)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
 at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:351)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:394)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)
 ... 43 more
Caused by: org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String))
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:289)
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:154)
 ... 51 more
Caused by: java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXADataSource.setTranslateBinary(java.lang.String)
 at java.lang.Class.getMethod(Class.java:1594)
 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXADataSource(XAManagedConnectionFactory.java:259)
 ... 52 more

It looks as though the xa-datasource-property tag is treating the text "true" as a string and not a boolean since it is looking for the method

setTranslateBinary(String translate)

instead of

setTranslateBinary(boolean translate)

Is there anyway to set this property as a boolean as otherwise I cannot use the database from JBoss with XA?

Thanks for your help.
Adrian

1. Re: How do you set a boolean property in an XA datasource?

weston.price Feb 6, 2007 5:58 AM (in response to apill)

We should be able to determine the type automatically from the underlying XADataSource class. Can you confirm that the XADataSource has a get method corresponding to the set?

In other words, they API should have a

getTranslateBinary method that returns a boolean.
Actions
2. Re: How do you set a boolean property in an XA datasource?

apill Feb 6, 2007 6:02 AM (in response to apill)

It has

public boolean isTranslateBinary()

not

public boolean getTranslateBinary()
Actions
3. Re: How do you set a boolean property in an XA datasource?

weston.price Feb 6, 2007 6:05 AM (in response to apill)

Yep, just looked at the JTOpen doc. We don't allow for this in the current implementation. We only use the "get" form. I will file a JIRA request. I should be able to get to it for 4.2
Actions
4. Re: How do you set a boolean property in an XA datasource?

apill Feb 6, 2007 6:08 AM (in response to apill)

Ok, thanks. In the meantime I'll see if wrapping the xa datasource class and adding the getter method to call the isTranslateBinary works for us.

Cheers for the quick reply.
Actions
5. Re: How do you set a boolean property in an XA datasource?

weston.price Feb 6, 2007 6:12 AM (in response to apill)

http://jira.jboss.org/jira/browse/JBAS-4072
Actions

6. Re: How do you set a boolean property in an XA datasource?

apill Feb 6, 2007 6:54 AM (in response to apill)

I fixed the issue until you have implemented the fix by subclassing the XA datasource. See below for anyone else wanting to do this.

import com.ibm.as400.access.AS400JDBCXADataSource;

/**
 * This class is a work around for a JBoss JCA datasource missing feature. For
 * more details see Jboss JIRA issue JBAS-4072
 *
 * @link http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4011836#4011836
 * @link http://jira.jboss.org/jira/browse/JBAS-4072
 * @since 0.0.1
 */
public class AS400JDBCXADataSourceWrapper extends AS400JDBCXADataSource
{

 /**
 * Serial version uid
 */
 private static final long serialVersionUID = 3851238116015754390L;

 /**
 * Proxy method to the isTranslateBinary() method of this class. This is to
 * allow JBoss XA datasources to set the translate binary property on the
 * datasource using setTranslateBinary. In JBoss 5.0.0.Beta1 and JBoss 4
 * versions before 4.2 do not support binary properties on XA datasources.
 *
 * @return
 */
 public boolean getTranslateBinary()
 {
 return this.isTranslateBinary();
 }

}

7. Re: How do you set a boolean property in an XA datasource?

jkonieczny Mar 25, 2010 7:15 PM (in response to apill)

This issue appears to have regressed in JBoss 5.1.0, exact same driver/property/issue.
Actions

Go to original post