Olá,
estou com um projeto web usando JNDI para acesso do abnco faz me parece que não está se conectando ao banco
e fiz um main para ver se está se conectando mais sai por erro …
package util;
import org.hibernate.Session;
public class ConectaHibernateMysql {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Session sessao=null;
try {
sessao=HibernateUtil.getSessionfactory().openSession();
System.out.println("Conectou....ok");
} catch (Throwable e) {
System.out.println("Erro ao conectar ao banco de dados..."+e.getMessage());
System.out.println("Erro ao conectar ao banco de dados..."+e);
}finally{
sessao.close();
}
}
}
---------------------
package util;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HibernateUtil {
private static final SessionFactory sessionFactory = buildSessionFactory();
private static SessionFactory buildSessionFactory(){
try {
Configuration cfg = new Configuration();
//AnnotationConfiguration cfg = new AnnotationConfiguration();
cfg.configure("hibernate.cfg.xml");
return cfg.buildSessionFactory();
} catch (Exception e) {
System.out.println("Criação Inicial do objeto SessionFactory falhou .Erro :"+e);
}
return getSessionfactory();
}
public static SessionFactory getSessionfactory(){
return sessionFactory;
}
}
------------
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/C:/workspace/SecurityJdbc/WebContent/WEB-INF/lib/slf4j-log4j12-1.6.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/C:/workspace/SecurityJdbc/WebContent/WEB-INF/lib/slf4j-simple-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
log4j:WARN No appenders could be found for logger (org.hibernate.type.BasicTypeRegistry).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" java.lang.NullPointerException
at util.ConectaHibernateMysql.main(ConectaHibernateMysql.java:20)
Criação Inicial do objeto SessionFactory falhou .Erro :org.hibernate.HibernateException: Could not find datasource
Erro ao conectar ao banco de dados...null
Erro ao conectar ao banco de dados...java.lang.NullPointerException
context.xml
[code]
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable=“true”>
<Resource name="jdbc/stripessec"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="root"
password="paulo"
driverClassName="com.mysql.jdbc.Driver"
url=“jdbc:mysql://localhost:3306/seguranca”/>
<Realm className="org.apache.catalina.realm.DataSourceRealm"
debug="99" dataSourceName="jdbc/stripessec" localDataSource="true"
userTable="usuario" userNameCol="login" userCredCol="password"
userRoleTable="regra" roleNameCol="regra" />
</Context>[/code]
web.xml
<!-- Configuração do DataSource. -->
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<resource-ref>
<description>Web Database</description>
<res-ref-name>jdbc/stripessec</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
hibernate.cfg.xml
<property name="connection.datasource">java:/comp/env/jdbc/stripessec</property>
<!--JDBC connection pool(use built-in)-->
<property name="connection.pool_size">1</property>
<!--SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all execute SQL to stdout-->
<property name="show_sql">false</property>
<property name="current_session_context_class">thread</property>