We are preparing de information you Request. In the meantime: If the problem is in the dataservice why I have the same error in the console application and not with the old jdbc driver?
Thanks, Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. UCI De: [email protected] [mailto:[email protected]] En nombre de Sumedha Rubasinghe Enviado el: martes, 07 de junio de 2011 15:04 Para: [email protected] Asunto: Re: [Carbon-dev] problem with jdbc driver in a dataservice query. 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
