andrewsok

Hi, I cannot reproduce it in my environment, it does produce pdf. You have the %20 at the end of the report location, which is a concern to me. Do you see anything specific in the log? Thanks!

Is it possible that you have java 1.5 also installed on your box, and tomcat uses it for some reason? The error text makes me think about this case..

Caleb, Look at DefaultParametersForm.jsp page, or ReportTopParametersForm.jsp if you use "top of the page" settings. The page defines how Input Controls render. To implement search, you will need to add server logic as well.

I am not sure what kind of help you are looking for... But let's see what options you have: 1) You leave you views, you create reports in iReport and deploy them in JS Pros: - the process is straight forward Cons: - you leave views -> maintenance and possibly inherited mess in queries - need to use iReport 2) You leave views, and create domains on top of them (threat them as tables) Pros: - all work in JS UI - may take advantages of domains (security, business view structure, data strategies, etc.) Cons: - you leave views -> maintenance and possibly inherited mess in queries 3) You create domains from scratch, and map all your views to derived table by just copying your view queries there Pros: - a single maintenance point (domain) - a possibility for incremental clean-up (you don't have to do everything at once) Cons: - some extra work is involved 4) You create domains from scratch, and create a new structure for your needs based on tables Pros: - a single maintenance point (domain) - you get it all fresh and clean Cons: - more extra work is involved As of best practice, it depends on your priorities. The quickest thing would probably be (2). The progressive thing with reduced risk would be (3). The getting it right (at expense of time and efforts) would be (4). And if you are not confortable with domains, (1) is there for you. Thanks, Andrew S.

The config file applicationContext-semanticLayer.xml declares all functions that DomEL supports. There is "if" functions there : <entry key="if"> <value>"case when (" + sqlArgs[0] + ") then (" + sqlArgs[1] + ") else (" + sqlArgs[2] + ") end"</value> </entry> If you call "if(f1, f2, f3)", f1 would be your condition field (boolean), f2 is the field reference to be used then f1==true, and f3 is the field to be used when f1==false Your requirement would look like following : you declare SalaryBand field and assign an expression if("Empoyee"."Salary" < 10000, 'Low', if("Empoyee"."Salary" < 40000, 'Medium', 'High'))

Timestamp with time zone is not a standard JDBC data type, therefore you need to add it in applicationContext-semanticLayer.xml, bean jdbcMetaConfiguration, entry OTHER (where NVARCHAR2 is declared). If you have problems finding out the vendor type name, please, paste here the exact table create SQL script which shows all types, and I will try to recreate it and tell you the name.

Here is result on my sample tables: SYN_CLOBTABLE ID : 3 : NUMBER TEXT : 2005 : CLOB SYN_MZHOU ID : 3 : NUMBER COL1 : 1111 : NCHAR COL2 : 1111 : NVARCHAR2 COL3 : 12 : VARCHAR2 COL4 : 12 : VARCHAR2 It looks like your result does not show fields. By exception you get, it might be the case where you have some special characters in the field names which are not compatble with JDBC drver. Unfortunatelly, JDBC is the only way JS may get the metainfo from the DB, and if driver does not support something, nothing we can do on JS side...

Actually, the point of exercise was to see fields, not tables. The setIncludeSynonyms(true) affects only fields. Example of properly working driver : TABLE1 FIELD1 FIELD2 TABLE2 FIELD1 FIELD2 Example of problematic driver : TABLE1 TABLE2 In later case fields do not show up. When you ran the mini app, did you see fields?

I am now sure what your developer skills are, but let me try... To separate JS issues from Oracle issues, could you take the attached zip, unpack, comlipe and run the sample app against your oracle with your driver, and see it if shows all synonym tables and fields properly? This way we will make sure JDBC works as it is supposed to. The line setIncludeSynonyms(true) is what we call when you set the config option into true.

The version 3.7 supports NVARCHAR2, and provides a framework to configure supporting any other non-standard vendor specific types (see applicationContext-semanticLayer.xml)

linvicch Wrote: my synonyms table works BUT NOW my non Synonyms table doesn't work throwing me the error At present time tables which doesn't contain any columns are not supported. Following empty tables will not be added I cannot reproduce this on my 10.2.0.1.0.. Could you provide as much info as you can, such as - DB version - JDBC driver version - create table and synonym scripts - possibly related messages in JS log

linvicch Wrote: By slow in performance, what will that affect? Does it affect the performance of future query or only on initial setup? This is about getting metadata (table/column names/types) performance. It does not affect query execution performance but slows down the how system resonses to user in domain designer where JasperServer has to wait for oracle JDBC driver. For example, user expands table node to see columns, and it may easily take 5 seconds to open it, and all time is spent in the driver method (actually, in DB itself).

Because Oracle decided to not show columns on synonym tables by default (JDBC driver performs very slow on this operation), you have to enable it in the configuration before using: applicationContext-semanticLayer.xml: ... <property name="includeSynonymsForOracle"> <!-- set 'true' if you use Oracle synonyms in Domains --> <value>false</value> </property> Set the property vale to "true" and restart the server.

This URL does not present WebServices interface. It gets handled by a normal HTTP Servlet (see web.xml). The functionality is provided by Mondrian, and it does not support GET method. Could you post more details where you get the exception (stack trace, etc.)?

URL parameters are case sensitive. It should be _flowId=viewReportFlow Post Edited by andrewsok at 01/26/2010 22:10