Skip to main content
Question

InLineQuerier - Database Not Specified

  • April 4, 2019
  • 2 replies
  • 19 views
R
Forum|alt.badge.img+1

Hello,

I have previously used InLIneQuerier to join FileGDB connections without issue, but am having trouble when using with Oracle connections.

When running the query within the transformer in order to test i keep getting the 'Database Not Specified' message as per screenshot.

In the example below all i have done is attached just one connected Oracle table to the transformer, and then used the Generate button just to test if this can do the most simple of queries and I am still getting this error message.

Any thoughts on where I could have gone wrong?

Thanks,

Robin

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3429 replies
  • April 4, 2019

In my experience the run button doesn't work in the inlinequerier. It doesn't mean that the query doesn't work, you have to test by running the workspace.

sipsysigh
Contributor
Forum|alt.badge.img+12
  • sipsysighContributor
  • Contributor
  • 37 replies
  • April 4, 2019

Hi,

Although this doesn't specifically answer your question, the following, lifted from the InlineQuerier help under the Usage Notes section, maybe useful given your Oracle example above:

  • If all the data to be queried already resides in a SQL-capable data source, consider using the SQLExecutor or SQLCreator instead, as queries will be more efficient when performed by the source database.
  • If the query is a simple join between features and a database source, and the key(s) are indexed in the database, consider using a DatabaseJoiner for more efficient processing.

Thanks,

Simon

Community Stats

32,081
Posts
121,824
Replies
39,716
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.