Craig
It's possible that DBNavigator is getting confused over InstantDB's lack of
a schema mechanism. However it still seems to be generating valid sql. It
might be worth getting a log of InstantDB activity to see if it is accepting
SQL commands from DBNavigator.
If you can issue your own SQL to the database then try:
SET EXPORT "mylog.log" TRACE 6
or alternatively, edit the .prp file and set:
traceFile=mylog.log
traceLevel=6
Regards
Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Craig <cwynn@ndak.net>
To: instantdb@enhydra.org <instantdb@enhydra.org>
Date: 01 August 2000 06:28
Subject: InstantDB: DB2 vs InstantDB using DBNavigator?
>DBNavigator is a bean that is used along with Select another bean that
>comes with Visualage For Java.
>InstantDB would be my 1st choice if I could either get it to work with
>DBNavigator and Select or if I thought I could write my own DB
>navigation tools. As it is I have no choice but to use DB2. DB2 works
>and InstantDB only partially works using these two VAJ IDE beans.
>
>I can get connected (the job of the Select bean) but only the
>next,previous,first,last buttons on DBNavigator work the
>insert,delete,and update features do not work.
>
>The Select Bean generates the select statement.
>The generated select statement for InstandDB is: SELECT * FROM
>"customer"
>The generated select statement for DB2 is : SELECT * FROM CRAIG.CUSTOMER
>
>CRAIG is a schema that is part of the required DB2 hierarchy for
>generating a table.
>
>Do you suppose that because InstantDB does not have a schema identifier
>it's causing DBNavigator to fail?
>
>craig
>
>
>
>---------------------------------------------------------------------------
--
>To unsubscribe from this mailing list, send email to majordomo@enhydra.org
>with the text "unsubscribe instantdb" in the body of the email.
>If you have other questions regarding this mailing list, send email to
>the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|