Link to home
Start Free TrialLog in
Avatar of Anthony Horner
Anthony Horner

asked on

configure dependency in POM for new database

I'm using an app (camunda) which allows you to create apps (war files) which can be deployed onto tomcat.

The vanilla version of the app is configured to use the H2 database for demos etc.  I've changed this so that the app now runs off a MySQL database.  And that is working fine.

The apps that I have been creating up to now which use the H2 database have the following dependency in their POM file:-

		<dependency>
			<groupId>com.h2database</groupId>
			<artifactId>h2</artifactId>
			<version>1.3.168</version>
			<scope>test</scope>
		</dependency>

Open in new window


I guess that I will need to change this so that it is now pointing to the MySQL database (again vanilla version), this is how the db is defined in a config file for camunda:-

    <Resource name="jdbc/ProcessEngine"
              auth="Container"
              type="javax.sql.DataSource"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
              uniqueResourceName="process-engine"
              driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://localhost:3306/camunda"
              username="Tony"
              password="toeknee"
              maxActive="20"
              minIdle="5" />

Open in new window


There is no error message yet because I'm working on another issue before this - which doesn't seem to be db-related however when I eventually get to deploy this app, then I'm guessing it won't work if it is looking to write data to H2.

Can anyone point me to what are the values for creating a MySQL dependency in the POM file?

TIA
ASKER CERTIFIED SOLUTION
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anthony Horner
Anthony Horner

ASKER

Thanks, it worked.
:)