Galera tenho um usuario no SQL server onde eu logo tranquilamente no SGBD. O SQLServer está configurado para autenticações windows e SQLServer, mas ao rodar a aplicação usando o Hibernate ele diz que não pode abrir uma conexão . Estou usando o driver JTDS,olha o hibernate.cfg.xml, tô pesquisando o hibernate :
# 1. <?xml version="1.0" encoding="UTF-8"?>
# 2. <!DOCTYPE hibernate-configuration PUBLIC
# 3. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
# 4. "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
# 5.
# 6. <hibernate-configuration>
# 7. <session-factory>
# 8. <property name="hibernate.connection.driver_class">
# 9. net.sourceforge.jtds.jdbc.Driver
# 10. </property>
# 11. <property name="hibernate.connection.url">
# 12. jdbc:jtds:sqlserver://127.0.0.1:1433/JAVA-HIBERNATE
# 13. </property>
# 14. <property name="hibernate.connection.username">
# 15. hibernate2010
# 16. </property>
# 17. <property name="hibernate.connection.password">
# 18. hibernate2010
# 19. </property>
# 20. <property name="hibernate.dialect">
# 21. org.hibernate.dialect.SQLServerDialect
# 22. </property>
# 23.
# 24. <property name="show_sql">true</property>
# 25. <property name="pool_size">10</property>
# 26.
# 27. <mapping resource="aluno.hbm.xml"/>
# 28.
# 29.
# 30. </session-factory>
# 31. </hibernate-configuration>
classe teste de funcionamento....
# 1. import org.hibernate.*;
# 2. import org.hibernate.cfg.*;
# 3. import javax.swing.*;
# 4.
# 5. public class GravaAluno {
# 6.
# 7. public static void main(String[] args){
# 8.
# 9. try{
# 10.
# 11. SessionFactory fabricaSessoes = new Configuration().configure("hibernate.cfg.xml").buildSessionFactory();
# 12. Session sessao = fabricaSessoes.openSession();
# 13.
# 14. Aluno aluno = new Aluno();
# 15. aluno.setAlu_cod(1);
# 16. aluno.setAlu_nome("EDUARDO");
# 17. aluno.setAlu_fone("88380438");
# 18. aluno.setAlu_cidade("Joao Pessoa");
# 19. aluno.setAlu_curso("Sistemas de Informações");
# 20.
# 21. Transaction tx_aluno = sessao.beginTransaction();
# 22. sessao.save(aluno);
# 23. tx_aluno.commit();
# 24. sessao.close();
# 25.
# 26.
# 27. }catch(Exception erro){
# 28. JOptionPane.showMessageDialog(null, "Erro de inserção: "+erro);
# 29. }
# 30.
# 31. }
# 32. }
erro:
# 1. 31 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.3.1.GA
# 2. 93 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
# 3. 140 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
# 4. 156 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
# 5. 250 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
# 6. 250 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
# 7. 437 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : aluno.hbm.xml
# 8. 562 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: Aluno -> Alunos
# 9. 578 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
# 10. 859 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
# 11. 859 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
# 12. 859 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
# 13. 937 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: net.sourceforge.jtds.jdbc.Driver at URL: jdbc:jtds:sqlserver://127.0.0.1:1433/JAVA-HIBERNATE
# 14. 937 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=hibernate2010, password=****}
# 15. 1187 [main] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata
# 16. java.sql.SQLException: Login failed for user 'hibernate2010'.
# 17. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
# 18. at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
# 19. at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
# 20. at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
# 21. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
# 22. at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
# 23. at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
# 24. at java.sql.DriverManager.getConnection(DriverManager.java:582)
# 25. at java.sql.DriverManager.getConnection(DriverManager.java:154)
# 26. at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
# 27. at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
# 28. at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
# 29. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
# 30. at GravaAluno.main(GravaAluno.java:19)
# 31. 1250 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.SQLServerDialect
# 32. 1265 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
# 33. 1281 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
# 34. 1281 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
# 35. 1281 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
# 36. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: disabled
# 37. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
# 38. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
# 39. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
# 40. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
# 41. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
# 42. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
# 43. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
# 44. 1296 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
# 45. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
# 46. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
# 47. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
# 48. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
# 49. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
# 50. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
# 51. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
# 52. 1296 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
# 53. 1312 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
# 54. 1312 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
# 55. 1312 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
# 56. 1312 [main] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
# 57. 1421 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
# 58. 1765 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
# 59. 1843 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 18456, SQLState: 28000
# 60. 1843 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Login failed for user 'hibernate2010'.
O que pode ser isso? será no hibernate, o usuario do Sql Server?