MySQL + Hibernate configuration in Mac OS

1 MySQL

    1) download MySQL from somewhere, mysql-5.5.13-osx10.6-x86.dmg, I just google it when I need to download.

http://download.softagency.net/mysql/Downloads/MySQL-5.5/  This is one of the repository

    2) MySQL JDBC Connector: mysql-connector-java-5.1.16.tar download it from Sourceforge, extract, put the jar file into lib folder of your project

    3) you can try with MySQL Front-end administration tool, e.g. "Navicat Lite", create a database, a table, and put some data into it.

    4) write some test code to see if it works with this env.

public class Conn { static Connection conn = null; static Statement stmt = null; static ResultSet rs = null; public void connect() { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/yagrDB", "root", ""); } catch (SQLException e) { e.printStackTrace(); } try { stmt = conn.createStatement(); } catch (SQLException e) { e.printStackTrace(); } String sql = "SELECT * FROM Contact"; try { rs = stmt.executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); } try { while(rs.next()){ System.out.print("id : "+rs.getInt(1)); } } catch (SQLException e) { e.printStackTrace(); } }} 

 

2 Hibernate

    1) download hibernate libs, hibernate-release-4.0.0.Beta1, could always download it from hibernate.org

    2) copy into lib folder

    3) install hibernate eclipse plugins and features, help you create xml cfg files

    4) _____not sure, if we could use JBoss download Hibernate and auto cfg all jar files? (version conflict prb might be involved, and make it unable to find class, just google and check versions, slf4j-1.6.1 download this, and put into lib folder)

    5) little test on env.

 

    Hibernate cfg xml

    Hibernate cfg xml<hibernate-configuration> <session-factory name="ContactSession"> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/yagrDB</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <mapping class="Contact"/> </session-factory></hibernate-configuration> 

     Mapping class //ID as a key value need to be set as auto incremental

     import javax.persistence.*;@Entity@Table( name = "Contact" )public class Contact { @Id @GeneratedValue(strategy=GenerationType.IDENTITY)int ID;String Name;String School;public int getID() {return ID;}public void setID(int iD) {ID = iD;}public String getName() {return Name;}public void setName(String name) {Name = name;}public String getSchool() {return School;}public void setSchool(String school) {School = school;}} 

     Test Code in Main

     try{SessionFactory sessionFactory;sessionFactory = new Configuration().configure().buildSessionFactory();Session session = sessionFactory.openSession();Contact contact = new Contact();contact.setID(123);contact.setName("Deepak");contact.setSchool("TKK");Transaction tx = null;tx = session.beginTransaction();session.save(contact);tx.commit();session.close();System.out.println("out");}catch (Exception e){e.printStackTrace();} 

 

     should work then!