Hi,

By looking at the exception log it seems the database / table that is
related the query is not available. Could you please check whether you have
specified the correct database/ table in the data service you deployed.

Thanks

On Fri, Feb 24, 2012 at 6:50 PM, Noel Marquez Batista <[email protected]>wrote:

> HI ALL, I´VE CREATED A CLIENT THAT ACCESS DIRECTLY INTO A DB USING JDBC
> AND IT´S WORKS PERFECTLY, BY I WANT TO DO THE SAME WITH A DATA SERVICE IN
> AS, AND IT IS NOT WORKING AT ALL. HERE IS THE QUERY:
>
> String parameter = "'100-047'";
>
> Select *  from  schema.function_get_tree('table.id = 1 AND table.number =
> '"+parameter+"'')
>
> SO WHEN I PUT THIS QUERY INTO THE SERVICE I SPPECIFIED THE PARAMETER IN
> THIS WAY:
>
> Select *  from  schema.function_get_tree('table.id = 1 AND table.number =
> :parameter')
>
> AND THIS IS THE ERROR WHEN I TRY IT:
>
> TID: [0] [WSO2 Application Server] [2012-02-23 15:50:34,777] ERROR
> {org.apache.axiom.om.impl.llom.OMSourcedElementImpl} - Could not get parser
> from data source for element {http://empresa.co}Grupos
> {org.apache.axiom.om.impl.llom.OMSourcedElementImpl}javax.xml.stream.XMLStreamException:
> DS Fault Message: Error in 'SQLQuery.processNormalQuery' DS Code:
> DATABASE_ERROR Source Data Service:- Name: PregradoWS Location:
> /PregradoWS.dbs Description: N/A Default Namespace: http://empresa.coCurrent 
> Request Name: ObtenerGrupoDadoIdGrupo Current Params:
> {parameter="'100-047'"} Nested Exception:- DS Fault Message: Error in
> 'createProcessedPreparedStatement' DS Code: UNKNOWN_ERROR Nested
> Exception:- org.postgresql.util.PSQLException: The column index is out of
> range: 1, number of columns: 0. at
> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:105)
> at
> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:110)
> at
> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.getReader(DSOMDataSource.java:116)
> at
> org.apache.axiom.om.impl.llom.OMSourcedElementImpl.getDirectReader(OMSourcedElementImpl.java:225)
> at
> org.apache.axiom.om.impl.llom.OMSourcedElementImpl.forceExpand(OMSourcedElementImpl.java:254)
> at
> org.apache.axiom.om.impl.llom.OMSourcedElementImpl.getFirstOMChild(OMSourcedElementImpl.java:867)
> at
>
>
> HELP, thanks.
>
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE
> ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
> _______________________________________________
> Carbon-dev mailing list
> [email protected]
> http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>



-- 
*Shelan Perera*

Software Engineer
**
*WSO2, Inc. : wso2.com*
lean.enterprise.middleware.

*Home Page*  :    shelan.org
*Blog*             : blog.shelan.org
*Linked-i*n      :http://www.linkedin.com/pub/shelan-perera/a/194/465
*Twitter*         :https://twitter.com/#!/shelan

*Mobile*          : +94 772 604 402
_______________________________________________
Carbon-dev mailing list
[email protected]
http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Reply via email to