Hi,
Thanks a lot for your suggestions which helped come forward - but there is
still a bit left.
The change in URL didn`t create any difference as you guessed.
Learning about the trace.db-file gave me errormessages showing what was missing
in the
links between the main form and subforms. But I haven`t succeded in getting it
to work fully.
In OOBase you enter only the name of the field that should connect between
tables.
Now I entered the full field-name TEST.PUBLIC.TABLE.FIELD which resulted in
that the subforms
were no longer empty - but I could never have the subforms to connect the
correct information
between the forms. I have tried to enter full SQL-sentences but with no better
result.
Then i tested to create another database in Embedded mode - and now the forms
WORK!!!
In the server mode i can only find SQLs like this:
/*SQL l:119 #:1*/SELECT * FROM \"OVDB1\".\"PUBLIC\".\"Utbildningar\" WHERE
\"OVDB1\".\"PUBLIC\".\"Utbildningar\".\"UtbShort\" = ?
... but in the embedded mode there are also the prep statements below but I
don`t understand there exact meaning.
I have tried to find a SQL telling something like in a query combining the
tables - which also are used in the forms:
SELECT "Utbildningar".*, "Utbildningstillfällen".* FROM
"OVDB1"."PUBLIC"."Utbildningstillfällen", "OVDB1"."PUBLIC"."Utbildningar"
WHERE "Utbildningstillfällen"."UtbShort" = "Utbildningar"."UtbShort" - but
didn`t succeed.
/*SQL l:98 #:1*/SELECT * FROM \"OVDB1\".\"PUBLIC\".\"Utbildningar\" WHERE
\"OVDB1\".\"PUBLIC\".\"Utbildningar\".\"UtbShort\" = ?/**/PreparedStatement
prep246 = conn2.prepareStatement("SELECT * FROM
\"OVDB1\".\"PUBLIC\".\"Utbildningstillf\u00e4llen\" WHERE ( 0 = 1 ) AND ( (
\"UtbShort\" = ? ) )", 1003, 1007);
/**/PreparedStatement prep273 = conn2.prepareStatement("SELECT * FROM
\"OVDB1\".\"PUBLIC\".\"Utbildningstillf\u00e4llen\" WHERE ( \"UtbShort\" = ?
)", 1005, 1008);
("SELECT * FROM \"OVDB1\".\"PUBLIC\".\"Utbildningstillf\u00e4llen\" WHERE ( 0 =
1 ) AND ( ( \"UtbShort\" = ? ) )", 1003, 1007);
I have used h2 1.3.159 and OO 3.2, 3.3 and 3 OOo-dev.My question is whether you
have any idea how to make the forms work in client/server mode. Mixed mode I
never tested but that is also possibleif it mean any difference. Another
question: as you see I use Swedish letters like ÅÄÖ which causes no problems
except when using the command-field in h2.When clicking a table in the left
column I get SELECT * FROM "Utbildningstillfällen" and when i run this I get
an errormessage" Table "Utbildningstillfällen" " not found. So I have to
change "ä" to "ä" and then it works.This problem can be new because I haven`t
discovered it before.Thank you Thomas for your immense work and that you could
use some time to my problem.Best regardsRiccard
From: Thomas Mueller
Sent: Tuesday, October 11, 2011 7:03 PM
To: [email protected]
Subject: Re: Problems with questionnaires when conecting OOBase to H2
Hi,
I'm sorry for the delay. I will not have the time to install OOBase myself and
test it, so my answer might not be helpful...
and the URL jdbc: H2:~test;MODE=HSQLDB which worked well.
To ensure this is not the problem, I suggest to use an absolute path, for
example jdbc:h2:/data/test;MODE=HSQLDB - but I know the chance this will solve
the problem is very small.
I guess to analyze the problem one would have to verify the SQL statements
generated by OOBase. To do that, you could use
jdbc:h2:/data/test;MODE=HSQLDB;TRACE_LEVEL_FILE=2
or
jdbc:h2:/data/test;MODE=HSQLDB;TRACE_LEVEL_FILE=3
and analyze the file /data/test.trace.db, which then contains all SQL
statements generated by OOBase.
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].
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.
