Andy Hahn

I found out the cause to this issue. It is not the same issue most people are experiencing, according to google. Maybe it will help somebody.

Our named query was returning NULL for a not-null column in a result set. We had to look at the sql hibernate was generating to determine this.

When we ran the sql manually in Sql Developer and sure enough we saw the NULL. This is an Oracle bug and our DBAs have opened a trouble ticket with Oracle.

Thanks-

Hi,
We are suddenly receiving the following exception in our production app when executing a named query which simply loads a collection of Org objects:
Caused by: org.springframework.orm.hibernate3.HibernateSystemException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.mycompany.model.hibernate.Org.setVrsnNbr; nested exception is org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.mycompany.model.hibernate.Org.setVrsnNbr at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:670) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:407) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372) at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:902) at com.mycompany.model.dao.hibernate.CommonDao.findNamedQuery(CommonDao.java:372) at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy8.findNamedQuery(Unknown Source) at com.mycompany.model.service.MyFileConfig.populateOrgMap(MyFileConfig.java:2544) .. 60 more Caused by: org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.mycompany.model.hibernate.Org.setVrsnNbr at org.hibernate.tuple.PojoTuplizer.setPropertyValuesWithOptimizer(PojoTuplizer.java:203) at org.hibernate.tuple.PojoTuplizer.setPropertyValues(PojoTuplizer.java:173) at org.hibernate.persister.entity.BasicEntityPersister.setPropertyValues(BasicEntityPersister.java:2919) at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113) at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:530) at org.hibernate.loader.Loader.doQuery(Loader.java:436) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218) at org.hibernate.loader.Loader.doList(Loader.java:1593) at org.hibernate.loader.Loader.list(Loader.java:1577) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at org.springframework.orm.hibernate3.HibernateTemplate$32.doInHibernate(HibernateTemplate.java:911) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367) .. 73 more Caused by: net.sf.cglib.beans.BulkBeanException at com.mycompany.model.hibernate.Org$$BulkBeanByCGLIB$$f3cf08e7.setPropertyValues(<generated>) at org.hibernate.tuple.PojoTuplizer.setPropertyValuesWithOptimizer(PojoTuplizer.java:200) .. 87 more Caused by: java.lang.NullPointerException .. 89 more

We have the vrsnNbr column defined as not null in the database.

Here is the mapping file:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping > <class name="com.mycompany.model.hibernate.Org" table="ORG" > <id name="orgId" column="ORG_ID" type="java.lang.Integer" > <generator class="com.mycompany.idgen.SeqPreAllocGen"> <param name="sequence">ORG_SEQ</param> <param name="max_lo">50</param> </generator> </id> <version name="vrsnNbr" column="VRSN_NBR" type="int" />

After googling for many hours I cannot seem to make sense of this exception. Any ideas would be welcomed!

Thanks-

Our DBA noticed some performance issues and ask if Hibernate used bind variables. I thought so but he checked the output from the Oracle logs and it doesnt look like it does, meaning it shows a plain insert into table () values();

If no, is there a way to make hibernate use bind variables on Session.save??

Thanks-

I try to avoid writing custom tags. I also hate maintaining them. But I see your point. Thanks

Looking for advice. To render my JSPs I am placing objects as request attributes and accessing them that way. Sometimes I need special methods that my pojos (most of which are hibernate) currently dont have. I would rather not add special formatting methods, etc to my pojos. Instead I would like to wrap the pojos with some type of view bean. Is there a recommended pattern for doing this?

Yeah I have used that, but man it can get messy fast. Especially with apache mod configs, and using taglibs to generate localized links (taglibs sometimes append on a session id). I think the easiest approach is to just put static files on a web server rather than embedding in a war/ear file. I hate to say that but its true. A servlet container is probably not the best place to store static content. So maybe thats why an exclude feature is not on the horizon even for the 3.0 servlet spec.

I am aware of the options, but I am intrigued by the servlet filter option. can you elaborate more on how that would work?

Is there a way to exclude files from a servlet-mapping url-pattern in an upcoming servlet spec? This is totally ridiculous if the answer is no.

I got rid of the HibernateCallback stuff and it works now. I don't think I would even need HibernateCallback since my Daos are wrapped by Service classes which are @Transactional.

I ended up also shortening my code to just return sqlQuery.list(). That slimmed down my code several lines.

Thanks for the advice!

For what kind of thing? I not sure if I've *ever* used it, although it's been a year or so.

For working with a SQLQuery object. Since createSQLQuery() is a method on session and not HibernateTemplate. My understanding is that I should to use HibernateCallback any time I work with session directly.

This is largely a matter of preference, but doesn't the list() method normally return an empty list? It just seems like you're making Hibernate *harder* to use, not easier.

Yes but I never liked the fact that Hibernate returns an empty collection - to me its like code that returns an empty String. I guess it just bugs me when code instantiates an unnecessary object. I also have a habit of checking nulls all the time. But I def see your point.

Im not sure why the parameters are not working. Maybe its a Hibernate bug in this particular version. I'll keep looking and let you know if I come up with anything. Thanks for looking.

I'd sure prefer a means of not having to build a map and list before every single query--to me it looks like you've eliminated the fluent query interface Hibernate provides and replaced it with what it was intended to fix.

I think Im stuck using the HibernateCallback for this type of thing, aren't I? How would you do it differently? I'm definitely interested in improving this code and if you can provide an example that would be great.

You also force a null check

You mean the method can return a null so someone would have to do a null check? Isn't that better than returning an empty collection? What's the alternative?

In any case, isn't setFirstResult() 0-based?

Yep I believe so. My example used a 1 for some reason.

Hi, I cant figure this out for the life of me. Any help is appreciated. Using Oracle 11g and Hibernate 3.0.5.

I have the following method in a class named HibernateQueryService:
public List executeSqlQuery(final String sql, final Map scalars, final Object[] parameterValues, final int firstRecord, final int maxResults) { List results = null; HibernateCallback callBack = new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { SQLQuery sqlQuery = session.createSQLQuery(sql); if (scalars != null) { for (Iterator it = scalars.entrySet().iterator(); it.hasNext();) { Map.Entry entry = (Map.Entry) it.next(); sqlQuery.addScalar((String)entry.getKey(), (Type) entry.getValue()); } } sqlQuery.setFirstResult(firstRecord); sqlQuery.setMaxResults(maxResults); if (parameterValues != null) { for (int i = 0; i < parameterValues.length; i++) { sqlQuery.setParameter(i, parameterValues[i]); } } return sqlQuery.list(); } }; ArrayList list = (ArrayList) getHibernateTemplate().execute(callBack, true); if (list != null && list.size() > 0) { results = list; } return results; }

and I get no results back when I run this code:

List parameters = new ArrayList(); parameters.add("12345"); Map scalars = new HashMap(); scalars.put("org_id", Hibernate.INTEGER); List orgIds = hibernateGenericQueryService.executeSqlQuery("select org_id from org where org_id = ?", scalars, parameters.toArray(), 1, 20);

The record exists in the table. The query works if hard code the org_id value in the sql instead of using the parameter - "?". Thoughts?

OK thanks. I wanted to avoid using a prefix since masking all of that with rules, etc in mod_jk is a pain and I really want short seo urls coming off of my domain name. I ended up just moving all of my images, css, js, etc to a web server so now I can filter everything using /*.

<servlet-mapping> <servlet-name>dispatcher</servlet-name> <url-pattern>/*</url-pattern> </servlet-mapping>

Is there any way to tell the <url-pattern> to exclude certain items? This question must come up a lot since MVC frameworks love to filter stuff, including css, images, and js scripts! If not, does anyone know if this will be available in a future servlet spec?
Thanks

I would like to create a secure login using spring security but I would also not like to use HttpSession. Does anyone know a good way of doing this?