Hi, please see answer inlined.
On 08.03.2013 14:40, PC Depot wrote: > Greetings > > I am interested in running uniCenta point of sale v3.02, an openbravo > fork, using a network version of derby. UniCenta installs only the > embedded jar by default & I've filled it with products for a small > take-out restaurant. The system works great as is with the following > configuration. > > Driver Library: C:\Program Files\unicentaopos-3.02\.\lib\derby.jar > Driver Class: org.apache.derby.jdbc.EmbeddedDriver > URL: jdbc:derby:C:\Documents and > Settings\Owner\unicentaopos-database;create=true > > So far I've successfully installed and started derby server with the > following command. > > C:\unicentaopos-database-network\lib>java -jar derbyrun.jar server start > > I'm trying to figure out what configuration to use in unicenta for the > pc hosting the server as well as the client pc. Here's what I've > tried so far on the host. > > Driver Library: C:\unicentaopos-database-network\lib\derbyclient.jar > Driver Class: org.apache.derby.jdbc.ClientDriver > URL: jdbc:derby:C:\unicentaopos-database-network\derbyDB;create=true You need to use the network version of the URL, cf. docs here: http://db.apache.org/derby/docs/10.9/adminguide/cadminappsclient.html i.e. your URL would look something like: jdbc:derby://<your server>:1527/derbyDB;create=true Hope this helps, Dag > > The driver always fails to load. Could someone help me with this? > Here are the server details. > > /C:\unicentaopos-database-network\bin>NetworkServerControl.bat sysinfo > -h localho > st -p 1527 > --------- Derby Network Server Information -------- > Version: CSS10090/10.9.1.0 - (1344872) Build: 1344872 DRDA Product > Id: CSS1009 > 0 > -- listing properties -- > derby.drda.maxThreads=0 > derby.drda.sslMode=off > derby.drda.keepAlive=true > derby.drda.minThreads=0 > derby.drda.portNumber=1527 > derby.drda.logConnections=false > derby.drda.timeSlice=0 > derby.drda.startNetworkServer=false > derby.drda.host=localhost > derby.drda.traceAll=false > ------------------ Java Information ------------------ > Java Version: 1.7.0_17 > Java Vendor: Oracle Corporation > Java home: C:\Program Files\Java\jre7 > Java classpath: derbyrun.jar > OS name: Windows XP > OS architecture: x86 > OS version: 5.1 > Java user name: Owner > Java user home: C:\Documents and Settings\Owner > Java user dir: C:\unicentaopos-database-network\lib > java.specification.name: Java Platform API Specification > java.specification.version: 1.7 > java.runtime.version: 1.7.0_17-b02 > --------- Derby Information -------- > [C:\unicentaopos-database-network\lib\derby.jar] 10.9.1.0 - (1344872) > [C:\unicentaopos-database-network\lib\derbytools.jar] 10.9.1.0 - > (1344872) > [C:\unicentaopos-database-network\lib\derbynet.jar] 10.9.1.0 - (1344872) > [C:\unicentaopos-database-network\lib\derbyclient.jar] 10.9.1.0 - > (1344872) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > Current Locale : [English/United States [en_US]] > Found support for locale: [cs] > version: 10.9.1.0 - (1344872) > Found support for locale: [de_DE] > version: 10.9.1.0 - (1344872) > Found support for locale: [es] > version: 10.9.1.0 - (1344872) > Found support for locale: [fr] > version: 10.9.1.0 - (1344872) > Found support for locale: [hu] > version: 10.9.1.0 - (1344872) > Found support for locale: [it] > version: 10.9.1.0 - (1344872) > Found support for locale: [ja_JP] > version: 10.9.1.0 - (1344872) > Found support for locale: [ko_KR] > version: 10.9.1.0 - (1344872) > Found support for locale: [pl] > version: 10.9.1.0 - (1344872) > Found support for locale: [pt_BR] > version: 10.9.1.0 - (1344872) > Found support for locale: [ru] > version: 10.9.1.0 - (1344872) > Found support for locale: [zh_CN] > version: 10.9.1.0 - (1344872) > Found support for locale: [zh_TW] > version: 10.9.1.0 - (1344872) > ------------------------------------------------------/ > > Regards > Griffin