0

how to add jdbc driver & Database url in Openice

Ashish Saini 9 years ago updated 9 years ago 2

I am trying to add jdbc driver "com.mysql.jdbc.Driver"

& Database url jdbc:mysql://192.168.1.105:1433/demo but its not working .

Please tell me how to add jdbc driver & Database Url of openice .

Add the following into the dependencies in the build.gradle present in root builder(next to hsqldb)

compile group: 'mysql', name: 'mysql-connector-java', version: '5.1.6'

This will download the jar and configure the database url properly (for mysql it is 3306, 1433 is oracle).

mine is :

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/mdpnp

<username>

<password>

I have add successfully dependencies and connection s is successfully established

but i dont know where data is stored ? I have to create the table name is mdpnp and create 5 columns .

It was successfully created ,but don't know where is going the data