<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
What is the data source where the DB table named JBPM_PROCESSDEFINITION is created ?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/rdelarosa">ricardo delarosa</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/537557#537557">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hello,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I would like to know what is the name of the data source where table named JBPM_PROCESSDEFINITION is created ? <br/>Or where can I configure this data source ?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I need this name, because when I tried to deploy a process with the code:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>--- beginning code ---<br/>repositoryService = processEngine.getRepositoryService();<br/>newDeployment = repositoryService.createDeployment() ;<br/>newDeployment = newDeployment.addResourceFromClasspath( nomDescriptorProceso );<br/>idDeploy = newDeployment.deploy() ;  /* ManejadorJBPM4.java:474 */<br/>--- ending code ---</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>In the last line the next exception is thrown:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>--- beginning exception ---<br/>2010-04-13 15:29:35,000 DEBUG [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8090-1) Cannot open connection [???]<br/>org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -7ffefa3a:74b:4bc4d384:8c status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -7ffefa3a:74b:4bc4d384:8c status: ActionStatus.ABORT_ONLY >))<br/>    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)<br/>    at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)<br/>    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)<br/>    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)<br/>    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)<br/>    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)<br/>    at org.hibernate.loader.Loader.doQuery(Loader.java:696)<br/>    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)<br/>    at org.hibernate.loader.Loader.doList(Loader.java:2228)<br/>    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)<br/>    at org.hibernate.loader.Loader.list(Loader.java:2120)<br/>    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)<br/>    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)<br/>    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)<br/>    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)<br/>    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)<br/>    at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)<br/>    at org.jbpm.pvm.internal.id.AcquireDbidBlockCmd.execute(AcquireDbidBlockCmd.java:23)<br/>    at org.jbpm.pvm.internal.id.AcquireDbidBlockCmd.execute(AcquireDbidBlockCmd.java:10)<br/>    at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)<br/>    at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:54)<br/>    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)<br/>    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)<br/>    at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)<br/>    at org.jbpm.pvm.internal.id.DatabaseDbidGenerator.acquireDbidBlock(DatabaseDbidGenerator.java:76)<br/>    at org.jbpm.pvm.internal.id.DatabaseDbidGenerator.getNextId(DatabaseDbidGenerator.java:63)<br/>    at org.jbpm.pvm.internal.repository.RepositorySessionImpl.deploy(RepositorySessionImpl.java:56)<br/>    at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:47)<br/>    at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:33)<br/>    at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)<br/>    at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:54)<br/>    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)<br/>    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)<br/>    at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)<br/>    at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)<br/>    at org.jbpm.pvm.internal.repository.DeploymentImpl.deploy(DeploymentImpl.java:91)<br/>    at supercadejbpm.ManejadorJBPM4.registrarProceso(ManejadorJBPM4.java:474)<br/>--- ending exception ---  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And I think that this exception is due to this data source is not properly defined. Am I wrong ?  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have defined a file named jbpm-ds.xml. <br/>I put this file in the "deploy" folder of jBoss v5.0.1.<br/>The contents of this file are:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><datasources><br/>   <local-tx-datasource><br/>      <jndi-name>JbpmDS</jndi-name><br/>      <connection-url>jdbc:oracle:thin:@127.0.0.1:1521:xe</connection-url><br/>      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class><br/>      <user-name>BPM</user-name><br/>      <password>BPM</password><br/>      <min-pool-size>1</min-pool-size><br/>      <max-pool-size>5</max-pool-size><br/>      <idle-timeout-minutes>0</idle-timeout-minutes><br/>      <track-statements/><br/>      <prepared-statement-cache-size>32</prepared-statement-cache-size><br/>   </local-tx-datasource><br/></datasources></p><p>____</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Besides I defined a file named "jbpm-oracle-ds.xml".<br/>I put this file in the "deploy/jbpm" folder of jBoss:<br/> <br/><datasources><br/>  <xa-datasource><br/>    <jndi-name>XAJbpmDS</jndi-name><br/>    <track-connection-by-tx/>    </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <isSameRM-override-value>false</isSameRM-override-value><br/>    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class><br/>    <xa-datasource-property name="URL">jdbc:oracle:thin:@127.0.0.1:1521:xe</xa-datasource-property><br/>    <xa-datasource-property name="User">BPM</xa-datasource-property><br/>    <xa-datasource-property name="Password">BPM</xa-datasource-property><br/>    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <no-tx-separate-pools/><br/>      <metadata><br/>         <type-mapping>Oracle9i</type-mapping><br/>      </metadata><br/>  </xa-datasource></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter" <br/>         name="jboss.jca:service=OracleXAExceptionFormatter"><br/>    <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends><br/>  </mbean></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p></datasources></p><p>____</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I addition, there is a file named "hsqldb-ds.xml" located on the directory "deploy".<br/>The contents of this file are:  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><datasources><br/>   <local-tx-datasource></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <jndi-name>DefaultDS</jndi-name></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <driver-class>org.hsqldb.jdbcDriver</driver-class></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <user-name>sa</user-name><br/>      <password></password></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <min-pool-size>5</min-pool-size></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <max-pool-size>20</max-pool-size></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- The time before an unused connection is destroyed --><br/>      <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use --><br/>      <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a problem with not reaping threads on closed connections --><br/>      <idle-timeout-minutes>0</idle-timeout-minutes></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- sql to call when connection is created<br/>        <new-connection-sql>some arbitrary sql</new-connection-sql></p><p>      --></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- sql to call on an existing pooled connection when it is obtained from pool <br/>         <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql><br/>      --></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- example of how to specify a class that determines a connection is valid before it is handed out from the pool<br/>         <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyValidConnectionChecker</valid-connection-checker-class-name><br/>      --></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- Whether to check all statements are closed when the connection is returned to the pool,<br/>           this is a debugging feature that should be turned off in production --><br/>      <track-statements/></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- Use the getConnection(user, pw) for logins<br/>        <application-managed-security/></p><p>      --></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- Use the security domain defined in conf/login-config.xml --><br/>      <security-domain>HsqlDbRealm</security-domain></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- Use the security domain defined in conf/login-config.xml or the<br/>           getConnection(user, pw) for logins. The security domain takes precedence.<br/>        <security-domain-and-application>HsqlDbRealm</security-domain-and-application><br/>      --></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- HSQL DB benefits from prepared statement caching --><br/>      <prepared-statement-cache-size>32</prepared-statement-cache-size></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --><br/>      <metadata><br/>         <type-mapping>Hypersonic SQL</type-mapping><br/>      </metadata></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- When using in-process (standalone) mode --><br/>      <depends>jboss:service=Hypersonic,database=localDB</depends><br/>      <!-- Uncomment when using hsqldb in server mode<br/>      <depends>jboss:service=Hypersonic</depends><br/>      --><br/>   </local-tx-datasource></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   <!-- Uncomment if you want hsqldb accessed over tcp (server mode)<br/>   <mbean code="org.jboss.jdbc.HypersonicDatabase" <br/>     name="jboss:service=Hypersonic"><br/>     <attribute name="Port">        <br/>        <value-factory bean="ServiceBindingManager" method="getIntBinding" <br/>           parameter="jboss:service=Hypersonic"/><br/>      </attribute><br/>     <attribute name="BindAddress">${jboss.bind.address}</attribute>     <br/>     <attribute name="Silent">true</attribute><br/>     <attribute name="Database">default</attribute><br/>     <attribute name="Trace">false</attribute><br/>     <attribute name="No_system_exit">true</attribute><br/>   </mbean><br/>   --><br/> <br/>   <!-- For hsqldb accessed from jboss only, in-process (standalone) mode --> <br/>   <mbean code="org.jboss.jdbc.HypersonicDatabase" <br/>     name="jboss:service=Hypersonic,database=localDB"><br/>     <attribute name="Database">localDB</attribute><br/>     <attribute name="InProcessMode">true</attribute><br/>   </mbean><br/>   <br/></datasources><br/>_________________________</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I am using a jBoss v5.0.1. Application Server and jBPM 4.3</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any help is sincerely appreciated.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Ricardo</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/537557#537557">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>