Hi Prabath A. Ing. Jorge Infante Osorio. J´Dpto Soluciones SOA. CDAE. UCI
De: [email protected] [mailto:[email protected]] En nombre de Prabath Abeysekera Enviado el: martes, 07 de junio de 2011 21:50 Para: [email protected] Asunto: Re: [Carbon-dev] problem with jdbc driver in a dataservice query. Hi Jorge, 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. If I'm not mistaken, you're using return generated keys?? AFAIK, postgres does not support the aforementioned functionality and that should be the reason why you getting the last mentioned issue. But if you still want to have something similar to return generated keys, you can use the alternative way of using "currval()" which is a built-in function in postgres, to get it done. This last error appear when I restart the server after change the jdbc driver from postgresql-8.4-701.jdbc4.jar to postgresql-8.1dev-400.jdbc3.jar to test inside WSAS if the query work like in the console app when I use postgresql-8.1dev-400.jdbc3.jar instead postgresql-8.4-701.jdbc4.jar. In any service deployed I have this error. As Sumedha mentioned, please attach the dbs so that we can have a proper look at it. I send you the requested information to your email, not to the public list due to security reasons. Sorry for that. Thanks, Jorge. 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 Cheers, -- Prabath Abeysekara Software Engineer WSO2 Inc. Email: [email protected] Mobile: +94774171471 _______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
