cancel
Showing results for 
Search instead for 
Did you mean: 

Error inserting data from JDBC

busymo16
Ninja
Ninja

Hello everyone,

I am trying to load data from oracle while using jdbc connector to neo4j with the following statement:

CALL apoc.periodic.iterate(
"cypher runtime=slotted
CALL apoc.load.jdbc('jdbc:oracle:thin:@connection_url', 'Select * from database.table', , {credentials:{user: '', password: ''}}) YIELD row",
"
CREATE (b:Profile
{
pk: row.PROFILE_PK,
name: row.NAME
}
)",
{batchSize: 10000, parallel:true}
)

Note that my connection string is working very good but I cannot share it here. After executing the following query I get the following error:

I do have a column in my oracle db that is of type CLOB but this column is not needed to be imported here. Anybody an idea of a possible workaround here? Thanks in advance!

1 ACCEPTED SOLUTION

glilienfield
Ninja
Ninja

Instead of your select statement as 'select *', try returning just the columns you want, which would excluded the CLOB.

View solution in original post

1 REPLY 1

glilienfield
Ninja
Ninja

Instead of your select statement as 'select *', try returning just the columns you want, which would excluded the CLOB.

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.