Mon, 07/16/2012 - 13:05
Hi Andrew,
We are investigating this. Thanks for reporting the issue.
Mash On!
- deepak alur | vp product + engineering at jackbe | follow me
Wed, 07/18/2012 - 14:59
Wed, 07/18/2012 - 15:16
Already using 1.2.5, verified I was using latest before I bugged you guys. I seemed to read that this is still an issue in 1.2.5 though; unfortunately I can't find that link on this particular computer I'm on at the moment.
Can you tell me what the relevant datatypes should be, schema-wise? Maybe we missed an upgrade step somewhere? We're on our third or fourth installation with the same DB install.
Windows Server 2008R2 64-bit, SQL Server 2005 64-bit, JTDS drivers.
Receive the following error when attempting to browse collateral by type: (tablet, android ota, etc.)
Error : JDO operation: Error executing JDOQL query "SELECT THIS.OBJECTTYPE,THIS.CONTENTMIME,THIS.CONTENTVERSIONCOMMENT,
THIS.CONTENTVERSIONNAME,THIS.CREATED_BY,THIS.CREATED,THIS.DESCRIPTION,
THIS.LAST_CHANGED_BY,THIS.LASTCHANGE,THIS.NAME_,
THIS.PROVIDER_ID,THIS.STATUS,THIS.OBJECTSUBTYPE,THIS.SYSTEM_TYPE,THIS.
THUMBNAIL_URL,THIS.ID,THIS.VERSION, THIS.WORKFLOW_STATE,THIS.XMLDATA
FROM dbo.REGISTRYOBJECT THIS
WHERE (EXISTS (SELECT 1 FROM dbo.RO_ATTRIBUTE
THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR WHERE (EXISTS
(SELECT 1 FROM dbo.RO_ATTRIBUTE_VALUE THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR_VALUES_ISPHONECOMPATIBLE_VAR_2 WHERE THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR_VALUES_ISPHONECOMPATIBLE_VAR_2.RO_ATTRIBUTE_ID = THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR.ID AND THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR_VALUES_ISPHONECOMPATIBLE_VAR_2."VALUE" = ? AND THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR.RO_ID = THIS.ID AND
THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR.RO_ID = THIS.ID AND
THIS_ATTRIBUTES_ISPHONECOMPATIBLE_VAR."NAME" = ?)) AND
(((THIS.OBJECTTYPE = ?) OR (THIS.OBJECTTYPE = ?))) AND
((THIS.SYSTEM_TYPE IS NULL OR THIS.SYSTEM_TYPE <> ?)) AND
(THIS.OBJECTTYPE = ? OR THIS.OBJECTTYPE = ? OR THIS.OBJECTTYPE = ? OR THIS.OBJECTTYPE = ?)))" :
The data types ntext and nvarchar are incompatible in the equal to operator..;
uncategorized SQLException for SQL []; SQL state [S1000]; error code [402]; The data types ntext and nvarchar are incompatible in the equal to operator.; nested exception is java.sql.SQLException: The data types ntext and nvarchar are incompatible in the equal to operator.