Showing posts with label jdbc. Show all posts
Showing posts with label jdbc. Show all posts

Wednesday, 19 February 2014

apt-get install debian PT4 (JDBC connector and Arduino IDE)



Here we are, today as you probably know we'll talk about installing JDBC connector for MySql/Tomcat/Eclipse and the Arduino IDE (in the top picture you can see my abnormal ability to modify images in paint).

JDBC connector:

First of all: you need to install it. To do so you tipe in a terminal: sudo apt-get install libmysql-java

This will extract the connector jar into the /usr/share/java/ directory


For install the JDBC driver into Eclipse you'll need to make it visible to Eclipse in some way.


Some guide tell you to put the jar into the Java Build Path libraries of your project. But, probably for some conflict between the CLASSPATH environment variables, in my case this does not work. Maybe it work in a non web project, but in my case with dynamic web project with tomcat as web-server it not.

So I put the jar into the lib dir of the apache tomcat's installation dir.
Doing this and run your project both on Eclipse or in the browser, the jar will be retrieved from the lib dir of tomcat instead to be retrieved from the build path.
If in the future I set the build path properly I'll either modify this post or do one new post.

Arduino IDE:


As you can see in the official website, the Arduino IDE has been packaged.
So to install it you only need to type sudo apt-get install arduino into a terminal and voilĂ , your Arduino IDE is ready to be used.
You need only to type arduino in a terminal and it will be asked to insert your user to the dialout group.
Click Add and then type the password.

After you has been inserted into the dialout group you can finally use your Arduino IDE:




At this point I don't need anything else on my new dev-machine.
If I find any other problem and relative solution I'll do another post.

See ya.
Ygy Freezone




Sunday, 16 February 2014

apt-get install debian PT3 (MySql)



And finally here we are, installing dbms driver on our Debian machine.

First type this line into a terminal: sudo aptitude -y install mysql-server-5.5

Right after the download of the package it will be ask to insert the mysql root password.



At this point, to test your new MySql db type in a terminal: mysql -u root -p


If you see this line, congratulation! MySql is running on your machine!

Well, now you maybe need a workbench tool to manage your databases.
Type in a terminal: sudo apt-get install mysql-workbench

After the installation, for open your workbench you just type mysql-workbench in a terminal, and you can start manage your DB.




Now, to start developing with Tomcat and Eclipse, you need the jdbc-connector.
Type in a terminal sudo apt-get install libmysql-java , and voilĂ  you have your connector ready to use.



Next time, "how put your jdbc connector on tomcat and eclipse" & "Arduino IDE".
See ya.
Ygy Freezone.