Java insert BdD executeUpdate
Bonjour,
voila je galère juste sur une insertion dans une base de données.
Voilà ma ligne de code
Code:
1
2
|
int majTable = dao.executeUpdate("INSERT INTO NoeudOrig VALUES(9)"); |
Ci-dessous ma méthode executeUpdate (elle est à la fin)
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
|
public class DaoImpl
extends HibernateDaoSupport
implements Dao{
public void save(List<Object> list){
for(Object obj : list){
getHibernateTemplate().save(obj);
}
}
public void saveOrUpdate(List<Object> list) {
for(Object obj : list){
getHibernateTemplate().saveOrUpdate(obj);
// AD le 2008/12/31 : permet de gagner de l'espace mémoire en évitant d'écrire inutilement dans la console
Session s = getHibernateTemplate().getSessionFactory().getCurrentSession();
s.flush();
s.clear();
// fin AD
}
}
@SuppressWarnings("unchecked")
public List<Object> findAll(Class entityClass) {
// return getHibernateTemplate().find("from " + entityClass.getName() + " a" );
return getHibernateTemplate()
.getSessionFactory()
.getCurrentSession()
.createQuery("from " + entityClass.getName() + " a" ).list();
}
@SuppressWarnings("unchecked")
public List<Object> executeQuery(String query){
return getHibernateTemplate()
.getSessionFactory()
.getCurrentSession()
.createQuery(query).list();
}
// RPE le 2008/09/30 : purge des données dans la BdD
@SuppressWarnings("unchecked")
public int executeUpdate(String query){
return getHibernateTemplate()
.getSessionFactory()
.getCurrentSession()
.createQuery(query).executeUpdate();
}
//fin RPE
} |
En fait, je n'arrive pas à insérer la ligne de code dans a base de données PostgreSQL. En tapant directement la ligne via un éditeur de bdd (pgAdmin III), ca fonctionne !!
Voilà mon message d'erreur :
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
|
10:19:30,327 ERROR PARSER:33 - line 1:55: expecting OPEN, found 'VALUES'
10:19:30,327 ERROR LoaderImpl:57 - File skiped
org.hibernate.hql.ast.QuerySyntaxException: expecting OPEN, found 'VALUES' near line 1, column 55 [INSERT INTO pratic.model.NoeudOrig VALUES(9)]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at pratic.model.impl.DaoImpl.executeUpdate(DaoImpl.java:56)
at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
at $Proxy11.executeUpdate(Unknown Source)
at pratic.loader.impl.LoaderImpl.load(LoaderImpl.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy12.load(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:283)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:272)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPoolprat.java:529) |
Merci d'avance pour vos infos !!
Ritchie.
