Hi Curtis,
"plocal" has exclusive access. If you want to work with the database from
ETL and other clients (like your app or Studio), you should start a
OrientDB server, create a new database on it, and change the URL to use the
"remote" protocol:
"dbURL": "remote:Test",
Lvc@
On 18 August 2014 09:10, 'Curtis Mosters' via OrientDB <
[email protected]> wrote:
> 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.
>
--
---
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.
