We had the exact same problem when using IBM DB2. It created an int field, but kept trying to wrap ticks around the field when issuing SQL. David said he was going to look at fixing the DB2 stuff, maybe that will fix Sybase as well.
Until then, we broke out the Turbine and Jetspeed stuff to run in MySql. The rest of our stuff uses our (preferred) DB2 server. >>> [EMAIL PROTECTED] 10/08/02 10:42AM >>> Hi all, does anyone have any experience with PSML stored in the above mentioned db? I tried to set it all up according to the docs, it really connects to the db, but then: it tries to do select on TURBINE_USER_GROUP_ROLE where (TURBINE_USER_GROUP_ROLE.USER_ID='3') although the db creation script creates the user_id of type integer! The Sybase jdbc2 driver says: Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the CONVERT function to run this query. How is the select command constructed? I have tried to lookup the select statement in the jetspeed cvs source files but found nothing... TIA, Jan --- Odchoz� zpr�va neobsahuje viry. Zkontrolov�no antivirov�m syst�mem AVG (http://www.grisoft.cz). Verze: 6.0.393 / Virov� b�ze: 223 - datum vyd�n�: 10/6/2002 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
