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 :D :
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:
[code] 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'.
Tá dando uma Execção de SQL, não pode abrir uma conexao no JOptionPane..
O que pode estar errado? Configuração do Hibernate ? O usuario no SqL Server?
Ajuda aê :? :? :lol:
