You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@tuscany.apache.org by Wojciech Blad <wo...@imantras.com> on 2006/11/22 05:02:58 UTC
empty select from oracle database
Hi All,
I am running DAS against oracle database (10.1.0.5 and 9.2). Insert
statements run fine, rows are being inserted into table without any
problems.
When I run simple select statement the list returned is empty.
I reconfigured DAS demo application to run against oracle database
instead of derby and select statements (select * from company) return no
values as well.
I see session within oracle and select statement has been executed, it
looks like problem is on DAS/SDO side.
Anyone had similar problem?
Thanks for any hints, beginning is always painful.
Wojtek
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Brent Daniel <br...@gmail.com>.
Wojtek,
Are you defining a ResultSetShape in the Config? Unfortunately, the
oracle JDBC drivers return an empty value for
ResultSetMetaData.getTableName(), so the DAS is not able to process
the data returned from a query without having some information about
the results passed in. I don't think we're throwing an exception in
this case today, but that's something we should look into.
Brent
On 11/22/06, Kevin Williams <ke...@qwest.net> wrote:
> Very strange. I know that Brent has done a fair amount of testing with
> Oracle so it is hard to imagine something as simple as this failing. I
> wonder if an exception is being eaten somewhere? If you have some time
> before morning you might run with logging enabled
> (http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/Improved_logging#preview)
> and post the results.
>
> Thanks.
> --
> Kevin
>
>
> Wojciech Blad wrote:
>
> > from sql session:
> > SID 134 - jdbc connection
> >
> > Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.5.0
> >
> > SQL> select sql_text from v$open_cursor where sid = 134;
> >
> > SQL_TEXT
> > ------------------------------------------------------------
> > select * from COMPANY
> >
> >
> > SQL> select * from COMPANY;
> >
> > ID NAME
> > --------------------------------------- --------------------
> > 1 aaa
> > 2 bbb
> > 3 ccc
> >
> >
> > Kevin Williams wrote:
> >
> >> Can you execute the identical SELECT directly from the Oracle console
> >> or some other tool? This will provide another data point.
> >> Thanks.
> >> --
> >> Kevin
> >>
> >>
> >> Wojciech Blad wrote:
> >>
> >>> Hi Kevin,
> >>>
> >>> Thanks for quick answer.
> >>>
> >>> I created tables company and department in oracle and populated with
> >>> sample data. Before changing demo application I tested on other
> >>> tables as well. No results returned.
> >>>
> >>> Kevin Williams wrote:
> >>>
> >>>> Hello Wojtek,
> >>>>
> >>>> The RDB DAS Company sample runs against a Derby instance
> >>>> prepopulated with Companies and related Departments. Have you
> >>>> prepopulated your Oracle database in a similar manner? You might
> >>>> try running your select statement directly against your database to
> >>>> verify that it returns results.
> >>>>
> >>>> Thanks.
> >>>> --
> >>>> Kevin
> >>>>
> >>>>
> >>>> Wojciech Blad wrote:
> >>>>
> >>>>> Hi All,
> >>>>>
> >>>>> I am running DAS against oracle database (10.1.0.5 and 9.2).
> >>>>> Insert statements run fine, rows are being inserted into table
> >>>>> without any problems.
> >>>>> When I run simple select statement the list returned is empty.
> >>>>> I reconfigured DAS demo application to run against oracle database
> >>>>> instead of derby and select statements (select * from company)
> >>>>> return no values as well.
> >>>>> I see session within oracle and select statement has been
> >>>>> executed, it looks like problem is on DAS/SDO side.
> >>>>>
> >>>>> Anyone had similar problem?
> >>>>>
> >>>>> Thanks for any hints, beginning is always painful.
> >>>>> Wojtek
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> ---------------------------------------------------------------------
> >>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> >>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>> ---------------------------------------------------------------------
> >>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> >>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> >>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> >> For additional commands, e-mail: tuscany-user-help@ws.apache.org
> >>
> >>
> >>
> >>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> > For additional commands, e-mail: tuscany-user-help@ws.apache.org
> >
> >
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Wojciech Blad <wo...@imantras.com>.
Hi Kevin,
Thanks for pointing to those sources, including ResultDescriptor element
in config file for each column solves the problem.
Wojtek
Kevin Williams wrote:
> Doh!
>
> Oracle does not provide complete ResultSetMetadata and this is almost
> certainly causing the symptoms you are seeing. I would have expected
> an exception and I will look into that. Also, we have a workaround
> available for JDBC drivers that do not fully implement
> ResultSetMetadata. You can explicitly define the result set shape for
> a select and we have some simple tests that use this feature here:
> /das/src/test/java/org/apache/tuscany/das/rdb/test/ResultSetShapeTests.java
>
>
> --
> Kevin
>
>
> Kevin Williams wrote:
>
>> Very strange. I know that Brent has done a fair amount of testing
>> with Oracle so it is hard to imagine something as simple as this
>> failing. I wonder if an exception is being eaten somewhere? If you
>> have some time before morning you might run with logging enabled
>> (http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/Improved_logging#preview)
>> and post the results.
>>
>> Thanks.
>> --
>> Kevin
>>
>>
>> Wojciech Blad wrote:
>>
>>> from sql session:
>>> SID 134 - jdbc connection
>>>
>>> Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.5.0
>>>
>>> SQL> select sql_text from v$open_cursor where sid = 134;
>>>
>>> SQL_TEXT
>>> ------------------------------------------------------------
>>> select * from COMPANY
>>>
>>>
>>> SQL> select * from COMPANY;
>>>
>>> ID NAME
>>> --------------------------------------- --------------------
>>> 1 aaa
>>> 2 bbb
>>> 3 ccc
>>>
>>>
>>> Kevin Williams wrote:
>>>
>>>> Can you execute the identical SELECT directly from the Oracle
>>>> console or some other tool? This will provide another data point.
>>>> Thanks.
>>>> --
>>>> Kevin
>>>>
>>>>
>>>> Wojciech Blad wrote:
>>>>
>>>>> Hi Kevin,
>>>>>
>>>>> Thanks for quick answer.
>>>>>
>>>>> I created tables company and department in oracle and populated
>>>>> with sample data. Before changing demo application I tested on
>>>>> other tables as well. No results returned.
>>>>>
>>>>> Kevin Williams wrote:
>>>>>
>>>>>> Hello Wojtek,
>>>>>>
>>>>>> The RDB DAS Company sample runs against a Derby instance
>>>>>> prepopulated with Companies and related Departments. Have you
>>>>>> prepopulated your Oracle database in a similar manner? You might
>>>>>> try running your select statement directly against your database
>>>>>> to verify that it returns results.
>>>>>>
>>>>>> Thanks.
>>>>>> --
>>>>>> Kevin
>>>>>>
>>>>>>
>>>>>> Wojciech Blad wrote:
>>>>>>
>>>>>>> Hi All,
>>>>>>>
>>>>>>> I am running DAS against oracle database (10.1.0.5 and 9.2).
>>>>>>> Insert statements run fine, rows are being inserted into table
>>>>>>> without any problems.
>>>>>>> When I run simple select statement the list returned is empty.
>>>>>>> I reconfigured DAS demo application to run against oracle
>>>>>>> database instead of derby and select statements (select * from
>>>>>>> company) return no values as well.
>>>>>>> I see session within oracle and select statement has been
>>>>>>> executed, it looks like problem is on DAS/SDO side.
>>>>>>>
>>>>>>> Anyone had similar problem?
>>>>>>>
>>>>>>> Thanks for any hints, beginning is always painful.
>>>>>>> Wojtek
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> ---------------------------------------------------------------------
>>>>>>>
>>>>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>>
>>>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>
>>>
>>>
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>
>>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Kevin Williams <ke...@qwest.net>.
Doh!
Oracle does not provide complete ResultSetMetadata and this is almost
certainly causing the symptoms you are seeing. I would have expected an
exception and I will look into that. Also, we have a workaround
available for JDBC drivers that do not fully implement
ResultSetMetadata. You can explicitly define the result set shape for a
select and we have some simple tests that use this feature here:
/das/src/test/java/org/apache/tuscany/das/rdb/test/ResultSetShapeTests.java
--
Kevin
Kevin Williams wrote:
> Very strange. I know that Brent has done a fair amount of testing
> with Oracle so it is hard to imagine something as simple as this
> failing. I wonder if an exception is being eaten somewhere? If you
> have some time before morning you might run with logging enabled
> (http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/Improved_logging#preview)
> and post the results.
>
> Thanks.
> --
> Kevin
>
>
> Wojciech Blad wrote:
>
>> from sql session:
>> SID 134 - jdbc connection
>>
>> Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.5.0
>>
>> SQL> select sql_text from v$open_cursor where sid = 134;
>>
>> SQL_TEXT
>> ------------------------------------------------------------
>> select * from COMPANY
>>
>>
>> SQL> select * from COMPANY;
>>
>> ID NAME
>> --------------------------------------- --------------------
>> 1 aaa
>> 2 bbb
>> 3 ccc
>>
>>
>> Kevin Williams wrote:
>>
>>> Can you execute the identical SELECT directly from the Oracle
>>> console or some other tool? This will provide another data point.
>>> Thanks.
>>> --
>>> Kevin
>>>
>>>
>>> Wojciech Blad wrote:
>>>
>>>> Hi Kevin,
>>>>
>>>> Thanks for quick answer.
>>>>
>>>> I created tables company and department in oracle and populated
>>>> with sample data. Before changing demo application I tested on
>>>> other tables as well. No results returned.
>>>>
>>>> Kevin Williams wrote:
>>>>
>>>>> Hello Wojtek,
>>>>>
>>>>> The RDB DAS Company sample runs against a Derby instance
>>>>> prepopulated with Companies and related Departments. Have you
>>>>> prepopulated your Oracle database in a similar manner? You might
>>>>> try running your select statement directly against your database
>>>>> to verify that it returns results.
>>>>>
>>>>> Thanks.
>>>>> --
>>>>> Kevin
>>>>>
>>>>>
>>>>> Wojciech Blad wrote:
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> I am running DAS against oracle database (10.1.0.5 and 9.2).
>>>>>> Insert statements run fine, rows are being inserted into table
>>>>>> without any problems.
>>>>>> When I run simple select statement the list returned is empty.
>>>>>> I reconfigured DAS demo application to run against oracle
>>>>>> database instead of derby and select statements (select * from
>>>>>> company) return no values as well.
>>>>>> I see session within oracle and select statement has been
>>>>>> executed, it looks like problem is on DAS/SDO side.
>>>>>>
>>>>>> Anyone had similar problem?
>>>>>>
>>>>>> Thanks for any hints, beginning is always painful.
>>>>>> Wojtek
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>>
>>>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>
>>>
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>
>>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Kevin Williams <ke...@qwest.net>.
Very strange. I know that Brent has done a fair amount of testing with
Oracle so it is hard to imagine something as simple as this failing. I
wonder if an exception is being eaten somewhere? If you have some time
before morning you might run with logging enabled
(http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/Improved_logging#preview)
and post the results.
Thanks.
--
Kevin
Wojciech Blad wrote:
> from sql session:
> SID 134 - jdbc connection
>
> Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.5.0
>
> SQL> select sql_text from v$open_cursor where sid = 134;
>
> SQL_TEXT
> ------------------------------------------------------------
> select * from COMPANY
>
>
> SQL> select * from COMPANY;
>
> ID NAME
> --------------------------------------- --------------------
> 1 aaa
> 2 bbb
> 3 ccc
>
>
> Kevin Williams wrote:
>
>> Can you execute the identical SELECT directly from the Oracle console
>> or some other tool? This will provide another data point.
>> Thanks.
>> --
>> Kevin
>>
>>
>> Wojciech Blad wrote:
>>
>>> Hi Kevin,
>>>
>>> Thanks for quick answer.
>>>
>>> I created tables company and department in oracle and populated with
>>> sample data. Before changing demo application I tested on other
>>> tables as well. No results returned.
>>>
>>> Kevin Williams wrote:
>>>
>>>> Hello Wojtek,
>>>>
>>>> The RDB DAS Company sample runs against a Derby instance
>>>> prepopulated with Companies and related Departments. Have you
>>>> prepopulated your Oracle database in a similar manner? You might
>>>> try running your select statement directly against your database to
>>>> verify that it returns results.
>>>>
>>>> Thanks.
>>>> --
>>>> Kevin
>>>>
>>>>
>>>> Wojciech Blad wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> I am running DAS against oracle database (10.1.0.5 and 9.2).
>>>>> Insert statements run fine, rows are being inserted into table
>>>>> without any problems.
>>>>> When I run simple select statement the list returned is empty.
>>>>> I reconfigured DAS demo application to run against oracle database
>>>>> instead of derby and select statements (select * from company)
>>>>> return no values as well.
>>>>> I see session within oracle and select statement has been
>>>>> executed, it looks like problem is on DAS/SDO side.
>>>>>
>>>>> Anyone had similar problem?
>>>>>
>>>>> Thanks for any hints, beginning is always painful.
>>>>> Wojtek
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>
>>>
>>>
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Wojciech Blad <wo...@imantras.com>.
from sql session:
SID 134 - jdbc connection
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.5.0
SQL> select sql_text from v$open_cursor where sid = 134;
SQL_TEXT
------------------------------------------------------------
select * from COMPANY
SQL> select * from COMPANY;
ID NAME
--------------------------------------- --------------------
1 aaa
2 bbb
3 ccc
Kevin Williams wrote:
> Can you execute the identical SELECT directly from the Oracle console
> or some other tool? This will provide another data point.
> Thanks.
> --
> Kevin
>
>
> Wojciech Blad wrote:
>
>> Hi Kevin,
>>
>> Thanks for quick answer.
>>
>> I created tables company and department in oracle and populated with
>> sample data. Before changing demo application I tested on other
>> tables as well. No results returned.
>>
>> Kevin Williams wrote:
>>
>>> Hello Wojtek,
>>>
>>> The RDB DAS Company sample runs against a Derby instance
>>> prepopulated with Companies and related Departments. Have you
>>> prepopulated your Oracle database in a similar manner? You might
>>> try running your select statement directly against your database to
>>> verify that it returns results.
>>>
>>> Thanks.
>>> --
>>> Kevin
>>>
>>>
>>> Wojciech Blad wrote:
>>>
>>>> Hi All,
>>>>
>>>> I am running DAS against oracle database (10.1.0.5 and 9.2). Insert
>>>> statements run fine, rows are being inserted into table without any
>>>> problems.
>>>> When I run simple select statement the list returned is empty.
>>>> I reconfigured DAS demo application to run against oracle database
>>>> instead of derby and select statements (select * from company)
>>>> return no values as well.
>>>> I see session within oracle and select statement has been executed,
>>>> it looks like problem is on DAS/SDO side.
>>>>
>>>> Anyone had similar problem?
>>>>
>>>> Thanks for any hints, beginning is always painful.
>>>> Wojtek
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>
>>>
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>
>>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Kevin Williams <ke...@qwest.net>.
Can you execute the identical SELECT directly from the Oracle console or
some other tool? This will provide another data point.
Thanks.
--
Kevin
Wojciech Blad wrote:
> Hi Kevin,
>
> Thanks for quick answer.
>
> I created tables company and department in oracle and populated with
> sample data. Before changing demo application I tested on other tables
> as well. No results returned.
>
> Kevin Williams wrote:
>
>> Hello Wojtek,
>>
>> The RDB DAS Company sample runs against a Derby instance prepopulated
>> with Companies and related Departments. Have you prepopulated your
>> Oracle database in a similar manner? You might try running your
>> select statement directly against your database to verify that it
>> returns results.
>>
>> Thanks.
>> --
>> Kevin
>>
>>
>> Wojciech Blad wrote:
>>
>>> Hi All,
>>>
>>> I am running DAS against oracle database (10.1.0.5 and 9.2). Insert
>>> statements run fine, rows are being inserted into table without any
>>> problems.
>>> When I run simple select statement the list returned is empty.
>>> I reconfigured DAS demo application to run against oracle database
>>> instead of derby and select statements (select * from company)
>>> return no values as well.
>>> I see session within oracle and select statement has been executed,
>>> it looks like problem is on DAS/SDO side.
>>>
>>> Anyone had similar problem?
>>>
>>> Thanks for any hints, beginning is always painful.
>>> Wojtek
>>>
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>>
>>>
>>>
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Wojciech Blad <wo...@imantras.com>.
Hi Kevin,
Thanks for quick answer.
I created tables company and department in oracle and populated with
sample data. Before changing demo application I tested on other tables
as well. No results returned.
Kevin Williams wrote:
> Hello Wojtek,
>
> The RDB DAS Company sample runs against a Derby instance prepopulated
> with Companies and related Departments. Have you prepopulated your
> Oracle database in a similar manner? You might try running your
> select statement directly against your database to verify that it
> returns results.
>
> Thanks.
> --
> Kevin
>
>
> Wojciech Blad wrote:
>
>> Hi All,
>>
>> I am running DAS against oracle database (10.1.0.5 and 9.2). Insert
>> statements run fine, rows are being inserted into table without any
>> problems.
>> When I run simple select statement the list returned is empty.
>> I reconfigured DAS demo application to run against oracle database
>> instead of derby and select statements (select * from company) return
>> no values as well.
>> I see session within oracle and select statement has been executed,
>> it looks like problem is on DAS/SDO side.
>>
>> Anyone had similar problem?
>>
>> Thanks for any hints, beginning is always painful.
>> Wojtek
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
>> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>>
>>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org
Re: empty select from oracle database
Posted by Kevin Williams <ke...@qwest.net>.
Hello Wojtek,
The RDB DAS Company sample runs against a Derby instance prepopulated
with Companies and related Departments. Have you prepopulated your
Oracle database in a similar manner? You might try running your select
statement directly against your database to verify that it returns results.
Thanks.
--
Kevin
Wojciech Blad wrote:
> Hi All,
>
> I am running DAS against oracle database (10.1.0.5 and 9.2). Insert
> statements run fine, rows are being inserted into table without any
> problems.
> When I run simple select statement the list returned is empty.
> I reconfigured DAS demo application to run against oracle database
> instead of derby and select statements (select * from company) return
> no values as well.
> I see session within oracle and select statement has been executed, it
> looks like problem is on DAS/SDO side.
>
> Anyone had similar problem?
>
> Thanks for any hints, beginning is always painful.
> Wojtek
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-user-help@ws.apache.org