Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  JDBC Store Node to Access Database

    Employee
    Posted 09-20-2018 08:33

    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?

     

     

     

     

     



  • 2.  RE: JDBC Store Node to Access Database

    Employee
    Posted 09-21-2018 09:18

    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:

     

     



  • 3.  RE: JDBC Store Node to Access Database

    Employee
    Posted 09-21-2018 09: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.