JDBC Store Node to Access Database

Follow

Nancy Valenti

• September 20, 2018 15:32

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?

 

 

 

 

 

0

• 

  Adrian Williams

  • September 21, 2018 16:17

  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:

   

  

   

  0

  Comment actions Permalink
• 

  Nancy Valenti

  • September 21, 2018 16:23

  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.

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.