Multiple Java Applications accessing one HSQLDB causes app to hang -


this semi-related previous question. previous question states, have desktop app calls off different main method kick off particular process. both desktop app , separate main method access same hsqldb database.

prior getting far, desktop app had been accessing hsqldb database using connection url one:

jdbc:hsqldb:file:/some/path/mydatabase

now works fine in single user environment. i've got multi-user environment desktop app , separate main process wanting read/write to/from database, wanted make database shared resource.

i've had @ hsqldb documentation , post creating shared hsqldb database no avail.

in post talks starting server via code. don't think want have hsqldb database , running time there multiple users of desktop app.

looking @ official hsqldb documentation, states can start hsqldb server this:

java -cp ../lib/hsqldb.jar org.hsqldb.server -database.0 file:mydb -dbname.0 xdb

if run above command own database file , name, seems start okay:

[server@6ca1c]: [thread[main,5,main]]: checkrunning(false) entered [server@6ca1c]: [thread[main,5,main]]: checkrunning(false) exited [server@6ca1c]: startup sequence initiated main() method [server@6ca1c]: loaded properties [/some/path/mydatabase/server.properties] [server@6ca1c]: initiating startup sequence... [server@6ca1c]: server socket opened in 16 ms.

i changed connection url following:

jdbc:hsqldb:hsql://localhost/xdb

this not seem work me. ideas i've done wrong or missing?

furthermore, when desktop app calls off external main method desktop app hangs external main method notices desktop app seems have lock on database. shut down desktop app, external main method expected do.

using jdbc:hsqldb:file:/some/path/mydatabase creating in-process database should not shared between multiple jvm (ideally), there way per guide

"in 1.8.0, can run server instance in thread same virtual machine application , provide external access in-process database."

imho, better way start in server mode in separate jvm.

update:

check log when hsqlsdb server starting up:

[server@83cc67]: initiating startup sequence... [server@83cc67]: server socket opened in 31 ms. [server@83cc67]: database [index=0, id=0, db=file:test, alias=] opened sucessfully in 250 ms.

match alias name in driver url

connection c = drivermanager.getconnection("jdbc:hsqldb:hsql://localhost/", "sa", "");

in case there no alias. tested , works fine.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more