JDBC Store Node to Access Database
Hello, I am trying to utilize the JDBC store node to add records to a table in an access database.
I have the connection set up, that works but I am not able to run the node and insert the records into the table.
It gives the following error:
Error occurred evaluating property 'SchemaName' on node 'JDBC Store'. Property 'SchemaName' referenced property 'DBOr' . No value was able to be evaluated for property 'DBOr'. Error seen in property 'SchemaName' at line 0, column 8.
Is there a specific process for inserting records into an Access Database using JDBC store?
-
I can get the same error if I have a property reference in the node's SchemaName property that is referencing a non-existent property, e.g.
The error is also produced if the referenced property exists (e.g. as a data flow property) but the value of the property is not specified. Are either of these two configurations used?
The default value for the SchemaName property is {{^DbUser^}} if required the default value can be set using the Restore Default Value option from the property's context menu:
-
I tried setting it to blank and restoring the Default Value, it doesn't seem to be functioning the way I would think. I will try it again. I don't have any SCHEMA information. At one point I did get some data loaded but I also got a lot of cells in my database with ERROR messages in them.
Please sign in to leave a comment.
Comments
2 comments