Subject Setting dialect when running SQL...?
Author phil_hhn
Hi, I have a new Firebird 1.5 database, dialect 3. Via java
(Statement.executeUpdate) I am running a database creation/population
script, and I get the odd error when running it (some bits of my
script need fixing).
However the errors that come up a reminiscent of dialect1 errors, not
dialect3. I.e I often get '104' errors, not '206' errors (hope those
numbers are right, don't have them in front of me right now). Maybe
I'm mistaken, but I understood from my scanning thru the dialect 1/3
stuff that 104 vs 206 errors are one of the differences between the
dialects.
If so, even though I have created a dialect 3 database, is there
something I need to put in my code to tell it that I'm executing
dialect 3 statements? (Maybe there's something in JDBC that I missed...)

Thanks