Helen Borrie wrote:

>>- If I run the script that creates the tables in Jaybird, then I can add
>>duplicates with IBOConsole, with my java application and with isql.exe.
>>- If I run the script to create the tables in isql.exe, I cannot add
>>duplicates, whether I'm using isql.exe, my Java application or IBOConsole.
>>
>>Has anyone else noticed something like this?
>>
>>I am using Firebird 1.5.1 on Win2K. I am also Jaybird 1.5.1 (although
>>the manifest says "Implementation-Version: 1.5.0JDK_1.4 (build:
>>CVSTag=HEAD date=20040916 2348)");
>>
>>
>
>Rule number one is DON'T TRY TO PERFORM DML ON AN UNCOMMITTED OBJECT!! The
>results will be at best, unpredictable and, often, will cause data to be
>logically corrupted.
>
>
>

Ok, let me show my ignorance, here. :-) What is DML?

>The difference in behaviour you observe is probably due to Jaybird using
>ServerAutocommit on each statement; whereas you are trying to run a script
>in isql without autoddl.
>
>You can force isql to do ServerAutocommit on the DDL statements *only* by
>starting the script with SET AUTODDL ON; Actually, I never rely on autoddl
>- probably just superstition - so I explicitly call COMMIT on any object in
>the rare event that I want to follow up a DDL operation with a DML
>operation on the object.
>
>
>

So you're saying that after each statement, I should add a "commit"?
Whenever I put acommit in my sql code, I get an answer from jaybird
saying that I should have a valid transaction. I guess there's some
setup that needs to occure on the Java side before I can use this properly.

>FYI, SET AUTODDL ON forces isql to treat DDL statements in scripts the same
>way it treats interactive DDL commands: it creates a discrete transaction
>for each DDL operation with the equivalent of Jaybird's ServerAutocommit.
>
>Don't forget to commit your DML statements.
>
>
>

Sorry, I have no idea what you are talking about, here. :-( I'm pretty
new to Firebird. It seems like I should know what DML, DDL,
ServerAutocomit and all that good stuff is. However, it looks like I'm
much close to dunce than to guru...

L