Re: [d2rq-dev] Using stored procedures with d2rq

[Richard C. <ri...@cy...>]

Daniel,

I've never tried using stored procedures so can't really help here, but if it works at all, then d2rq:sqlExpression is probably the thing to use.

Did you try running the command line tools with --verbose or --debug? This should show the SQL queries that D2RQ is executing. Maybe this helps with figuring out why things are not working.

Best,
Richard


On 3 Oct 2013, at 10:37, dan...@es... wrote:

> Hi all,
> 
>   I've been trying to map the results of a stored procedure instead  
> of tables. I've tried using the  "SQLExpression" tag, but I wasn't  
> able to get anything.  Is it supposed to work? In this case I should  
> be doing something wrong, of is there anything prepared for that?
> 
>   For more details, the stored procedure I'm trying to map is the  
> next one (as I query for it in the database):
> 
>       get_traceroutes(ARRAY['agent_id', 'destination_id', 'first',  
> 'last', 'hops', 'hop_count', 'tool_id'], 'agent_id = 11824 AND  
> destination_id = 1416 AND hop_count > 20','2012-09-09  
> 14:30:09','2012-09-13 14:30:09') AS foo(agent_id integer,  
> destination_id integer, first timestamp without time zone, last  
> timestamp without time zone, hops ip_hop_t[], hop_count integer,  
> tool_id integer))
> 
>   Thank you in advance.
> 
>   Best regards, Daniel
> 
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> d2rq-map-devel mailing list
> d2r...@li...
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel