View Full Version : Mysql

12-27-2005, 12:02 PM
Pentaho is exactly what I'm looking for. Will you be releasing a version of the Pentaho demo that will run with Mysql as the database engine? If not is there an easy way to switch everything over? The demo you provided would be much easier to understand if it were Mysql based.


12-31-2005, 03:07 PM
I changed everything over to Mysql myself.

01-02-2006, 07:32 AM
Thats great. We will be providing a MySQL-based demo soon.

James Dixon

01-03-2006, 07:27 AM
I was testing different configurations this weekend. It would be nice to have Mysql scripts to create and load the databases for Hibernate, Quartz, Shark and anything else that is required for the core Pentaho server. I created those 3 databases and copied the data over, but I think it would be best if you created the scripts. I don't intend to modify your core server install, it works great.

I currently have the pentaho_j2ee_deployments- working with Jboss-4.0.2. I'm using the Hypersonic sample data for Hibernate, Quartz and Shark. I'm using Mysql 5 for my data. Hibernate didn't seem to like Mysql 5 very much and I suspect it would run better with a 3-X version.

Thanks for making such a great product.

01-10-2006, 11:54 AM
dwarden - how did you transfer the databases + data from Hypersonic to MySQL? I too am trying to set up a MySQL based demo environment and am struggling with the Hibernate and Shark components.


01-10-2006, 01:08 PM
I used Squirrel SQL Client from the Sourceforge http://sourceforge.net/projects/squirrel-sql. I was able to generate the SQL files to create the tables and load the data from Hypersonic, Quartz and Shark. Mysql won't let you copy and paste tables. Either the tables or the indexes weren't what Hibernate expected to find and I didn't have time to debug the SQL. I suspect there was an index problem due to the errors Hibernate generated.

You should consider leaving Hibernate,Quartz and Shark on Hypersonic until the Pentaho people publish their Mysql demo. When the Mysql tables are complete you should be able to use Squirrel or some other SQL client to export the data from Hypersonic and import it into Mysql. I have those 3 packages running under Hypersonic and I'm using Mondrian to query databases on Mysql. I was able to use BIRT to do a quick report from Mysql, but report writers are a little limited for me. When Pentaho publishes a Mysql package I should be able to move everything I've been working on in a couple of hours. Depending how everything looks I may only move the Hypersonic data over.


01-11-2006, 05:02 AM
Hey all,

The hibernate tables will be generated in MySQL automatically. Simply modify the hibernate.cfg.xml to point to use the appropriate JDBC driver and stuff, and change the dialect to:


Then, when you start up the platform, all the tables will be created, with the appropriate cascading referential integrity.

01-11-2006, 05:09 AM
Hey there,

I got the database create scripts for MySQL from the Quartz distribution, zipped them up, and placed them here. http://forums.pentaho.org/archived_att/files/quartz_mysql.zip

01-11-2006, 05:12 AM

Thanks for your help.

01-11-2006, 07:36 AM
I think I found my original mistake. I didn't change the Hibernate xml to include the org.pentaho.repository.MySQL5InnoDBDialect. I used the org.pentaho.repository..MySQLDialect. Hibernate created its tables on the first Mondrian query.

Pentaho rocks!

Thanks for your help.

02-04-2006, 02:41 AM
I also want to change hypersonic database to my sql,
can u guide me regading this one, what are the steps to be followed and which files I ahve to modified.
And in another post u have to told to check "http://sourceforge.net/projects/squirrel-sql." this is showing an invalid project.
please help to cahnge my database to mysql.

02-06-2006, 06:28 AM
Try searching SourceForge for squirrel-sql. I followed Marc's advice and most of the Hibernate tables were created when Jboss started up. While testing Hibernate complained about some other tables so I created them manually. I will post the SQL from my MySQL setup, you may need to edit it if you need InnoDB.

You will need to change the dialect and Hypersonic entries in all the files involved. Search your hard drive for them, there location will vary depending on your setup. Here are some of the files that will need to be edited:


Change the dialect to:


Depending on the version of MySQL you are using. I moved everything over by searching and editing all the files containing Hypersonic links.

I'm not an expert on the Pentaho setup. James or Marc if you can offer more advice it would be very helpful.

Thanks http://forums.pentaho.org/archived_att/files/hibernate.txt

Post edited by: dwarden, at: 02/06/2006 10:29