Question Re: Isolation Level Logging in Technology Q&A

Isolation Level Logging

Former Member — Fri, 25 Jan 2013 11:46:22 GMT

We are facing the following problem. Our sybase database log file gets exponentially big because of isolation level logging on every call to query a tables via JPA. Is there any switch available in Sybase which can be used as a part of connection parameters to suppress logging of isolation level.

Re: Isolation Level Logging

Breck_Carter — Sun, 27 Jan 2013 16:59:30 GMT

What version and build of SQL Anywhere are you using?

What exactly do you mean by "isolation level logging"? I've never seen that term before, and there are zero Google hits (well, one hit, your question).

Re: Isolation Level Logging

justin_willey — Mon, 28 Jan 2013 06:08:09 GMT

Do you mean "request level logging" ?

Re: Isolation Level Logging

reimer_pods — Mon, 28 Jan 2013 08:21:22 GMT

If it is auditing you want to disable for a connection, have a look at the docs: http://dcx.sybase.com/index.html#1201/en/dbadmin/dboptions-s-4586690.html

Re: Isolation Level Logging

jeff_albion — Mon, 28 Jan 2013 10:05:56 GMT

I also think you should provide more details about your 'query through JPA' - is that 'Java Persistence API'? Are you using Hibernate or a similar framework?

Where are you currently seeing the logging of an 'isolation level' in your application?

Re: Isolation Level Logging

VolkerBarth — Mon, 28 Jan 2013 11:59:30 GMT

...at least these comments all count as "high-level guessing":)

Re: Isolation Level Logging

Breck_Carter — Mon, 28 Jan 2013 17:32:10 GMT

Five different people respond, are met with silence... that merits at least one down vote IMO.