当前位置:首页 > 开发 > 编程语言 > Hibernate > 正文

Hibernate之Mysql或Mariadb数据库连接问题

发表于: 2015-02-24   作者:codyJava   来源:转载   浏览:
摘要: Hibernate之Mysql或Mariadb数据库连接问题 项目是用Maven做的build,配置主要需要注意一下几个地方: 1. 数据库Mysql或Mariadb  yum repository: http://mirrors.neusoft.edu.cn/mariadb/mariadb-10.0.16/ Mariadb: https://mariadb.com/kb/e

Hibernate之Mysql或Mariadb数据库连接问题

项目是用Maven做的build,配置主要需要注意一下几个地方:

1. 数据库Mysql或Mariadb

 yum repository:

http://mirrors.neusoft.edu.cn/mariadb/mariadb-10.0.16/

Mariadb:

https://mariadb.com/kb/en/mariadb/

<dependency>
            <groupId>org.mariadb.jdbc</groupId>
            <artifactId>mariadb-java-client</artifactId>
            <version>1.1.8</version>
	    <scope>compile</scope>
</dependency>
<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>5.1.9</version>
</dependency>

 

 

2. Hibernate 版本 4.3.8.Final

 

        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>4.3.8.Final</version>
			<scope>compile</scope>
        </dependency>

 3. src\main\resources\hibernate.cfg.xml

 

 

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
  	<property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property>
    <property name="hibernate.bytecode.use_reflection_optimizer">false</property>
    <property name="hibernate.connection.password">passw0rd</property>
    <property name="hibernate.connection.url">jdbc:mariadb://9.114.194.77:3306/cody</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="show_sql">true</property>
    <property name="format_sql">true</property>
    <property name="use_sql_comments">false</property>
    <mapping resource="com/mkyong/customer/hibernate/Customer.hbm.xml" />
  </session-factory>
</hibernate-configuration>

 

 

错误:Error calling Driver#connect,connect refused...

xxx is not allowed to connect to this MariaDB server

类似这样的错。

需要注意以下几个地方:

1.  hibernate.cfg.xml的配置

 

<property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property>
 <property name="hibernate.connection.url">jdbc:mariadb://9.114.194.77:3306/cody</property>

 2. 检查SessionFactory 是不是正常

参考官方文档:

http://docs.jboss.org/hibernate/orm/4.3/manual/en-US/html/ch01.html#tutorial-firstapp-firstclass

public class HibernateListener implements ServletContextListener{
 
    private Configuration config;
    private SessionFactory factory;
    private String path = "/hibernate.cfg.xml";
    private static Class clazz = HibernateListener.class;
 
    public static final String KEY_NAME = clazz.getName();
 
	public void contextDestroyed(ServletContextEvent event) {
	  //
	}
 
	public void contextInitialized(ServletContextEvent event) {
 
	 try { 
	        URL url = HibernateListener.class.getResource(path);
	        config = new Configuration().configure(url);
	        System.out.println("Hibernate Configuration loaded");
	        
	        ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(config.getProperties()).build();
	        System.out.println("Hibernate serviceRegistry created");
	        
	        factory = config.buildSessionFactory(serviceRegistry);
	        System.out.println("Session Factory:" + factory.toString());
	        
	        //save the Hibernate session factory into serlvet context
	        event.getServletContext().setAttribute(KEY_NAME, factory);
	  } catch (Exception e) {
	         System.out.println(e.getMessage());
	         e.printStackTrace();
	   }
	}
}

 3. 数据库的授权:

通常这种修改都是web server 和 db在两个机器上,所以有个访问权限的问题。

通常访问的时候会以 root@<web server ip>的形式,这就需要授权和添加相关的用户密码才能访问db。

可以参考这篇文章:

http://www.cnblogs.com/xyzdw/archive/2011/08/11/2135227.html

一、在安装mysql/MariaDB的机器上运行:

1、mysql -h localhost -u root -p //这样应该可以进入MySQL/MariaDB服务器

2、mysql>GRANT   ALL   PRIVILEGES   ON   *.*   TO   'root'@'%'   WITH   GRANT   OPTION //赋予任何主机访问数据的权限

3、mysql>FLUSH   PRIVILEGES //修改生效

 

4、mysql>EXIT //退出DB

二、配置mysql数据库的user 表的‘%’用户信息:

MariaDB [mysql]> UPDATE user SET Password=PASSWORD('newpwd') WHERE User='root';
MariaDB [mysql]>FLUSH PRIVILEGES;
MariaDB [mysql]>exit;

 

错误:

hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

 参考文档:

http://www.tuicool.com/articles/7FZrYzE

 

Hibernate之Mysql或Mariadb数据库连接问题

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号