Running a SQL script with apache derby IJ with glassfish5 on linux mint got this error:
IJ ERROR: Unable to establish connection
$GLASSFISH_HOME/bin/asadmin start-domain
........
Admin Port: 4848
Command start-domain executed successfully.
$GLASSFISH_HOME/bin/asadmin start-database
Starting database in Network Server mode on host 0.0.0.0 and port 1527.
--------- Derby Network Server Information --------
Version: CSS10140/10.14.2.0 - (1828579) Build: 1828579 DRDA Product Id: CSS10140
-- listing properties --
derby.drda.traceDirectory=/home/akao
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=0.0.0.0
derby.drda.traceAll=false
------------------ Java Information ------------------
Java Version: 1.8.0_251
Java Vendor: Oracle Corporation
Java home: /home/akao/jdk/jdk1.8.0_251/jre
Java classpath: /home/akao/glassfish/glassfish5/glassfish/lib/asadmin/cli-optional.jar:/home/akao/glassfish/glassfish5/javadb/lib/derby.jar:/home/akao/glassfish/glassfish5/javadb/lib/derbytools.jar:/home/akao/glassfish/glassfish5/javadb/lib/derbynet.jar:/home/akao/glassfish/glassfish5/javadb/lib/derbyclient.jar
OS name: Linux
OS architecture: amd64
OS version: 4.10.0-38-generic
Java user name: akao
Java user home: /home/akao
Java user dir: /home/akao
java.specification.name: Java Platform API Specification
java.specification.version: 1.8
java.runtime.version: 1.8.0_251-b08
--------- Derby Information --------
[/home/akao/glassfish/glassfish5/javadb/lib/derby.jar] 10.14.2.0 - (1828579)
[/home/akao/glassfish/glassfish5/javadb/lib/derbytools.jar] 10.14.2.0 - (1828579)
[/home/akao/glassfish/glassfish5/javadb/lib/derbynet.jar] 10.14.2.0 - (1828579)
[/home/akao/glassfish/glassfish5/javadb/lib/derbyclient.jar] 10.14.2.0 - (1828579)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/Canada [en_CA]]
Found support for locale: [cs]
version: 10.14.2.0 - (1828579)
Found support for locale: [de_DE]
version: 10.14.2.0 - (1828579)
Found support for locale: [es]
version: 10.14.2.0 - (1828579)
Found support for locale: [fr]
version: 10.14.2.0 - (1828579)
Found support for locale: [hu]
version: 10.14.2.0 - (1828579)
Found support for locale: [it]
version: 10.14.2.0 - (1828579)
Found support for locale: [ja_JP]
version: 10.14.2.0 - (1828579)
Found support for locale: [ko_KR]
version: 10.14.2.0 - (1828579)
Found support for locale: [pl]
version: 10.14.2.0 - (1828579)
Found support for locale: [pt_BR]
version: 10.14.2.0 - (1828579)
Found support for locale: [ru]
version: 10.14.2.0 - (1828579)
Found support for locale: [zh_CN]
version: 10.14.2.0 - (1828579)
Found support for locale: [zh_TW]
version: 10.14.2.0 - (1828579)
------------------------------------------------------
------------------------------------------------------
Starting database in the background.
Log redirected to /home/akao/derby.log.
Command start-database executed successfully.
~/glassfish/glassfish5/javadb/bin/ij
ij version 10.14
ij> run '/home/akao/derby-hr-schema-master/HR_CREATE.sql';
ij> CREATE TABLE regions(region_id NUMERIC
CONSTRAINT region_id_nn NOT NULL
, region_name VARCHAR (25)
);
IJ ERROR: Unable to establish connection
...
IJ ERROR: Unable to establish connection
ij> COMMIT;
IJ ERROR: Unable to establish connection
ij>
HR_CREATE.sql is as follows (shortened for brevity):
CREATE TABLE regions(region_id NUMERIC
CONSTRAINT region_id_nn NOT NULL
, region_name VARCHAR (25)
);
CREATE UNIQUE INDEX reg_id_pk
ON regions (region_id);
] 
Search
Help
Register
Login
Home
