We need a patch, and a license statement:
http://www.h2database.com/html/build.html#providing_patches
On 2012-07-08 19:18, awebdeveloper wrote:
Awesome! I managed to fix it :-)
It was really simple, I added the following code snippet to the
parseSet() method of the org.h2.command.Parser class.
else if(readIf("NAMES")) {
// Quercus PHP MySQL driver compatibility
readIfEqualOrTo();
read();
return new NoOperation(session);
}
after line 4604 (after the "else if(readIf("RECOVER")) {}" block).
After that I tested it with the Quercus PHP MySQL driver and it worked
like a charm!
How do I proceed to have the fix included in the H2 distribution?
On Friday, July 6, 2012 6:13:02 PM UTC+2, awebdeveloper wrote:
Hi Noel,
Thank you for giving me a place to start! :-)
On Friday, July 6, 2012 9:09:57 AM UTC+2, Noel Grandin wrote:
Start with the org.h2.command.Parser class. It's a standard
recursive
descent parser, very easy to work with.
On 2012-07-05 23:56, awebdeveloper wrote:
> Hi,
>
> I am connecting to H2 in MySQL compatibility mode using a
MySQL driver
> (Caucho Quercus' MySQL driver to be exact). I am getting an
error
> during connection, saying there is a syntax error in the SQL
query:
> SET NAMES 'latin1'; (Basically SET NAMES is not supported by
H2 yet.)
> This is valid for MySQL, but as I am aware, H2's MySQL
compatibility
> is not 100%. I've seen that solving this is already on the
todo list
> for H2, but it's kind of tucked away somewhere in the lower
half of
> priorities :-) I am trying to raise awareness for this
issue, maybe it
> can be given a higher priority. Also, I would be interested in
> working/coding on this issue myself. But I probably need
some help in
> that area, since I have never worked with the H2 code base
before.
>
> If anyone could give me some feedback/tips/help with this,
it would be
> greatly appreciated :-)
> --
> You received this message because you are subscribed to the
Google
> Groups "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/VtdpwtcF7UkJ
<https://groups.google.com/d/msg/h2-database/-/VtdpwtcF7UkJ>.
> To post to this group, send email to
[email protected]
<mailto:[email protected]>.
> To unsubscribe from this group, send email to
> [email protected]
<mailto:h2-database%[email protected]>.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en
<http://groups.google.com/group/h2-database?hl=en>.
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/nisT4YPA2hYJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
