os.luisgustavo Posted July 28, 2014 Share Posted July 28, 2014 Good afternoon everyone! I use ireport 3.7.1, and Oracle Database 11g I have the following problem, when I compile and run a query with outer join(oracle) in Ireport, works normally and returns the expected result. But when I run the application in JSF the query with outer join, have problems and the result does not return as expected. Apparently the problem is that the ireport is failing to understand the outer join. Was that possible? Does anyone have a solution for this problem? This is the query: SELECT a.nameCompany, FROM company a, products b WHERE A.cod = b.cod(+) ORDER BY a.nameCOMPANY[/code] Thanks! Link to comment Share on other sites More sharing options...
marianol Posted July 28, 2014 Share Posted July 28, 2014 Which version of the JR Library are you running in your JSF application? Also do the JDBC drivers and Java Versions match from iReport 3.7.1 and your JSF app? Link to comment Share on other sites More sharing options...
hozawa Posted July 29, 2014 Share Posted July 29, 2014 iReport is just calling jdbc driver to get results.Also, if iReport is working normally while your jsf program is not, it seems to indicate that your jsf is not working. Apparently, you jsf program is having problems. Fix that. Make sure that it's using the correct jdbc driver. JDBC driver version should match the supported jdk version. 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