Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7A7A59D2E for ; Thu, 14 Jun 2012 13:21:14 +0000 (UTC) Received: (qmail 61436 invoked by uid 500); 14 Jun 2012 13:21:14 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 61398 invoked by uid 500); 14 Jun 2012 13:21:14 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 61366 invoked by uid 99); 14 Jun 2012 13:21:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Jun 2012 13:21:14 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_HI,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kristian.waagan@oracle.com designates 148.87.113.117 as permitted sender) Received: from [148.87.113.117] (HELO rcsinet15.oracle.com) (148.87.113.117) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Jun 2012 13:21:04 +0000 Received: from acsinet22.oracle.com (acsinet22.oracle.com [141.146.126.238]) by rcsinet15.oracle.com (Sentrion-MTA-4.2.2/Sentrion-MTA-4.2.2) with ESMTP id q5EDKhei027100 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Thu, 14 Jun 2012 13:20:43 GMT Received: from acsmt356.oracle.com (acsmt356.oracle.com [141.146.40.156]) by acsinet22.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id q5EDKgKC010721 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 14 Jun 2012 13:20:42 GMT Received: from abhmt110.oracle.com (abhmt110.oracle.com [141.146.116.62]) by acsmt356.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id q5EDKgcm015476 for ; Thu, 14 Jun 2012 08:20:42 -0500 Received: from [10.172.141.135] (/10.172.141.135) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Thu, 14 Jun 2012 06:20:42 -0700 Message-ID: <4FD9E4D4.10508@oracle.com> Date: Thu, 14 Jun 2012 15:19:16 +0200 From: Kristian Waagan Organization: Oracle Corporation User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.1) Gecko/20120208 Thunderbird/10.0.1 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: Re: DERBY-5818 References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------000808090804040609060808" X-Source-IP: acsinet22.oracle.com [141.146.126.238] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------000808090804040609060808 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 14.06.2012 14:12, SAURABH KEJRIWAL wrote: > I want the version details through SQL query. Could you please help me > for this? Hi Saurabh, Can you just confirm that doing this via a JDBC method call isn't an option for you? If JDBC is okay, maybe the method DatabaseMetaData.getDatabaseProductVersion gives you what you need. -- Kristian --------------000808090804040609060808 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 14.06.2012 14:12, SAURABH KEJRIWAL wrote:

I want the version details through SQL query. Could you please help me for this?

Hi Saurabh,

Can you just confirm that doing this via a JDBC method call isn't an option for you?
If JDBC is okay, maybe the method DatabaseMetaData.getDatabaseProductVersion gives you what you need.

--
Kristian
--------------000808090804040609060808--