{"action":"opened","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb-docs/issues/172","repository_url":"https://api.github.com/repos/orientechnologies/orientdb-docs","labels_url":"https://api.github.com/repos/orientechnologies/orientdb-docs/issues/172/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb-docs/issues/172/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb-docs/issues/172/events","html_url":"https://github.com/orientechnologies/orientdb-docs/issues/172","id":163667214,"number":172,"title":"Cannot use teleporter for DB2","user":{"login":"ayashaswini2","id":20224803,"avatar_url":"https://avatars.githubusercontent.com/u/20224803?v=3","gravatar_id":"","url":"https://api.github.com/users/ayashaswini2","html_url":"https://github.com/ayashaswini2","followers_url":"https://api.github.com/users/ayashaswini2/followers","following_url":"https://api.github.com/users/ayashaswini2/following{/other_user}","gists_url":"https://api.github.com/users/ayashaswini2/gists{/gist_id}","starred_url":"https://api.github.com/users/ayashaswini2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ayashaswini2/subscriptions","organizations_url":"https://api.github.com/users/ayashaswini2/orgs","repos_url":"https://api.github.com/users/ayashaswini2/repos","events_url":"https://api.github.com/users/ayashaswini2/events{/privacy}","received_events_url":"https://api.github.com/users/ayashaswini2/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-04T12:30:47Z","updated_at":"2016-07-04T12:30:47Z","closed_at":null,"body":"We are using DB2 as our primary database. We want to use teleporter for data syncronisation, data viewing etc.\r\n\r\nI had checked jdbc-drivers.json in config directory in orientdb. There is no such configuration for DB2.\r\n\r\nIn jdbc-drivers.jso for all the other databases there is direct url reference to driver jar files from some sites.\r\nBut for DB2 there is no such direct links. \r\n\r\nSo, I added the following script to the bottom of jdbc-drivers.json and added the db2 driver in lib folder in orientdb.\r\n\r\n```\r\n\"DB2\": {\r\n\t\"className\": \"com.ibm.db2.jcc.DB2Driver\",\r\n\t\"url\":\"/home/yashaswini/orientDB/orientdb-enterprise-2.2.3/lib/db2jcc.jar\",\r\n\t\"version\":\"4.1.0\",\r\n\t\"format\":[\r\n\t     \"jdbc:db2://<HOST>:<PORT>/<DB>\"\r\n\t]\r\n\r\n    }\r\n```\r\n\r\nThough 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.\r\n\r\nIs there any way I can get DB2 working in teleporter?\r\nI would be grateful if anyone can help me in this regard.\r\n\r\nBelow is the whole script of jdbc-drivers.json after I edited.\r\n\r\n```\r\n{\r\n    \"Oracle\": {\r\n        \"className\": \"oracle.jdbc.driver.OracleDriver\",\r\n        \"url\": \"http://svn.ets.berkeley.edu/nexus/content/repositories/myberkeley/com/oracle/ojdbc7/12.1.0.1/ojdbc7-12.1.0.1.jar\",\r\n        \"version\": \"7-12.1.0.1\",\r\n        \"format\": [\r\n            \"jdbc:oracle:thin:@<HOST>:<PORT>:<SID>\"\r\n        ]\r\n    }, \r\n    \"SQLServer\": {\r\n        \"className\": \"com.microsoft.sqlserver.jdbc.SQLServerDriver\",\r\n        \"url\": \"http://www.java2s.com/Code/JarDownload/sqljdbc4/sqljdbc4-2.0.jar.zip\",\r\n        \"version\": \"4.2.0\",\r\n        \"format\": [\r\n\t    \"jdbc:sqlserver://<HOST>:<PORT>;databaseName=<DB>\"\r\n        ]\r\n    },\r\n    \"MySQL\": {\r\n        \"className\": \"com.mysql.jdbc.Driver\",\r\n        \"url\": \"http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.36/mysql-connector-java-5.1.36.jar\",\r\n        \"version\": \"5.1.36\",\r\n        \"format\": [\r\n            \"jdbc:mysql://<HOST>:<PORT>/<DB>\"\r\n        ]\r\n    },\r\n    \"PostgreSQL\": {\r\n        \"className\": \"org.postgresql.Driver\",\r\n        \"url\": \"https://jdbc.postgresql.org/download/postgresql-9.4-1201.jdbc4.jar\",\r\n        \"version\": \"9.4-1201\",\r\n        \"format\": [\r\n            \"jdbc:postgresql://<HOST>:<PORT>/<DB>\"\r\n        ]\r\n    },\r\n    \"HyperSQL\": {\r\n        \"className\": \"org.hsqldb.jdbc.JDBCDriver\",\r\n        \"url\": \"http://central.maven.org/maven2/org/hsqldb/hsqldb/2.3.3/hsqldb-2.3.3.jar\",\r\n        \"version\": \"2.3.3\",\r\n        \"format\": [\r\n            \"jdbc:hsqldb:hsql://<HOST>:<PORT>\",\r\n            \"jdbc:hsqldb:file:<filepath>\"\r\n        ]\r\n    },\r\n    \"DB2\": {\r\n\t\"className\": \"com.ibm.db2.jcc.DB2Driver\",\r\n\t\"url\":\"/home/yashaswini/orientDB/orientdb-enterprise-2.2.3/lib/db2jcc.jar\",\r\n\t\"version\":\"4.1.0\",\r\n\t\"format\":[\r\n\t     \"jdbc:db2://<HOST>:<PORT>/<DB>\"\r\n\t]\r\n\r\n    }\r\n}\r\n\r\n```\r\n\r\n"}}
{"actor":{"display_login":"ayashaswini2"}}