baggypants Posted February 11, 2011 Share Posted February 11, 2011 I thought I had this pinned down from doing it with version 3.5 and 3.7 but I've not.I've used the handily provided DDL files in the buildomatic folder to create the relevent tables in user jasperdb40 on a local server 192.168.2.203I've edited META-INF/context.xml to <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasperdb40" password="password" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.2.203:1521:ORCL" />I'e altered META-INF/jasperserver-DS-jdbc.xml to <jdbc-driver-params> <url>jdbc:oracle:thin:@192.168.2.203:1521:ORCL</url> <driver-name>oracle.jdbc.driver.OracleDriver</driver-name> <properties> <property> <name>user</name> <value>jasperdb</value> </property> </properties> <password-encrypted>password</password-encrypted> </jdbc-driver-params>I've changed WEBINF/hibernate.properties tometadata.hibernate.dialect=org.hibernate.dialect.Oracle10gDialectand edited js.jdbc.properties tometadata.hibernate.dialect=org.hibernate.dialect.Oracle10gDialectmetadata.jdbc.driverClassName=oracle.jdbc.driver.OracleDrivermetadata.jdbc.url=jdbc:oracle:thin:@192.168.2.203:1521:ORCLmetadata.jdbc.username=jasperdb40metadata.jdbc.password=passwordand yet in the apache stdout_<date> .log I still get things likeCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureandCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.when I stat the MySQL database it all sets going like nothing has changed, even though I've deleted work\Catelina multiple times. what do you think? What did I miss? Link to comment Share on other sites More sharing options...
baggypants Posted February 16, 2011 Author Share Posted February 16, 2011 Here are the full log files from an attempted start with the changes made above in case anyone stumbles on this thead and can make sense of them. Link to comment Share on other sites More sharing options...
baggypants Posted February 16, 2011 Author Share Posted February 16, 2011 found the answer over herehttp://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=83889#84090stop tomcat and delete <tomcat>/conf/Catalina/localhost/{web-app-name}.xmlrestart and it's all good.Top Drawer. Link to comment Share on other sites More sharing options...
cpsheff Posted March 23, 2011 Share Posted March 23, 2011 I was interested in your post as I had 3.7 CE working against an Oracle 10g repository but although I believe I have followed the same steps as yourself I cannot get the login screen to appear correctly using 4 CP (it looks like stylesheets not loading - see attached screenshot).The steps I have followed are:run js-create.ddlrun quartz.ddlrun upgrade-oracle-3.7.0-4.0.0-pro.sqledit hibernate.properties as described in your postEdit jasperserverDS-jdbc.xml as described in your postEdit js.jdbc.properties as described in your postIs there anything I am missing here? Link to comment Share on other sites More sharing options...
tkavanagh Posted March 25, 2011 Share Posted March 25, 2011 The issue is that for 4.0, the style sheets are stored and looked for in the jasperserver repository. This enables all the functionality of allowing admins to create customized UI themes and have them be viewable immediately. But all the theme work is the same for all DB platforms - so if the themes are loaded from the js-catalog-minimal file successfully then I would think that everything should work. Link to comment Share on other sites More sharing options...
cpsheff Posted March 29, 2011 Share Posted March 29, 2011 Thanks for that, I realised that I would have to use Buildomatic to get this sorted.I spotted another question you had replied to re. Oracle & switched from the Windows installer to the jasperreports-server-cp-4.0.0-bin.zip to use this instead.I have extracted this, copied the oracle_master.properties file to the buildomatic folder & renamed to default_master.properties & entered all the relevant details. I have then made several attempts to either upgrade or create a new db without success.If I try to use js-install-ce.bat I get the error in the attached js-install-ce_2011-03-29_14-13_13826.log file (I get a similar error when I try using js-upgrade-samedb-ce.bat).If I try to use the js-upgrade-newdb-ce.bat I seem to get further but it still fails - see attached js-upgrade-ce_2011-03-29_14-51_14208.log file.I have run through the configuration of import & export utilities but keep getting errors related to the summary error:Caused by: java.lang.ClassNotFoundException: com.jaspersoft.ji.hibernate.dialect.OracleUnicodeDialectI have tried editing the db.properties in conf_source\db\oracle to ensure all settings are correct & re-generating the build_conf but still no joy.I have been through the whole of the JasperReports-Server-CP-Install-Guide doc & can't see any other things to try - any pointers would be very gratefully received! Link to comment Share on other sites More sharing options...
ramnik Posted March 29, 2011 Share Posted March 29, 2011 1. Since, Oracle 10g is not certified for Community version, You are not able to find right instrcution in Install guide2. Regd ur issue :- you need to edit hibernate.properties file and change the dialect to oracle. By Default, it is mysql . Ramnik KaurSenior QA Engineer Link to comment Share on other sites More sharing options...
cpsheff Posted March 30, 2011 Share Posted March 30, 2011 Thanks, I have tried editing the hibernate.properties but keep getting the error: [java] Caused by: java.lang.ClassNotFoundException: com.jaspersoft.ji.hibernate.dialect.OracleUnicodeDialectI guess we are missing something for Oracle databases in CP version? Link to comment Share on other sites More sharing options...
tkavanagh Posted March 31, 2011 Share Posted March 31, 2011 Shoot, the he OracleUnicodeDialect.java is only in the Pro source code base. I would like to get any of the "pro" database building/configuring files into the Community source code. I'm working on that!Here is the dialect class, let me know if this works... hopefully there are not other dependencies ... com/jaspersoft/ji/hibernate/dialect/OracleUnicodeDialect.classHopefully, I'll have more to report to you regarding moving all the "pro" platform support to the Community code base. Link to comment Share on other sites More sharing options...
cpsheff Posted April 1, 2011 Share Posted April 1, 2011 Thanks - will try this out as soon as I can! Link to comment Share on other sites More sharing options...
toddbrook Posted April 1, 2011 Share Posted April 1, 2011 I've been working with cpsheff on this one and we now have jasperserver-cp-4.0.0 working against an oracle repository with jasperserver installed on windows.I think that this is a full list of what we had to do to get here.- get the war file distribution and unpack it- edit buildomatic\bin\validation.xml to allow installation against an oracle database (search for <fail>JasperServer CE doesn't support ${dbType} DB type!</fail> and add a line for oracle just above this)- edit buildomatic\conf_source\templates\js.jdbc.properties to specify oracle jdbc driver, connection url and repository user name and password- create and edit default_master.properties from oracle_master.properties as described in installation guide- copy buildomatic\install_resources\sql\oracle\js-pro-create.xml and rename it as js-create.ddl (or edit buildomatic\bin\db_common.xml to run js-pro-create.ddl instead of js-create.ddl)- drop a suitable ojdbc.jar into buildomatic\conf_source\ieCe\lib- create a jar from the OracleUnicodeDialect.class file attached above and drop this in buildomatic\conf_source\ieCe\lib- run js-install-ce.bat- once installer completes drop the OracleUnicodeDialect jar into webapps\jasperserver\WEB-INF\lib- make sure there is an ojdbc jar somewhere in your tomcat- start tomcat Link to comment Share on other sites More sharing options...
sappo Posted April 26, 2011 Share Posted April 26, 2011 Code:Hi guys, here are a few annotations to toodbrook's installation step, thanks for that btw. if you're like me not familiar how to build a jar file on the console cause usually the IDE is doing that job for you, here you go. At first create the folder structure "./com/jaspersoft/ji/hibernate/dialect" and copy the OracleUnicodeDialect.class into the last one. If your're working on Linux make sure the class's name is written in camel case. Now open the console navigate to the parent folder from "com" and execute "jar -cf OracleUnicodeDialect.jar ./com/jaspersoft/ji/hibernate/dialect/*.class Enjoy! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now