orientechnologies / orientechnologies/orientdb-docs

Cannot use teleporter for DB2

Open
#172 1 comment 0 reactions 1 assignee View on GitHub

@G4br13l3 is already working on this.

Since Jul 4, 2016.

wrong repository
Dominant language
CSS
Stars
59
Forks
165
PR merge metrics
No merged PRs in 30d

Description

We are using DB2 as our primary database. We want to use teleporter for data syncronisation, data viewing etc.

I had checked jdbc-drivers.json in config directory in orientdb. There is no such configuration for DB2.

In jdbc-drivers.jso for all the other databases there is direct url reference to driver jar files from some sites.
But for DB2 there is no such direct links.

So, I added the following script to the bottom of jdbc-drivers.json and added the db2 driver in lib folder in orientdb.

"DB2": {
    "className": "com.ibm.db2.jcc.DB2Driver",
    "url":"/home/yashaswini/orientDB/orientdb-enterprise-2.2.3/lib/db2jcc.jar",
    "version":"4.1.0",
    "format":[
         "jdbc:db2://<HOST>:<PORT>/<DB>"
    ]

    }

Though I have mentioned DB2 as additional database in jdbc-drivers.json, it doesn't show up in drop down of database list in teleporter page in OrientDB studio.

Is there any way I can get DB2 working in teleporter?
I would be grateful if anyone can help me in this regard.

Below is the whole script of jdbc-drivers.json after I edited.

{
    "Oracle": {
        "className": "oracle.jdbc.driver.OracleDriver",
        "url": "http://svn.ets.berkeley.edu/nexus/content/repositories/myberkeley/com/oracle/ojdbc7/12.1.0.1/ojdbc7-12.1.0.1.jar",
        "version": "7-12.1.0.1",
        "format": [
            "jdbc:oracle:thin:@<HOST>:<PORT>:<SID>"
        ]
    }, 
    "SQLServer": {
        "className": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
        "url": "http://www.java2s.com/Code/JarDownload/sqljdbc4/sqljdbc4-2.0.jar.zip",
        "version": "4.2.0",
        "format": [
        "jdbc:sqlserver://<HOST>:<PORT>;databaseName=<DB>"
        ]
    },
    "MySQL": {
        "className": "com.mysql.jdbc.Driver",
        "url": "http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.36/mysql-connector-java-5.1.36.jar",
        "version": "5.1.36",
        "format": [
            "jdbc:mysql://<HOST>:<PORT>/<DB>"
        ]
    },
    "PostgreSQL": {
        "className": "org.postgresql.Driver",
        "url": "https://jdbc.postgresql.org/download/postgresql-9.4-1201.jdbc4.jar",
        "version": "9.4-1201",
        "format": [
            "jdbc:postgresql://<HOST>:<PORT>/<DB>"
        ]
    },
    "HyperSQL": {
        "className": "org.hsqldb.jdbc.JDBCDriver",
        "url": "http://central.maven.org/maven2/org/hsqldb/hsqldb/2.3.3/hsqldb-2.3.3.jar",
        "version": "2.3.3",
        "format": [
            "jdbc:hsqldb:hsql://<HOST>:<PORT>",
            "jdbc:hsqldb:file:<filepath>"
        ]
    },
    "DB2": {
    "className": "com.ibm.db2.jcc.DB2Driver",
    "url":"/home/yashaswini/orientDB/orientdb-enterprise-2.2.3/lib/db2jcc.jar",
    "version":"4.1.0",
    "format":[
         "jdbc:db2://<HOST>:<PORT>/<DB>"
    ]

    }
}

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.