<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic External database select and insert in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/external-database-select-and-insert/m-p/97952#M67480</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi experts !&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have already post this but on the developer forum and it was not the good, so I post my question.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;And now, I have not one but two questions (sorry) :&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="color:#400080;"&gt;First :&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;So, I have designed a simple process under activiti (start event –&amp;gt; taskuser1 –&amp;gt; taskuser2 –&amp;gt; end event).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;In the taskuser1, I have a form with some form properties.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;When I deploy my process under activiti explorer, it works fine with the form.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;But, my next step is : take data from an external mysql database and display it into a form property.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;How can I do that ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I tried to add in Preferences –&amp;gt; Data Management –&amp;gt; Connectivity –&amp;gt; Driver Definitions my jdbc driver and it's ok.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;But when I right click on my project in the activiti Explorer and choose New –&amp;gt; Other –&amp;gt; Connection Profile and try to add a connection, It doesn't work.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Is it the best way to take data from an external database and inject them into a form ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I try since yesterday but no way to do that.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;(I specify that I want use H2 and an external database (mysql))"&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="color:#400080;"&gt;Second : &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;In a other way, I try to populate my external database with the data filled by the user in the usertask1 form but I don't know how do that.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I think I should connect my external mysql database with a connection profil but like said in the first point, it seems not work fine (oing failed).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;But after, how do that ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I don't really understand the userguide about this point.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;End of my questions.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks for your responses &lt;img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;(I am sorry if this questions and so responses very simple, but I a very very beginner in activiti and not really good in development)&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 17 Jul 2012 15:03:50 GMT</pubDate>
    <dc:creator>pkruch</dc:creator>
    <dc:date>2012-07-17T15:03:50Z</dc:date>
    <item>
      <title>External database select and insert</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/external-database-select-and-insert/m-p/97952#M67480</link>
      <description>Hi experts !I have already post this but on the developer forum and it was not the good, so I post my question.And now, I have not one but two questions (sorry) :First &lt;IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" /&gt;o, I have designed a simple process under activiti (start event –&amp;gt; taskuser1 –&amp;gt; taskuser2 –&amp;gt; end event).In the taskuser1,</description>
      <pubDate>Tue, 17 Jul 2012 15:03:50 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/external-database-select-and-insert/m-p/97952#M67480</guid>
      <dc:creator>pkruch</dc:creator>
      <dc:date>2012-07-17T15:03:50Z</dc:date>
    </item>
    <item>
      <title>Re: External database select and insert</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/external-database-select-and-insert/m-p/97953#M67481</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;If you want to have external pre-data filled in into a form, you'll have to make activiti aware of your services that access that data. You can follow 2 approaches:&lt;/SPAN&gt;&lt;BR /&gt;&lt;UL&gt;&lt;LI&gt;Create services that epos the data you need. Wire in your services (spring e.g..) to make them available in Activiti-expressions. see &lt;A href="http://activiti.org/userguide/index.html#exposingConfigurationBeans" rel="nofollow noopener noreferrer"&gt;http://activiti.org/userguide/index.html#exposingConfigurationBeans&lt;/A&gt; and &lt;A href="http://activiti.org/userguide/index.html#N10701" rel="nofollow noopener noreferrer"&gt;http://activiti.org/userguide/index.html#N10701&lt;/A&gt;. You could use the "default" attribute on formProperties to include an expression like "${myService.getSomeValue()}.&lt;/LI&gt;&lt;BR /&gt;&lt;LI&gt;If you want to have a list of options to select from, you'll have to create a custom variable type, which does some lookup for you in the service and displays it. Additionally, when usig explorer, you should create a custom "rendered" from this. Look into org.activiti.explorer.ui.form.UserFormPropertyRenderer for inspiration on this.&lt;/LI&gt;&lt;/UL&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 18 Jul 2012 06:50:47 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/external-database-select-and-insert/m-p/97953#M67481</guid>
      <dc:creator>frederikherema1</dc:creator>
      <dc:date>2012-07-18T06:50:47Z</dc:date>
    </item>
    <item>
      <title>Re: External database select and insert</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/external-database-select-and-insert/m-p/97954#M67482</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;@pkruch&amp;nbsp; if you get an answer please write i want the answers of your questions too&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 17 Nov 2015 10:09:01 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/external-database-select-and-insert/m-p/97954#M67482</guid>
      <dc:creator>heba</dc:creator>
      <dc:date>2015-11-17T10:09:01Z</dc:date>
    </item>
  </channel>
</rss>

