topic Re: How to get dbsqlSession in Alfresco Archive

How to get dbsqlSession

ahmetkara — Mon, 21 Mar 2011 20:45:46 GMT

Hi,I need to get current db session. I am trying to get like that "CommandContext.getCurrent().getDbSqlSession()" but it returns null. Is it possible to get current session?Thanks.

Re: How to get dbsqlSession

frederikherema1 — Tue, 22 Mar 2011 07:06:57 GMT

The commandContext can be obtained through Context.getCommandContext()

Re: How to get dbsqlSession

ahmetkara — Thu, 24 Mar 2011 06:53:48 GMT

Thanks for your reply, but I am trying like you wrote, unfotunately I get exception, like below.

INFO: JobAcquisitionThread starting to acquire jobs
Exception in thread "main" java.lang.NullPointerException

Re: How to get dbsqlSession

frederikherema1 — Thu, 24 Mar 2011 06:59:27 GMT

Are you sure your database has/is being initialized? What's the value of the databaseUpgrade property?

Re: How to get dbsqlSession

ahmetkara — Thu, 24 Mar 2011 07:21:12 GMT

I've got no databaseUpgrade property in my activiti.cfg.xml, what should it be??
This is my config. file.
<bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">

    <!– Database configurations –>
    <property name="databaseType" value="mysql" />
    <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/activiti_mine?autoReconnect=true" />
    <property name="jdbcDriver" value="com.mysql.jdbc.Driver" />
    <property name="jdbcUsername" value="activiti" />
    <property name="jdbcPassword" value="activiti" />
<property name="history" value="full" />

<property name="databaseSchemaUpdate" value="true" />
    <property name="jobExecutorActivate" value="true" />
    <property name="mailServerHost" value="localhost" />
    <property name="mailServerPort" value="5025" />

</bean>

Re: How to get dbsqlSession

frederikherema1 — Thu, 24 Mar 2011 07:32:16 GMT

sorry, I meant "databaseSchemaUpdate" which looks allright in your config. Can you see the full stacktrace in your logs (line-number in JobeExecutor for example)?

Re: How to get dbsqlSession

ahmetkara — Thu, 24 Mar 2011 08:28:04 GMT

Sorry, I can't, that is all I see, I am posting again.

org.activiti.engine.impl.jobexecutor.JobAcquisitionThread run
INFO: JobAcquisitionThread starting to acquire jobs
Exception in thread "main" java.lang.NullPointerException