Project

General

Profile

Actions

Bug #760

closed

Erreur sur nouveau gestionnaire de ressources

Added by Anonymous over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Urgent
Start date:
07/06/2010
Due date:
% Done:

100%

Estimated time:
4.00 h
Spent time:
Navigateur:
Votre version de Silverpeas:
5.2
Système d'exploitation:
Windows XP
Votre base de données:
Toutes
Livraison en TEST:
Livraison en PROD:

Description

Impossible d'obtenir l'objet distant
Impossible de récupérer les réservations du mois
ERROR: column

org.postgresql.util.PSQLException: ERROR: column

Sur Intranoo, même erreur il y a plus de détails :

java.sql.SQLException: Nom de colonne non valide : 'status'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
at com.silverpeas.resourcesmanager.model.ResourcesManagerDAO.getMonthReservation(ResourcesManagerDAO.java:964)
at com.silverpeas.resourcesmanager.control.ejb.ResourcesManagerBmEJB.getMonthReservation(ResourcesManagerBmEJB.java:432)

Actions #1

Updated by Emmanuel Hugonnet over 14 years ago

  • Assignee set to Emmanuel Hugonnet
  • Target version set to Version 5.2.1
  • Système d'exploitation set to Windows XP
Actions #2

Updated by Anonymous over 14 years ago

Trace obtenue sous PostgresQL :

06/07/10-16:45:39,037 - ERROR : RuntimeException in method: public abstract java.util.List com.silverpeas.resourcesmanager.control.ejb.ResourcesManagerBm.getMonthReservation(java.lang.String,java.util.Date,java.lang.String,java.lang.String) throws java.rmi.RemoteException:
Impossible de récupérer les réservations du mois
nested (Deepest) :
org.postgresql.util.PSQLException: ERROR: column "status" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
at com.silverpeas.resourcesmanager.model.ResourcesManagerDAO.getMonthReservation(ResourcesManagerDAO.java:964)
at com.silverpeas.resourcesmanager.control.ejb.ResourcesManagerBmEJB.getMonthReservation(ResourcesManagerBmEJB.java:432)

Actions #3

Updated by Emmanuel Hugonnet over 14 years ago

  • Estimated time set to 4.00 h
Actions #4

Updated by Emmanuel Hugonnet over 14 years ago

  • Status changed from New to Closed

Modification des scripts SQL pour les 3 SGBD.
Attention si vous avez installé une version de Silverpeas 5.1.x toute fraiche sous Postgresql il faut corriger à la main les tables avec les deux commandes SQL suivantes :
@
ALTER TABLE SC_Resources_Reservation
ADD status varchar (50) NULL
;

ALTER TABLE SC_Resources_ReservedResource
ADD status varchar (50) NULL
;@

Actions #5

Updated by Emmanuel Hugonnet over 14 years ago

  • % Done changed from 0 to 100
  • Votre base de données changed from PostgreSQL to Toutes
Actions

Also available in: Atom PDF