Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread EWB 3 Build 8 - Problem When Server Database Configuration Saved
Sun, Apr 12 2020 5:15 PMPermanent Link

Rob Frye

When configurations within Servers - Internal - Databases are saved, the ewbsrvr.db is not being written out properly.  A file of only 6 bytes is created.  For example, make a change in Databases (eg. add a database or dataset) and then stop the server or close the IDE.  When trying to restart the server or starting the IDE, a 'Stream read failure' error will occur.  The only way I can address the problem is to delete the damaged ewbsrvr.db file.  Configurations that were created with earlier builds of EWB seem to function properly until they are edited.

(The error message is exactly the same as what Steve already reported.)

Rob
Mon, Apr 13 2020 3:03 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Rob,

<< When configurations within Servers - Internal - Databases are saved, the ewbsrvr.db is not being written out properly.  A file of only 6 bytes is created.  For example, make a change in Databases (eg. add a database or dataset) and then stop the server or close the IDE.  When trying to restart the server or starting the IDE, a 'Stream read failure' error will occur.  The only way I can address the problem is to delete the damaged ewbsrvr.db file.  Configurations that were created with earlier builds of EWB seem to function properly until they are edited. >>

Yeah, I think that I got caught with a half-added change to the server database streaming.  I will have a build 9 out shortly for this.  In the meantime, don't edit any server-side objects until the fix is out.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Apr 13 2020 8:03 PMPermanent Link

Rob Frye

Hi Tim

The 'DB' extension on the mentioned file caused me to wonder if you were using SQLite.  If so, are you giving any consideration to adding SQLite as a fourth engine choice for databases?

Rob
Tue, Apr 14 2020 12:24 PMPermanent Link

Zoran

Rob Frye wrote:

Hi Tim

The 'DB' extension on the mentioned file caused me to wonder if you were using SQLite.  If so, are you giving any consideration to adding SQLite as a fourth engine choice for databases?

Rob


I'll second that.
Zoran
Wed, Apr 15 2020 11:31 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Rob,

<< The 'DB' extension on the mentioned file caused me to wonder if you were using SQLite.  If so, are you giving any consideration to adding SQLite as a fourth engine choice for databases? >>

No, it's a custom database format.  The web server has some specific requirements in this area, specifically in terms of performance, compression, and versioning of server objects.

You can use SQLite now via the ADO/ODBC database engine type.

Tim Young
Elevate Software
www.elevatesoft.com
Image