Okay, so it doesn't actually happen when we try to write a value
to the DB, but when we try to write a NULL to the DB. Can you put in a
println or something (JDBCCommand.java:275) and just output the column
name and JDBC type that it's setting for the PreparedStatement so we're
sure of exactly what is causing the error?
Aaron
On Wed, 1 Nov 2000, Ingo Bruell wrote:
> Here the log:
>
> ---- snip ----
> [Mandant] create(1)
> [Adresse] create(1,0)
> [XADataSource] Resource 'org.jboss.minerva.xa.XAResourceImpl@6f144c'
> enlisted fo
> r 'org.jboss.minerva.xa.XAConnectionImpl@61dfb5'.
> [XADataSource] Pool OraclePool [1/1/Unlimited] gave out pooled object:
> org.jboss
> .minerva.xa.XAConnectionImpl@61dfb5
> [Adresse] [de.oblgmbh.meta.interfaces.AdressePK@1] setTyp(M)
> [JAWS] java.sql.SQLException: Ung�ltiger Spaltentyp <!-- Invalid Column
> Type -->
> [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
> [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219)
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.
> java:4027)
> [JAWS] at
> oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStat
> ement.java:913)
> [JAWS] at
> org.jboss.minerva.jdbc.PreparedStatementInPool.setNull(PreparedStatem
> entInPool.java:91)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.
> java:275)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters
> (JDBCCreateEntityCommand.java:165)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.j
> ava:154)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCC
> reateEntityCommand.java:135)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPe
> rsistenceManager.java:122)
> [JAWS] at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersisten
> ceManager.java:156)
> [JAWS] at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:433)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityC
> ontainer.java:591)
> [JAWS] at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(Ent
> itySynchronizationInterceptor.java:160)
> [JAWS] at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInst
> anceInterceptor.java:86)
> [JAWS] at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.ja
> va:135)
> [JAWS] at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
> torCMT.java:263)
> [JAWS] at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.ja
> va:86)
> [JAWS] at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityIntercep
> tor.java:126)
> [JAWS] at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:1
> 06)
> [JAWS] at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:315)
> [JAWS] at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRM
> PContainerInvoker.java:143)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [JAWS] at java.security.AccessController.doPrivileged(Native Method)
> [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [JAWS] at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4
> 43)
> [JAWS] at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport
> .java:643)
> [JAWS] at java.lang.Thread.run(Thread.java:484)
> [JAWS] java.sql.SQLException: Ung�ltiger Spaltentyp
> [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
> [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219)
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.
> java:4027)
> [JAWS] at
> oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStat
> ement.java:913)
> [JAWS] at
> org.jboss.minerva.jdbc.PreparedStatementInPool.setNull(PreparedStatem
> entInPool.java:91)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.
> java:275)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters
> (JDBCCreateEntityCommand.java:165)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.j
> ava:154)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCC
> reateEntityCommand.java:135)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPe
> rsistenceManager.java:122)
> [JAWS] at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersisten
> ceManager.java:156)
> [JAWS] at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:433)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityC
> ontainer.java:591)
> [JAWS] at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(Ent
> itySynchronizationInterceptor.java:160)
> [JAWS] at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInst
> anceInterceptor.java:86)
> [JAWS] at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.ja
> va:135)
> [JAWS] at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep
> torCMT.java:263)
> [JAWS] at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.ja
> va:86)
> [JAWS] at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityIntercep
> tor.java:126)
> [JAWS] at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:1
> 06)
> [JAWS] at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:315)
> [JAWS] at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRM
> PContainerInvoker.java:143)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:142)
> [JAWS] at java.security.AccessController.doPrivileged(Native Method)
> [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> [JAWS] at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4
> 43)
> [JAWS] at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport
> .java:643)
> [JAWS] at java.lang.Thread.run(Thread.java:484)
> [XADataSource] Pool OraclePool [0/1/Unlimited] returned object
> org.jboss.minerva
> .xa.XAConnectionImpl@61dfb5 to the pool.
> [Mandant] Could not create entity:java.sql.SQLException: Ung�ltiger
> Spaltentyp <!-- Invalid Column Type -->
> ---- snap ----
>
> CU
>
> ---
> Ingo Bruell
> OBL GmbH ([EMAIL PROTECTED])
> Hude (Oldenburg)
> Germany
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
