I have a data store called IPMDS2 using the jdbc/IPMDS2DataSource entry in the c

kevind605 over 11 years ago

I have a data store called IPMDS2 using the jdbc/IPMDS2DataSource entry in the config for an Oracle database. In that data source is an entity called lab_orders which was created automatically from a complex data type called Lab_Orders. I can write to this table using the write to data store entity smart servcie. I can retrieve data from the table using a query rule. But when I try to use the query database smart service and enter a query to retrieve the data, I get: The database returned ARV's that may not be supported. Message: Table \\'ipmds2.lab_orders\\' doesn\\'t exist. Any ideas why? Thanks.
...

Discussion posts and replies are publicly visible

Parents

0 kevind605 over 11 years ago

Nope. I tried the simplest of queries...select orderID from lab_orders. orderID is one of the fields in the table, and the query rule retrieves it no problem. I made sure I picked the correct data store from the drop-down on the setup tab of the query database smart service. And I used the rule in the same process model as the query smart service, just to eliminate that question.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kevind605 over 11 years ago

Nope. I tried the simplest of queries...select orderID from lab_orders. orderID is one of the fields in the table, and the query rule retrieves it no problem. I made sure I picked the correct data store from the drop-down on the setup tab of the query database smart service. And I used the rule in the same process model as the query smart service, just to eliminate that question.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data