VARCHAR > 3000 characters with JTurbo and SQL Server 7 (WO 5.2)
VARCHAR > 3000 characters with JTurbo and SQL Server 7 (WO 5.2)
- Subject: VARCHAR > 3000 characters with JTurbo and SQL Server 7 (WO 5.2)
- From: Sébastien Rottiers <email@hidden>
- Date: Thu, 6 Mar 2003 14:54:35 +0100
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.