I have a website driven by content in an EDB database.

It is a pretty simple Delphi program: Vanilla web-broker.

Content is retrieved from 1 main data-table.
There are a large number of images (thousands) so I have put all the images in a data-table for easier management.

Each page is composed of 1 main section of content (from the main data-table) and any number of images. The HTML for the main page includes HREFs to pull down the images.

It works quite well, once it works ... I launch the server, start the EDB Server, start my web-app.

Then if I open a web-browser linked to my website 2 things can happen:

1. The first few pages include a few blank images and then after the 3rd or 4th page the whole thing works. In this case EDB Server will then always be showing 6 active sessions.

2. The system never settles, always including some blank images on pages, sometimes just returning page content: "200OK" and showing an error on the server (attached). In this case the EDB Server will always be showing a single active session.

The weird thing is how random the 2 outcomes are.

In Web-broker app is incredibly simple. In includes a web-module (Webbroker equivalent of Data module) with EDB Components, there is only 1 EDB Session in the App, and it is on the web-module.

I assumed the web-module was exactly the same as a Datamodule, but it is clearly a bit different, ie 1 running App/Website can start multiple web-modules, creating multiple Sessions. It seems to be this multiple session creation which is causing the issues.

Does anyone have experience of working with EDB and Web-broker?

On-line help / Googling is pretty hopeless. There is very little useful information out there.

Sorry forgot the error message I mentioned in the main post.

Adam Brett wrote:

> I have a website driven by content in an EDB database.
>
> It is a pretty simple Delphi program: Vanilla web-broker.
>
> Content is retrieved from 1 main data-table.
> There are a large number of images (thousands) so I have put all the
> images in a data-table for easier management.
>
> Each page is composed of 1 main section of content (from the main
> data-table) and any number of images. The HTML for the main page
> includes HREFs to pull down the images.
>
> It works quite well, once it works ... I launch the server, start the
> EDB Server, start my web-app.
>
> Then if I open a web-browser linked to my website 2 things can happen:
>
> 1. The first few pages include a few blank images and then after the
> 3rd or 4th page the whole thing works. In this case EDB Server will
> then always be showing 6 active sessions.
>
> 2. The system never settles, always including some blank images on
> pages, sometimes just returning page content: "200OK" and showing an
> error on the server (attached). In this case the EDB Server will
> always be showing a single active session.
>
> The weird thing is how random the 2 outcomes are.
>
> In Web-broker app is incredibly simple. In includes a web-module
> (Webbroker equivalent of Data module) with EDB Components, there is
> only 1 EDB Session in the App, and it is on the web-module.
>
> I assumed the web-module was exactly the same as a Datamodule, but it
> is clearly a bit different, ie 1 running App/Website can start
> multiple web-modules, creating multiple Sessions. It seems to be this
> multiple session creation which is causing the issues.
>
> Does anyone have experience of working with EDB and Web-broker?
>
> On-line help / Googling is pretty hopeless. There is very little
> useful information out there.

Hi Adam, have you checked all of your functions to be thread-safe.
Web-Module / Datamodule will call each session with its own thread.

--
--
Yusuf Zorlu | MicrotronX