kemal

I found the following problems in /install_resources/sql/mysql/js-create.ddl MYSQL does not like "TYPE=InnoDB" it wants "ENGINE=InnoDB" for table create statements Also "maxValue" is a reserved word so it cannot be used as a column name create table JIDataType ( id bigint not null, type tinyint, maxLength integer, decimals integer, regularExpr varchar(255), minValue tinyblob, maxValue tinyblob, strictMin bit, strictMax bit, primary key (id) ) ENGINE=InnoDB; I can change TYPE to ENGINE myself but what can i do about the column name? Does this mean MySQL cannot be used with Jasper Server anymore? thanks kemal

Hi All, I am trying to install Jasper Server 4.2.1 on Mac OSX Server 10.6.8 Glassfish 3.1.1 MySql 5.5.18 All running on the same server. I tested Glassfish & MySQL and they are both working just fine. I Downloaded jasperreports-server-cp-4.2.1.zip from sf.net and followed the instructions to modify default_master.properties file to say: appServerType = glassfish3 appServerDir = /users/admin/glassfish3 dbtype = mysql dbHost = localhost dbUsername = root dbPassword = ???? -------------------------------- When I run the ./js-install.ce.sh most of the steps execute fine and it actually creates the database named "jasperserver" But I get the following error recreate-js-db: fill-js-ce-db-minimal: [echo] Filtering properties (cleaning out blank spaces) init-js-db-ce: [echo] About to validate JDBC jar existence [echo] Look in: /Users/admin/Downloads/jasperreports-server-cp-4.2.1-bin/buildomatic/conf_source/db/mysql/jdbc [echo] Found jar file: assuming OK [advanced-sql] Executing resource: /Users/admin/Downloads/jasperreports-server-cp-4.2.1-bin/buildomatic/install_resources/sql/mysql/js-create.ddl [advanced-sql] Failed to execute: create table JIAccessEvent ( id bigint not null auto_increment, user_id bigint not null, event_date datetime not null, resource_id bigint not null, updating bit not null, primary key (id) ) type=InnoDB BUILD FAILED /Users/admin/Downloads/jasperreports-server-cp-4.2.1-bin/buildomatic/bin/db-common.xml:875: The following error occurred while executing this line: Any Idea what is wrong? thanks in advance