Hi Everyone,
I'm using the iBatis data mapper 1.6.1 for my c# (VS2005) ASP .NET project..
I'm
trying to persist an image and even though it all runs fine, the image does
not seem to be stored in the database. We're using an SQL Server 2000
back end and the column in question is an "image" type. I've tried looking
at the FAQ and
doing a search on the net... there's a lot of resources saying that it CAN
be done but unfortunately nothing on HOW to do it.
In my, class, i've defined the image as :
private Byte[] distributionChart;
with the standard properties:
public Byte[] DistributionChart
{
get { return distributionChart; }
set { distributionChart = value; }
}
My parameter map uses :
<parameter property="DistributionChart" column="distributionChart"
dbType="image" />
And my stored procedure:
CREATE PROCEDURE QuantonomicsProvider_UpdateEvent
@eventId int,
@distributionChart image
AS
UPDATE AnnouncementEvent
SET DistributionChart = distributionChart
WHERE Id = @eventId
GO
I've stepped through my code and can confirm that there's data in the
object and in the "distributionChart" property before i'm storing it. The
update works without throwing an exception, but there's nothing in the
database.
Does anyone know what i'm doing wrong? Thanks
Toast
--
View this message in context:
http://www.nabble.com/persisting-image-in-SQL-Server-tp14271111p14271111.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
