HI Jorge, On Wed, Jun 8, 2011 at 7:31 AM, Jorge Infante Osorio <[email protected]> wrote:
> 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. > Sure no probs. :) > > 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 > -- Prabath Abeysekara Software Engineer WSO2 Inc. Email: [email protected] <[email protected]> Mobile: +94774171471 <http://harshana05.blogspot.com/>
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
