Sybase and binary PK

Frank Leffler <[email protected]> Mon, 21 Oct 2002 11:56:25 +0200

Newsgroups	gmane.comp.web.webobjects.eof
Organization	Medienwerft - Agentur für digitale Medien und Kommunikation mbH
Message-ID	<[email protected]>

Hi,

i have a problem using Sybase ASE 12.5 (on a linux box) with WO51. Whenever i 
try to insert data i get an error. I'm using binary pk's which seems to be 
the problem. My table definition looks like the following:

T_SALUTATION( IS_MALE smallint(5)
              IS_REGISTERABLE smallint(5)
              NAME varchar(64)
              SALUTATION_ID binary(10)
              SORT_ORDER smallint(5)
            )

The error comes up when inserting a new object into the table

SQLException: SQLState(42000) vendor code(257)
com.sybase.jdbc2.jdbc.SybSQLException: Internal type conversion from 'IMAGE' 
to 'BINARY' is not allowed. Use CONVERT to start this query.
	at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2535)
	at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1916)


Everything was fine on a Sybase 11.9.

Thanks for help
Frank