robbr
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by robbr
-
-
I have the applicationContext.xml on the classpath with the sessionFactory bean. I'm using annotations with Spring and Hibernate. Now when I test the connection I get a cryptic error:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: Address near line 1, column 27 [select address as address Address as address]
The stack trace is absolutely no help, there is no "Caused By: " entry. Why is this statement even being executed? My Query text is blank. Even when I comment out all the mappings in my hibernate configuration file it tries to do this.Thanks in advance I'm really stumped on this one. -
I'm using Spring with Hibernate and need to generate a Jasper report from some of the data in the beans so I fired up iReport and defined a Spring Loaded Hibernate Connection. My application connects to the database fine but I can't seem to get it hooked up to iReport. I have applicationContext.xml on the classpath and mysql-connector-java-<version>-bin.jar loaded as well yet no matter what I try I get a stack trace with
No suitable driver found for jdbc:mysql://127.0.0.1:3306/databasename
I know it's finding com.mysql.jdbc.Driver because when I change the name in hibernate.properties I get a different error. I copied the mysql-connector jar to the ext folder of my JDK as well. I also tried typing localhost instead of the ip and connecting to any and all databases I had locally. Nothing will get me connected. What can I do to diagnose/fix this problem? Thanks in advance.
Post Edited by robbr at 09/21/2009 11:38
Getting fields from JRBeanCollectionDataSource
in Products
Posted
I passed a JRBeanCollectionDataSource in to my report parameters and can display the serialized object just fine, but obviously I need to be able to display specific fields from the data source. This sounds simple but I cannot find a way to do it!
I try using getFieldValue() but how am I supposed to get the JRField? Shouldn't there just be a method that takes a String and returns the entry at that field for that space in the report?
I thought maybe $P{JRDataSource}.getFieldValue(JRFillElement.getField("id")) would work but getField is protected.
What is the correct way to do this?
Thanks in advance.