Re: UnsupportedOperationException when using CAS JDBC Authentication Handler

 Hi Scott,

thank you for the hint.
The correct declaration of the datasource block for an 
OracleDateSource looks like this:

<bean id="dataSource" class="oracle.jdbc.pool.OracleDataSource
">
  <property name="driverType">
    <value>oracle.jdbc.driver.OracleDriver</value>
  </property>
  <property name="URL">
    <value>jdbc:oracle:thin:@127.0.0.1
:1522:ora817</value>
  </property>
  <property name="user">
    <value>test_user</value>
  </property>
  <property name="password">
    <value>test1</value>
  </property>
</bean>

Regards,
Heiko

2006/12/11, Scott Battaglia <scott.battaglia-Re5JQEeQqe8AvxtiuMwx3w@xxxxxxxxxxxxxxxx >:

The data source that you are attempting to use does not support the method getConnection(username,  password).  You would need to try using another data source (i.e. maybe Oracle's specific data source).

-Scott

On 12/11/06, Heiko < lodhur-gM/Ye1E23mwN+BqQ9rBEUg@xxxxxxxxxxxxxxxx> wrote:

Hi,

I'm tried to use the CAS JDBC Authentication Handler and
changed the deployerConfigContext.xml like described at

http://www.helios-technologies.com/wiki/en/CAS_JDBC_Authentication_Handler_Setup

Here's my the content of my deployerConfigContext.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC  "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd ">
<beans>
    <bean id="authenticationManager"
          class="org.jasig.cas.authentication.AuthenticationManagerImpl">
      <property name="credentialsToPrincipalResolvers">
        <list>
          <bean class=" org.jasig.cas.authentication.principal.UsernamePasswordCredentialsToPrincipalResolver" />
          <bean class="org.jasig.cas.authentication.principal.HttpBasedServiceCredentialsToPrincipalResolver" />
        </list>
      </property>

      <property name="authenticationHandlers">
        <list>
          <bean class="org.jasig.cas.authentication.handler.support.HttpBasedServiceCredentialsAuthenticationHandler " />
          
          <bean id="BindModeSearchDatabaseAuthenticationHandler"
                class="org.jasig.cas.adaptors.jdbc.BindModeSearchDatabaseAuthenticationHandler">
            <property name="dataSource" ref="dataSource" />
          </bean>
        </list>
      </property>
    </bean>
    
    <bean id="dataSource" class=" org.apache.commons.dbcp.BasicDataSource">
      <property name="driverClassName">
        <value>oracle.jdbc.driver.OracleDriver</value>
      </property>
      <property name="url">
        <value>jdbc:oracle:thin:@127.0.0.1:1522:oracle817</value>
      </property>
      <property name="username">
        <value>test_user</value>
      </property>
        <property name="password">
      <value>test1</value>
        </property>
    </bean>
</beans>

The the additional libs (cas-server-jdbc-3.0.5.jar , commons-dbcp-1.2.1.jar, commons-pool-1.3.jar
commons-collections-3.2.jar and the Oracle JDBC driver) are present in the WEB-INF/lib directory
of CAS.

But if I try to log on I get following error:

2006-12-11 18:07:15,305 ERROR [ org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/cas].[cas]] - <Servlet.service() for servlet cas threw exception>
java.lang.UnsupportedOperationException
    at org.apache.commons.dbcp.PoolingDataSource.getConnection (PoolingDataSource.java:116)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:554)
    at org.jasig.cas.adaptors.jdbc.BindModeSearchDatabaseAuthenticationHandler.authenticateUsernamePasswordInternal (BindModeSearchDatabaseAuthenticationHandler.java:36)
    at org.jasig.cas.authentication.handler.support.AbstractUsernamePasswordAuthenticationHandler.authenticate(AbstractUsernamePasswordAuthenticationHandler.java:58)
    at org.jasig.cas.authentication.AuthenticationManagerImpl.authenticate(AuthenticationManagerImpl.java:79)
    at org.jasig.cas.CentralAuthenticationServiceImpl.createTicketGrantingTicket(CentralAuthenticationServiceImpl.java :282)
    at org.jasig.cas.web.flow.AuthenticationViaFormAction.submit(AuthenticationViaFormAction.java:116)
    ... and so on
    
Where is my mistake?

(I use Tomcat 5.5.20 with Java 1.5.0_06)

Regards,
Heiko

_______________________________________________
Yale CAS mailing list
cas-c5E7yoNEsvRIM2btvs0Z1A@xxxxxxxxxxxxxxxx
http://tp.its.yale.edu/mailman/listinfo/cas

_______________________________________________
Yale CAS mailing list
cas-c5E7yoNEsvRIM2btvs0Z1A@xxxxxxxxxxxxxxxx
http://tp.its.yale.edu/mailman/listinfo/cas