Error inserting data from JDBC

Neo4j Graph Platform Import / Export
, ,
1

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:

Screenshot 2022-02-16 at 14.39.26
Screenshot 2022-02-16 at 14.39.262674×128 21.2 KB

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!

2

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