Connect To oracle database

[mondaldebanjan]

How to connect to oracle db?
What will be the url how to change the library?

[yogthos]

You just have to give it an Oracle JDBC URL, e.g:

(conman/connect! {:jdbc-url "jdbc:oracle:thin:@myhost:1521:orcl"})

[mondaldebanjan]

i have made the template according to +mysql
and changed the jdbc url
but when i run migrate
No suitable driver found for jdbc:oracle:thin.... it shows

[mondaldebanjan]

where else i have to change ? and where i can put my driver?
Please help me here

[yogthos]

You have to add the Oracle driver dependency in project.clj, unfortunately Oracle doesn't publish their drivers on public Maven repositories.

So, you'd have to download the driver from the Oracle site, and do a local install for it.

[mondaldebanjan]

ok Thank you

[mondaldebanjan]

now having an error while migrating:
at clojure.main.main(main.java:37)
Caused by: java.sql.BatchUpdateException: error occurred during batching: ORA-00902: invalid datatype

    at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4615)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)

[yogthos]

That sounds like you have a type mismatch between the table column and the type of the data you're trying to set there. It does appear that you're able to connect to the db via conman though.

[mondaldebanjan]

yes it is now connected :)

[yogthos]

cool, I think we can close this one as the other problems don't appear to be conman related :)

[mondaldebanjan]

any update on this one ?
yogthos/migratus#43