Hi Thomas,
You were right - the database is in PrivAccts.h2.db. So I had a look
inside that file as well, but again, table and field names are all in
camel case.
The odd thing is that when I set up the database url as -
jdbc: h2:file:D:\OpenOffice\Databases\PrivAccts;IFEXISTS=TRUE
then the tables are all loaded normally.
But as soon as I change it like this -
jdbc: h2:file:D:\OpenOffice\Databases\PrivAccts;IFEXISTS=TRUE;
DATABASE_TO_UPPER=FALSE
none of the tables are loaded and I get the message -
Table "TRANSDETAILS" not found; SQL statement:
SELECT Date FROM TransDetails WHERE TransRef = 10858 AND Sect = 1
It does seem like the problem has something to do with the way I am
appending DATABASE_TO_UPPER=FALSE.
Can you see what I am doing wrong?
Thanks,
Noel
On Mar 7, 6:43 pm, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> I was talking about the h2 database. I doubt that the PrivAccts.odb
> contains the H2 database file.
>
> Regards,
> Thomas
>
>
>
>
>
>
>
> On Friday, February 24, 2012, Noel L wrote:
> > Hi Thomas,
>
> > > You need to edit the SQL script first, so that the identifier names are
> > of
> > > the correct case (find-replace).
>
> > In my post of Jan 27, 2:55 pm, I mentioned that I unzipped
> > PrivAccts.odb and searched in several of the unpacked files. In all
> > cases the SQL I found had the correct case (e.g. TransDetails for a
> > table name). So that is probably not where you mean.
>
> > Where do I find the SQL script referred to above?
>
> > Thanks,
> > Noel
>
> > On Feb 23, 6:42 pm, Thomas Mueller
> > <[email protected]<javascript:;>
>
> > wrote:
> > > Hi,
>
> > > My problem is that when I append DATABASE_TO_UPPER=FALSE to the
>
> > > > database URL and reload the database, none of my tables are loaded and
> > > > I get an error message like "There exists no table named
> > > > 'PRIVACCTS.PUBLIC.TransHeader' " (This is with h2-1.3.162.jar loaded
> > > > in the Java Class Path.)
>
> > > You need to edit the SQL script first, so that the identifier names are
> > of
> > > the correct case (find-replace).
>
> > > Does appending DATABASE_TO_UPPER=FALSE to the URL in some way affect
>
> > > > the loading of the tables?
>
> > > No, but the SQL script does.
>
> > > Regards,
> > > Thomas
>
> > --
> > 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]<javascript:;>
> > .
> > To unsubscribe from this group, send email to
> > [email protected] <javascript:;>.
> > 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.
