[Obm] Erreur SQL

[Vince]

Bonjour,

J'ai un petit problème lors d'une requête dont voici le log ci-dessous :

2012-11-21 10:56:05,528 CalendarBindingImpl ERROR - [CUID 1277] 
L'élément du batch 14 INSERT INTO EventLink (eventlink_event_id, 
eventlink_entity_id, eventlink_state, eventlink_required, 
eventlink_percent, eventlink_usercreate, eventlink_is_organizer) VALUES 
(41996, 447, ACCEPTED, OPT, 100,149,1) a été annulé. Appeler 
getNextException pour en connaître la cause.
java.sql.BatchUpdateException: L'élément du batch 14 INSERT INTO 
EventLink (eventlink_event_id, eventlink_entity_id, eventlink_state, 
eventlink_required, eventlink_percent, eventlink_usercreate, 
eventlink_is_organizer) VALUES (41996, 447, ACCEPTED, OPT, 100,149,1) a 
été annulé. Appeler getNextException pour en connaître la cause.
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2531)
         at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1344)
         at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:343)
         at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2668)
         at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:616)
         at 
org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:477)
         at $Proxy16.executeBatch(Unknown Source)
         at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)


Si je tente cette ligne SQL directement dans postgres, il me dit que la 
colonne ACCEPTED n'existe pas. Cf ci-dessous.

obm=# INSERT INTO EventLink (eventlink_event_id, eventlink_entity_id, 
eventlink_state, eventlink_required, eventlink_percent, 
eventlink_usercreate, eventlink_is_organizer) VALUES (41996, 447, 
ACCEPTED, OPT, 100,149,1);
ERREUR:  la colonne « accepted » n'existe pas
LINE 1: ...eate, eventlink_is_organizer) VALUES (41996, 447, ACCEPTED, ...

Merci de votre aide.

Vincent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.obm.org/pipermail/obm/attachments/20121121/69ef75d6/attachment.htm