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: [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]
---------------------------------------------------------------------
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]
