Hi Giulio, Blueprints doesn't allow NULL value. You can still do that with OrientDB, but you should set this:
alter database custom standardElementConstraints=false Lvc@ On 26 January 2015 at 12:26, Giulio Grosso <[email protected]> wrote: > Hi Luca, > this is the entire exception: > > Error in Pipeline execution: java.lang.IllegalArgumentException: Property > value can not be null > java.lang.IllegalArgumentException: Property value can not be null > at > com.tinkerpop.blueprints.util.ExceptionFactory.propertyValueCanNotBeNull(ExceptionFactory.java:60) > at > com.tinkerpop.blueprints.impls.orient.OrientElement.validateProperty(OrientElement.java:536) > at > com.tinkerpop.blueprints.impls.orient.OrientElement.setProperty(OrientElement.java:179) > at > com.orientechnologies.orient.etl.transformer.OEdgeTransformer.executeTransform(OEdgeTransformer.java:114) > at > com.orientechnologies.orient.etl.transformer.OAbstractTransformer.transform(OAbstractTransformer.java:37) > at > com.orientechnologies.orient.etl.OETLPipeline.execute(OETLPipeline.java:108) > at > com.orientechnologies.orient.etl.OETLProcessor.executeSequentially(OETLProcessor.java:483) > at > com.orientechnologies.orient.etl.OETLProcessor.execute(OETLProcessor.java:291) > at > com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:163) > > Giulio > > Il giorno venerdì 23 gennaio 2015 19:42:27 UTC+1, Lvc@ ha scritto: >> >> Hi Giulio, >> Please could you post the entire exception? >> >> Lvc@ >> >> >> On 23 January 2015 at 12:52, Giulio Grosso <[email protected]> wrote: >> >>> Hi all, >>> what's wrong with my ETL script? I get the exception "Property value >>> cannot be null". >>> >>> -- ETL SCRIPT START -- >>> >>> { >>> "config": { >>> "verbose": true >>> }, >>> "extractor" : { >>> "jdbc": { "driver": "oracle.jdbc.driver.OracleDriver", >>> "url": "jdbc:oracle:thin:@//<ip_address>:<port>/<sid>", >>> "userName": <user>, >>> "userPassword": <pwd>, >>> "query": "select * from account" } >>> }, >>> "transformers" : [ >>> { "vertex": { "class": "Account"} }, >>> { "edge": { "class": "has_account", "direction" : "in", >>> "joinFieldName": "user_id", >>> "lookup":"User.id", "unresolvedLinkAction":"CREATE"} } >>> ], >>> "loader" : { >>> "orientdb": { >>> "dbURL": "plocal:d:/database/nosql/orientdb-community-2.0/ >>> databases/<db_name>", >>> "dbUser": <o_user>, >>> "dbPassword": <o_pwd>, >>> "dbAutoCreate": true, >>> "dbType": "graph", >>> "tx": true, >>> "batchCommit": 10000 >>> } >>> } >>> } >>> >>> -- ETL SCRIPT END -- >>> >>> Thanks a lot in advance! >>> >>> Ciao, >>> >>> Giulio >>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "OrientDB" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
