javax.ejb.EJBException: javax.ejb.CreateException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknow
Bonjour
J'ai l'erreur suivante, quand j'essaye de se connecter à ma bd mysql ;jonas:
Citation:
javax.ejb.EJBException: Imposssible de retrouver le beanSessionjavax.ejb.CreateException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'montant_' in 'field list'
CallConvertisseur.doGet(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
voila le code de ma servlet:
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
| import javax.naming.*;
import javax.naming.NamingException;
import javax.rmi.PortableRemoteObject;
import javax.ejb.*;
import convertisseur.*;
import entitebean.*;
import java.util.Enumeration;
import java.util.Vector;
import java.io.PrintWriter;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CallConvertisseur extends HttpServlet {
private PrintWriter out;
static HashMap map = new HashMap();
String[] sc=new String[100];
public void doGet(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException {
res.setContentType("text/html");
out = res.getWriter();
try{
Context ic=new InitialContext();
// Recherche de l'interface home de sesssion bean
out.println("appel du bean session");
Object objref=ic.lookup("convertisseur/MonConvertisseurDevise");
// Rfrence l'EJB
ConvertisseurDeviseHome home1=(ConvertisseurDeviseHome)PortableRemoteObject.narrow(objref,ConvertisseurDeviseHome.class);
// Recherche de l'interface home de entité bean
out.println("appel du bean entité");
Object ref = ic.lookup("ConvertisseurHome");
ConvertisseurHome home2=(ConvertisseurHome)PortableRemoteObject.narrow(ref,ConvertisseurHome.class);
if(req.getParameter("calculer")!=null)
{
ConvertisseurDevise monConvertisseurDevise = home1.create();
float mont=Float.parseFloat(req.getParameter("montant"));
float tdc=Float.parseFloat(req.getParameter("tdc"));
String dev=req.getParameter("devise");
String phr=monConvertisseurDevise.deviseToEuro(mont,dev,tdc);
req.setAttribute("phrase",phr);
RequestDispatcher dist=req.getRequestDispatcher("/formulaire.jsp");
dist.forward(req, res);
}
else if(req.getParameter("save")!=null)
{
ConvertisseurDevise monConvertisseurDevise = home1.create();
map =monConvertisseurDevise.affichage();
for (int j=0;j<map.size();j++)
{
String s =(String)map.get(j);
sc= s.split(";");
float mont=Float.parseFloat(sc[0]);
float tdc=Float.parseFloat(sc[2]);
Convertisseur c=home2.create(0,mont,sc[1],tdc);
}
req.setAttribute("phrase","Enregistrement effectue avec succes");
RequestDispatcher dist=req.getRequestDispatcher("/formulaire.jsp");
dist.forward(req, res);
}else
{ String s="";int i=0;String[] sc=new String[100];
ConvertisseurDevise monConvertisseurDevise = home1.create();
map =monConvertisseurDevise.affichage();
out.println("<table width='600'align='center' cellpadding='0' cellspacing='0'>");
out.println("<tr bgcolor='#CCCCCC'>");
out.println("<td align='center'>");
out.println("Montant");
out.println("</td>");
out.println("<td align='center'>");
out.println("Devise");
out.println("</td>");
out.println("<td align='center'>");
out.println("Taux de change");
out.println("</td>");
out.println("<td align='center'>");
out.println("Montant * Taux de change");
out.println("</td>");
out.println("</tr>");
for (int j=0;j<map.size();j++)
{
String sr = (String)map.get(j);
sc= sr.split(";");
float t=Float.valueOf(sc[0].trim()).floatValue()*Float.valueOf(sc[2].trim()).floatValue();
out.println("<tr bgcolor='#FFFFCC'>");
out.println("<td align='center'>");
out.println(sc[0]);
out.println("</td>");
out.println("<td align='center'>");
out.println(sc[1]);
out.println("</td>");
out.println("<td align='center'>");
out.println(sc[2]);
out.println("</td>");
out.println("<td align='center'>");
out.println(""+t+" Euro");
out.println("</td>");
out.println("</tr>");
}
out.println("<table width='600'align='center' cellpadding='0' cellspacing='0'>");
out.println("<tr>");
out.println("<td align='center'>");
out.println("<FIELDSET align='center'>");
out.println("<LEGEND>ToTal</LEGEND>");
out.println(""+sc[3]+" Euro");
out.println("</FIELDSET>");
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</table>");
}
}catch(Exception e){
throw new EJBException("Imposssible de retrouver le beanSession"+e);
}
}
} |
Merci
