Read this:
http://wamoz.com/JDBC_and_Oracle_LOB.asp
Burkhard
----- Original Message -----
From: "Tim McCune" <[EMAIL PROTECTED]>
To: "JBoss Users" <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 9:47 PM
Subject: [JBoss-user] Invalid column type using Oracle
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I'm trying to setup JBoss to use Oracle. Every time JBoss tries to
> insert a new record into a table that contains a BLOB, I get the
> following exception:
>
> ...
> [JAWS] Set parameter: idx=3, jdbcType=JAVA_OBJECT, value=NULL
> [JAWS] java.sql.SQLException: Invalid column type
> [JAWS] at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> [JAWS] at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
> [JAWS] at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.j
> ava:4560)
> [JAWS] at
> oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedState
> ment.java:869)
> [JAWS] at
> org.opentools.minerva.jdbc.PreparedStatementInPool.setNull(PreparedSta
> tementInPool.java:92)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.j
> ava:280)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.setParameters(
> JDBCCreateEntityCommand.java, Compiled Code)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.ja
> va:159)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCr
> eateEntityCommand.java, Compiled Code)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPer
> sistenceManager.java:122)
> [JAWS] at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenc
> eManager.java, Compiled Code)
> [JAWS] at
> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
> ...
>
> The stack trace goes on. I can send the whole thing along if it will
> help. The CREATE TABLE command seems to be working fine when the app
> gets deployed. I'm running Oracle 8.1.7. Any suggestions would be
> greatly appreciated. Thanks.
>
> Tim McCune
> Software Architect, ChannelPoint
> "If you can't spot the sucker in the first half hour at the table,
> then you ARE the sucker." -- Mike McDermott, Rounders
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBOvBkI9UPOr8a7vy5EQLisQCcDtigHSNnqBCsq5g0cA9R/o2c4LQAoLnJ
> Kw/G2AQJWjHmG2AxxOIHF2FT
> =spKj
> -----END PGP SIGNATURE-----
>
JDBC and Oracle LOB columns.url