We have done all of our development and testing on PostgreSQL so unfortunately do not have specific instructions or documentation with MySQL. However, a general outline would work as follows:
You will need to download the MySQL JDBC driver and include that in the class path
Database configuration will have to use the MySQL dialect; if you are using GenMAPP Builder, this can be chosen in the Database Configuration dialog; if you are using XMLPipeDB as a library, you will likely need to edit the hibernate.properties file on your own
The database schema to use may vary. Adapting this to MySQL will vary depending on the specific use case(s) you are envisioning for XMLPipeDB. In general, you will need to run the XSD-to-DB utility from the XMLPipeDB suite with the MySQL database driver and settings (see above). This will produce a .sql file that you can then load into MySQL. Once that is done, running on the MySQL database driver and configuration should be all that is needed after.
Caveats though: as stated in the first paragraph, we have not done this firsthand ourselves, due to our focus on PostgreSQL. There may be PostgreSQL-specific queries in our codebase that you might need to adapt to MySQL. Fortunately we don't anticipate this to be a lot thanks to SQL's standardization, but there are some differences and I just wanted to alert you to the possibility that this will come up.
That's what I can supply; hope that can give you a start.
John David N. Dionisio, PhD
Professor, Computer Science
Associate Director, University Honors Program
Loyola Marymount University
Hello,
Can anybody provide instructions on how to set up the XMLPipeDB using MySQL database connection?
I've checked already the manual but it is not stated there.
Hello Angel,
We have done all of our development and testing on PostgreSQL so unfortunately do not have specific instructions or documentation with MySQL. However, a general outline would work as follows:
You will need to download the MySQL JDBC driver and include that in the class path
Database configuration will have to use the MySQL dialect; if you are using GenMAPP Builder, this can be chosen in the Database Configuration dialog; if you are using XMLPipeDB as a library, you will likely need to edit the hibernate.properties file on your own
The database schema to use may vary. Adapting this to MySQL will vary depending on the specific use case(s) you are envisioning for XMLPipeDB. In general, you will need to run the XSD-to-DB utility from the XMLPipeDB suite with the MySQL database driver and settings (see above). This will produce a .sql file that you can then load into MySQL. Once that is done, running on the MySQL database driver and configuration should be all that is needed after.
Caveats though: as stated in the first paragraph, we have not done this firsthand ourselves, due to our focus on PostgreSQL. There may be PostgreSQL-specific queries in our codebase that you might need to adapt to MySQL. Fortunately we don't anticipate this to be a lot thanks to SQL's standardization, but there are some differences and I just wanted to alert you to the possibility that this will come up.
That's what I can supply; hope that can give you a start.
John David N. Dionisio, PhD
Professor, Computer Science
Associate Director, University Honors Program
Loyola Marymount University