> David said he was going to look at fixing the DB2 stuff, maybe that will > fix Sybase as well.
The DB2 install was crashing on XP. Im going to try it later today on other OSs > -----Original Message----- > From: Woody Sturges [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 7:49 AM > To: [EMAIL PROTECTED] > Subject: Re: experience with PSML in Sybase Adaptive Server Enterprise > > > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
