Hi Andrew,
> I would have thought that I could control this on a connection by
> connection bases, however whenever I try to set a connection that is
> opened in Basic with CONNECTION.setAutoCommit(False) I receive the error
> - This call is not allowed when sharing connections.
>
> First question I open the connections with a fairly standard peice of code
> conn =
> CreateUnoService("com.sun.star.sdb.DatabaseContext").getByname("imgCatelogue").getConnection("",
>
> "" )
> Is there something I should be doing different with the getconnection
> call, so that I can change THIS connection to autocommit=false.
Try getIsolatedConnection instead of getConnection. The latter only
creates a connection proxy, which shares the real connection with all
other proxies obtained via the same method.
> Second question - Is there someway to make this database autocommit by
> default.
Nope, sorry.
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
