Skip to main content
Question

InLineQuerier - Database Not Specified

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

2 replies

ebygomm
Influencer
Forum|alt.badge.img+33
  • ebygommInfluencer
  • Influencer
  • 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+7
  • sipsysighContributor
  • Contributor
  • 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

Reply


Helpful Members This Week

Community Stats

31,191
Posts
118,244
Replies
38,801
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.