I developed a zk application with hibernate and mysql on eclipse. The application runs perfectly from eclipse. I tested the application on windows with locally installed tomcat and mysql successfully. When I try to run the same application on a debian server the application displays a message box containing: Cannot open connection [SQL: 1044, 42000]. I have another java application running on the same server and connecting to mysql smoothly. I’ve googled a lot and can’t find solution. Where can I look for the cause of this problem?
Your question is very bad, we don't even have a real error except the small thing you give.
For next time questions, please post the (only important piece if you know what to take) stacktrace.
Now, If I google your fault I came accros this :
ERROR 1044 (42000): Access denied for user xxx to database xxx
So I should check your propertie file (or JNDI file) if your settings are correct.
Greetz chill.
Sorry if bad question. All I wanted was to explain what the situation is. Please point me where can I check for errors. What “propertie file” are you referring? Below is my hibernate.cfg.xml:
Tags
People
Badges
Help
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/clinisoft?createDatabaseIfNotExist=true</property>
<property name="hibernate.connection.username">sa</property>
<property name="hibernate.connection.password">p3ermed</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.current_session_context_class">thread</property>
<property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>[. . .]
I'm guessing localhost:3306 is not the right address for your database. It's normally on other server then your application server so try changing that to the correct ip adres (or name). This can explain why you can't connect.
chillworld ( 2015-08-31 10:03:17 +0800 )editNormally they put those values in a propertie file so you can have different prop files for dev, ts, acc and prod without changing your application.
chillworld ( 2015-08-31 10:04:27 +0800 )editAsked: 2015-08-31 09:11:03 +0800
Seen: 45 times
Last updated: Sep 01 '15