SQL Statement too long? That's a new one on me. Well, perhaps
you have to create the tables manually instead of letting JAWS do it. But
this doesn't give me a great deal of confidence in their implementation...
Aaron
On Tue, 10 Oct 2000, Ingo Bruell wrote:
> 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 ---------------------------
>
>
>
>
