Atomikos Forum

JTA Transactions with Atomkios in Tomcat 5.5  issues

Hi all

  I am trying to configure JTA Transactions with Atomkios in Tomcat 5.5 with jndi support
    I am using spring,jpa+hybernate
 when i m trying to access my database, i am getting the error like this

    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
    org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
    org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:572)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
    com.evolvus.springsecurity.impl.CustomJdbcDaoImpl.loadUsersByUsername(CustomJdbcDaoImpl.java:78)
    org.springframework.security.core.userdetails.jdbc.JdbcDaoImpl.loadUserByUsername(JdbcDaoImpl.java:152)
    com.evolvus.springsecurity.impl.UsernamePasswordAuthenticationProvider.authenticate(UsernamePasswordAuthenticationProvider.java:27)
    org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:120)
    org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:48)
    com.evolvus.springsecurity.impl.LoginAuthenticationFilter.attemptAuthentication(LoginAuthenticationFilter.java:38)
    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:109)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

  my config.xml
 
 

    <beans: bean id="dataSource"
      class="org.springframework.jndi.JndiObjectFactoryBean" >
      <beans: property name="jndiName">
      <beans:value>java:comp/env/jdbc/welcome</beans:value>
      </beans: property> 
    </beans: bean>
    and i configure data source in tomcat5.5/config/context.xml     
 

      <Resource name="jdbc/welcome" 
        auth="Container"
        type="com.atomikos.jdbc.AtomikosDataSourceBean"
        factory="com.atomikos.tomcat.BeanFactory"
        uniqueResourceName="jdbc/myDB"
        xaDataSourceClassName="org.apache.derby.jdbc.EmbeddedXADataSource"
        maxPoolSize="3"
        minPoolSize="1"
        xaProperties.databaseName="payhub"
        xaProperties.url="jdbc\:mysql\://devserver\:3306/payhub"
        />           

and in my application web.xml is
 

    <resource-ref>
      <description>PaymentsDatabase</description>
      <res-ref-name>jdbc/welcome</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      <res-sharing-scope>Shareable</res-sharing-scope>
    </resource-ref>

 
what mistake i have done here?
johnabraham Send private email
Wednesday, November 24, 2010
 
 
http://db.apache.org/derby/docs/10.1/publishedapi/org/apache/derby/jdbc/EmbeddedXADataSource.html

Your Derby datasource does not have a setter for 'url'. You have to configure it differently - pls check the jdbc/xa samples in the current version downloadable from our site (it uses Derby).

HTH
Guy Pardon Send private email
Wednesday, November 24, 2010
 
 
but here i am using  mysql datasource.. is there is any difference between using derby and mysql
johnabraham Send private email
Thursday, December 02, 2010
 
 
Your config states:

xaDataSourceClassName="org.apache.derby.jdbc.EmbeddedXADataSource"

So you are using Derby, not MySQL...
Guy Pardon Send private email
Monday, December 06, 2010
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics