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:-
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:-
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
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>
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" />
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:)
ASKER