Hi Curtis,
I don't know why you change from Person to Author, maybe this is the
problem?
However, use last release 0.9.2-SNAPSHOT. About the loader you can setup
more params. For example it's important for performance reason that you set
an index against Person.id. I've added also a log before and after
transformation. Try running the following:
{
"config": {
"verbose": true
},
"extractor" : {
"jdbc": { "driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://localhost/test",
"userName": "root",
"userPassword": "",
"query": "select * from Author" }
},
"transformers" : [
{ log : { prefix: "BEFORE->" } },
{ "vertex": { "class": "Author"} },
{ log : { prefix: "AFTER->" } }
],
"loader" : {
"orientdb": {
dbURL: "plocal:D:\Eclipse LaTeX\DB - orientdb\databases\Test6",
dbUser: "admin",
dbPassword: "admin",
dbAutoDropIfExists: false,
dbAutoCreate: true,
tx: false,
wal: false,
batchCommit: 1000,
dbType: "graph",
indexes: [{class:"Person", fields:["id:string"],
type:"UNIQUE_HASH_INDEX" }]
}
}
}
Lvc@
ᐧ
On 25 August 2014 22:45, 'Curtis Mosters' via OrientDB <
[email protected]> wrote:
> Alright I just want to give an update. So I have the Author ETL:
>
> {
> "config": {
> "verbose": true
> },
> "extractor" : {
> "jdbc": { "driver": "com.mysql.jdbc.Driver",
> "url": "jdbc:mysql://localhost/test",
> "userName": "root",
> "userPassword": "",
>
> "query": "select * from Author" }
> },
> "transformers" : [
> { "vertex": { "class": "Author"} }
> ],
> "loader" : {
> "orientdb": {
> "dbURL": "plocal:D:\Eclipse LaTeX\DB - orientdb\databases\Test6",
> "dbAutoCreate": true
> }
> }
> }
>
> The database does not exist. Maybe that's the reason why it's not working
> for me. I always runned my example with an existing database. I dunno. But
> here is the error I get when running that JSON:
>
> D:\Eclipse LaTeX\DB - orientdb\bin>oetl.bat backup\luca\Author.json
> OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
> BEGIN ETL PROCESSOR
> ETL process halted: com.orientechnologies.orient.etl.
> OETLProcessHaltedException:
> java.lang.NullPointerException
>
> And just when I add:
>
> "dbType": "graph"
>
> to the "loader" I get it running. Is that right, but why is that working
> for you Lucan and not for me? =/
>
>
>
> --
>
> ---
> 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.
