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. As Sumedha mentioned, please attach the dbs so that we can have a proper look at it. > > 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] <[email protected]> Mobile: +94774171471 <http://harshana05.blogspot.com/>
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
