pbl Jboss Tools Strust hibernate connection imposible
voici hibernateUtil
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HibernateUtil {
private static final SessionFactory sessionFactory = buildSessionFactory();
private static SessionFactory buildSessionFactory() {
try {
// Create the SessionFactory from hibernate.cfg.xml
return new Configuration().configure().buildSessionFactory();
}
catch (Throwable ex) {
// Make sure you log the exception, as it might be swallowed
System.err.println("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
}
public static SessionFactory getSessionFactory() {
return sessionFactory;
}
} |
voici la classe Action
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
| package Action;
import java.util.List;
import metier.*;
import beans.ClientForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
public class Inscription extends org.apache.struts.action.Action {
public Inscription() {
}
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
ClientForm monClient = (ClientForm) form;
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Client where login='"+monClient.getLogin()+"'");
List<Client> list = query.list();
tx.commit();
session.close();
if (list != null) {mapping.findForward("loginExistant");}
else {
Session session2 = HibernateUtil.getSessionFactory().openSession();
Transaction tx2 = session.beginTransaction();
Client client = new Client();
Query query2 = session.createSQLQuery("Select max(idclient) from Client");
List<Integer> list2 = query2.list();
tx2.commit();
session2.close();
Session session3 = HibernateUtil.getSessionFactory().openSession();
Transaction tx3 = session.beginTransaction();
client.setConfirme(0);
client.setEmail(monClient.getEmail());
client.setIdClient(list2.get(0)+1);
client.setLogin(monClient.getLogin());
client.setPassword(monClient.getMdp());
client.setPasswordConfirme(monClient.getMdpc());
session3.saveOrUpdate(client);
session3.flush();
tx3.commit();
session3.close();
Mail mail = new Mail();
try {mail.envoiMail(monClient.getEmail());}
catch (Exception e) {mapping.findForward("erreureEmail");}
mapping.findForward("bienvenue");
}
return null;
}
} |
voici les erreures
Code:
1 2 3 4 5 6
| exception
javax.servlet.ServletException: org.hibernate.exception.JDBCConnectionException: Cannot open connection
cause m�re
org.hibernate.exception.JDBCConnectionException: Cannot open connection
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/mabasse |
or il y a bien je suppose conection puisqu'il y a creation de la classe hibernate Client sérialized.