Hi, just wanted to say I got it working. Was just something wrong with the
MySQL db.
D:\Eclipse LaTeX\DB - orientdb\bin>oetl.bat backup\config-test.json
OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
+ extracted 277 records (0 records/sec) - 277 records -> loaded 276
vertices (0
vertices/sec) Total time: 1004ms [0 warnings, 0 errors]
+ extracted 958 records (670 records/sec) - 958 records -> loaded 957
vertices (
670 vertices/sec) Total time: 2020ms [0 warnings, 0 errors]
+ extracted 1.875 records (897 records/sec) - 1.875 records -> loaded 1.874
vert
ices (897 vertices/sec) Total time: 3042ms [0 warnings, 0 errors]
+ extracted 3.012 records (1.137 records/sec) - 3.012 records -> loaded
3.011 ve
rtices (1.137 vertices/sec) Total time: 4042ms [0 warnings, 0 errors]
+ extracted 4.847 records (1.820 records/sec) - 4.847 records -> loaded
4.846 ve
rtices (1.820 vertices/sec) Total time: 5050ms [0 warnings, 0 errors]
+ extracted 6.120 records (1.264 records/sec) - 6.120 records -> loaded
6.119 ve
rtices (1.264 vertices/sec) Total time: 6057ms [0 warnings, 0 errors]
+ extracted 9.257 records (3.137 records/sec) - 9.257 records -> loaded
9.256 ve
rtices (3.137 vertices/sec) Total time: 7057ms [0 warnings, 0 errors]
+ extracted 10.118 records (779 records/sec) - 10.118 records -> loaded
10.117 v
ertices (779 vertices/sec) Total time: 8161ms [0 warnings, 0 errors]
+ extracted 14.813 records (4.695 records/sec) - 14.813 records -> loaded
14.812
vertices (4.695 vertices/sec) Total time: 9161ms [0 warnings, 0 errors]
+ extracted 22.490 records (7.646 records/sec) - 22.490 records -> loaded
22.489
vertices (7.646 vertices/sec) Total time: 10165ms [0 warnings, 0 errors]
+ extracted 31.388 records (8.792 records/sec) - 31.388 records -> loaded
31.387
vertices (8.792 vertices/sec) Total time: 11177ms [0 warnings, 0 errors]
+ extracted 39.891 records (8.435 records/sec) - 39.891 records -> loaded
39.890
vertices (8.435 vertices/sec) Total time: 12185ms [0 warnings, 0 errors]
+ extracted 47.016 records (7.125 records/sec) - 47.016 records -> loaded
47.015
vertices (7.125 vertices/sec) Total time: 13185ms [0 warnings, 0 errors]
+ extracted 54.705 records (7.620 records/sec) - 54.705 records -> loaded
54.704
vertices (7.620 vertices/sec) Total time: 14194ms [0 warnings, 0 errors]
END ETL PROCESSOR
+ extracted 55.619 records (9.326 records/sec) - 55.619 records -> loaded
55.618
vertices (9.326 vertices/sec) Total time: 14292ms [0 warnings, 0 errors]
That's pretty cool. But when I check the database e.g. in the Studio and
wanna do some ETL stuff again, I get:
Caused by: com.orientechnologies.orient.core.exception.OStorageException:
Cannot
open local storage 'D:/Eclipse LaTeX/DB - orientdb/databases/Test' with
mode=rw
I can understand this security solution but it's contra productive to me.
How could I disable that? Basically I wanna do ETL, check in the studio,
some ETL... and so on. That way I'm doing it I always have to restart the
server after checking in the Studio.
Am Freitag, 15. August 2014 22:23:38 UTC+2 schrieb Curtis Mosters:
>
> I wanted to use the ETL to import some MySQL data.
>
> So this is the json:
>
> {
> "config": {
> "verbose": true
> },
> "extractor" : {
> "jdbc": { "driver": "com.mysql.jdbc.Driver",
> "url": "jdbc:mysql://localhost/test",
> "userName": "root",
> "userPassword": "",
> "query": "select * from person" }
> },
> "transformers" : [
> { "vertex": { "class": "Person"} }
> ],
> "loader" : {
> "orientdb": {
> "dbURL": "plocal:D:\Eclipse LaTeX\DB - orientdb\databases\Test",
> "dbAutoCreate": true
> }
> }
> }
>
> And it works:
>
> D:\Eclipse LaTeX\DB - orientdb\bin>oetl.bat backup\config-test.json
> OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
> BEGIN ETL PROCESSOR
> END ETL PROCESSOR
> + extracted 1 records (0 records/sec) - 1 records -> loaded 0 documents (0
> docum
> ents/sec) Total time: 34ms [0 warnings, 0 errors]
>
> But when I look now in the folder for some Peron files, there are none of
> them. Also looked in the Studio, nothing.
>
> I also mentioned that I now cannot remove the "Test" folder which was
> created by ETL. Just can be deleted when the server was shutdown.
>
> I really have no idea what's going on.
>
> Btw the MySQL db is "test" with just the table "person" and one entry.
> Please give me some tips guys =)
>
>
>
--
---
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.
