You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by PC Depot <gr...@boropcdepot.com> on 2013/03/08 05:40:48 UTC
Derby Embedded Server & Network Client
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
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
Re: Derby Embedded Server & Network Client
Posted by Dag Wanvik <da...@oracle.com>.
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