Hi Jorge, Could you attach Persona.dbs & the definition for function1 please?. The problem is in your response definition. But we should be able to confirm after seeing the data service configuration.
/sumedha On Wed, Jun 8, 2011 at 12:28 AM, Jorge Infante Osorio <[email protected]>wrote: > Hi folks. > > We are implementing some data services that use a PostgreSQL database as it > source. Until now just work fine but in one query any time we want to > consult it we receive this error from postgreSQL: > > > > DS Fault Message: Error in pre-fetching dataNested Exception:-javax.xml.stre > > am.XMLStreamException: DS Fault Message: Error in 'SQLQuery.processNormalQue > > ry'Source Data Service:-Name: PersonaLocation: /opt/wso2wsas-3.2.1/repositor > > y/deployment/server/dataservices/Persona.dbsDescription: N/ADefault Namespac > e: http://ws.wso2.org/dataserviceCurrent > > Request Name: buscarDatosPersonaCurrent Params: {sex=M}Nested Exception:-org > .postgresql.util.PSQLException: ERROR: > function datos.funcion1 > > (character varying, character varying, character varying, character varying, > > character varying, date, character varying, integer, character varying, > character varying, double precision, double precision, character varying, > > character varying, character varying, character varying, character varying, > > character varying, character varying, character varying, character varying, > > character varying, character varying, character varying, character varying, > character varying) does not exist > Hint: No function matches the given name and argument types. > You might need to add explicit type casts. Position: 15 > > In pgadmin the function work fine. > > We are using postgresql-8.4-701.jdbc4.jar and detect that this is the > problem: the jdbc driver. In a console application we receive the same > error. > > If we use postgresql-8.1dev-400.jdbc3.jar in a simple console application > with J2SE the function work fine. > > Then we change the jdbc driver in WSAS 3.2.1 to > postgresql-8.1dev-400.jdbc3.jar but with errors due to “Returning > autogenerated keys is not supported”. > > Any idea for a solution to this problem? > > > Thanks,Ing. Jorge Infante Osorio. > J´Dpto Soluciones SOA. > CDAE. > UCI > > > > _______________________________________________ > Carbon-dev mailing list > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
