Bugs item #554535, was opened at 2002-05-10 10:14
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=554535&group_id=22866
Category: JBossCMP
>Group: v3.0 Rabbit Hole
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Niall O'Sullivan (nosullivan)
Assigned to: Dain Sundstrom (dsundstrom)
Summary: Oracle BLOB and byte array
Initial Comment:
Re-submiting a bug that was never fixed and closed.
The Orginial problem was
> [ 434620 ] Oracle BLOB and byte array
The Conclusion was
> If this problem persists with JBoss 2.4 or 3 then please
> report it again. JBoss 2.2 is not supported anymore.
I can confirm that this is still a bug in 2.4.
JBoss: JBoss-2.4.4_Jetty-3.1.7-1
OS: Windows 2K and Windows NT
JDK: 1.4
DB: Oracle 8.1.6
The suggested fix in [434620] works for me but hasn't
been integrated into jboss and presumably hasn't
been tested against other DBs.
----------------------------------------------------------------------
>Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-06-27 15:05
Message:
Logged In: YES
user_id=251431
The patch was applied to both JAWS and JBossCMP in
Branch_3_0 and HEAD.
This only fixes blob handling in Oracle 8.
----------------------------------------------------------------------
Comment By: Niall O'Sullivan (nosullivan)
Date: 2002-06-21 05:05
Message:
Logged In: YES
user_id=540986
I'm using the 8.1.6 oci drivers for jdk 1.2 (a.k.a.
classes12.zip).
I will get around to testing it on 8.0.5 and 8.1.7 as well,
but don't have access to 9 at all.
----------------------------------------------------------------------
Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-06-19 15:05
Message:
Logged In: YES
user_id=251431
Ok this sort of works.
What driver versions are you two using?
Does this code work with Orcale 9?
----------------------------------------------------------------------
Comment By: Niall O'Sullivan (nosullivan)
Date: 2002-06-19 05:07
Message:
Logged In: YES
user_id=540986
> I NEED YOU TO TEST THIS (IN HEAD)
I can confirm that this is working fine on my machine
(Win2k, jdk 1.4, oracle 8.1.6) with the head revision from
cvs as of sometime yesterday evening.
Thanks allot.
czawadka,
The fact that it is the cmp engine, and not you, that
is writing the blobs is irrelevant. The fact remains that
your problem occurs when you attempt to *write* a blob
to the DB and this bug was isolated to *reading* blobs.
Furthermore the 2 line fix for this bug was in a separate
class file, even in a separate package. Yes, both problems
are related to oracle blobs, and they have been effected by
dsundstrom's recent work, but that's were the similarities
end I'm afraid, I suggest you submit your problem independently.
----------------------------------------------------------------------
Comment By: Cezary Zawadka (czawadka)
Date: 2002-06-19 02:21
Message:
Logged In: YES
user_id=311672
dsundstrom wrote that this patch has been integrated into
JBossCMP (jboss3 cmp-2.0 engine?)(exactly into
org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil) . So, I think, it is
related. I've got the latest source code (2002.06.18) from
SourceForge and it's not working due to earlier exception. I'm
using only CMP entity beans where some of them have BLOB
cmp fields (I'm not writing BLOBs on my own)
----------------------------------------------------------------------
Comment By: Niall O'Sullivan (nosullivan)
Date: 2002-06-18 11:40
Message:
Logged In: YES
user_id=540986
> Is this working? I've got following exception with oracle
driver
> (8.1.7):
Your problem appears to be un-related. This bug was to
do with reading blobs, and it only effected
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand, you seem
to have problems writing blobs.
----------------------------------------------------------------------
Comment By: Cezary Zawadka (czawadka)
Date: 2002-06-18 05:26
Message:
Logged In: YES
user_id=311672
Is this working? I've got following exception with oracle driver
(8.1.7):
java.lang.ClassCastException:
org.jboss.ejb.plugins.cmp.jdbc.ByteArrayBlob
at oracle.jdbc.driver.OraclePreparedStatement.setBlob
(OraclePreparedStatement.java:1446)
at
org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.set
Blob(LocalPreparedStatement.java:680)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter
(JDBCUtil.java:220)
at
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBrid
ge.setArgumentParameters
(JDBCAbstractCMPFieldBridge.java:283)
In oracle driver (OraclePreparedStatement) is:
public synchronized void setBlob(int i, Blob blob)
throws SQLException {
setBLOB(i, (BLOB)blob);
}
The same code is in the current release (9.2.0.1) of oracle driver.
----------------------------------------------------------------------
Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-06-16 15:20
Message:
Logged In: YES
user_id=251431
This patch has been integrated into JBossCMP (HEAD) with
some slight modifications (see original patch for details).
I NEED YOU TO TEST THIS (IN HEAD)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=554535&group_id=22866
-------------------------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
