Hi Aaron,
> Thanks for the info. DO you know if the JDBC driver is available
> for download? Or does it only come with the full product? Also, will you
It only come with the OS OS/400 and the Java ToolBox/400. There are updates
available, but they need the OS.
> be able to run the database test on DB2/400 to test our mappings?
I have tries id, but following error was thrown:
----------- snipp --------
[Auto deployer] Starting
[Auto deploy] Auto deploy of
file:/F:/Programme/Java/jboss2/deploy/dbtest.jar
[Container factory]
Deploying:file:/F:/Programme/Java/jboss2/deploy/dbtest.jar
[Container factory] Loading ejb-jar.xml :
jar:file:/F:/Programme/Java/jboss2/tmp
/deploy/tmpejbjar36791.jar!/META-INF/ejb-jar.xml
[Container factory] Loading standardjboss.xml :
jar:file:/F:/Programme/Java/jbos
s2/lib/ext/jboss.jar!/org/jboss/metadata/standardjboss.xml
[Verifier] Verifying
file:/F:/Programme/Java/jboss2/tmp/deploy/tmpejbjar36791.ja
r
[Verifier] AllTypes: Verified.
[Verifier] Record: Verified.
[Container factory] Deploying AllTypes
[Container factory] Container Invoker Optimize='false'
[Container factory] Deploying Record
[Container factory] Container Invoker Optimize='false'
[JAWS] Initializing JAWS plugin for Record
[JAWS] Loading standardjaws.xml :
jar:file:/F:/Programme/Java/jboss2/lib/ext/jbo
ss.jar!/org/jboss/ejb/plugins/jaws/metadata/standardjaws.xml
[JAWS]
jar:file:/F:/Programme/Java/jboss2/tmp/deploy/tmpejbjar36791.jar!/META-IN
F/jaws.xml found. Overriding defaults
[XADataSource] No transaction right now.
[XADataSource] Pool AS400Pool [1/1/Unlimited] gave out pooled object:
org.jboss.
minerva.xa.XAConnectionImpl@49131c
[XADataSource] Pool AS400Pool [0/1/Unlimited] returned object
org.jboss.minerva.
xa.XAConnectionImpl@49131c to the pool.
[XADataSource] No transaction right now.
[XADataSource] Pool AS400Pool [1/1/Unlimited] gave out pooled object:
org.jboss.
minerva.xa.XAConnectionImpl@49131c
[JAWS] Table Record created
[XADataSource] Pool AS400Pool [0/1/Unlimited] returned object
org.jboss.minerva.
xa.XAConnectionImpl@49131c to the pool.
[JAWS] Initializing JAWS plugin for AllTypes
[XADataSource] No transaction right now.
[XADataSource] Pool AS400Pool [1/1/Unlimited] gave out pooled object:
org.jboss.
minerva.xa.XAConnectionImpl@49131c
[XADataSource] Pool AS400Pool [0/1/Unlimited] returned object
org.jboss.minerva.
xa.XAConnectionImpl@49131c to the pool.
[XADataSource] No transaction right now.
[XADataSource] Pool AS400Pool [1/1/Unlimited] gave out pooled object:
org.jboss.
minerva.xa.XAConnectionImpl@49131c
[JAWS] com.ibm.as400.access.AS400JDBCException: [SQL0101] SQL-Anweisung zu
lang
oder zu komplex. (SQL-Statement too long)
[JAWS] at
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatem
ent.java:442)
[JAWS] at
com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JD
BCPreparedStatement.java:707)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeUpdate(Prepared
StatementInPool.java:81)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAnd
HandleResult(JDBCUpdateCommand.java:49)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.j
ava:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitComma
nd.java:98)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenc
eManager.java:97)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManage
r.java:101)
[JAWS] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:191)
[JAWS] at org.jboss.ejb.Application.init(Application.java:158)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:635)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:227)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
[JAWS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
[JAWS] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:286)
[JAWS] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:222)
[JAWS] at org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:265)
[JAWS] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:90)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
[JAWS] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
[JAWS] at
org.jboss.dependencies.DependencyManager.startMBean(DependencyManager
.java:284)
[JAWS] at
org.jboss.dependencies.DependencyManager.loadService(DependencyManage
r.java:261)
[JAWS] at
org.jboss.dependencies.DependencyManager.processService(DependencyMan
ager.java:243)
[JAWS] at
org.jboss.dependencies.DependencyManager.startMBeans(DependencyManage
r.java:117)
[JAWS] at org.jboss.Main.<init>(Main.java:166)
[JAWS] at org.jboss.Main.<init>(Main.java:98)
[JAWS] at org.jboss.Main$1.run(Main.java:88)
[JAWS] at java.security.AccessController.doPrivileged(Native Method)
[JAWS] at org.jboss.Main.main(Main.java:79)
[XADataSource] Pool AS400Pool [0/1/Unlimited] returned object
org.jboss.minerva.
xa.XAConnectionImpl@49131c to the pool.
[JAWS] Could not create table AllTypes: [SQL0101] SQL-Anweisung zu lang oder
zu
komplex.
[Container factory] Bound Record to Record
[Container factory] Bound AllTypes to AllTypes
[Container factory] Deployed application:
file:/F:/Programme/Java/jboss2/deploy/
dbtest.jar
----------- snapp ---------------------------
