Alessandro Colantoni wrote:
I'm using Microsoft sql server and not MySQL.

Sorry, I can't read. :-)

Happy to Know that is not an Ojb problem, so I have just to fix on my code.
Martin Post has me make to think if I have to configure something in repository-database.xml.
that's my jdbc-connection-descriptor :
<jdbc-connection-descriptor jcd-alias="default"
default-connection="true"platform
="MsSQLServer" jdbc-level="2.0" driver="
com.microsoft.jdbc.sqlserver.SQLServerDriver" protocol="jdbc" subprotocol="
microsoft:sqlserver"
dbalias="//walqasrv01:1433;DatabaseName=trayectorias"username
="steria" password="filemon" eager-release="false"
batch-mode="false"useAutoCommit
="0" ignoreAutoCommitExceptions="false">

I think you should give the default useAutoCommit="2" a try since you were using explicit transaction handling in your code.

With mode 0 you are dependent on the auto-commit state from SQL Server,
which I would assume is default ON since your programmatic rollback
did not happen.

See also http://db.apache.org/ojb/docu/guides/repository.html#useAutoCommit

Regards,
 Martin

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to