[midPoint] MySQL configuration for 3.0

[Viliam Repan]

Hi Deepak,

datasource should work, I currently don't have time to test it on my 
computer against MySQL, but configuration looks fine to me.
 From what I can see there is a configuration problem in your 
application server.

Invocation of init method failed; nested exception is
javax.naming.NameNotFoundException: Name [jdbc/mysql] is not bound in
this Context. Unable to find [jdbc].

If it is tomcat maybe resource link to this datasource is missing in 
context.xml or something like that...

Best regards,

Vilo


On 26.08.2014 10:39, Deepak Natarajan wrote:
> Hi -
>
> I have been trying to update my MySQL configuration from 2.3 to fit with
> 3.0 since I noticed that the relevant documentation has changed as well.
>
> Question : Is the MySQL configuration not relying on the new data source
> defined in Tomcat?
>
> https://wiki.evolveum.com/display/midPoint/Repository+Configuration
>
> I have the Resource defined as shown :
>
>      <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
>          username="x" password="x"
>          url="jdbc:mysql://localhost:3306/midpoint"
>          driverClassName="com.mysql.jdbc.Driver"
>          accessToUnderlyingConnectionAllowed="true"
>          initialSize="5" maxWait="5000"
>          maxActive="30" maxIdle="5"
>          validationQuery="select id from m_system_configuration"
>          poolPreparedStatements="true"/>
>
> And the corresponding configuration in config.xml :
>
>          <repository>
>             
> <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
>              <embedded>false</embedded>
>             
> <hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointMySQLDialect</hibernateDialect>
>              <hibernateHbm2ddl>validate</hibernateHbm2ddl>
>              <dataSource>java:comp/env/jdbc/mysql</dataSource>
>          </repository>
>
> But this is failing.
>
>
> 014-08-26 08:27:43,408 [RMI TCP Connection(2)-127.0.0.1] ERROR
> (org.springframework.web.context.ContextLoader): Context initialization
> failed
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'repositoryService' defined in class path resource
> [ctx-configuration.xml]: Initialization of bean failed; nested exception
> is org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'sessionFactory' defined in URL
> [jar:file:/Users/dnataraj/dev/midpoint/gui/admin-gui/target/midpoint/WEB-INF/lib/repo-sql-impl-3.0.jar!/ctx-repository-session.xml]:
> Initialization of bean failed; nested exception is
> org.springframework.beans.factory.BeanExpressionException: Expression
> parsing failed; nested exception is
> org.springframework.expression.spel.SpelEvaluationException:
> EL1021E:(pos 14): A problem occurred whilst attempting to access the
> property 'dataSource': 'Unable to access property 'dataSource' through
> getter'
>          ... 73 common frames omitted
> Caused by: java.lang.reflect.InvocationTargetException: null
>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.7.0_45]
>          at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[na:1.7.0_45]
>          at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_45]
>          at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45]
>          at
> org.springframework.expression.spel.support.ReflectivePropertyAccessor$OptimalPropertyAccessor.read(ReflectivePropertyAccessor.java:495)
> ~[spring-expression-3.1.0.RELEASE.jar:3.1.0.RELEASE]
>          ... 74 common frames omitted
> Caused by: org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'jndiDataSource' defined in URL
> [jar:file:/Users/dnataraj/dev/midpoint/gui/admin-gui/target/midpoint/WEB-INF/lib/repo-sql-impl-3.0.jar!/ctx-repository-session.xml]:
> Invocation of init method failed; nested exception is
> javax.naming.NameNotFoundException: Name [jdbc/mysql] is not bound in
> this Context. Unable to find [jdbc].
>
> However, I see that the MySQL configuration looks different here :
>
> https://wiki.evolveum.com/display/midPoint/MySQL
>
> Which does not use the new DS - and this is what I had earlier and it works.
>

-- 
Ing. Viliam Repáň
Evolveum, s.r.o.

tel: +421 910 797978
mail: vilo.repan at evolveum.com