-
1. Re: Error: "DEPLOYMENTS MISSING DEPENDENCIES"
peterj Apr 6, 2010 1:19 PM (in response to rdelarosa)1 of 1 people found this helpfulWere there any error earlier in the console log? Is so, please post the first one.
According to the this deployment report, it would appear that the DefaultDS datasource did not deploy correctly. Did you do anything with the server/xxx/deploy/hsqldb-ds.xml file? Did you poerhaps attempt to replace hsqldb with another database?
-
2. Re: Error: "DEPLOYMENTS MISSING DEPENDENCIES"
rdelarosa Apr 6, 2010 2:57 PM (in response to peterj)Thank you for helping me.
I replaced the file "server/default/deploy/hsqldb-ds.xml" with the file named "jbpm-ds.xml", in the same directory.
The content of the jbpm-ds.xml file is:
<code>
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:xe</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>BPM</user-name>
<password>BPM</password>
<min-pool-size>1</min-pool-size>
<max-pool-size>5</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--
<security-domain>HsqlDbRealm</security-domain>
-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<!-- metadata -->
<!-- type-mapping>Hypersonic SQL</type-mapping -->
<!-- /metadata -->
<!-- depends>jboss:service=Hypersonic,database=jbpmDB</depends -->
</local-tx-datasource><!-- mbean code="org.jboss.jdbc.HypersonicDatabase"
name="jboss:service=Hypersonic,database=jbpmDB">
<attribute name="Database">jbpmDB</attribute>
<attribute name="InProcessMode">true</attribute>
</mbean --></datasources>
</code>
Related with the problem, in the log "server.log" the next line was written:
<code>
INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
</code>
Best regards,
Ricardo
-
3. Re: Error: "DEPLOYMENTS MISSING DEPENDENCIES"
peterj Apr 6, 2010 3:12 PM (in response to rdelarosa)1 of 1 people found this helpfulReplacing HSQLDB with Oracle is not a simple as replacing the hsqldb-ds.xml file. There are a number of additional configuration changes that youy need to make. Do ytou really want to replace HSQLDB with Oracle, or do you just need to access an Oracle database?
Also, your jbpm-ds.xml file is incorrect, it still contains hsqldb articats.
-
4. Re: Error: "DEPLOYMENTS MISSING DEPENDENCIES"
rdelarosa Apr 6, 2010 3:28 PM (in response to peterj)Peter:
I just need to access an Oracle database.
Do I need to make additional configurations to access an Oracle database ?
I improved the content of my jbpm-ds.xml. This content is:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:xe</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>BPM</user-name>
<password>BPM</password>
<min-pool-size>1</min-pool-size>
<max-pool-size>5</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
</local-tx-datasource></datasources>
______
Thank you in advance.
Ricardo
-
5. Re: Error: "DEPLOYMENTS MISSING DEPENDENCIES"
peterj Apr 6, 2010 3:59 PM (in response to rdelarosa)Restore the original hsqldb-ds.xml. Look in the docs/examples/jca directory, there are several example *-ds.xml files there for many databases, including Oracle. Use that as a guideline. Also, you will have to change the jndi-name to something other than DefaultDS.
There is a wiki page that tells how to do all of this but the stupid search engine for this forum can't find it. Finally found it by digging through the wiki:
-
6. Re: Error: "DEPLOYMENTS MISSING DEPENDENCIES"
rdelarosa Apr 12, 2010 12:44 PM (in response to peterj)Thank you Peter,
Your response solves my problem.
Best regards,
Ricardo