JasperServer without MySQL

[kitakura]

Is it possible to install JasperServer without MySQL?

Thanks,

Kassie

[anandharaj]

Hi,

JasperServer definitely need repository to hold the data, so as an alternative to MySQL, you can use PostgreSQL.

 

[kitakura]

Hi Anandharaj, thank you for your response!  

:)

Kassie

[riesvantwisk]

hey Anandharaj,

 

 

we have been workign on getting JasperServer to work under glassfish and PostgreSQL, however it does work partially and properly because of the the fact that our MySQL converted DDL is incorrect.Do you happen to have a DDL for PostgreSQL to share? 

If not, I will spend some more time to investigate the problems and see what fields types I need to use for PG

 

Ries

[riesvantwisk]

 I think I got it working on PostgreSQL,

 

I needed to change some other var chars(2000) to test fields.

If there is anybody who want's to test this, please let me know and will send you a DDL for PostgreSQL

 

Ries

[swood]

You can generate the DDL for a different database from the source. Look at the Source Build Guide. The step in there:

cd jasperserver-repository-hibernate/build_db (create and populate db schema)
mvn clean install

generates the DDL and can optionally drop/create the repository database as you have configured it.

The DDL for the database will be in jasperserver-repository-hibernate/build_db/target/sql

 

Sherman

Jaspersoft

[anandharaj]

Hi,

I have no problem sharing the DDL for postgreSQL, for which version you want?

[riesvantwisk]

@ Sherman and Anandharaj,

In the mean time we got it running my converting the MySQL DDL to PostgreSQL. it's mostly search and replace some varchars and binary types. But for sure I will try the compile from source method and see if I can generate a DDL directly.

This will also allow me to test if it works under OSX leopard which would be nice (currently I run it under Ubuntu in parallels)

All I can say now is great product and we properly will have more fun when we start deploying more complicated reports.

thanks for your time and efforts to help me out!

Ries

 

[riesvantwisk]

 @All,

 

Just wanted to mention that compiling from source is easer then trying to convert the MySQL version to PostgreSQL.

That said, the DDL for PostgreSQL is outdated and from it looks is that the DDL for PostgreSQL shipped with JasperServer 3.0 is still at 2.1 version.

However following "Upgrade to 3.0" chapter will do tje Job.

 

Ries

[kitakura]

Hi, can JasperServer work with Oracle instead of MySQL?  If so, how can I accomplish this?

Thank you,

Kassie

[swood]

You can build from source as outlined in this thread, setting the parameters for Oracle.

 

Jaspersoft also has commercial versions that come pre-configured for Oracle.

 

Sherman

Jaspersoft

[jfrench]

Sherman:

 

This post is very helpful for generating the Oracle DDL. Thank you. However, I can't find any reference in the documentation or src build for jasperserver-3.0 yet that tells you how to build the scripts/oracle/jasperserverCreateDefaultSecurity-oracle.sql file. I had to swipe mine from the 30 day trial download of JasperServer pro.

 

Thanks, Jon

[jfrench]

Sherman: I'm going to post this again. Apologies if my quick reply already came through.

 

Could you post instructions on how to generate the

scipts/oracle/jasperserverCreateDefaultSecurity-oracle.sql
 

file for the community source build. I can't find any documentation that descripts how to generate this file.

 

Thx.
 

[halfer]

Some earlier questions on this thread appeared to be connected to switching out the use of MySQL for another database. In most cases, I would say - just leave the default JasperServer tables in MySQL, and then add the ability to connect to other databases.

 

For example we have a dedicated JasperServer server, using MySQL for the basic install. We have then added the necessary jar files to be able to connect to Oracle 9i and 10g, with most reports being based off SQL queries, and one from a PL/SQL query. We found no compelling reason to switch the base install tables to Oracle too.