Forum Discussion

feenst's avatar
feenst
New Contributor III
9 years ago

Error when reading from SQLMX database via JDBC connector

I am working on a pipeline to pull data from a SQL Server database and insert into a SQLMX database. I got this pipeline working, but it fails after the first run as it’s trying to insert records t...
feenst's avatar
feenst
New Contributor III
9 years ago

Yes, it seems to only happen during save.

Not sure why the SQLMX fails though when the SQL Server (via JDBC as well) succeeds as I can’t use a LIMIT clause when querying the SQL Server database directly …

  • akidave's avatar
    akidave
    Employee
    9 years ago

    The specific database snaps know which features are supported for each database. The generic database snaps try to detect the features supported based on the database JDBC metadata, but that is not reliable in some cases. Using Execute would be a workaround, or SELECT snaps can be used just for execution.