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 <[EMAIL PROTECTED]> 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]
