Hi,
could you post more detailed info, like the generated sql-string (e.g.
using p6spy), the used query for "Consultate" (or is the query internal
generated by OJB) and the used OJB version?
regards,
Armin
Christopher Cheng wrote:
Hi all,
I have a problem to map "ntext column type" in SQL Server 2000 in OJB
<field-descriptor
name="remarks"
column="remarks"
jdbc-type="CLOB"
/>
I tried CLOB, BLOB and VARBINARY already and I have the following error:
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException
during the execution of the query (for
com.mycompany.model.reference.Consulate): The text, ntext, or image data
type cannot be selected as DISTINCT.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
