bhaugland Posted October 13, 2006 Share Posted October 13, 2006 Is there any news about the availability of an oracle patch for 1.1. I have tried generating the scripts myself using the source from the source zip file but have been unable to compile. Link to comment Share on other sites More sharing options...
timmyd Posted October 27, 2006 Share Posted October 27, 2006 Why don't you post the stuff that you've done, and maybe we can work on it together. Link to comment Share on other sites More sharing options...
swood Posted November 1, 2006 Share Posted November 1, 2006 We are working on this. ShermanJasperSoft Link to comment Share on other sites More sharing options...
JamesCG26 Posted November 1, 2006 Share Posted November 1, 2006 Hi, I have Jasper Intelligence working in oracle already. Just finished it now. It required no code changes, just the database setting up correctly. Link to comment Share on other sites More sharing options...
bhaugland Posted November 2, 2006 Author Share Posted November 2, 2006 I managed to get JasperIntelligence 1.1 running on oracle using the oracle patch for 1.0.1. However I am not sure if there were any database changes that might affect the run. Could you shed some light on this ThanksBruce Haugland Link to comment Share on other sites More sharing options...
sbirney Posted November 4, 2006 Share Posted November 4, 2006 hello, here are the instructions and files that I used to convert a 1.1.0 install to use oracle for the metadata. Let me know if it is not clear in any way. thanks,Sam [file name=oracle_patch_1.zip size=6461]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/oracle_patch_1.zip[/file] Link to comment Share on other sites More sharing options...
kartikgajjar Posted November 6, 2006 Share Posted November 6, 2006 Hi, I'm able to connect, login after oracle connection. Created folder & data source. While saving report unit received following error. org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@126a408 targetAction = com.jaspersoft.jasperserver.war.action.ReportUnitAction@1db3e20, attributes = map[[empty]]] in state 'saveReport' of flow 'reportUnitFlow'; nested exception is org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed Has above to do anything with oracle version, mine is 8.1.7.3 Link to comment Share on other sites More sharing options...
csmth Posted January 18, 2007 Share Posted January 18, 2007 kartikgajjar wrote:Hi, I'm able to connect, login after oracle connection.Created folder & data source. While saving report unit received following error.org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@126a408 targetAction = com.jaspersoft.jasperserver.war.action.ReportUnitAction@1db3e20, attributes = map[[empty]]] in state 'saveReport' of flow 'reportUnitFlow'; nested exception is org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failedHas above to do anything with oracle version, mine is 8.1.7.3 It is not version specific. I am testing JI with oracle 9.2.0.6 Link to comment Share on other sites More sharing options...
csmth Posted January 19, 2007 Share Posted January 19, 2007 I think the error message is more clear in oracle10g environment, when creating saving a validated report:org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@1c98c1b targetAction = com.jaspersoft.jasperserver.war.action.ReportUnitAction@10d78ec, attributes = map[[empty]]] in state 'saveReport' of flow 'reportUnitFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]; uncategorized SQLException for SQL [insert into JIFileResource (data, file_type, reference, id) values (?, ?, ?, ?)]; SQL state [72000]; error code [1460]; ORA-01460: unimplemented or unreasonable conversion requested ; nested exception is java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested Post edited by: csmth, at: 2007/01/19 06:49Post edited by: csmth, at: 2007/01/19 07:21 Link to comment Share on other sites More sharing options...
tkavanagh Posted January 19, 2007 Share Posted January 19, 2007 I saw this same error message when debugging an issue for a remote client. What was found was that the NLS_LANG setting was not the same between the Oracle client and the Oracle Server. The default setting of NLS_LANG is american_american_ascii7 (or similar). This will be the setting if no NLS_LANG env var is set. You can check to see that the server and the client have the same settings. Anyway, this is one way to get this particular error. Link to comment Share on other sites More sharing options...
taborda Posted March 19, 2007 Share Posted March 19, 2007 Where can i find the Oracle patch for JS 1.2.0 ?? ;) best regards,João Taborda 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