Re: [Springframework-developer] Turning off autocommit in JBoss / Oracle datasource

[Rod J. <rod...@in...>]

Would be cool but when I last looked at it over a year ago it was scary
stuff. If anyone can do it, we can. Might be good to see how many people
want it... I would probably use it from time to time. Not too often though.

----- Original Message -----
From: "Dmitriy Kopylenko" <dko...@ru...>
To: <spr...@li...>
Sent: Thursday, May 13, 2004 12:19 AM
Subject: Re: [Springframework-developer] Turning off autocommit in JBoss /
Oracle datasource


> BTW, is there a possibility to create an abstraction for Oracle XMLType
> so the application code wouldn't have to deal with the low level JDBC
> code? Kinda like LOB support.
>
> Thomas, Juergen?
>
> Regards,
> Dmitriy.
>
>
> Levkovitch, Lidia wrote:
>
> >I think I've sent this to a wrong list before... Sorry!
> >=========================
> >Thanks to Rod and Colin for responses and advice, and big thanks to
Dmitriy
> >for on-site debugging!
> >
> >My problem was actually in my own code. Because I am using some special
> >features of Oracle 9 (namely, XMLType), I have to get a connection and
> >create my own prepared statements with it. I was getting this connection
> >from my DAO's datasource (getDs().getConnection()), instead of using
> >DataSourceUtils.getConnection(getDs()) as the documentation instructs. As
> >soon as I changed that, all my transactions started to work perfectly!
> >
> >Now I understand that I don't really have to change the autocommit
property,
> >but in case someone is interested, here is what I found out (and it isn't
> >much!). According to JBoss forums, autocommit is SUPPOSED to be off with
my
> >configuration (which is really just the default Oracle config file for
> >JBoss).
> >Oracle's instructions for creating a datasource file do not discuss
> >autocommit at all, and it seems that there's no property in the
datasource
> >configuration that controls it; one can only change it programmatically.
> >I guess in my case it is off by default, but then something switches it
on
> >as JBoss starts up with whatever services I have set up there. Not that
it
> >bothers me now, since Spring takes care of everything.
> >
> >Once again - thanks, everyone!
> >Lidia
> >
> >-----Original Message-----
> >Folks,
> >
> >I am using a datasource to have my Spring DAOs connect to Oracle
database.
> >Apparently, with my set up, autocommit is turned on, and this is not what
I
> >need! I have actually put this line of code inside one of the DAOs'
> >afterPropertiesSet() method:
> >logger.debug("autocommit is " + getDs().getConnection().getAutoCommit());
> >and this prints "autocommit is true".
> >
> >Is there a way to configure my datasource so that autocommit is set to
> >false? I am using JBoss 3.2.1 with Oracle 9.2. In one of JBoss forums it
> >actually.
> >
> >The datasource is defined in myapp-ds.xml file like this:
> >(this is based on the example that came with JBoss) <datasources>
> >  <local-tx-datasource>
> >    <jndi-name>myapp-ds</jndi-name>
> >
> > <connection-url>jdbc:oracle:thin:@[my database
> >name]</connection-url>
> >    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
> >    <user-name>[my user name]</user-name>
> >    <password>[my password]</password>
> >    <min-pool-size>3</min-pool-size>
> >    <max-pool-size>30</max-pool-size>
> >    <blocking-timeout-millis>3000</blocking-timeout-millis>
> >    <idle-timeout-minutes>15</idle-timeout-minutes>
> >
>
><exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleE
x
> >ceptionSorter</exception-sorter-class-name>
> >  </local-tx-datasource>
> ></datasources>
> >
> >All my DAO objects use the dataSource bean which is defined in my
> >application context as follows: <bean id="dataSource"
> >class="org.springframework.jndi.JndiObjectFactoryBean"
> >singleton="true" lazy-init="default" autowire="default"
> >dependency-check="default">
> >- <property name="jndiName">
> >  <value>myapp-ds</value>
> >  </property>
> >- <property name="resourceRef">
> >  <value>true</value>
> >  </property>
> >  </bean>
> >
> >Thank you very much!
> >Lidia
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by Sleepycat Software
> >Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to
> >deliver higher performing products faster, at low TCO.
> >http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3
> >_______________________________________________
> >Springframework-developer mailing list
> >Spr...@li...
> >https://lists.sourceforge.net/lists/listinfo/springframework-developer
> >
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Sleepycat Software
> Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to
> deliver higher performing products faster, at low TCO.
> http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer