Hello,
here is the complete stacktrace
Code:
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction;
nested exception is javax.persistence.PersistenceException: org.hibernate.TransactionException: JDBC begin failed:
org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:382)
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(
AbstractPlatformTransactionManager.java:371)
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(
TransactionAspectSupport.java:335)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
$Proxy52.loadUserByUsername(Unknown Source)
org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:
86)
org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(
AbstractUserDetailsAuthenticationProvider.java:129)
org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:130)
org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.
java:48)
org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:148)
org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.
java:48)
org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(
UsernamePasswordAuthenticationFilter.java:97)
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(
AbstractAuthenticationProcessingFilter.java:199)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.
java:79)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
db.properties
Code:
# the driver class which is used to access the db
# db.driver=org.h2.Driver
db.driver=com.mysql.jdbc.Driver
# the URL to the database
db.url=jdbc:mysql://somedomain.com:3306/name_db?characterEncoding\=UTF-8
# technical username for database
db.username=changed
# password for technical user
db.password=changed
# JPA Vendor adapter database dialect
db.dialect=MYSQL
# setting for Hibernate what to do with the database schema
# db.hibernate.hbm2ddl.auto=create-drop
db.hibernate.hbm2ddl.auto=update
# The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit.
db.maxActive=30
# The maximum number of connections that can remain idle in the pool, without extra ones being released, or negative for no limit.
db.maxIdle=30
#---------------------------------------------
# Settings for Mart db |
#---------------------------------------------
# the driver class which is used to access the db
# mart.db.driver=org.h2.Driver
mart.db.driver=com.mysql.jdbc.Driver
# the URL to the database
mart.db.url=jdbc:mysql://somedomain.com:3306/vw?characterEncoding=UTF-8
# technical username for database
# mart.db.username=
mart.db.username=dev
# password for technical user
# mart.db.password=
mart.db.password=dev
# JPA Vendor adapter database dialect
# mart.db.dialect=H2
mart.db.dialect=MYSQL
# setting for Hibernate what to do with the database schema
# mart.db.hibernate.hbm2ddl.auto=create-drop
mart.db.hibernate.hbm2ddl.auto=create-drop
# The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit.
mart.db.maxActive=30
# The maximum number of connections that can remain idle in the pool, without extra ones being released, or negative for no limit.
mart.db.maxIdle=30
# Sets the default limitation of result sets for mart queries.
# This setting can be overwritten by setting maxResult property in DatasourceTemplate.
mart.db.defaultMaxResults=500
The MySQL_dynamicTime.properties contains some special sql which can't be the probleme I think
e.g.
Code:
today=SELECT MIN(date_id), MAX(date_id) FROM date_dim WHERE date_id \= \:today;
yesterday=SELECT MIN(date_id), MAX(date_id) FROM date_dim WHERE date_id \= DATE_ADD(\:today, INTERVAL -1 DAY);
500 Error, TransactionException: JDBC begin failed
Reply With Quote
