Re: VARCHAR > 3000 characters with JTurbo and SQL Server 7 (WO 5.2)
Re: VARCHAR > 3000 characters with JTurbo and SQL Server 7 (WO 5.2)
- Subject: Re: VARCHAR > 3000 characters with JTurbo and SQL Server 7 (WO 5.2)
- From: Sébastien Rottiers <email@hidden>
- Date: Fri, 7 Mar 2003 10:11:59 +0100
Thank you for these informations but it doesn't work.
I soon will pass to SQL Server 2000 with Microsoft JDBC driver. perhaps
that will correct the problem.
Sibastien
Le jeudi, 6 mar 2003, ` 17:27 Europe/Paris, Jonathan Rochkind a icrit :
I use MS SQL Server and JTurbo, but I haven't run into that problem,
and don't really understand it or have ideas for fixing it.
But one thing to be aware of: the "value type" column in EOModeler.
Setting this column properly can often take care of such problems.
Apple keeps changing where (or if!) they document the possible values
for the 'value type' column. I can't seem to find it at the moment,
but it's still in the Google cache at this (sorry, horribly long) URL:
http://216.239.51.100/
search?sourceid=navclient&q=cache:http://developer.apple.com/te
chpubs/webobjects/UsingEOModeler/4WorkingWithAttributes/Value_T
ype.html.
But it looks like it would be worth trying both 'S' and 'C' for the
value type of that attribute, with both a varchar and a text, and see
if any of those combinations work.
Also, be aware that if you are using MS SQL Server 2000, there is a
free Microsoft provided JDBC Driver, which is officially supported by
Apple for use with WO/EOF as of WO 5.1. Since I use MS SQL Server 7,
that's not an option for me. But if you use MS SQL Server 2000, it
might work better (since it's officially supported by Apple) than
JTurbo.
At 02:54 PM 3/6/2003 +0100, Sibastien Rottiers wrote:
Hi list,
If I try to modify a record which contains a column defined in
VARCHAR of more than 3000 characters I obtain this exception:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.JDBCExpression: "UPDATE
dbo.THEMES_ODJ SET commentaire = ? WHERE (id_themes_odj = ? AND
id_odj_cr = ? AND theme = ? AND commentaire is NULL AND id_personne =
? AND duree = ? AND ligne = ?)" withBindings:
1:"12345678901234567890...12345678901234567890"(commentaire),
2:12(idThemesOdj), 3:14(idOdjCr), 4:"Point 2"(theme),
5:3337(idPersonne), 6:15(duree), 7:2(ligne)>:
Next exception:SQL State:42000 -- error code: 260 -- msg:
Disallowed implicit conversion from data type ntext to data type
varchar, table 'SNIP_SP_DEMO.dbo.THEMES_ODJ', column 'commentaire'.
Use the CONVERT function to run this query.
and if i define this column in text in SQL Server and NSData in
EOModeler i obtain this exception :
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.JDBCExpression: "SELECT
t0.commentaire FROM dbo.THEMES_CR t0 WHERE (t0.id_themes_cr = ? AND
t0.id_odj_cr = ? AND t0.theme = ? AND t0.id_action = ? AND
t0.id_personne = ? AND t0.isFinished is NULL AND t0.ligne = ?) FOR
UPDATE" withBindings: 1:10(idThemesCr), 2:14(idOdjCr),
3:"Point1"(theme), 4:74(idAction), 5:2431(idPersonne), 6:1(ligne)>:
Next exception:SQL State:01000 -- error code: 1003 -- msg: Line
1: FOR UPDATE clause allowed only for DECLARE CURSOR.
Is there a solution to this problem ?
thanks
Sibastien
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.