The first exception indicates that jBoss was unable to turn off
auto-commit on the Connection it created. We need to turn off auto-commit
for the transactions to work properly. The SQLException you get from
Informix is not very informative. Do you know why the Informix driver
would refuse to turn off auto-commit?
Note that this is just a "warning" (the stack trace should
be removed - there's a message like "unable to disable auto-commit" that
should appear instead), so you can ignore it if you have a good reason
(like perhaps Informix never uses autocommit?).
The second problem means that the Informix XADataSource
implementation is rejecting one of the calls we make to configure it.
Unfortunately, these calls are not standard and we have to try them using
reflection. I think we try "setURL" and "setProperties". Can you see
whether the class "com.informix.jdbcx.IfxXADataSource" has both of those
methods? If not, what methods *do* you use to configure the
IfxXADataSource?
Finally, is there anywhere I could download a trial version of
Informix for Linux with the drivers you describe so I could try this out
myself?
Aaron
On Thu, 9 Nov 2000, Kos Gorazd RDSM wrote:
> > Hi!
> >
> > I was trying to deploy CMP with Informix DB. I have found myself in a
> > deadend. If anybody could help me I would be very pleased.
> >
> > Here is my problem:
> > In jboss.conf I wrote:
> >
> > <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
> > CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String" VALUE="InformixDB">
> > <ARG TYPE="java.lang.String"
> > VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> > </MLET>
> >
> > When i tried to run JBoss i got following Exception:
> > [XADataSource] XA Connection pool InformixDB bound to InformixDB
> >
> > [XADataSource] java.sql.SQLException
> > [XADataSource] at
> > com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:308)
> > [XADataSource] at
> > com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1057)
> > [XADataSource] at
> > org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.jav
> > a:128)
> > [XADataSource] at
> > org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.jav
> > a:155)
> > [XADataSource] at
> > org.jboss.minerva.factories.XAConnectionFactory.createObject(XAConnectionF
> > actory.java:216)
> > [XADataSource] at
> > org.jboss.minerva.pools.ObjectPool.createNewObject(ObjectPool.java:790)
> > [XADataSource] at
> > org.jboss.minerva.pools.ObjectPool.getObject(ObjectPool.java:548)
> > [XADataSource] at
> > org.jboss.minerva.datasource.XAPoolDataSource.getConnection(XAPoolDataSour
> > ce.java:169)
> > [XADataSource] at
> > org.jboss.jdbc.XADataSourceLoader.initializePool(XADataSourceLoader.java:2
> > 84)
> > [XADataSource] at
> > org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:248
> > )
> > [XADataSource] at
> > org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:90)
> > [XADataSource] at java.lang.reflect.Method.invoke(Native Method)
> > [XADataSource] at
> > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> > [XADataSource] at
> > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> > [XADataSource] at
> > org.jboss.dependencies.DependencyManager.startMBean(DependencyManager.java
> > :284)
> > [XADataSource] at
> > org.jboss.dependencies.DependencyManager.loadService(DependencyManager.jav
> > a:261)
> > [XADataSource] at
> > org.jboss.dependencies.DependencyManager.processService(DependencyManager.
> > java:243)
> > [XADataSource] at
> > org.jboss.dependencies.DependencyManager.processService(DependencyManager.
> > java:238)
> > [XADataSource] at
> > org.jboss.dependencies.DependencyManager.processService(DependencyManager.
> > java:238)
> > [XADataSource] at
> > org.jboss.dependencies.DependencyManager.processService(DependencyManager.
> > java:238)
> > [XADataSource] at
> > org.jboss.dependencies.DependencyManager.startMBeans(DependencyManager.jav
> > a:117)
> > [XADataSource] at org.jboss.Main.<init>(Main.java:166)
> > [XADataSource] at org.jboss.Main.<init>(Main.java:98)
> > [XADataSource] at org.jboss.Main$1.run(Main.java:88)
> > [XADataSource] at
> > java.security.AccessController.doPrivileged(Native Method)
> > [XADataSource] at org.jboss.Main.main(Main.java:79)
> >
> >
> > Then I replace settings in jboss.conf:
> >
> > <MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> > ARCHIVE="jboss.jar,ifxjdbcx.jar" CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String" VALUE="InformixDB">
> > <ARG TYPE="java.lang.String"
> > VALUE="com.informix.jdbcx.IfxXADataSource">
> > </MLET>
> >
> > and i got following Exception:
> >
> > [Configuration] URL set to
> > jdbc:informix-sqli://ntjava:1526/mncommon:INFORMIXSERVER=ol_ntjava in
> > DefaultDomain:service=XADataSource,name=InformixDB
> > [Default] javax.management.RuntimeMBeanException: RuntimeException thrown
> > in the MBean's setter
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:1
> > 417)
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:1
> > 331)
> > [Default] at
> > org.jboss.configuration.ConfigurationService.load(ConfigurationService.jav
> > a:141)
> > [Default] at java.lang.reflect.Method.invoke(Native Method)
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> > [Default] at org.jboss.Main.<init>(Main.java:147)
> > [Default] at org.jboss.Main.<init>(Main.java:98)
> > [Default] at org.jboss.Main$1.run(Main.java:88)
> > [Default] at java.security.AccessController.doPrivileged(Native
> > Method)
> > [Default] at org.jboss.Main.main(Main.java:79)
> > [Default] javax.management.RuntimeMBeanException: RuntimeException thrown
> > in the MBean's setter
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:1
> > 417)
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:1
> > 331)
> > [Default] at
> > org.jboss.configuration.ConfigurationService.load(ConfigurationService.jav
> > a:141)
> > [Default] at java.lang.reflect.Method.invoke(Native Method)
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> > [Default] at
> > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> > [Default] at org.jboss.Main.<init>(Main.java:147)
> > [Default] at org.jboss.Main.<init>(Main.java:98)
> > [Default] at org.jboss.Main$1.run(Main.java:88)
> > [Default] at java.security.AccessController.doPrivileged(Native
> > Method)
> > [Default] at org.jboss.Main.main(Main.java:79)
> >
> > How can I solve one of this problem?
> >
> > Gorazd Kos
> >
> > IskraTEL d.o.o.
> > Tr�a�ka c. 37a
> > 2000 Maribor
> >
> > phone: +386 2 3003 292
> > fax: +386 4 207 39 292
> >
> >
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
