> Good to know! On the other hand, T-SQL can be used with two different > JDBC drivers. The official Microsoft one (sqljdbc) and an also > "official" open source one (jtds).
We actually use jTDS. My sense is that to avoid the round-trip means having special communication protocol with the server. If that were present in SQLServer, then the SQLServer standard driver would make use of it. > Note that getSQL() renders bind variables as "?". What you would need > is Factory.renderInlined(QueryPart). Thanks for the tip. Wouldn't the API look cleaner from a usage point of view if we had a direct method like the "getSQL" one rather than having to go through the Factory? Out of curiosity, how do you inline certain complex types like doubles or dates? > As a Factory configuration, this setting could be applied > on a per-query basis, i.e. if you have 10-20 queries that are executed > 100's of times, you could still profit from preparing statements. Does it mean I have to create one factory per thread? In fact, how is jOOQ with regards to multi threading? Are some objects multithreaded? > This is an important improvement for jOOQ, so I'll add this as a > feature request to the road map: Again: do cross check my claims! I wouldn't want you to spoil your API with unneeded features. Cheers, -Christopher
