Hi Richard, * Richard Cyganiak > > Do you see any warnings generated by D2R Server?
I do not. > What version of Oracle and what version of the JDBC driver are you using? I'm using an ojdbc14.jar that I got from my own laptop, and I'm not sure what Oracle version is being used. I can't check, either, since right now the customer site is having login issues, so I can't do anything at all... :-( Anyway, it's possible that there is a mismatch here, and that that's the root cause. I'll find the details on that ASAP. > What's happening apparently is that D2RQ can't properly interpret the date > values returned by the JDBC driver. This is likely a bug and we need the > information above to track it down (DATE in Oracle works fine on the versions > we've tested; the code is aware of the fact that Oracle DATE includes a > time). What happens next is that D2RQ treats the value that it can't > interpret as NULL. Since a NULL here doesn't match the query pattern, no > result will be generated. This makes perfect sense to me. I reported this as an issue: https://github.com/d2rq/d2rq/issues/147 I'll add the two versions as soon as I can get into the system again. > (Since you have a LIMIT 10, D2RQ will walk through all 2.8M rows trying to > find some results. In the queries that work, D2RQ just needs to look at the > first few rows of your table to get 10 results. This explains the difference > in runtime.) Yes, that's what I assumed. > (Regarding the suboptimal SQL query, are you running D2R Server with --fast?) No, I'm not. I'll do that next time I can get in. (Thanks! I'd read about that option, then forgotten it. Perhaps the default should be the other way around?) --Lars M. http://www.garshol.priv.no/tmphoto/ http://www.garshol.priv.no/blog/ ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ d2rq-map-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
