db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SAURABH KEJRIWAL <saurabh.iit...@gmail.com>
Subject DERBY-5818
Date Thu, 14 Jun 2012 12:12:31 GMT
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

Mime
View raw message