<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi
</p>
<p>it has been a while but I had the same setup and error while upgrading.
</p>
<p>As far as I remember this did the trick:</p>
<ul>
<li>setup a new DB (the schemas aren't compatible)</li>
<li>download jdbc-driver and save to any location (to explicitly name it for ninja-tool)
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a class="moz-txt-link-freetext" href="https://downloads.mariadb.com/Connectors/java/connector-java-2.2.5/mariadb-java-client-2.2.5.jar" moz-do-not-send="true">https://downloads.mariadb.com/Connectors/java/connector-java-2.2.5/mariadb-java-client-2.2.5.jar</a>
</pre></li>
<li><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">use ninja-3.2.7.jar out of midpoint-3.8's sources to export the 3.2.7-Objects</p></li>
<ul>
<li><pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">java -Dloader.path=/opt/midpoint/mariadb-java-client-2.2.5.jar -jar midpoint-3.8/lib/ninja-3.7.2.jar -m /opt/midpoint/midpoint-3.7.2-home -U 'jdbc:mariadb://localhost:3306/midpoint' -u 'midpoint' -p '<pw>' export -O midpoint-pre-v3_8.zip -z -l 4`
</pre></li>
</ul>
</ul>
<ul>
<li>start your new mP3.8-Instance with new DB (use provided sql-script for initial db-setup like in any new installation beforehand)</li>
</ul>
<ul>
<li>then import the Objects using ninja.jar out of midpoint 3.8's sources<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p></li>
<ul>
<li><pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><style type="text/css"></style><style type="text/css">p, li { white-space: pre-wrap; }</style>java -Dloader.path=/opt/midpoint/mariadb-java-client-2.2.5.jar -jar midpoint-3.8/lib/ninja.jar -m /opt/midpoint/midpoint-3.7-home -U 'jdbc:mariadb://localhost:3306/midpoint38' -u 'midpoint' -p '<pw>' import -i midpoint-pre-v3_8.zip -z -l 4`
</pre></li>
</ul>
</ul>
<style type="text/css"> p, li { white-space: pre-wrap; }
</style>
<p>
</p>
<p>good luck!</p>
<p>Fabian</p>
<p>
</p>
<div class="moz-cite-prefix">Am 13.11.18 um 15:14 schrieb Nico:<br>
</div>
<blockquote type="cite"
cite="mid:CAGh9kZxLe39Z7M4ESSWx5q3Y_Lpo6Op39xPvytHEtcwcSzbKbQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Hello everyone,</div>
<div><br>
</div>
<div>i am trying to update an existing midpoint
instance 3.7.2 with mariaDB to 3.8.</div>
<div><br>
</div>
<div>My installation path is:
/opt/idm/midpoint-3.7.2/ <br>
</div>
<div>And my MIDPOINT_HOME is:
/opt/idm/midpoint-3.7.2/var</div>
<div>Java 1.8.0.191 is installed</div>
<div><br>
</div>
<div>config.xml looks like:</div>
<div> <repository><br>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><br>
<database>mariadb</database><br>
<jdbcUsername>midpoint</jdbcUsername><br>
<jdbcPassword>PASSWORD</jdbcPassword><br>
<jdbcUrl>jdbc:mariadb://HOST:3306/midpoint?characterEncoding=utf8</jdbcUrl><br>
</repository><br>
</div>
<div><br>
</div>
<div>Command: /opt/idm/midpoint/bin/ninja.sh -v
count</div>
<div>(Like said in the upgrade documentation step
1.c)</div>
<div><br>
</div>
<div>The Error says:</div>
<div>2018-11-13 14:58:09,518 [main] INFO (SYSOUT):
Initializing repository using midpoint home<br>
Unexpected exception occurred (class
org.springframework.beans.factory.UnsatisfiedDependencyException),
reason: Error creating bean with name
'repositoryService': Unsatisfied dependency
expressed through field 'sequenceHelper'; nested
exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'sequenceHelper':
Unsatisfied dependency expressed through field
'objectUpdater'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'objectUpdater':
Unsatisfied dependency expressed through field
'closureManager'; nested exception is
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'orgClosureManager':
Invocation of init method failed; nested exception
is org.hibernate.TransactionException: Transaction
not successfully started<br>
Exception stack trace:<br>
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'repositoryService':
Unsatisfied dependency expressed through field
'sequenceHelper'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'sequenceHelper':
Unsatisfied dependency expressed through field
'objectUpdater'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'objectUpdater':
Unsatisfied dependency expressed through field
'closureManager'; nested exception is
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'orgClosureManager':
Invocation of init method failed; nested exception
is org.hibernate.TransactionException: Transaction
not successfully started<br>
...</div>
<div>...</div>
<div>...</div>
<div>Caused by: org.hibernate.TransactionException:
Transaction not successfully started<br>
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:202)<br>
...</div>
<div><br>
</div>
<div> I enabled the sql query log. But there is not
one SQL which is getting executed. </div>
<div>Has someone managed to upgrade from 3.7.2 with
mariaDB? Or had someone the same problem?</div>
<div><br>
</div>
<div>Kind Regards</div>
<div>Nico Pätzelt<br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com" moz-do-not-send="true">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" moz-do-not-send="true">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
--
Fabian Bosch, Solutions-Engineer
DAASI International GmbH
Europaplatz 3
D-72072 Tübingen
Germany
phone: +49 7071 407109-0
fax: +49 7071 407109-9
email: <a class="moz-txt-link-abbreviated" href="mailto:fabian.bosch@daasi.de" moz-do-not-send="true">fabian.bosch@daasi.de</a>
web: <a class="moz-txt-link-abbreviated" href="http://www.daasi.de" moz-do-not-send="true">www.daasi.de</a>
Sitz der Gesellschaft: Tübingen
Registergericht: Amtsgericht Stuttgart, HRB 382175
Geschäftsleitung: Peter Gietz</pre>
</body>
</html>