Hi,
I've read all threads concerning BLOBs, CMP and MySQL.
Yet I don't know how to read BLOBs with CMP in combination with
- mysql-connector-java-3.0.8-stable-bin.jar (driver)
- jboss3.2
- mysql4.0
By the way, I managed to read BLOB 'manually' through direct query execution. With
| ResultSet rs = ...;
| java.sql.Blob blob= rs.getBlob("myBlob");
|
| to get the Blob from the result set.
|
|
| My questions are:
| A.
|
| What should be in jbosscmp-jdbc.xml?
| This?
| | <cmp-field>
| | <field-name>myBlob</field-name>
| | <column-name>myBlob</column-name>
| | <jdbc-type>JAVA_OBJECT</jdbc-type>
| | <sql-type>BLOB</sql-type>
| | </cmp-field>
| Or?
| <cmp-field>
| | <field-name>myBlob</field-name>
| | <column-name>myBlob</column-name>
| | <jdbc-type>BLOB</jdbc-type>
| | <sql-type>BLOB</sql-type>
| | </cmp-field>
| Or
|
| <cmp-field>
| | <field-name>myBlob</field-name>
| | <column-name>myBlob</column-name>
| | <jdbc-type>VARBINARY</jdbc-type>
| | <sql-type>BLOB</sql-type>
| | </cmp-field>
| or something else?
|
| I saw several stories on this forum which where in contradiction.
|
| B.
| What are the field types in the CMP-EJB for the corresponding BLOB?
|
| Object?
| or
| byte[] ?
| or
| java.sql.Blob ?
| or
| a wrapper class with "byte[] myBytes" as field and with Serializable
implementation?
| or
| Something else?
|
| Any help is appreciated very much.
| Thanks,
|
| Evert Bende
|
http://212.203.14.69/topsolar/cgi-bin/climatetop50/cgi-bin/topsites.cgi?action=button&id=69
| http://www.wattabout.com/index
|
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839089#3839089
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839089
-------------------------------------------------------
This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
