question on autcommit of transaction and database configuration

[Former Member]

I have a ase 12.5 with following setting on a dev server:

select into/bulkcopy/pllsort : true

ddl in tran: true

when run a pb app without autocommit setting. It is fine.

but on my production server, same db have different option setting:

select into/bulkcopy/pllsort : false

ddl in tran: false

then run same app, the transaction from pb app not commit, cause lot of lock and crash app.

So what the relationship between pb transaction autocommit attribute and sybase ase database dboptions setting?

[Former Member]

I think you need to change that setting in production to match development. Normally you can't run ddl and bcp commands within a transaction, this setting changes that.

You might have an open (uncommitted) update transaction which is where the locks are coming from.

[Former Member]

Hi Kent;

  FWIW: Check the "locking scheme) in development vs production. You may have page level in one DB vs row locking enabled in the other environment. This can make a world of difference in the locking conflicts when you run your PB application.

Regards ... Chris