hi,
     i am using mysql as a syncope internal database

my *persistence.properties *file:

jpa.driverClassName=com.mysql.jdbc.Driver
jpa.url=jdbc:mysql://localhost:3306/syncope1.2?characterEncoding=UTF-8
jpa.username=root
jpa.password=spectrum
jpa.dialect=org.apache.openjpa.jdbc.sql.MySQLDictionary
jpa.pool.validationQuery=SELECT 1
#note: other connection pool settings can also be configured here, see
persistenceContext.xml
quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
quartz.sql=tables_mysql_innodb.sql
audit.sql=audit_mysql_innodb.sql
database.schema= 

my *console.properties*

scheme=http
host=localhost
port=9080
rootPath=/syncope/rest/

context.xml:
<Resource name="jdbc/syncopeDataSource" auth="Container"
type="javax.sql.DataSource"
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
          testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1"
validationInterval="30000"
          maxActive="100" minIdle="2" maxWait="10000" initialSize="2"
removeAbandonedTimeout="20000"
          removeAbandoned="true" logAbandoned="true" suspectTimeout="20000"
          timeBetweenEvictionRunsMillis="5000"
minEvictableIdleTimeMillis="5000"         
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
          username="root" password="spectrum"
driverClassName="com.mysql.jdbc.Driver"
         
url="jdbc:mysql://localhost:3306/syncope1.2?characterEncoding=UTF-8"/>

environment:
windows 8
apache tomcat 7.0.55




--
View this message in context: 
http://syncope-user.1051894.n5.nabble.com/Error-while-deploying-1-2-0-m1-tp5707684p5707693.html
Sent from the syncope-user mailing list archive at Nabble.com.

Reply via email to