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
