topic Activity and internet connection in Alfresco Archive

Activity and internet connection

jtawk — Mon, 04 Oct 2010 17:25:11 GMT

Hi, I am new to Activiti and i have an issue with internet and Ibatis connection.I cannot start Activiti without internet connection, each time i do, i get an error "Error while building ibatis SqlSessionFactory".Why this behavior and how can i run Activiti regardless of the internet status?Rega

Re: Activity and internet connection

jbarrez — Wed, 06 Oct 2010 08:44:03 GMT

Could you post the full stacktrace?

I'm using Activiti a lot without internet connection (eg on the train) and I have never had an issue.

Re: Activity and internet connection

jtawk — Wed, 06 Oct 2010 20:23:59 GMT

Hi, thanks for replying, below is what i am getting:

Caused by: org.activiti.engine.ActivitiException: Error while building ibatis SqlSessionFactory: Error creating document instance.  Cause: java.net.ConnectException: Connection timed out: connect
 at org.activiti.engine.impl.db.DbSqlSessionFactory.createSessionFactory(DbSqlSessionFactory.java:136)
 at org.activiti.engine.impl.db.DbSqlSessionFactory.configurationCompleted(DbSqlSessionFactory.java:116)
 at org.activiti.engine.impl.cfg.ProcessEngineConfiguration.notifyConfigurationComplete(ProcessEngineConfiguration.java:249)
 at org.activiti.engine.impl.cfg.ProcessEngineConfiguration.configurationComplete(ProcessEngineConfiguration.java:228)
 at org.activiti.engine.impl.cfg.ProcessEngineConfiguration.buildProcessEngine(ProcessEngineConfiguration.java:212)
 at com.roxana.smd.activiti.engine.impl.cfg.SmdProcessEngineConfiguration.buildProcessEngine(SmdProcessEngineConfiguration.java:75)
 at com.roxana.smd.activiti.engine.impl.cfg.spring.SmdProcessEngineFactoryBean.getObject(SmdProcessEngineFactoryBean.java:78)
 at com.roxana.smd.activiti.engine.impl.cfg.spring.SmdProcessEngineFactoryBean.getObject(SmdProcessEngineFactoryBean.java:1)
 at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
 … 56 more
Caused by: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: java.net.ConnectException: Connection timed out: connect
 at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:136)
 at org.apache.ibatis.parsing.XPathParser.<init>(XPathParser.java:32)
 at org.apache.ibatis.builder.xml.XMLConfigBuilder.<init>(XMLConfigBuilder.java:47)
 at org.apache.ibatis.builder.xml.XMLConfigBuilder.<init>(XMLConfigBuilder.java:34)
 at org.activiti.engine.impl.db.DbSqlSessionFactory.createSessionFactory(DbSqlSessionFactory.java:127)
 … 64 more
Caused by: java.net.ConnectException: Connection timed out: connect
 at java.net.PlainSocketImpl.socketConnect(Native Method)
 at java.net.PlainSocketImpl.doConnect(Unknown Source)
 at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
 at java.net.PlainSocketImpl.connect(Unknown Source)
 at java.net.SocksSocketImpl.connect(Unknown Source)
 at java.net.Socket.connect(Unknown Source)
 at java.net.Socket.connect(Unknown Source)
 at sun.net.NetworkClient.doConnect(Unknown Source)
 at sun.net.www.http.HttpClient.openServer(Unknown Source)
 at sun.net.www.http.HttpClient.openServer(Unknown Source)
 at sun.net.www.http.HttpClient.<init>(Unknown Source)
 at sun.net.www.http.HttpClient.New(Unknown Source)
 at sun.net.www.http.HttpClient.New(Unknown Source)
 at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
 at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
 at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
 at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
 at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
 at org.apache.xerces.impl.XMLEntityManager.startEntity(Unknown Source)
 at org.apache.xerces.impl.XMLEntityManager.startDTDEntity(Unknown Source)
 at org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(Unknown Source)
 at org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown Source)
 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
 at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
 at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
 at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
 at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:134)
 … 68 more

Re: Activity and internet connection

frederikherema1 — Thu, 07 Oct 2010 06:25:18 GMT

I'm guessing the myBatis XMLParser is trying to validate the configuration against the dtd-schema (http://ibatis.apache.org/dtd/ibatis-3-config.dtd).

Which container do you use? Or are you just running standalone?

Re: Activity and internet connection

jtawk — Thu, 07 Oct 2010 07:13:00 GMT

I am using Activiti with Mysql inside spring 3.0.3.

Re: Activity and internet connection

iravanchi — Thu, 07 Oct 2010 08:16:52 GMT

Yes, it seems DTD download.

I'm using Spring 3.0.3 too, in Tomcat, but with H2 database.

My internet connection in the office comes and goes regularly, but I haven't had such problem with DTD validation. An when the internet is connected, it's usually very slow, so I should have noticed a delay on startup, which I haven't.

Maybe the issue is about MySQL's config?

Re: Activity and internet connection

jtawk — Thu, 07 Oct 2010 08:37:15 GMT

no, it's the same with H2. I guess the issue had to do with spring and iBatis configuration.

Re: Activity and internet connection

iravanchi — Thu, 07 Oct 2010 08:53:37 GMT

I meant the MySQL-specific XML files inside Activiti that configure the database access, not the connection configuration.

Re: Activity and internet connection

jtawk — Thu, 07 Oct 2010 11:48:07 GMT

This was due to a Lib conflict that was causing the XML parser to look up the doctype from the net and not from the jar.
Thanks for your help and your time.

Re: Activity and internet connection

afshad — Thu, 01 Mar 2012 22:38:16 GMT

This was due to a Lib conflict that was causing the XML parser to look up the doctype from the net and not from the jar.
Thanks for your help and your time.

How did you fix this??
I am getting a similar exception
Error while building ibatis SqlSessionFactory: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource org/activiti/db/mapping/entity/Attachment.xml

When trying to create a process engine as given in the user guide:
ProcessEngine processEngine = ProcessEngineConfiguration.createStandaloneInMemProcessEngineConfiguration()
                    .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE)
                    .setJdbcUrl("jdbc:h2:mem:my-own-db;DB_CLOSE_DELAY=1000")
                    .setJobExecutorActivate(true)
                    .buildProcessEngine();

Re: Activity and internet connection

afshad — Fri, 02 Mar 2012 16:21:38 GMT

Its ok I finally got activiti to work with OSGI

Re: Activity and internet connection

vadim — Tue, 23 Oct 2012 13:39:12 GMT

How to increase connection timeout? I have created a lot of human tasks (>800) in nested multi instance processes and receive always timeout exception

…Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "ACT_RU_EXECUTION"; SQL statement:
select
        JOB.*
    from ACT_RU_JOB JOB
        LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = JOB.PROCESS_INSTANCE_ID_

        LEFT OUTER JOIN ACT_RE_PROCDEF PD ON PD.ID_ = PI.PROC_DEF_ID_
    where (JOB.RETRIES_ > 0)
      and (JOB.DUEDATE_ is null or JOB.DUEDATE_ < ?)
      and (JOB.LOCK_OWNER_ is null or JOB.LOCK_EXP_TIME_ < ?)
          and (
                    (JOB.EXECUTION_ID_ is null)
                        or ((PI.SUSPENSION_STATE_ = 1)
                        and (PD.SUSPENSION_STATE_ = 1))
      )
    LIMIT ? OFFSET ? [50200-168]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:169)
        at org.h2.message.DbException.get(DbException.java:146)
        at org.h2.table.RegularTable.doLock(RegularTable.java:500)
        at org.h2.table.RegularTable.lock(RegularTable.java:434)
        at org.h2.table.TableFilter.lock(TableFilter.java:143)
        at org.h2.table.TableFilter.lock(TableFilter.java:145)
        at org.h2.command.dml.Select.queryWithoutCache(Select.java:604)
        at org.h2.command.dml.Query.query(Query.java:307)
        at org.h2.command.dml.Query.query(Query.java:277)

Re: Activity and internet connection

frederikherema1 — Tue, 23 Oct 2012 15:26:57 GMT

H2 isn't really a production-database and sometimes locks full tables, while it shouldn't. This is something other DB's don't have and it's recommended to use another one.

If you really want to use H2 (maybe for testing?), look in the H2 documentation for this, think it's a parameter in the jdbc-URL.

Re: Activity and internet connection

jonathan1 — Tue, 27 Nov 2012 19:50:14 GMT

I ran into the same problem as JTawk and didn't see an easy solution posted on the thread, so I thought I'd post mine in case someone else has the same problem.

Switching the dependency in my Activiti pom.xml file from apache ibatis to mybatis cleared up the problem for me and avoided messing around with ibatis working with my proxy settings.