Subject | Why does not apply insertion result. |
---|---|
Author | neodreamer@ymail.com |
Post date | 2011-01-25T08:45:03Z |
I work two isql instance with one database. ((A isql instance) and (B isql intance) is connected with test.fdb.)
A isql : Create table. (table name is "member")
B isql : Can see the table.(SHOW SCHEMA "member") (I know that DDL is committed automatically.)
A isql : Insert one record into the "member" table.
B isql : Cannot find any data on "member" table.( I cannot find data because It does not commit on A isql. I think... )
A isql : Run commit command.
B isql : Cannot find any data on "member" table. (WHY??)
B isql : Terminate and rerun instance. and connect to test.fdb. I can find date on "member" table.
A isql : Insert another record into the "member" table. And run the commit command.
B isql : Cannot find second data on "member" table. (WHY??)
B isql : Run the commit command.
B isql : Can find whole data on "member" table.
A isql : Create table. (table name is "member")
B isql : Can see the table.(SHOW SCHEMA "member") (I know that DDL is committed automatically.)
A isql : Insert one record into the "member" table.
B isql : Cannot find any data on "member" table.( I cannot find data because It does not commit on A isql. I think... )
A isql : Run commit command.
B isql : Cannot find any data on "member" table. (WHY??)
B isql : Terminate and rerun instance. and connect to test.fdb. I can find date on "member" table.
A isql : Insert another record into the "member" table. And run the commit command.
B isql : Cannot find second data on "member" table. (WHY??)
B isql : Run the commit command.
B isql : Can find whole data on "member" table.