db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag Wanvik <dag.wan...@oracle.com>
Subject Re: Derby Embedded Server & Network Client
Date Mon, 11 Mar 2013 03:07:44 GMT
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


Mime
View raw message