Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

apoc.load.jdbcUpdate doesn't work in apoc.periodic.repeat procedure #4136

Open
dewbj opened this issue Jul 5, 2024 · 0 comments
Open

apoc.load.jdbcUpdate doesn't work in apoc.periodic.repeat procedure #4136

dewbj opened this issue Jul 5, 2024 · 0 comments

Comments

@dewbj
Copy link

dewbj commented Jul 5, 2024

Expected Behavior (Mandatory)

A new row of data should be inserted into the target table, similar to the behavior without using apoc.periodic.repeat.

Actual Behavior (Mandatory)

Despite successfully testing the statement with apoc.cypher.doIt, applying apoc.periodic.repeat still results in failure and displays the following error message:

螢幕擷取畫面 2024-07-05 104110

How to Reproduce the Problem

Simple Dataset (where it's possibile)

//Insert here a set of Cypher statements that helps us to reproduce the problem

call apoc.periodic.repeat(
    '000. test',
    '
		with 
			"jdbc:mysql://[example_url]/data_mart" as jdbc,
			"insert ignore into merchandise_id (id, source) values (\'1\', \'Example Data\');" as sql
        call apoc.load.jdbcUpdate(
			jdbc,
			sql, 
			[],
			{credentials: {user: "user", password: "password"}}
		)
    ',
    60*60
)

Steps (Mandatory)

  1. Install the apoc procedure and the mysql-jdbc driver, then restart the Neo4j database.
  2. Create a MySQL database and a table named merchandise_id with two columns: id (varchar) and source (varchar).
  3. Insert example data using the previously written Cypher statement.

Screenshots (where it's possibile)

Specifications (Mandatory)

Currently used versions

Versions

  • OS: Ubuntu 22.04.3 LTS (GNU/Linux 6.2.0-1017-aws x86_64)
  • Neo4j: neo4j 4.4.26
  • Neo4j-Apoc: 4.4.0.28
  • MySQL-JDBC-Driver: mysql-connector-j-8.4.0.jar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Development

No branches or pull requests

3 participants