Bugs item #669139, was opened at 2003-01-17 03:16
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=669139&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Florian Steinsiepe (floechen)
Assigned to: Nobody/Anonymous (nobody)
Summary: BLOB: Unknown Types value
Initial Comment:
We recently upgraded from 3.0.2 to 3.0.4. Since then,
we see the error report below (worked correctly in 3.0.2!):
The error occurs because JBoss can't handle the SQL
type BLOB anymore. We tested the behaviour on JDK 1.3.1
(manual-down) and 1.4.1 (Debian Blackdown package),
using MySQL 3.23.49 on Debian (woody),
mm.mysql-2.0.14-bin.jar as the JDBC driver (Debian
package), JUnit 3.8.1-2 (Debian package) and JUnitEE
1.5 (manual-down).
To verify the results, please configure a MySQL
datasource named "java:/mySQLDS" and deploy the
attached ear file. To access the web URL, use the
following address:
http://<mytestserver>/wgms/junitee_tests.html
and select the second option from the multiselect box.
junit.framework.AssertionFailedError:
javax.ejb.CreateException: Could not create
entity:javax.ejb.EJBException: Internal error setting
parameters for field Remarks; CausedByException is:
Unknown Types value
at junit.framework.Assert.fail(Assert.java:47)
at
test.org.wgms.AbstractWGMSTest.printErrorAndFail(AbstractWGMSTest.java:62)
at
test.org.wgms.TestWGMSStatelessUserSessionBean.testUserSessionBean(TestWGMSStatelessUserSessionBean.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at
junit.framework.TestResult$1.protect(TestResult.java:106)
at
junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.junitee.runner.TestRunner.run(TestRunner.java:59)
at
org.junitee.servlet.JUnitEEServlet.doGet(JUnitEEServlet.java:149)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:366)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:293)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:581)
at
org.mortbay.http.HttpContext.handle(HttpContext.java:1687)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:544)
at
org.mortbay.http.HttpContext.handle(HttpContext.java:1637)
at org.mortbay.http.HttpServer.service(HttpServer.java:875)
at org.jboss.jetty.Jetty.service(Jetty.java:543)
at
org.mortbay.http.HttpConnection.service(HttpConnection.java:806)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:956)
at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:823)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:203)
at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:290)
at
org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:743)
at java.lang.Thread.run(Thread.java:536)
----------------------------------------------------------------------
Comment By: Stephen Coy (scoy)
Date: 2003-01-21 20:28
Message:
Logged In: YES
user_id=463096
What are you using for field mappings in your jbosscmp-jdbc.xml?
JBoss 3.0.4 BLOBs have been tested against mySQL configuration similar to yours (see
the LOB tests).
The mappings need to be similar to:
<cmp-field>
<field-name>binaryData</field-name>
<column-name>binarydata</column-name>
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
</cmp-field>
----------------------------------------------------------------------
Comment By: Florian Steinsiepe (floechen)
Date: 2003-01-17 03:25
Message:
Logged In: YES
user_id=521125
Although we uploaded the mentioned jar file, it doesn't
appear in the list of "Existing Files". Please contact
[EMAIL PROTECTED] to get a copy by mail.
Sorry.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=669139&group_id=22866
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
