-----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

Reply via email to