Re: experience with PSML in Sybase Adaptive Server Enterprise

[Woody Sturges]

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:  

For additional commands, e-mail:

RE: Help, DB2 integration problem #2

[Woody Sturges]

Hi David,

  We manually modified and ran the scripts, but Jetspeed had problems
interacting with DB/2 even after the DB was setup.  Our location would
be VERY interested in getting DB/2 support back up to speed...  (no pun
intended)

Thanks,
Woody

>>> [EMAIL PROTECTED] 09/26/02 06:19AM >>>
Sorry about the DB2 scripts.
I tested on Hypersonic, MySQL and Oracle.
Do you know if DB2 has a free database download that I can test on?
I think I could get it fixed fairly quickly...


> -Original Message-
> From: Marian Skalsky [mailto:[EMAIL PROTECTED]] 
> Sent: 26 September 2002 07:35
> To: Jetspeed Users List
> Subject: Re: Help, DB2 integration problem #2
> 
> 
> Hi Philipp!
> This will NOT help you, but I have JetSpeed 1.4b1 successfuly 
> working with ORACLE database and had no problems with scripts 
> provided. $kala.
> 
> - Original Message -
> From: "Philipp Schoepf" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 25, 2002 6:52 PM
> Subject: Help, DB2 integration problem #2
> 
> 
> Hi all,
> 
> I'm in really big trouble with my DB2-Jetspeed integration. 
> Like a said in my previous thread there are some problems 
> using the turbine-db2.sql und populate-db2.sql scripts for 
> the creation of a jetspeed db2 database. Could anyone tell 
> me, if he ran into similar problems when integrating DB2 and 
> Jetspeed? The provided scripts seem totally wrong! The error 
> I got before was just because of the ";" in the scripts. 
> After I deleted the ";" I was able to create the tables. But 
> the next problem was not far away... The populate-db2.sql 
> script seems as faulty as the turbine-db2.sql script. For 
> example it tries to insert values into the user_id colums 
> although this is permitted  by db2 (just because the id'sare 
> generated automatically using the GENERATED ALWAYS AS 
> IDENTITY statement). There is also an error when inserting 
> the long value into the blob colum for the user infos. Did I 
> download the wrong version of jetspeed (1.4b1) or did I make 
> a wrong db2 configuration?
> 
> This is going to make me mad, so I would be very  grateful if 
> someone could help me
> 
> Best regards,
> 
> --
> --
> --
> Philipp Schöpf
> IBM e-business Innovation Center
> Alter Wandrahm 10, 20457 Hamburg
> Fon: +49 (0)40/41912-461
> Web: http://www.ibm.com/services/de/innovation 
> --
> --
> --
> 
> 
> --
> To unsubscribe, e-mail:   
>  [EMAIL PROTECTED]>
> For 
> additional commands, 
> e-mail: 
> 


BBCi at http://www.bbc.co.uk/ 

This e-mail (and any attachments) is confidential and may contain 
personal views which are not the views of the BBC unless specifically 
stated.
If you have received it in error, please delete it from your system, do

not use, copy or disclose the information in any way nor act in 
reliance on it and notify the sender immediately. Please note that the

BBC monitors e-mails sent or received. Further communication will 
signify your consent to this.


--
To unsubscribe, e-mail:  

For additional commands, e-mail:



--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: Help, DB2 integration problem #2

[Woody Sturges]

FWIW, we had the same problems and submitted it to bugtrack.  We were
unable to figure it out, so we're using MySQL for all the Jetspeed
stuff, and DB2 for all of our application stuff.  Hopefully, someone
will fix the DB2 portion in Jetspeed so we can consolidate back to our
preferred DB.

>>> [EMAIL PROTECTED] 09/25/02 11:52AM >>>
Hi all,

I'm in really big trouble with my DB2-Jetspeed integration. 
Like a said in my previous thread there are some problems using the 
turbine-db2.sql und populate-db2.sql scripts for the creation of a 
jetspeed db2 database.
Could anyone tell me, if he ran into similar problems when integrating
DB2 
and Jetspeed? The provided scripts seem totally wrong! 
The error I got before was just because of the ";" in the scripts.
After I 
deleted the ";" I was able to create the tables. But the next problem
was 
not far away... The populate-db2.sql script seems as faulty as the 
turbine-db2.sql script. For example it tries to insert values into the

user_id colums although this is permitted  by db2 (just because the 
id'sare generated automatically using the GENERATED ALWAYS AS IDENTITY

statement). There is also an error when inserting the long value into
the 
blob colum for the user infos.
Did I download the wrong version of jetspeed (1.4b1) or did I make a
wrong 
db2 configuration?

This is going to make me mad, so I would be very  grateful if someone 
could help me

Best regards,

--
Philipp Schöpf
IBM e-business Innovation Center
Alter Wandrahm 10, 20457 Hamburg
Fon: +49 (0)40/41912-461
Web: http://www.ibm.com/services/de/innovation 
--

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: rundata.getACL() returns null for logged-in userwithroles/permissions

[Woody Sturges]

Thanks Mark, that worked fine.  I'll submit a bug.
Woody

>>> [EMAIL PROTECTED] 09/17/02 10:25AM >>>
Woody,

I think that I ran into this before and I still don't know why
rundata's ACL
is null. Feel free to submit this as a bug (perhaps then it will get
looked
at). Here's some code to get user permissions:

Hashtable permSet = new Hashtable(); // use whatever container you
like
here
Iterator roles =
JetspeedSecurity.getRoles(data.getUser().getUserName());
while (roles.hasNext()) {
Iterator perms =
JetspeedSecurity.getPermissions(((Role)roles.next()).getName());
while (perms.hasNext()) {
try {
String perm = ((Permission)perms.next()).getName();
if (!permSet.containsKey(perm)) {
permSet.put(perm, "");
}
} catch (Exception e1) {
}
}
}

In the end, permSet will contain unique set of user permission names.
Hope
this helps.

Best regards,

Mark C. Orciuch
Next Generation Solutions, Ltd.
e-Mail: [EMAIL PROTECTED] 
web: http://www.ngsltd.com 


> -Original Message-
> From: Woody Sturges [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, September 17, 2002 10:07 AM
> To: [EMAIL PROTECTED] 
> Subject: rundata.getACL() returns null for logged-in user
> withroles/permissions
>
>
> Hi all, I'm having a problem getting an AccessControlList from within
a
> VelocityPortletAction.  I'm using the passed RunData object to grab
the
> ACL, but it returns null.  The getUser() works, and the current user
has
> roles and permissions (they can run the portlet, which is secured
with a
> role).  Here's my code:
>
> public void doSend(RunData data, Context context)
> {
>   try {
>   String userName = data.getUser().getUserName();
>   PermissionSet permissions = null;
>   AccessControlList acl = data.getACL();
>   if (acl == null) {
>   System.out.println("ACL is NULL!");
>   } else {
>   permissions = data.getACL().getPermissions();
>   }
>
>   System.out.println("userName: " + userName + ",
> permissions: " + permissions);
>
>   } catch (Exception e) {
>   e.printStackTrace();
>   context.put("message", e.getMessage());
>   }
> }
>
> The above prints:
> [9/17/02 9:18:20:734 CDT] 50795bb5 SystemOut U ACL is NULL!
> [9/17/02 9:18:20:734 CDT] 50795bb5 SystemOut U userName:
wsturges,
> permissions: null
>
> Can anyone offer any suggestions?  Thanks in advance,
> Woody
>
> --
> 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]>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

rundata.getACL() returns null for logged-in user withroles/permissions

[Woody Sturges]

Hi all, I'm having a problem getting an AccessControlList from within a
VelocityPortletAction.  I'm using the passed RunData object to grab the
ACL, but it returns null.  The getUser() works, and the current user has
roles and permissions (they can run the portlet, which is secured with a
role).  Here's my code:

public void doSend(RunData data, Context context)
{
try {
String userName = data.getUser().getUserName();
PermissionSet permissions = null;
AccessControlList acl = data.getACL();
if (acl == null) {
System.out.println("ACL is NULL!");
} else {
permissions = data.getACL().getPermissions();
}

System.out.println("userName: " + userName + ",
permissions: " + permissions);

} catch (Exception e) {
e.printStackTrace();
context.put("message", e.getMessage());
}
}

The above prints: 
[9/17/02 9:18:20:734 CDT] 50795bb5 SystemOut U ACL is NULL!
[9/17/02 9:18:20:734 CDT] 50795bb5 SystemOut U userName: wsturges,
permissions: null

Can anyone offer any suggestions?  Thanks in advance,
Woody

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: jetspeed = slowspeed?

[Woody Sturges]

Andrew,

  I'm a newbie too.  Welcome.  Something I noticed is that some of the
example portlets will take a while when you refresh the page (especially
if they're trying to grab stuff off the inet or are having problems). 
Have you tried making your new portlet the only one on your current
pane?  That would rule out the effect of other portlets interfering with
response time.  If that does it, then you can slowly add portlets to
identify the problem causer...

Woody

>>> [EMAIL PROTECTED] 08/28/02 06:44AM >>>
Hi,
I'm a jetspeed newbie, impressed with its functionality etc.  My only
concern about using it in production is with response time.  A user
portal
page takes about 8-10 seconds to appear, even with just a 'hello
world'
portlet defined for the user.Meanwhile, I have some fairly
intensive
servlets on the same box that take only 1-2 seconds.  (800MHz, NT,
256Mb,
JRun servlet engine.)

My settings are prettly much out-of-the-box.  cachedOnName="true"
cachedOnValue="true" are set for all portlets.

Are my response times the norm or am I missing something?  Would using
external RDMS rather than Turbine improve things (I've tried SQL server
and
Sybase with no luck).?

Thanks!
Andrew



--
To unsubscribe, e-mail:  

For additional commands, e-mail:



--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: Way to show a portlet twice?

[Woody Sturges]

Look at the bottom of the PortletHowTo for info on the
instance/abstract/ref entries.  This allows you to setup the same
portlet with different 'parameters' (variables) that you can check for. 
I think that may be what you're looking for.

Then again, I'm a newbie...
Woody

>>> [EMAIL PROTECTED] 08/19/02 11:12AM >>>
Is there currently a way to allow a user to make a portlet show up
twice?

This way they can have, for instance, two weather forecasts from two
different cities?  This ability is very important for the application I
am thinking of using Jetspeed as the basis for.

Thanks,

Alan

--
To unsubscribe, e-mail:  

For additional commands, e-mail:



--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

How to maximize a portlet programatically

[Woody Sturges]

Hi all,

  This is probably a newbie question, but how do you maximize a portlet
programatically?  I have a portlet that needs to maximize itself when
the user starts interacting with it.  When the user is done (a parm
quits being sent), it should restore itself.

Any pointers would be appreciated...

Thanks,
Woody Sturges

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>