[displaying sql statement in Jdev 11]

OK, maybe I can explain what I'm looking for a different way.

 

Does anyone know how to set up logging such that the sql statement shows up in the log? What are the steps?

 

 

thanks,

 

Joe

 

[displaying sql statement in Jdev 11]

Hey Guys,

 

OK, I'm moving from Jdev 10 to Jdev 11 and, in 10, I have the logging set up so that I always see the sql statement JR is going to execute displayed in the console log. For some reason in 11, this isn't happening.

 

Does anyone know what hoops I have to jump through to get this to work?

 

Thanks,

 

Joe

[Compile difference between 3.5.2 and 3.76?]

Hi All,

 

Ok, I recently decided to move up to the new version of Jasper from V 3.5.2

 

All was good when I added the JAR to my JDev project and it compiles and runs fine.

 

However, when I compile with Maven and move over to our appserver running linux, I get

10/12/01 13:00:14 net.sf.jasperreports.engine.JRException: Error loading byte data : /opt/oracle/product/10gOC4J2/j2ee/home/caa001rr_1291237214488_88209.class
10/12/01 13:00:14     at net.sf.jasperreports.engine.util.JRLoader.loadBytes(JRLoader.java:290)
10/12/01 13:00:14     at net.sf.jasperreports.engine.design.JRAbstractClassCompiler.compileUnits(JRAbstractClassCompiler.java:69)
10/12/01 13:00:14     at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188)
10/12/01 13:00:14     at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215)

 

What the heck? If I move back to the 3.5.2 JAR it works just fine again. Can someone tell me what changed so I know what I have to change?

 

Thanks,

 

Jet

[Use Temp file?]

Hi Carl,

 

Thanks for checking. I know the property wasn't added until version 3.7.5 of JasperReports so I'm guessing that's why you're not seeing it. Of course, I don't see it in version 3.7.6 either!

 

Near as I can tell, it's just something you have to add by adding a property to the report in the properties dialog.

[Use Temp file?]

yes, I know they added it to Jasper, I was wondering if iReport had added support via a check box or something like that.

I haven't found it in my search.

 

Thanks.

[Use Temp file?]

Hi, Does the most current version of iReport allow you to set the

net.sf.jasperreports.export.jexcelapi.use.temporary.file property?

 

Thanks.

[Clicking in the left margin]

Really? No one knows what this does?

[Clicking in the left margin]

Ok, I accidently clicked in the the left margin of iReport and now my excel output has extra blank rows.

 

One, what is the click supposed to do?

and

two how the heck do I get rid of it!

 

Thanks,

Jet

[Excel found unreadable content in 'report.xml' ...]

Ah, got it. You need http://mirrors.ibiblio.org/pub/mirrors/maven/net.sourceforge.jexcelapi/jars/jxl-2.6.3.jar to go with Japer 3.1.4

[Excel found unreadable content in 'report.xml' ...]

I'm having the same problem. Seems worse with large reports.

I'm trying to use the JExcelApiExporter work around, but now I'm getting a "java.lang.NoSuchFieldError: AUTOMATIC" error. Apparently the JExcelApiExporter can't find "Colour.AUTOMATIC"

Any clue what library I need for it to find this?

 

 

[sub reports flat don't work for me]

Thanks, but I *think* I figured it out. The problem involved database connections. Seems that even if your all text header doesn't need the database, you better put a query in sub query or nothing will show up (or use the no data band). I just put in a 'select * from dual' and it seems to work.

 

Thanks for offering to help! It's much appreciated.

 

Jet

[sub reports flat don't work for me]

An update. It appears that the problem is only when running in iReport. In other words if I run the report from a java program the subreports will show up.

 

Makes it hard to use iReport as a developmenet tool.  :(

[sub reports flat don't work for me]

I'm very frustrated with ireport. I can't get a subreport to work in any way, shape or form.

I have tried the simplest of all sub reports and still no go. Can someone post a simple, simple version of a subreport that I can try?

What I'd like to do is have it in my pageHeader band.

 

Maybe I just need to reinstall iReport.

 

Has anyone else had such a baffling problem?

 

Thanks,

Jet