Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (herse.apache.org: 32.97.182.144 is neither permitted
 nor denied by domain of Stan.Bradbury@gmail.com)
Message-ID: <460163EE.9050403@gmail.com>
Date: Wed, 21 Mar 2007 09:57:18 -0700
From: Stanley Bradbury <Stan.Bradbury@gmail.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: How can I access BIRT classic model database using ij scripting
 tool.
References: <9574722.post@talk.nabble.com> <460030DA.8030205@gmail.com>
 <9595041.post@talk.nabble.com>
In-Reply-To: <9595041.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.
>>>  
>>>
>>>       
>>
>>     
>
>