No consigo conectar un programa sencillo en java con mi base de datos.Tengo el siguiente archivo de propiedades:
hibernate.connection.driver_class = org.gjt.mm.mysql.Driver
hibernate.connection.url = jdbc:mysql://localhost:3306/prueba
hibernate.connection.username = luis
hibernate.connection.password = 1234
Mi base de datos es mysql y le he dado permisos al usuario luis para esa contraseña mediante el GRANT.
Uso el IDE Eclipse Europa y me da el siguiente error:
13:04:18,551 INFO Environment:479 - Hibernate 3.1
13:04:18,556 INFO Environment:494 - loaded properties from resource hibernate.properties: {hibernate.connection.username=luis, hibernate.connection.password=****, hibernate.cglib.use_reflection_optimizer=true, hibernate.connection.url=jdbc:mysql://localhost:3306/prueba, hibernate.connection.driver_class=org.gjt.mm.mysql .Driver}
13:04:18,556 INFO Environment:525 - using CGLIB reflection optimizer
13:04:18,559 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
13:04:18,604 INFO Configuration:496 - Reading mappings from resource: User.hbm.xml
13:04:19,522 INFO HbmBinder:265 - Mapping class: User -> users
caca
13:04:19,532 INFO Configuration:1022 - processing extends queue
13:04:19,533 INFO Configuration:1026 - processing collection mappings
13:04:19,533 INFO Configuration:1035 - processing association property references
13:04:19,533 INFO Configuration:1057 - processing foreign key constraints
13:04:19,580 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:04:19,581 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:04:19,581 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
13:04:19,586 INFO DriverManagerConnectionProvider:80 - using driver: org.gjt.mm.mysql.Driver at URL: jdbc:mysql://localhost:3306/prueba
13:04:19,586 INFO DriverManagerConnectionProvider:86 - connection properties: {user=luis, password=****}
13:04:19,604 WARN SettingsFactory:103 - Could not obtain connection metadata
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at com.mysql.jdbc.MysqlIO.init(Unknown Source)
at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unk nown Source)
at com.mysql.jdbc.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionPr ovider.getConnection(DriverManagerConnectionProvid er.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(Se ttingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Conf iguration.java:1859)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1152)
at principal.main(principal.java:24)
Exception in thread "main" org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDial ect(DialectFactory.java:57)
at org.hibernate.dialect.DialectFactory.buildDialect( DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect (SettingsFactory.java:378)
at org.hibernate.cfg.SettingsFactory.buildSettings(Se ttingsFactory.java:110)
at org.hibernate.cfg.Configuration.buildSettings(Conf iguration.java:1859)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1152)
at principal.main(principal.java:24).
No consigo dar con la fuente del error. Alguien puede ayudarme???
Gracias por anticipado