Hi,

I am wondering...

What happens exactly when i change a panel while users are at the same time using it?

Sometimes it looks as if such changing panels "freeze" and do not work properly anymore. And sometimes it looks as if it is running in the old way (before the changes).

What should happen? Should a running application automatically take up changes? Or should i stop all user sessions, save the application and let them login again?

Kind regards, Jan Willem Vermeer

asked 06 Oct '15, 11:46

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1131227
accept rate: 0%


Hi Jan,

In production, the easiest solution to deploy a new version of your application is to take the current application running in production offline, deploy the new application and finally bring the application back online.

Kind Regards,
Yalim

link

answered 07 Oct '15, 07:25

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Hi Yalim,

That's not the answer to my question :)

Can you explain what an application is? Is it a package that is generated/compiled at the moment i start it? Or is it a bundle of packages/procedures that live read Formspider repository tables? When i develop an application, sometimes the running version keeps on working, but most of the times it does not respond anymore. How come?

Offcourse i could take the application offline, but that's exactly one of the annoying problems with Oracle Forms.

Kind regards, Jan Willem

By the way, it is not "Jan" but "Jan Willem" or "JW" :)

link

answered 07 Oct '15, 08:20

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1131227
accept rate: 0%

Hi FS team,

Can you answer these questions?

I also would like to know if it is possible to see which users are currently running the application. So i can warn them that it will go offline.

Kind regards, Jan Willem

link

answered 15 Oct '15, 10:41

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1131227
accept rate: 0%

Hi Jan Willem,

Here are the answers to your questions:

Can you explain what an application is? Is it a package that is generated/compiled at the moment i start it? Or is it a bundle of packages/procedures that live read Formspider repository table

I think it makes more sense to talk about how Formspider objects are implemented rather than how an application is implemented. I'll just give a few examples here for the most important FS Objects. I won't go into too many details.

For example, a datasource definition is implemented as a Package and as a table. (Check the Physical tab in the Datasource Definition Dialog. In hindsight Implementation is a better name for this tab.) These database objects are regenerated every time you make a modification to a data source definition. Datasources on the other hand are just rows in tables. Formspider generates a PL/SQL package for each Panel. Every time you save a Panel in the IDE, the panel package is regenerated. These panel packages are used to initialize the panels during run time (the first time they are referenced by an application a user is running).

The reason your application sometimes continues to work even if you modify a panel (but sometimes it doesn't) is because Formspider initializes panels only when they are referenced during run time(either by showing up on the screen or by being referenced in an API call). If you modify a panel which is already initialized in your currently running application then things will not work. If the panel is not yet initialized for your application, then things will progress smoothly. The same is true for datasources and all other Formsider objects. (There might be exceptions but I cannot think of any right now)

I must emphasize that a Formspider developer never ever has to worry about these implementation details. Formspider takes care of the maintenance of these objects. I am just explaining because you asked. :-)

In theory, I think it should be possible to update a Formspider application live although we don't provide any tools that directly helps for this purpose (we can do this in the future but it is not part of our current roadmap). I suspect maybe Michiel might have experience with this?

I will provide a query that will give you the current online users at a later time. I am out of the office today.

Kind Regards,
Yalim

link

answered 16 Oct '15, 07:35

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

edited 16 Oct '15, 07:37

Hi Yalim,

My conclusion is that applications can only be updated when no users are active.

I have three subsequent questions about this:

1) Can you provide the query to select current online users?

2) Is it possible to push a message in the application so all users can see that i will stop the application at a certain time?

3) Is it possible to kill the sessions of the current users?

Kind regards, Jan Willem

link

answered 26 Oct '15, 09:40

Jan%20Willem%20Vermeer's gravatar image

Jan Willem V...
1131227
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×32
×27
×16
×3

Asked: 06 Oct '15, 11:46

Seen: 1,054 times

Last updated: 26 Oct '15, 09:40


© Copyright Gerger 2017