Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 17817 invoked from network); 22 Mar 2007 11:39:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 22 Mar 2007 11:39:34 -0000 Received: (qmail 59450 invoked by uid 500); 22 Mar 2007 11:39:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 59422 invoked by uid 500); 22 Mar 2007 11:39:39 -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 59407 invoked by uid 99); 22 Mar 2007 11:39:39 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Mar 2007 04:39:39 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Mar 2007 04:39:29 -0700 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HULdN-0000EE-E1 for derby-user@db.apache.org; Thu, 22 Mar 2007 04:39:09 -0700 Message-ID: <9611804.post@talk.nabble.com> Date: Thu, 22 Mar 2007 04:39:09 -0700 (PDT) From: Senthil Gugan To: derby-user@db.apache.org Subject: Re: How can I access BIRT classic model database using ij scripting tool. In-Reply-To: <460163EE.9050403@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: senthilgugan@gmail.com References: <9574722.post@talk.nabble.com> <460030DA.8030205@gmail.com> <9595041.post@talk.nabble.com> <460163EE.9050403@gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org Hi Stanley, Thank you for your reply. Now i'm able to access the database table. Thanks, Senthil. Stanley Bradbury wrote: > > You need to specify the schema name or set your default schema to > > CLASSICMODELS - select * from claisicmodels.customers; should work > > Senthil Gugan wrote: >> Hi Sunitha, >> Thanks for your help. >> Now i'm able to connect the classic model DB via ij, using the >> statement, >> ij> connect >> 'jdbc:derby:jar:(/var/EclipseBirt/eclipse/plugins/org.eclipse.birt.report.data.oda.sampledb_2.1.1.v20070205-1728/db/BirtSample.jar)BirtSample'; >> but couldn't able to access the tables in the database. Can you tell me >> how >> to do it. >> >> here is what i did: >> ij> connect >> 'jdbc:derby:jar:(/var/EclipseBirt/eclipse/plugins/org.eclipse.birt.report.data.oda.sampledb_2.1.1.v20070205-1728/db/BirtSample.jar)BirtSample'; >> ij> select * from customers; >> this statement shows the error: ERROR 42X05: Table/View 'CUSTOMERS' does >> not >> exist. >> >> Note: i'm able to execute the following statement. >> ij> show tables; >> TABLE_SCHEM |TABLE_NAME |REMARKS >> ------------------------------------------------------------------------ >> SYS |SYSALIASES | >> SYS |SYSCHECKS | >> SYS |SYSCOLUMNS | >> SYS |SYSCONGLOMERATES | >> SYS |SYSCONSTRAINTS | >> SYS |SYSDEPENDS | >> SYS |SYSFILES | >> SYS |SYSFOREIGNKEYS | >> SYS |SYSKEYS | >> SYS |SYSSCHEMAS | >> SYS |SYSSTATEMENTS | >> SYS |SYSSTATISTICS | >> SYS |SYSTABLES | >> SYS |SYSTRIGGERS | >> SYS |SYSVIEWS | >> SYSIBM |SYSDUMMY1 | >> CLASSICMODELS |CUSTOMERS | >> CLASSICMODELS |EMPLOYEES | >> CLASSICMODELS |OFFICES | >> CLASSICMODELS |ORDERDETAILS | >> CLASSICMODELS |ORDERS | >> CLASSICMODELS |PAYMENTS | >> CLASSICMODELS |PRODUCTLINES | >> CLASSICMODELS |PRODUCTS | >> >> 24 rows selected >> ij> >> >> Thanks, >> Senthil. >> >> Sunitha Kambhampati wrote: >> >>> Senthil Gugan wrote: >>> >>> >>>> Hi, >>>> I am working on LINUX SuSe10.2 OS with the following version of >>>> softwares, jdk1.5.0_11, eclipse3.2(BIRT2.1.2). >>>> I have installed the Derby plugin in the Eclipse plugin >>>> Directory. >>>> Here my problem is I couldn't able to access the BIRT classic model >>>> database using the ij scripting tool. >>>> Can anybody tell me is it possible to access the BIRT classic >>>> model >>>> database using the ij scripting tool?. >>>> >>>> >>>> >>> The BIRT Classic model database is in a jar file. I have the >>> birt-database-2.2M2 downloaded on my machine and the database is inside >>> BirtSample.jar under birt-database-2.2M2\ClassicModels\derby\bin >>> >>> More info in docs about how to access database in a jar is here: >>> http://db.apache.org/derby/docs/dev/devguide/cdevdvlp24155.html >>> >>> To access this via ij , set classpath to include the jar. >>> $ export CLASSPATH="BirtSample.jar;$CLASSPATH" >>> $ java org.apache.derby.tools.ij >>> ij version 10.2 >>> ij> connect 'jdbc:derby:jar:(C:\work\scripts\BirtSample.jar)BirtSample'; >>> ij> show tables; >>> TABLE_SCHEM |TABLE_NAME |REMARKS >>> ------------------------------------------------------------------------ >>> SYS |SYSALIASES | >>> SYS |SYSCHECKS | >>> SYS |SYSCOLUMNS | >>> SYS |SYSCONGLOMERATES | >>> SYS |SYSCONSTRAINTS | >>> SYS |SYSDEPENDS | >>> SYS |SYSFILES | >>> SYS |SYSFOREIGNKEYS | >>> SYS |SYSKEYS | >>> SYS |SYSSCHEMAS | >>> SYS |SYSSTATEMENTS | >>> SYS |SYSSTATISTICS | >>> SYS |SYSTABLES | >>> SYS |SYSTRIGGERS | >>> SYS |SYSVIEWS | >>> SYSIBM |SYSDUMMY1 | >>> CLASSICMODELS |CUSTOMERS | >>> CLASSICMODELS |EMPLOYEES | >>> CLASSICMODELS |OFFICES | >>> CLASSICMODELS |ORDERDETAILS | >>> CLASSICMODELS |ORDERS | >>> CLASSICMODELS |PAYMENTS | >>> CLASSICMODELS |PRODUCTLINES | >>> CLASSICMODELS |PRODUCTS | >>> >>> 24 rows selected >>> ij> >>> >>> >>>> I have no problem in accessing the Derby database using the ij >>>> scripting tool. >>>> >>>> Thanks in advance, >>>> Senthil. >>>> >>>> >>>> >>> >>> >> >> > > > > -- View this message in context: http://www.nabble.com/How-can-I-access-BIRT-classic-model-database-using-ij-scripting-tool.-tf3434369.html#a9611804 Sent from the Apache Derby Users mailing list archive at Nabble.com.