No, it's an oracle bug, since blob-types work in other databases.
Burkhard
----- Original Message -----
From: "Tim McCune" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 5:41 PM
Subject: RE: [JBoss-user] Invalid column type using Oracle
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Thanks, that was enlightening. :) So...is this problem a bug in
> JBoss?
>
> > -----Original Message-----
> > From: Burkhard Vogel [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 03, 2001 3:48 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [JBoss-user] Invalid column type using Oracle
> >
> >
> > 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(OraclePreparedSta
> > te
> > > ment.java:869)
> > > [JAWS] at
> > >
> > org.opentools.minerva.jdbc.PreparedStatementInPool.setNull(PreparedS
> > ta
> > > 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.setParameter
> > s(
> > > 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(JDBC
> > Cr
> > > eateEntityCommand.java, Compiled Code)
> > > [JAWS] at
> > >
> > org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSP
> > er
> > > sistenceManager.java:122)
> > > [JAWS] at
> > >
> > org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersiste
> > nc
> > > 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-----
> > >
> >
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBOvF7/NUPOr8a7vy5EQKQgwCgnoW0d7aqKavE5lgu5zCihrcRJf4An1LH
> qUibLSYlf8JztaXVjzZHHxuI
> =JShv
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
