You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by Michael Mogley <mm...@adelphia.net> on 2003/11/23 07:35:15 UTC
fixed PlatformMySQLImpl to support LOBs
All,
I believe I've fixed the problem. The MySQL implementation was completely
ignoring the special case of BLOB/CLOB. I simply copied the LOB treatment
in PlatformOracleImpl and merged this into PlatformMySQLImpl, with some
minor changes. Have not fully tested but it works fine for what I'm doing,
which is inserting images into blob fields.
I'm not sure yet how to create patches, so here is the changed method in
PlatformMySQLImpl:
/*
* @see Platform#setObjectForStatement(PreparedStatement, int, Object,
int)
*/
public void setObjectForStatement(PreparedStatement ps, int index,
Object value, int sqlType)
throws SQLException
{
switch (sqlType)
{
case Types.BIT:
ps.setObject(index, value);
break;
case Types.BLOB:
case Types.LONGVARBINARY:
case Types.VARBINARY:
if (value instanceof byte[]) {
byte buf[] = (byte[]) value;
ByteArrayInputStream inputStream = new
ByteArrayInputStream(buf);
ps.setBinaryStream(index, inputStream, buf.length);
break;
}
case Types.CLOB:
Reader reader = null;
int length = 0;
if (value instanceof String)
{
reader = new StringReader((String) value);
length = (((String) value)).length();
}
else if (value instanceof byte[])
{
byte buf[] = (byte[]) value;
ByteArrayInputStream inputStream = new
ByteArrayInputStream(buf);
reader = new InputStreamReader(inputStream);
}
ps.setCharacterStream(index, reader, length);
break;
default:
super.setObjectForStatement(ps,index,value,sqlType);
break;
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: fixed PlatformMySQLImpl to support LOBs
Posted by Michael Mogley <mm...@adelphia.net>.
Cool! Thanks for putting it in so quickly.
----- Original Message -----
From: "Jakob Braeuchi" <jb...@gmx.ch>
To: "OJB Developers List" <oj...@db.apache.org>
Sent: Sunday, November 23, 2003 2:23 AM
Subject: Re: fixed PlatformMySQLImpl to support LOBs
> hi michael,
>
> thanks for the patch. it's available in cvs now.
>
> jakob
>
> Michael Mogley wrote:
>
> > All,
> >
> > I believe I've fixed the problem. The MySQL implementation was
completely
> > ignoring the special case of BLOB/CLOB. I simply copied the LOB
treatment
> > in PlatformOracleImpl and merged this into PlatformMySQLImpl, with some
> > minor changes. Have not fully tested but it works fine for what I'm
doing,
> > which is inserting images into blob fields.
> >
> > I'm not sure yet how to create patches, so here is the changed method in
> > PlatformMySQLImpl:
> >
> > /*
> > * @see Platform#setObjectForStatement(PreparedStatement, int,
Object,
> > int)
> > */
> > public void setObjectForStatement(PreparedStatement ps, int index,
> > Object value, int sqlType)
> > throws SQLException
> > {
> > switch (sqlType)
> > {
> > case Types.BIT:
> > ps.setObject(index, value);
> > break;
> >
> > case Types.BLOB:
> > case Types.LONGVARBINARY:
> > case Types.VARBINARY:
> > if (value instanceof byte[]) {
> > byte buf[] = (byte[]) value;
> > ByteArrayInputStream inputStream = new
> > ByteArrayInputStream(buf);
> > ps.setBinaryStream(index, inputStream, buf.length);
> >
> > break;
> > }
> >
> > case Types.CLOB:
> > Reader reader = null;
> > int length = 0;
> >
> > if (value instanceof String)
> > {
> > reader = new StringReader((String) value);
> > length = (((String) value)).length();
> > }
> > else if (value instanceof byte[])
> > {
> > byte buf[] = (byte[]) value;
> > ByteArrayInputStream inputStream = new
> > ByteArrayInputStream(buf);
> > reader = new InputStreamReader(inputStream);
> > }
> >
> > ps.setCharacterStream(index, reader, length);
> > break;
> >
> > default:
> > super.setObjectForStatement(ps,index,value,sqlType);
> > break;
> > }
> > }
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-dev-help@db.apache.org
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: fixed PlatformMySQLImpl to support LOBs
Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi michael,
thanks for the patch. it's available in cvs now.
jakob
Michael Mogley wrote:
> All,
>
> I believe I've fixed the problem. The MySQL implementation was completely
> ignoring the special case of BLOB/CLOB. I simply copied the LOB treatment
> in PlatformOracleImpl and merged this into PlatformMySQLImpl, with some
> minor changes. Have not fully tested but it works fine for what I'm doing,
> which is inserting images into blob fields.
>
> I'm not sure yet how to create patches, so here is the changed method in
> PlatformMySQLImpl:
>
> /*
> * @see Platform#setObjectForStatement(PreparedStatement, int, Object,
> int)
> */
> public void setObjectForStatement(PreparedStatement ps, int index,
> Object value, int sqlType)
> throws SQLException
> {
> switch (sqlType)
> {
> case Types.BIT:
> ps.setObject(index, value);
> break;
>
> case Types.BLOB:
> case Types.LONGVARBINARY:
> case Types.VARBINARY:
> if (value instanceof byte[]) {
> byte buf[] = (byte[]) value;
> ByteArrayInputStream inputStream = new
> ByteArrayInputStream(buf);
> ps.setBinaryStream(index, inputStream, buf.length);
>
> break;
> }
>
> case Types.CLOB:
> Reader reader = null;
> int length = 0;
>
> if (value instanceof String)
> {
> reader = new StringReader((String) value);
> length = (((String) value)).length();
> }
> else if (value instanceof byte[])
> {
> byte buf[] = (byte[]) value;
> ByteArrayInputStream inputStream = new
> ByteArrayInputStream(buf);
> reader = new InputStreamReader(inputStream);
> }
>
> ps.setCharacterStream(index, reader, length);
> break;
>
> default:
> super.setObjectForStatement(ps,index,value,sqlType);
> break;
> }
> }
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org