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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
