nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Activity and internet connection

jtawk

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?

Regards

Find more posts tagged with

Comments

jbarrez

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.

jtawk

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

frederikherema1

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?

jtawk

I am using Activiti with Mysql inside spring 3.0.3.

iravanchi

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?

jtawk

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

iravanchi

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

jtawk

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.

afshad

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();

afshad

Its ok I finally got activiti to work with OSGI

vadim

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)

frederikherema1

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.

jonathan1

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.