Ask Your Question
0

how to use pcloud online access to database multiuser without lck problem

asked 2018-01-04 10:49:51 +0200

koolninja gravatar image

updated 2018-01-04 10:50:33 +0200

As on Local network with startserver.bat multiuser have access to database but how to use online storage pcloud for server multiuser. As all front hand files on client but which files should on pcloud. Also avoid lck problem...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-04 17:13:30 +0200

Ratslinger gravatar image

Hello,

I have not used pCloud specifically but I can't see how it is any different than Google Drive, DropBox or others I have tested with.

To properly use Base with a cloud service, only one user can update the database (a split or embedded DB) at a time. The cloud service is merely a storage area. The user actually downloads the file to the local system and uses them there. When finished the updated files are put back on the cloud. If multiple users are to have access, only one at a time may update the files. For further reference see this post and the related link within.

edit flag offensive delete link more

Comments

I have experience in server mode that only one user can update but view by multiple users without lck problem. This is working fine in lan network. Over internet we can view data from database. To view data , Copying large database is not always feasible. So database updates online stroage and directly view data by multiple users without lock problem. For this direct update database online.

koolninja gravatar imagekoolninja ( 2018-01-05 18:58:37 +0200 )edit

I am very sorry but you comment is even more confusing than your question. What is this 'lock problem' you refer to? I have HSQL 2.3.2 running in server mode with three users. Each is capable of updating the database even with the XXXXXX.lck file there (unless you are referring to something else).

Then you are talking about pCloud which is file storage. You don't run the server on the cloud. Don't understand "Copying large database"?

Ratslinger gravatar imageRatslinger ( 2018-01-06 04:58:18 +0200 )edit

Even if you could run a server on the cloud, it still has to cross the internet. What exactly is the problem and what are you trying to accomplish? From what is presented, the server is not running properly if only one user can update. May also include design or procedure problem. Many things unknown here.

Ratslinger gravatar imageRatslinger ( 2018-01-06 05:00:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-04 10:49:51 +0200

Seen: 69 times

Last updated: Jan 04 '18