Problem with dropping it into tomcat, tomcat would have the JTA/
persistence/JNDI for this to attach to.
I've reconstructed my maven build to build from CAS 3.3.3
I've created a second data source for the CAS persistence and updated
the ticket registry for spring 2.5, still getting an error that seems
to indicate the tables don't exist (still no tables in the database
either) there aren't any error indicating that the table build failed.
Error message:
2009-07-03 15:09:11,923 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
Starting cleaning of expired tickets from ticket registry at [Fri Jul
03 15:09:11 GMT 2009]
2009-07-03 15:09:12,407 ERROR [org.quartz.core.JobRunShell] - Job
DEFAULT.jobDetailTicketRegistryCleaner threw an unhandled Exception:
org
.springframework.scheduling.quartz.JobMethodInvocationFailedException:
Invocation of method 'clean' on target class [class
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner]
failed; nested exception is
org.springframework.dao.InvalidDataAccessApiUsageException:
org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
is not mapped [select t from TicketGrantingTicketImpl t]; nested
exception is java.lang.IllegalArgumentException:
org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
is not mapped [select t from TicketGrantingTicketImpl t]
at
org
.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean
$
MethodInvokingJob
.executeInternal(MethodInvokingJobDetailFactoryBean.java:269)
at
org
.springframework
.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool
$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: org.springframework.dao.InvalidDataAccessApiUsageException:
org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
is not mapped [select t from TicketGrantingTicketImpl t]; nested
exception is java.lang.IllegalArgumentException:
org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
is not mapped [select t from TicketGrantingTicketImpl t]
at
org
.springframework
.orm
.jpa
.EntityManagerFactoryUtils
.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:271)
at
org
.springframework
.orm
.jpa
.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:
120)
at
org
.springframework
.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:
212)
at
org
.springframework
.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)
at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:
189)
at
org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:
151)
at org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:311)
at org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:307)
at
org
.jasig
.cas
.ticket.registry.JpaTicketRegistry.getTickets(JpaTicketRegistry.java:
117)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun
.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
TicketRegistry.xml
<beans xmlns="http://www.springframework.org/schema/beans";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:p="http://www.springframework.org/schema/p";
xmlns:tx="http://www.springframework.org/schema/tx";
xmlns:jee="http://www.springframework.org/schema/jee";
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
http://www.springframework.org/schema/jee
http://www.springframework.org/schema/jee/spring-jee-2.5.xsd";>
<!-- JPA attached to jboss persistence unit -->
<bean id="ticketRegistry"
class="org.jasig.cas.ticket.registry.JpaTicketRegistry">
<constructor-arg index="0" ref="entityManagerFactory" />
</bean>
<jee:jndi-lookup id="entityManagerFactory" jndi-
name="java:CasPersistence"/>
<bean id="transactionManager"
class="org.springframework.transaction.jta.JtaTransactionManager" />
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
persistence.xml
<persistence xmlns="http://java.sun.com/xml/ns/persistence";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
"
version="1.0">
<persistence-unit name="CasPersistence" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:CAS</jta-data-source>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.SQLServerDialect"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
<property
name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
<property name="jboss.entity.manager.factory.jndi.name"
value="java:CasPersistence"/>
</properties>
</persistence-unit>
</persistence>
cas-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>CAS</jndi-name>
<connection-url>jdbc:sqlserver://devdb.conncoll.edu:
1433;databaseName=CAS</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</
driver-class>
<user-name>xxxxx</user-name>
<password>*****</password>
<check-valid-connection-sql>SELECT 1 FROM sysobjects</check-valid-
connection-sql>
<metadata>
<type-mapping>MS SQLSERVER2000</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
One idea I'd like to try, if anyone has the SQL script for the table
create I want to see if the persistence functions when the tables exist.
-Andrew
On Jun 24, 2009, at 10:20 PM, Scott Battaglia wrote:
> I'm not sure why your tables aren't being created. The typical
> reason is that the database user doesn't have the appropriate
> permissions. Can you drop the WAR file in a simple Tomcat instance
> just to see if it works from there? (its probably a pain in the butt
> to do that, but I'm not familiar enough with JBoss to tell you that
> something is wrong)
>
>
>
> On Wed, Jun 24, 2009 at 12:23 PM, Andrew Tillinghast <[email protected]
> > wrote:
> Ok, sorry to be confusing. Let me clarify.
>
> We're running on JBoss 5.1.0GA and for other applications we need
> JBoss rather then Tomcat, would prefer 5.X could possibly function
> under 4.2.x also seems like going 4.2 would just delay the issue.
>
> I've got CAS installed with OW, LDAP etc, but no persistence if I
> use the <bean id="ticketRegistry"
> class="org.jasig.cas.ticket.registry.DefaultTicketRegistry" /> the
> CAS service is working fine, actually deployed in production this
> way right now and working for the few hundred students that check
> email during the summer.
>
> We'll be "casifying" additional applications and use volume will
> increase as the summer end so we'll need High Availablity/Clustering
> so I'm attempting to establish persistence, I've reviewed the
> persistence overview here:
> http://www.ja-sig.org/wiki/display/CASUM/Service+Availability+Strategies
> and I've chosen to go with JPA because we have an existing
> clustered MS SQL server on our backend.
>
> I've followed through the steps in the JPA instructions here:
> http://www.ja-sig.org/wiki/display/CASUM/JpaTicketRegistry
>
> However, when attempting to follow those instructions CAS startup
> would fail with "Instantiation of bean failed; nested exception is
> java.lang.NoClassDefFoundError: org/springframework/jdbc/datasource/
> lookup/DataSourceLookup"
>
> This error came up even though I tried different datasources and I
> made sure that the proper jars were in my classpath. I tried using
> the SQLJDBC drivers and data source first and then also with the
> jtds ones. All of them came back with the DataSourceLookup error.
>
> Example of one of the datasource beans I tried:
> <bean id="dataSource"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource"
> p:driverClassName="net.sourceforge.jtds.jdbc.Driver"
>
> p:url="jdbc:jtds:sqlserver://devdb.conncoll.edu:1433;database=CAS;"
> p:username="xxxxxx"
> p:password="******" />
>
> After some more research I found information about connecting the
> JPA persistence to the JBoss JTA persistence. http://www.swview.org/node/214
> I changed my ticketRegistry.xml as per the my previous list posting.
> Now CAS starts error free and validates login but fails on creating
> the ticket when login is successful the text of the error leads me
> to think that the database connection is established but the tables
> aren't there when trying to save the ticket.
>
> Despite the error free startup I'm not seeing tables for CAS being
> created in the jboss databse (no error in CAS.log either.)
>
> CAS.log shows the following error on Clean, which is essentially the
> same error as ticket create:
>
> 2009-06-24 11:53:38,841 INFO
> [org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner]
> - Starting cleaning of expired tickets from ticket registry at [Wed
> Jun 24 11:53:38 EDT 2009]
> 2009-06-24 11:53:39,177 ERROR [org.quartz.core.JobRunShell] - Job
> DEFAULT.jobDetailTicketRegistryCleaner threw an unhandled Exception:
> org
> .springframework
> .scheduling.quartz.JobMethodInvocationFailedException: Invocation of
> method 'clean' on target class [class $Proxy292] failed; nested
> exception is
> org.springframework.dao.InvalidDataAccessApiUsageException:
> org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
> is not mapped [from TicketGrantingTicketImpl]; nested exception is
> java.lang.IllegalArgumentException:
> org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
> is not mapped [from TicketGrantingTicketImpl]
> at
> org
> .springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean
> $
> MethodInvokingJob
> .executeInternal(MethodInvokingJobDetailFactoryBean.java:269)
> at
> org
> .springframework
> .scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
> at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
> at org.quartz.simpl.SimpleThreadPool
> $WorkerThread.run(SimpleThreadPool.java:520)
> Caused by:
> org.springframework.dao.InvalidDataAccessApiUsageException:
> org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
> is not mapped [from TicketGrantingTicketImpl]; nested exception is
> java.lang.IllegalArgumentException:
> org.hibernate.hql.ast.QuerySyntaxException: TicketGrantingTicketImpl
> is not mapped [from TicketGrantingTicketImpl]
> at
> org
> .springframework
> .orm
> .jpa
> .EntityManagerFactoryUtils
> .convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:
> 271)
> at
> org
> .springframework
> .orm
> .jpa
> .DefaultJpaDialect
> .translateExceptionIfPossible(DefaultJpaDialect.java:120)
> at
> org
> .springframework
> .dao
> .support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:
> 212)
> ....
>
> I fully admit that I may be misreading the error, and that the JNDI/
> JTA/JPA connection might be failing and just not generating any
> warnings or error. While I am a reasonably skilled programer I am
> far from a JAVA guru.
> At this point I am begging for assistance with persistence I am not
> restricted to JPA as the solution it just seemed the most reasonable
> clustering solution for our environment with already having
> established an HA SQL server for our other apps on the same server.
>
> -Andrew
>
> On Jun 24, 2009, at 9:49 AM, Scott Battaglia wrote:
>
>> You're confusing me. ;-) What's the actual problem? Last time you
>> said the tables hadn't been created now you're saying the dataource
>> isn't working.
>>
>>
>>
>>
>> On Wed, Jun 24, 2009 at 9:44 AM, Andrew Tillinghast <[email protected]
>> > wrote:
>> I added that line, and I changed the JTA reference so that it's a
>> datasource, right now the CAS service starts without any errors and
>> it correctly authenticates the user, when the user successfully
>> logs in however CAS errors out with:
>>
>> 09:36:00,146 ERROR [[cas]] Servlet.service() for servlet cas threw
>> exception
>> java.lang.IllegalArgumentException: Unknown entity:
>> org.jasig.cas.ticket.TicketGrantingTicketImpl
>> at
>> org
>> .hibernate
>> .ejb
>> .AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:
>> 223)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>> at java.lang.reflect.Method.invoke(Unknown Source)
>> at org.springframework.orm.jpa.ExtendedEntityManagerCreator
>> $
>> ExtendedEntityManagerInvocationHandler
>> .invoke(ExtendedEntityManagerCreator.java:358)
>> at $Proxy298.persist(Unknown Source)
>> at org.springframework.orm.jpa.JpaTemplate
>> $5.doInJpa(JpaTemplate.java:268)
>> at
>> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:184)
>> at
>> org.springframework.orm.jpa.JpaTemplate.persist(JpaTemplate.java:266)
>> at
>> org
>> .jasig
>> .cas
>> .ticket.registry.JpaTicketRegistry.addTicket(JpaTicketRegistry.java:
>> 48)
>> at
>> org
>> .jasig
>> .cas
>> .CentralAuthenticationServiceImpl
>> .createTicketGrantingTicket(CentralAuthenticationServiceImpl.java:
>> 425)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>> at java.lang.reflect.Method.invoke(Unknown Source)
>> at
>> org
>> .springframework
>> .aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:
>> 307)
>> at
>> org
>> .springframework
>> .aop
>> .framework
>> .ReflectiveMethodInvocation
>> .invokeJoinpoint(ReflectiveMethodInvocation.java:182)
>> ....
>>
>> Here is my ticketRegistry,xml now:
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <beans xmlns="http://www.springframework.org/schema/beans";
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
>> xmlns:p="http://www.springframework.org/schema/p";
>> xmlns:tx="http://www.springframework.org/schema/tx";
>> xmlns:jee="http://www.springframework.org/schema/jee";
>> xsi:schemaLocation="http://www.springframework.org/schema/
>> beans
>> http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
>> http://www.springframework.org/schema/tx
>> http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
>> http://www.springframework.org/schema/jee
>> http://www.springframework.org/schema/tx/spring-jee-2.0.xsd";>
>>
>> <!-- JPA attached to jboss persistence unit -->
>> <bean id="ticketRegistry"
>> class="org.jasig.cas.ticket.registry.JpaTicketRegistry">
>> <constructor-arg index="0" ref="entityManagerFactory" />
>> </bean>
>>
>> <bean id="entityManagerFactory"
>> class
>> =
>> "org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
>> <property name="dataSource" ref="dataSource"/>
>> <property name="jpaVendorAdapter">
>> <bean
>> class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
>> <property name="showSql" value="true"/>
>> <property name="generateDdl" value="true" />
>> <property name="database" value="SQL_SERVER"/>
>> </bean>
>> </property>
>> <property name="jpaProperties">
>> <props>
>> <prop
>> key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
>> <prop key="hibernate.hbm2ddl.auto">update</prop>
>> <prop
>> key
>> =
>> "hibernate
>> .transaction
>> .manager_lookup_class
>> ">org.hibernate.transaction.JBossTransactionManagerLookup</prop>
>> <prop
>> key="hibernate.transaction.auto_close_session">true</prop>
>> <prop
>> key="hibernate.current_session_context_class">jta</prop>
>> <prop
>> key="hibernate.connection.release_mode">auto</prop>
>> </props>
>> </property>
>> </bean>
>>
>> <bean id="dataSource"
>> class="org.springframework.jndi.JndiObjectFactoryBean">
>> <property name="jndiName" value="java:/DefaultDS"></property>
>> </bean>
>>
>> <bean id="transactionManager"
>> class="org.springframework.transaction.jta.JtaTransactionManager">
>> <property name="transactionManagerName" value="java:/
>> TransactionManager" />
>> <property name="autodetectUserTransaction" value="false" />
>> </bean>
>>
>> <tx:annotation-driven transaction-manager="transactionManager"/>
>> <!-- TICKET REGISTRY CLEANER --> <bean
>> id="ticketRegistryCleaner"
>> class
>> =
>> "org
>> .jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner"
>>
>> p:ticketRegistry-ref="ticketRegistry" /> <bean
>> id="jobDetailTicketRegistryCleaner"
>> class
>> =
>> "org
>> .springframework
>> .scheduling.quartz.MethodInvokingJobDetailFactoryBean"
>> p:targetObject-ref="ticketRegistryCleaner"
>> p:targetMethod="clean" /> <bean
>> id="triggerJobDetailTicketRegistryCleaner"
>> class="org.springframework.scheduling.quartz.SimpleTriggerBean"
>>
>> p:jobDetail-ref="jobDetailTicketRegistryCleaner"
>> p:startDelay="20000" p:repeatInterval="5000000" /> <bean
>> id="scheduler"
>> class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
>> <property name="triggers"> <list>
>> <ref
>> local="triggerJobDetailTicketRegistryCleaner" /> </list>
>> </
>> property> </bean> </beans>
>>
>> At this point I have everything else working except persistence/
>> clustering any help at all would be great, or help figuring out why
>> the data source wouldn't work when I tried normal JPA instead of
>> the JTA connection.
>>
>>
>> -Andrew
>>
>
> --
> You are currently subscribed to [email protected] as:
> [email protected]
>
>
> To unsubscribe, change settings or access archives, see
> http://www.ja-sig.org/wiki/display/JSG/cas-user
>
> --
> You are currently subscribed to [email protected] as:
> [email protected]
> To unsubscribe, change settings or access archives, see
> http://www.ja-sig.org/wiki/display/JSG/cas-user
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
