db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Senthil Gugan <senthilgu...@gmail.com>
Subject Re: How can I access BIRT classic model database using ij scripting tool.
Date Thu, 22 Mar 2007 11:39:09 GMT

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.


Mime
View raw message