You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Woody Sturges <WS...@bjc.org> on 2002/10/08 16:48:55 UTC
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.
>>> zamostny@seznam.cz 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:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
Re: experience with PSML in Sybase Adaptive Server Enterprise
Posted by Marian Skalsky <ms...@euromove.sk>.
Hi!
I have working JetSpeed (night build 22-9-2002) on ORACLE 8. But only the
Turbine part, not the PSML stuff.
It works fine now. I had som litle problem with consistency of sql script
shared with JS and the torque scheme, but I've solve that. It was added to
bugs and maybe allready solved.
I had a JS 1.4b1 installed on ORACLE before, and it worked with no problems.
The only slip was the lack of sorting the portlets in to categories in that
version.
$kala.
----- Original Message -----
From: "Jan Zámostný" <za...@seznam.cz>
To: "Jetspeed Users List" <je...@jakarta.apache.org>
Sent: Wednesday, October 09, 2002 11:07 AM
Subject: Re: experience with PSML in Sybase Adaptive Server Enterprise
> The problem appears with the default hypersonic db as well (see the
> jetspeed.log) - the framework generates some select statements correctly
and
> some not... The only difference is that hypersonic doesn't care and can
run
> select * from turbine_role where role_id='1'
> as well as
> select * from turbine_role where role_id=1
> But obviously it is not correct behavior... Has anyone successfuly tested
> jetspeed with db other than hypersonic or mysql? Jetspeed loks very very
> good but this would be a serious problem for us as we necessarily need it
to
> use the Sybase ASE db...
> Thanks a lot,
> Jan
>
> ----- Original Message -----
> From: "David Sean Taylor" <da...@bluesunrise.com>
> To: "Jetspeed Users List" <je...@jakarta.apache.org>
> Sent: Tuesday, October 08, 2002 4:57 PM
> Subject: RE: experience with PSML in Sybase Adaptive Server Enterprise
>
>
> > > 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:WSTURGES@bjc.org]
> > > Sent: Tuesday, October 08, 2002 7:49 AM
> > > To: jetspeed-user@jakarta.apache.org
> > > 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.
> > >
> > > >>> zamostny@seznam.cz 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:
> > > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > >
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
>
>
> ---
> 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/7/2002
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: experience with PSML in Sybase Adaptive Server Enterprise
Posted by David Sean Taylor <da...@bluesunrise.com>.
Jetspeed + Oracle works fine, haven't seen this problem.
I tried to install DB2 (again) and the installation program just disappears
(crashes?).
Anyone had success installing the free DB2 Personal Edition?
This is actually a problem in Torque and seems like a very easy fix in the
Torque templates.
Im looking into moving Jetspeed to the latest Torque version. Perhaps its
fixed there.
> -----Original Message-----
> From: Jan Zámostný [mailto:zamostny@seznam.cz]
> Sent: Wednesday, October 09, 2002 2:08 AM
> To: Jetspeed Users List
> Subject: Re: experience with PSML in Sybase Adaptive Server Enterprise
>
>
> The problem appears with the default hypersonic db as well (see the
> jetspeed.log) - the framework generates some select statements
> correctly and
> some not... The only difference is that hypersonic doesn't care
> and can run
> select * from turbine_role where role_id='1'
> as well as
> select * from turbine_role where role_id=1
> But obviously it is not correct behavior... Has anyone successfuly tested
> jetspeed with db other than hypersonic or mysql? Jetspeed loks very very
> good but this would be a serious problem for us as we necessarily
> need it to
> use the Sybase ASE db...
> Thanks a lot,
> Jan
>
> ----- Original Message -----
> From: "David Sean Taylor" <da...@bluesunrise.com>
> To: "Jetspeed Users List" <je...@jakarta.apache.org>
> Sent: Tuesday, October 08, 2002 4:57 PM
> Subject: RE: experience with PSML in Sybase Adaptive Server Enterprise
>
>
> > > 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:WSTURGES@bjc.org]
> > > Sent: Tuesday, October 08, 2002 7:49 AM
> > > To: jetspeed-user@jakarta.apache.org
> > > 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.
> > >
> > > >>> zamostny@seznam.cz 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:
> > > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > >
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
>
>
> ---
> 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/7/2002
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: experience with PSML in Sybase Adaptive Server Enterprise
Posted by Jan Zámostný <za...@seznam.cz>.
The problem appears with the default hypersonic db as well (see the
jetspeed.log) - the framework generates some select statements correctly and
some not... The only difference is that hypersonic doesn't care and can run
select * from turbine_role where role_id='1'
as well as
select * from turbine_role where role_id=1
But obviously it is not correct behavior... Has anyone successfuly tested
jetspeed with db other than hypersonic or mysql? Jetspeed loks very very
good but this would be a serious problem for us as we necessarily need it to
use the Sybase ASE db...
Thanks a lot,
Jan
----- Original Message -----
From: "David Sean Taylor" <da...@bluesunrise.com>
To: "Jetspeed Users List" <je...@jakarta.apache.org>
Sent: Tuesday, October 08, 2002 4:57 PM
Subject: RE: experience with PSML in Sybase Adaptive Server Enterprise
> > 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:WSTURGES@bjc.org]
> > Sent: Tuesday, October 08, 2002 7:49 AM
> > To: jetspeed-user@jakarta.apache.org
> > 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.
> >
> > >>> zamostny@seznam.cz 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:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
---
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/7/2002
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: experience with PSML in Sybase Adaptive Server Enterprise
Posted by David Sean Taylor <da...@bluesunrise.com>.
> 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:WSTURGES@bjc.org]
> Sent: Tuesday, October 08, 2002 7:49 AM
> To: jetspeed-user@jakarta.apache.org
> 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.
>
> >>> zamostny@seznam.cz 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>