Hi,

I've got a problem with the Commit-procedure of the Database. I try to insert a new row in my dataset and everything works just fine, except the commit of the transaction. In the grid on my form, I can see that the new data is successfully inserted in the dataset. But the transaction is still active after the commit-command and there's no change on the datasets on the webserver.

I try to do the following:

Open the dataset
Start the transaction
Change the state of the dataset to insert
Fill the columns with data
Call the save method
Call the commit method after the save method is executed

Am I missing something? I can get the dataset from the webserver and view it in my grid-component, so I'm pretty sure its not a connection problem.

Juergen,

<< I've got a problem with the Commit-procedure of the Database. I try to
insert a new row in my dataset and everything works just fine, except the
commit of the transaction. In the grid on my form, I can see that the new
data is successfully inserted in the dataset. But the transaction is still
active after the commit-command and there's no change on the datasets on the
webserver. >>

Do you have an OnCommitError event handler defined/assigned for the global
Database component ?  If not, then you should be seeing an exception if
there's an error with the commit request.

What database are you using on the back-end (or in the IDE) ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

>> "Tim Young [Elevate Software]" wrote:
>>
>> Do you have an OnCommitError event handler defined/assigned for the global
>> Database component ?  If not, then you should be seeing an exception if
>> there's an error with the commit request.
>>
>> What database are you using on the back-end (or in the IDE) ?

No, I don't have an OnCommitError event handler assigned and I don't see an exception. But if I check if the Transaction is still active I get a True-result.

Also, if I run the procedure multiple times, I can see that the transaction string (via GetTransactions) is getting bigger and the commit comand doesn't empty the transaction string.

I use a DBISAM-Database (Database System Utility Version 4.25 Build 7)

Juergen,

<< No, I don't have an OnCommitError event handler assigned and I don't see
an exception. But if I check if the Transaction is still active I get a
True-result.

Also, if I run the procedure multiple times, I can see that the transaction
string (via GetTransactions) is getting bigger and the commit comand doesn't
empty the transaction string.

I use a DBISAM-Database (Database System Utility Version 4.25 Build 7) >>

Do you have FireFox or Chrome ?  If so, then you can use the F12 developer
tools window to debug what is getting sent "over the wire" via the Network
panel, and if there is any error occurring during the process.

Likewise, if you want to just send me your project, I can take a look and
tell you what the problem is.

Tim Young
Elevate Software
www.elevatesoft.com

<<Do you have FireFox or Chrome ?  If so, then you can use the F12 developer
tools window to debug what is getting sent "over the wire" via the Network
panel, and if there is any error occurring during the process.>>

I made a new project from scratch to test the transaction-process. When I run it and commit the transaction, I get the following error message: "Error: Database commit response error"

The developer tools show a HTTP 500 internal server error:

"[16:11:44.040] POST http://192.168.16.5/Database_Save/datasets?method=commit [HTTP/1.1 500 Error 15ms]"

Juergen,

Are you using the external EWB Web Server, the internal local web server in
the IDE, or something else for the web server ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

<<Are you using the external EWB Web Server, the internal local web server in
the IDE, or something else for the web server ?>>

I'm using the external EWB Web Server.

Also I'm using an older version of the DBISAM Server (Version 4.25 Build 7). Could that be the problem?

Thanks

<<Also I'm using an older version of the DBISAM Server (Version 4.25 Build 7). Could that be the problem?>>

A little correction: The engine version of the DBISAM server is 4.21 Build 10

Sorry

Ooops, sorry, found my problem. I did use a customized DBISAM server.

Now I tried a regular one with standard settings and everything works fine.

Sorry for the confusion

Juergen,

<< Ooops, sorry, found my problem. I did use a customized DBISAM server.

Now I tried a regular one with standard settings and everything works fine.

Sorry for the confusion >>

Good, thanks for the update.

Tim Young
Elevate Software
www.elevatesoft.com