Hi Gert,

Thanks....

Here is what I did - 

- installing the commons-dbcp bundle
===> osgi/install
http://repo2.maven.org/maven2/org/apache/servicemix/bundles/org.apache.servicemix.bundles.commons-dbcp/1.2.2_5/org.apache.servicemix.bundles.commons-dbcp-1.2.2_5.jar

s...@root:/> osgi/list | grep common
[  18] [Active     ] [       ] [   30] Apache ServiceMix Bundles:
commons-jexl-1.1 (1.1.0.1)
[  20] [Active     ] [       ] [   30] Apache ServiceMix Bundles:
commons-httpclient-3.1 (3.1.0.1)
[  26] [Active     ] [       ] [   30] Apache ServiceMix Bundles:
commons-vfs-1.0 (1.0.0.1)
[  29] [Active     ] [       ] [   30] Apache ServiceMix Bundles:
commons-codec-1.2 (1.2.0.1)
[ 115] [Active     ] [       ] [   60] Apache ServiceMix Bundles:
commons-net-1.4.1 (1.4.1.1)
[ 159] [Active     ] [       ] [   60] Apache ServiceMix Bundles:
commons-dbcp-1.2.2 (1.2.2.5)

- installing the MySQL driver bundle
===> downloaded mysql-connector-java-5.1.10.tar.gz and extracted
mysql-connector-java-5.1.10-bin.jar to
/usr/local/apache-servicemix-4.0.0/lib/optional

- configuring the ActiveMQ persistence as you posted earlier
===> did as 
<persistenceAdapter>
        <journaledJDBC dataDirectory="${activemq.base}/data"
createTablesOnStartup="true" journalLogFiles="5" dataSource="#mysql-ds"/>
</persistenceAdapter> 

===> and (outside of broker tag)

  <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url"
value="jdbc:mysql://localhost:3306/activemq?relaxAutoCommit=true"/>
    <property name="username" value="root"/>
    <property name="password" value="****"/>
    <property name="poolPreparedStatements" value="true"/>
  </bean> 

- an osgi:list which shows the status of the bundles you deployed

===> Attaching listing in a txt file 
http://old.nabble.com/file/p27333374/log-errors.txt log-errors.txt 

- the messages you find in the log file, so we can start
troubleshooting it that way

===> here you go 

s...@root:/> log/display | grep -i error
10:33:35,034 | ERROR | ExtenderThread-3 | OsgiBundleXmlApplicationContext  |
gatedExecutionApplicationContext  293 | Pre refresh error
        at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:231)
        at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:167)
        at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:420)
        at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:354)
        at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:453)
        at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3229)
10:33:35,050 | ERROR | ExtenderThread-3 | WaiterApplicationContextExecutor |
WaiterApplicationContextExecutor  398 | Unable to create application context
for [activemq-broker.xml], unsatisfied dependencies: none
        at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:231)
        at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:167)
        at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:420)
        at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:354)
        at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErrorReporter.reportError(XMLSchemaValidator.java:453)
        at
com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportSchemaError(XMLSchemaValidator.java:3229)
10:35:54,284 | INFO  | localShell       | CommandLineExecutorImpl          |
om.shell.CommandLineExecutorImpl   64 | Executing (String): log/display |
grep -i error
10:35:54,296 | INFO  | localShell       | CommandLineExecutorImpl          |
om.shell.CommandLineExecutorImpl  104 | Executing (grep): [-i, error]

Many Thanks :)
Pawan

-- 
View this message in context: 
http://old.nabble.com/MySQL-configuration-tp27266466p27333374.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.

Reply via email to