I am able to get it worked JDBC connectivity from oracle to orientdb.
First thing is to load JDBC driver from ORACLE_HOME/jdbc/lib/ojdbc6.jar
(/db/app/oracle/product/11.2.0.4/db_home2/jdbc/lib) to ORIENT_HOME/lib.
Create database and your class extending to super class V assign the
properties.
Jason config file should look like
{
"config": {
"log": "debug"
},
"extractor" : {
"jdbc": { "driver": "oracle.jdbc.driver.OracleDriver",
"url": "jdbc:oracle:thin:@hostname:1534/dbname",
"userName": "oracle",
"userPassword": "oracle",
"query": "select * from VODAFONE_COUNTRY_TMP" }
},
"transformers" : [
{ "vertex": { "class":"VODAFONE_COUNTRY_TMP"} }
],
"loader" : {
"orientdb": {
"dbURL":
"plocal:/nosql/orientdb/orientdb-enterprise-2.1-rc1/databases/orientdbcrm",
"dbUser": "admin",
"dbPassword": "admin",
"dbAutoCreate": False,
"tx": false,
"batchCommit": 10,
dbType:"graph"
}
}
}
execute ./oetl.sh test.json
inserted 250 records. Going to Test Big table now.
On Sunday, June 14, 2015 at 1:34:45 PM UTC-4, scott molinari wrote:
> This might interest you too. I just ran into it.
>
>
> https://github.com/orientechnologies/orientdb/issues/4269#issuecomment-111716003
>
> Scott
>
--
---
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.
