I tried, but that char sequence doesn't appear in the file itself, only in the error ouput for oetl.bat on Windows. The Linux error message excludes that string of characters but is otherwise identical.
On Monday, April 13, 2015 at 5:13:58 PM UTC-5, l.garulli wrote: > > I see this weird char sequence at the beginning of the content: . Try > to remove them and retry. > > Lvc@ > > > On 13 April 2015 at 23:34, William Marshall <[email protected] > <javascript:>> wrote: > >> For the past few days I've been trying to get the orientdb-etl process to >> import data from either JDBC or CSV, but I can't get it to parse my >> configuration files. I've tried on both Windows and Linux, but I end up >> with the same "Error on unmarshalling JSON content" every time. According >> to JSON Lint my JSON is valid. None of the values are NULL, empty strings, >> or contain backslashes. >> >> *Configuration File (company.json) contents* >> { >> "config": { "log": "debug" }, >> "extractor": { >> "jdbc": { >> "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", >> "url": "jdbc:sqlserver://serverIP:Port;databaseName=DBName;", >> "userName": "**********", >> "userPassword": "**********", >> "query": "SELECT [COMPANY_ID],[COMPANY_NAME],[TRUE_LAST_DATE] >> FROM [Testing].[Company]" >> } >> }, >> "transformers": [ >> { "vertex": { "class": "Company", "skipDuplicates": true } } >> ], >> "loader": { >> "orientdb": { >> "dbURL": "plocal:/databases/iirDev", >> "dbType": "graph", >> "dbAutoCreate": true, >> "standardElementConstraints": false, >> "classes": [ { "name": "Company", "extends": "V" } ] >> } >> } >> } >> >> >> *Resulting Error Messages* >> *Windows* >> G:\orientdb\bin>oetl.bat company.json >> OrientDB etl v.2.0.6 (build @BUILD@) www.orientechnologies.com >> Exception in thread "main" >> com.orientechnologies.orient.core.exception.OSerializationException: Error >> on unmarshalling JSON content '{ >> "config": { "log": "debug" }, >> "extractor": { >> "jdbc": { >> "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", >> "url": "jdbc:sqlserver://serverIP:Port;databaseName=DBName;", >> "userName": "**********", >> "userPassword": "**********", >> "query": "SELECT [COMPANY_ID],[COMPANY_NAME],[TRUE_LAST_DATE] >> FROM [Testing].[Company]" >> } >> }, >> "transformers": [ >> { "vertex": { "class": "Company", "skipDuplicates": true } } >> ], >> "loader": { >> "orientdb": { >> "dbURL": "plocal:/databases/iirDev", >> "dbType": "graph", >> "dbAutoCreate": true, >> "standardElementConstraints": false, >> "classes": [ { "name": "Company", "extends": "V" } ] >> } >> } >> }': content must be between { } >> at >> com.orientechnologies.orient.core.serialization.serializer.record.string.ORecordSerializerJSON.unwrapSource(ORecordSerializerJSON.java:399) >> at >> com.orientechnologies.orient.core.serialization.serializer.record.string.ORecordSerializerJSON.fromString(ORecordSerializerJSON.java:173) >> at >> com.orientechnologies.orient.core.record.ORecordAbstract.fromJSON(ORecordAbstract.java:165) >> at >> com.orientechnologies.orient.core.record.impl.ODocument.fromJSON(ODocument.java:1649) >> at >> com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:145) >> G:\orientdb\bin> >> *Linux* >> orientdb@linux:/usr/bin/orientdb/bin> sh oetl.sh company.json >> OrientDB etl v.2.0.6 (build @BUILD@) www.orientechnologies.com >> >> 2015-04-13 21:19:11:187 WARNING Not enough physical memory available for >> DISKCACHE: 1,999MB (heap=494MB). Set lower Maximum Heap (-Xmx setting on >> JVM) and restart OrientDB. Now running with DISKCACHE=256MB >> [orientechnologies]Exception in thread "main" >> com.orientechnologies.orient.core.exception.OSerializationException: Error >> on unmarshalling JSON content '{ >> "config": { "log": "debug" }, >> "extractor": { >> "jdbc": { >> "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", >> "url": "jdbc:sqlserver://serverIP:Port;databaseName=DBName;", >> "userName": "**********", >> "userPassword": "**********", >> "query": "SELECT [COMPANY_ID],[COMPANY_NAME],[TRUE_LAST_DATE] >> FROM [Testing].[Company]" >> } >> }, >> "transformers": [ >> { "vertex": { "class": "Company", "skipDuplicates": true } } >> ], >> "loader": { >> "orientdb": { >> "dbURL": "plocal:/databases/iirDev", >> "dbType": "graph", >> "dbAutoCreate": true, >> "standardElementConstraints": false, >> "classes": [ { "name": "Company", "extends": "V" } ] >> } >> } >> }': content must be between { } >> at >> com.orientechnologies.orient.core.serialization.serializer.record.string.ORecordSerializerJSON.unwrapSource(ORecordSerializerJSON.java:399) >> at >> com.orientechnologies.orient.core.serialization.serializer.record.string.ORecordSerializerJSON.fromString(ORecordSerializerJSON.java:173) >> at >> com.orientechnologies.orient.core.record.ORecordAbstract.fromJSON(ORecordAbstract.java:165) >> at >> com.orientechnologies.orient.core.record.impl.ODocument.fromJSON(ODocument.java:1649) >> at >> com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:145) >> >> Does anyone have any ideas on what is going on here? >> >> -- >> >> --- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Best Regards, > > Luca Garulli > CEO at Orient Technologies LTD > the Company behind OrientDB > http://about.me/luca.garulli > > -- --- 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.
