chriswright

I have a SLES 11server giving the following error towards the end of the installation: Problem running post-install step. Installation may not complete correctly Error running /opt/jasperreports-server-cp-4.2.1/apache-ant/bin/ant import-ce -DimportFile=install_resources/export/js-catalog : BUILD FAILED /opt/jasperreports-server-cp-4.2.1/buildomatic/bin/import-export.xml:252: The following error occurred while executing this line: /opt/jasperreports-server-cp-4.2.1/buildomatic/bin/import-export.xml:158: Java returned: 255 any help greatly appreciated.. thanks

Does an yone have JasperServer 4.0 working with LDAP authentication enabled?

I have installed 4.0 on a SLES 11 VM. The installation is fine - jasperadmin login works, sample reports work... I want to get LDAP working as I did in 3.7. I modify applicationContext-security.xml and uncomment sections for LDAP. I'm getting: 2011-05-11 08:51:00,188 ERROR ContextLoader,main:215 - Context initialization failed org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 116 in XML document from ServletContext resource [/WEB-INF/applicationContext-security.xml] is invalid; nested exception is org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'bean'. One of '{"http://www.springframework.org/schema/beans":meta, "http://www.springframework.org/schema/beans":constructor-arg, "http://www.springframework.org/schema/beans":property, "http://www.springframework.org/schema/beans":lookup-method, "http://www.springframework.org/schema/beans":replaced-method, WC[##other:"http://www.springframework.org/schema/beans"]}' is expected. Line 116 of the file is: <bean id="ldapAuthenticationProvider" class="org.springframework.security.providers.ldap.LdapAuthenticationProvider"> <constructor-arg> An d following lines are: <bean class="org.springframework.security.providers.ldap.authenticator.BindAuthenticator"> <constructor-arg><ref local="ldapContextSource"/></constructor-arg> <property name="userDnPatterns"><list><value>uid={0},ou=baltimore,ou=tech</value></list></property> <property name="userSearch" ref="userSearch"/> </bean> </constructor-arg> <constructor-arg> <bean class="org.springframework.security.ldap.populator.DefaultLdapAuthoritiesPopulator"> <constructor-arg index="0"><ref local="ldapContextSource"/></constructor-arg> <constructor-arg index="1"><value></value></constructor-arg> <property name="groupRoleAttribute"><value>cn</value></property> <property name="groupSearchFilter"><value>(&(uniqueMember={0})(objectclass=groupofuniquenames))</value></property> <property name="searchSubtree"><value>true</value></property> </bean> </constructor-arg> </bean> I'm befuddled... any help will be greatly appreciated. Thanks Chris

I'm having a problem with the clob data type. I found a workaround but thought I'd post here to search for a true fix. I've configured a data source to access a MS SQL 2000 database. I couldn't get Microsoft drivers to work so instead I'm using net.sourceforge.jtds.jdbc.Driver. My url is jdbc:jtds:sqlserver://ipaddress/databaseName. Also to get this to work. I went to Tools,Options, Classpath tab and added jtds-1.2.5.jar The SQL database table I am accessing has a field named 'ResumeText' with a data type of TEXT, length 16. If I add the field to my report query it shows in iReport as a data type of clob. So, now the problem... When I preview my report, instead of seeing the actual text in the field I see "net.sourceforge.jtds.jdbc.ClobImpl@____" . The workaround I discovered: In my report query instead of 'Select Resumetext' I do a 'Select CAST(resumetext as varchar(8000))'. This works but will have issues if I have more than 8000 characters. Not sure if this will happen, but nonetheless this workaround isn't quite right. Seems to me I should be able to leave the type as clob and not run the risk of truncation. Any help greatly appreciated Chris

Greetings, I'd really like to get a look at the Cascading multi select example in ireport but can't find the jrxml file to do so. Any help appreciated. thanks Chris

Naresh, I am a newbie but might be able to help you with your comment about writing a single query. After configuring my data source I was able to simply launch the report wizard and use the design query button which presents a gui that enables multiple table selection and automatically finds the join conditions between tables. You can use the gui to modify the join condition or flip over to the sql tab and manually modify. I found the interface to be intuitive. This is in the community edition. Hope this helps. Chris

Svenn, I did change the underlying format to date in the datasource. As to why the dates are being stored as varchar(50) I don't know. The application is an open-source project that I am customizing for my use. I can change the field to date from varchar(50) but will need to do some exensive checking to make sure this doesn't break anything. So anyway, having changed the format to "date" from varchar(50) in the datasource (which is a mysql database), the problem still exists. Again it seems to me there should be a way to see more about why the jrxml doesn't compile (i.e I can't view with the JRViewer. Is there an error log anywhere? Thanks for your help

Svenn, I went to mysql and chaned the field format to date from varchar(50) which is how the application was configured. I assume this is what you meant by $F{timeentry_DateWorked} should be a date object. I changed the class to: java.lang.String. It still doesn't work. Wth this config the expression $F{timeentry_DateWorked} now doesn't work either. Is there an error log somewhere to look at? thanks Chris

I am new to JasperReports and iReport ... I'm trying to format a date and have entered the expression: new SimpleDateFormat("dd/MM/yyyy").format($F{timeentry_DateWorked}) Under the expression editor, validation errors tab I get: Expression successfully validated. (the text is red however) I have the class set to: java.util.Date and evaluation time is set to: now I have been testing whethre it works by using the Build, Execute (with active connection) menu choice. Nothing is displayed. If I change the expression to simply: $F{timeentry_DateWorked} and the class to string it works. Also, it would be nice to see what my problem is by looking at a log file or something to give me more info. Your help is much appreciated thanks