Re: [HSCALE-user] JDBC Batching and Stored Procedures

[Peter R. <pet...@op...>]

... resending this message since listserver at sf.net seemed to be down 
for quite a while :(



Paul,

> I have read up a bit on HSCALE and I have a couple questions about it.  
> First of all, does it support JDBC batching?  Also, how about simple 

JDBC-Batching is supported as long as you don't use
"rewriteBatchedStatements=true" with Connector-J (see
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html)

Currently HSCALE does not support multi-value INSERT statements.

> stored procedures?  If would be fantastic if HSCALE can support these 

Stored procedures are supported (HSCALE + MySQL Proxy is just a proxy).
But I think you meant "Is using partitioned tables within stored
procedures supported?": No. I doubt that this will be the case in the
near future since you have no control over stored procedures from within
the proxy and thus would have to come up with some completely different
approach.
Personally, I don't use stored procedures since they put application
logic into the DBMS. But that is really, really just my point of view ;)

Greetings

Peter

..: Next time, please subscribe to the mailing list before posting.