db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Saurabh Kejriwal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5818) values syscs_util.syscs_get_database_property('DataDictionaryVersion' ) does not return full version information
Date Thu, 14 Jun 2012 11:55:42 GMT
Saurabh Kejriwal created DERBY-5818:
---------------------------------------

             Summary: values syscs_util.syscs_get_database_property('DataDictionaryVersion'
) does not return full version information
                 Key: DERBY-5818
                 URL: https://issues.apache.org/jira/browse/DERBY-5818
             Project: Derby
          Issue Type: Bug
            Reporter: Saurabh Kejriwal


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.


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message