question on creating groups in servoy application server

Classic Servoy
1

Hi,

I installed Servoy 4.1.4 and now i want to add a group and a user belonging tot that group.

I can do this in developer, but I do not see this group and user in the Server Admin Page.
(after stopping Developer and starting Server)

What am i missing ??

Regards,

Hans

2

probably you didn’t commit the user/group in repository

3

Hi,

First of all thanks for the answer, I tried it

If i add a user or group and then commit , I get an error : java.lang.Long cannot be cast to java.lang.Integer

To be sure I have been clear in the first entry :

The Developer and the Server are started from the same Servoy installation.

So, the question is : how do i add a group to the servoy server ( so it is shown on the servoy admin page)

Regards,

Hans

4

Hi,

Also tried this with Servoy Version: 5.0.0 - build 859.

Same problem, when i add a group or a user and then commit the change from developer to the server
i get the error writeProjectToRepository

java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
at com.servoy.eclipse.team.Zb.Zb(Zb.java:636)
at com.servoy.eclipse.team.Zb.Za(Zb.java:560)
at com.servoy.eclipse.team.Zb.Za(Zb.java:52)
at com.servoy.eclipse.team.Zb.Za(Zb.java:202)
at com.servoy.eclipse.team.ui.actions.Zg.Za(Zg.java:3)
at com.servoy.eclipse.team.ui.actions.Zf.execute(Zf.java:32)
at org.eclipse.team.ui.synchronize.ModelOperation.run(ModelOperation.java:106)
at org.eclipse.team.internal.ui.actions.JobRunnableContext.run(JobRunnableContext.java:144)
at org.eclipse.team.internal.ui.actions.JobRunnableContext$ResourceJob.runInWorkspace(JobRunnableContext.java:72)
at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:38)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Please advice,

This stops us from going production with 4 or 5.

Or is there some other simple way / workaround to create a group in servoy server ??

Regards,

Hans Nieuwenhuis

5

Found a workaround :

  • Create the group and a user on it in servoy developer.
  • Export from developer and include the users/groups in the export
  • import in servoy server with the option to create non-existing users

The new group and user are created during the import.

This is a big effort though, just to add a group.

Regards,

Hans

6

This problem is caused by group_id which is seen as a long while we assume it is an integer. What type you have for column group_id in servoy_groups table from repository ? Did you alter the repository manually (as we create this column as int)?

7

We did not change it.

I have to install a new laptop for my colleague today.
I’ll check immediate after the install and let you know.

Thanks,

Hans

8

Hi Laurian,

Did a fresh install (4.1.4 and oracle 10gr2) and
the groups table is :

SQL> describe servoy_groups
Name Null? Type

GROUP_ID NOT NULL NUMBER(10)
GROUP_NAME NOT NULL VARCHAR2(100 CHAR)
GROUP_DESCRIPTION VARCHAR2(100 CHAR)

If it was an integer it would show up as NUMBER(38)

Regards,

Hans

9

Hans Nieuwenhuis:
Hi Laurian,

Did a fresh install (4.1.4 and oracle 10gr2) and
the groups table is :

SQL> describe servoy_groups
Name Null? Type

GROUP_ID NOT NULL NUMBER(10)
GROUP_NAME NOT NULL VARCHAR2(100 CHAR)
GROUP_DESCRIPTION VARCHAR2(100 CHAR)

If it was an integer it would show up as NUMBER(38)

Regards,

Hans

So it doesn’t work even from a fresh install with a new repository ? We’ll try this as well.

10

Indeed doesn’t work well on Oracle repository database, please add a case about this.

11

Ok, Thanks.

I’ll create a case.

Regards,

Hans