Hi,
I am new to Apache Derby Database. I have filed following bug against DERBY
product.
*DERBY-5818: values
syscs_util.syscs_get_database_property('DataDictionaryVersion' ) does not
return full version information*
Details
------------
$ ./sysinfo
------------------ Java Information ------------------
Java Version: 1.6.0
Java Vendor: Sun Microsystems Inc.
Java home: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre
Java classpath:
/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derby.jar:/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbynet.jar:/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbytools.jar:/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbyclient.jar
OS name: Linux
OS architecture: i386
OS version: 2.6.18-164.0.0.0.1.el5xen
Java user name: ansverma
Java user home: /home/ansverma
Java user dir: /scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/bin
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
java.runtime.version: 1.6.0-b09
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derby.jar] 10.8.2.2
- (1181258)
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbytools.jar]
10.8.2.2 - (1181258)
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbynet.jar]
10.8.2.2 - (1181258)
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbyclient.jar]
10.8.2.2 - (1181258)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [cs]
version: 10.8.2.2 - (1181258)
Found support for locale: [de_DE]
version: 10.8.2.2 - (1181258)
Found support for locale: [es]
version: 10.8.2.2 - (1181258)
Found support for locale: [fr]
version: 10.8.2.2 - (1181258)
Found support for locale: [hu]
version: 10.8.2.2 - (1181258)
Found support for locale: [it]
version: 10.8.2.2 - (1181258)
Found support for locale: [ja_JP]
version: 10.8.2.2 - (1181258)
Found support for locale: [ko_KR]
version: 10.8.2.2 - (1181258)
Found support for locale: [pl]
version: 10.8.2.2 - (1181258)
Found support for locale: [pt_BR]
version: 10.8.2.2 - (1181258)
Found support for locale: [ru]
version: 10.8.2.2 - (1181258)
Found support for locale: [zh_CN]
version: 10.8.2.2 - (1181258)
Found support for locale: [zh_TW]
version: 10.8.2.2 - (1181258)
------------------------------------------------------
Description
-----------------
I am using Derby 10.8.2.2. I want to get derby version details through SQL.
I ran following query to retrieve version information.
$ java -jar
/scratch/ansverma/JavaDBnew//db-derby-10.8.2.2-bin/lib/derbyrun.jar ij
ij version 10.8
ij> CONNECT 'jdbc:derby:test2;user=test2;password=test2';
ij> values syscs_util.syscs_get_database_property('DataDictionaryVersion');
1
--------------------------------------------------------------------------------------------------------------------------------
10.8
1 row selected
It did not return full version information (10.8.2.2) for Derby.
Expected result = 10.8.2.2
Actual result = 10.8
I want the version details through SQL query. Could you please help me for
this?
Thanks,
Saurabh
