Install Jasperserver comunity edition on oracle

11- start tomcat

12- login in the url http://localhost:8080/jasperserver/

username  jasperadmin and password   password

This is great. I've bookmarked this thread.

I've also jiggled about with the schema sql script for 3.5 It seems to work fine but no warrenty or recompense etc... I've split it into two scritps. One creates the tables and the other adds the default security settings. I did this because I have a situation where the tables create fine, but if I run the security script and then try to run a js-import it seems to crash on the user import with the code below.

Just creating the tables and running js-import withouth creating the default security works fine though.

User anonymousUser already exists, skipping.
15:17:20,992 ERROR Cipherer:146 - java.lang.NumberFormatException: For input string: "pa"
java.lang.NumberFormatException: For input string: "pa"</td></tr></tbody></table>

I have install jasperserver 3.5 on mysql and work fine.

I modify this installation to work on ORACLE.

I modify this file:

1. create user jasper/jasper

2. installa the script  on user jasper

3. modify this file:

D:\\Programmi\\Apache Software Foundation\\Tomcat 6.0\\webapps\\jasperserver\\WEB-INF\\hibernate.properties

# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "applicationContext-*.xml".
# Targeted at system administrators, to avoid touching the context XML files.

# Property that determines the Hibernate dialect
metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect
metadata.hibernate.dataSource.jndiName=jdbc/jasperserver
#
# default_schema setting will be uncommented if your database requires
# a schema to be specified (such as for DB2)
#
#metadata.hibernate.default_schema=${metadata.hibernate.default_schema}

D:\\Programmi\\Apache Software Foundation\\Tomcat 6.0\\webapps\\jasperserver\\META-INF\\context.xml

<Context path="/jasperserver"
            debug="5" reloadable="true" crossContext="true">

        <!-- maxActive: Maximum number of dB connections in pool. Make sure you
             configure your mysqld max_connections large enough to handle
             all of your db connections. Set to 0 for no limit.
        -->
        <!-- maxIdle: Maximum number of idle dB connections to retain in pool.
             Set to -1 for no limit.  See also the DBCP documentation on this
             and the minEvictableIdleTimeMillis configuration parameter.
         -->
        <!-- maxWait: Maximum time to wait for a dB connection to become available
             in ms, in this example 10 seconds. An Exception is thrown if
             this timeout is exceeded.  Set to -1 to wait indefinitely.
        -->
    <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
            username="jasper" password="jasper" driverClassName="oracle.jdbc.driver.OracleDriver"
            url="jdbc:oracle:thin:@192.168.1.101:1521:orcl"/>
</Context>

D:\\Programmi\\Apache Software Foundation\\Tomcat 6.0\\webapps\\jasperserver\\META-INF\\jasperserverDS-jdbc.xml

<?xml version='1.0' encoding='UTF-8'?>
<jdbc-data-source xmlns="http://www.bea.com/ns/weblogic/90" xmlns:sec="http://www.bea.com/ns/weblogic/90/security" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls" xsi:schemaLocation="http://www.bea.com/ns/weblogic/920 http://www.bea.com/ns/weblogic/920.xsd">
  <name>JasperServerDataBase</name>
  <jdbc-driver-params>
    <url>jdbc:oracle:thin:@192.168.1.101:1521:orcl</url>
    <driver-name>oracle.jdbc.driver.OracleDriver</driver-name>
    <properties>
      <property>
        <name>user</name>
        <value>jasper</value>
      </property>
    </properties>
    <password-encrypted>jasper</password-encrypted>
  </jdbc-driver-params>
  <jdbc-connection-pool-params>
    <test-table-name>SQL SELECT 1</test-table-name>
  </jdbc-connection-pool-params>
  <jdbc-data-source-params>
    <jndi-name>JasperServerDataBase</jndi-name>
    <global-transactions-protocol>OnePhaseCommit</global-transactions-protocol>
  </jdbc-data-source-params>
</jdbc-data-source>
 

When i try to connect i have this log:

12:30:49,524  WARN JDBCExceptionReporter,http-3434-1:77 - SQL Error: 1064, SQLState: 42000
12:30:49,524 ERROR JDBCExceptionReporter,http-3434-1:78 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and roles0_.userId=1' at line 1
12:30:49,540  WARN LoggerListener,http-3434-1:55 - Authentication event AuthenticationFailureServiceExceptionEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: 127.0.0.1; SessionId: E747FF27AC24C5B5E6272286813E82D3; exception: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser.roles#1]; nested exception is org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser.roles#1]

Why?!

Thank's

Lorenzo Renzi

iTHAN srl

Here are the updated scripts with the admin fix from yeti96

I've followed the instructions for my JasperServer 3.5.

I'm getting the exception BAD CREDENTIALS

"11:56:02,944  WARN LoggerListener,http-9080-8:55 - Authentication event AuthenticationFailureBadCredentialsEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: 127.0.0.1; SessionId: B93C4C6B80CCDB8EE3FFE704B934ACBA; exception: Bad credentials"

I've attached all the changed files with this post.

I'm using Oracle 10g, Tomcat 6.0, JasperServer 3.5, Firefox on Windows XP.

The name of host is "proxy" and the service is "proxy".

The username and password for Oracle is "jasperreport".

I've checked the JIUSER table from Oracle, it has the the user "jasperadmin" (the schema was created with the later Oracle-3.5.zip with encrypted passwrod).

Anyother information required, i'll provide.

Regards.

AsadULLAH.

this is my grain of rice for JasperServer 3.7.0 and Oracle10g, works fine, into rar you can see all files needed and scripts for database.