ASTQueryTranslatorFactory or ClassicQueryTranslatorFactory

[Mark Johnson-13]

It appears that in the default properties.xml atleap rc3 is setup to  
use the ClassicQueryTranslatorFactory; however, when I go to deploy the  
latest version of atleap on tomcat 5.0 using the  
ClassicQueryTranslatorFactory I get a failure.  I am pasting the stack  
trace below.  Any help I would appreciate very much!

2006-02-27 09:38:11 NamingContextListener[/Catalina/localhost/atleap]:  
   
ResourceRef[className=javax.sql.DataSource,factoryClassLocation=null,fac
toryClassName=org.apache.naming.factory.ResourceFactory,{type=scope,cont
ent=Shareable},{type=auth,content=Container},{type=url,content=jdbc:
mysql://localhost:3306/atleap_db?characterEncoding=utf
-8&useUnicode=true&autoReconnect=true},{type=maxIdle,content=30},{type=m
axActive,content=20},{type=driverClassName,content=com.mysql.jdbc.Driver
},{type=maxWait,content=10000},{type=removeAbandoned,content=true},{type
=username,content=root},{type=factory,content=org.apache.commons.dbcp.Ba
sicDataSourceFactory},{type=logAbandoned,content=true},{type=defaultAuto
Commit,content=true},{type=removeAbandonedTimeout,content=60},{type=pass
word,content=}]
2006-02-27 09:38:11 NamingContextListener[/Catalina/localhost/atleap]:  
  Resource parameters for UserTransaction = null
2006-02-27 09:38:11 StandardContext[/atleap]Loading Spring root  
WebApplicationContext
2006-02-27 09:39:35 StandardContext[/atleap]Exception sending context  
initialized event to listener instance of class  
com.blandware.atleap.webapp.listener.StartupListener
org.springframework.orm.hibernate3.HibernateSystemException: ordinal  
parameter mismatch; nested exception is  
org.hibernate.HibernateException: ordinal parameter mismatch
org.hibernate.HibernateException: ordinal parameter mismatch
        at  
org.hibernate.engine.query.HQLQueryPlan.buildParameterMetadata(HQLQueryP
lan.java:206)
        at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:90)
        at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:52)
        at  
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache
.java:71)
        at  
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionIm
pl.java:108)
        at  
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.j
ava:88)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at  
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at  
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at  
org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInv
ocationHandler.invoke(HibernateTemplate.java:1178)
        at $Proxy19.createQuery(Unknown Source)
        at  
com.blandware.atleap.persistence.hibernate.core.BaseDAOHibernate$1.doInH
ibernate(BaseDAOHibernate.java:240)
        at  
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTe
mplate.java:365)
        at  
org.springframework.orm.hibernate3.HibernateTemplate.executeFind(Hiberna
teTemplate.java:337)
        at  
com.blandware.atleap.persistence.hibernate.core.BaseDAOHibernate.execute
Find(BaseDAOHibernate.java:238)
        at  
com.blandware.atleap.persistence.hibernate.core.BaseDAOHibernate.execute
Find(BaseDAOHibernate.java:102)
        at  
com.blandware.atleap.persistence.hibernate.core.MenuDAOHibernate.findMen
uItemByIdentifierAndParentAndOwner(MenuDAOHibernate.java:173)
        at  
com.blandware.atleap.service.core.impl.MenuManagerImpl.findMenuItemByIde
ntifierAndParentAndOwner(MenuManagerImpl.java:201)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at  
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at  
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at  
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(
AopUtils.java:335)
        at  
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp
oint(ReflectiveMethodInvocation.java:181)
        at  
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref
lectiveMethodInvocation.java:148)
        at  
org.springframework.transaction.interceptor.TransactionInterceptor.invok
e(TransactionInterceptor.java:96)
        at  
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref
lectiveMethodInvocation.java:170)
        at  
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo
pProxy.java:176)
        at $Proxy9.findMenuItemByIdentifierAndParentAndOwner(Unknown Source)
        at  
com.blandware.atleap.webapp.util.core.MenuUtil.processRedifinitions(Menu
Util.java:708)
        at  
com.blandware.atleap.webapp.util.core.MenuUtil.initializeMenuRepository(
MenuUtil.java:613)
        at  
com.blandware.atleap.webapp.listener.StartupListener.contextInitialized(
StartupListener.java:191)
        at  
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j
ava:3827)
        at  
org.apache.catalina.core.StandardContext.start(StandardContext.java:
4343)
        at  
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja
va:823)
        at  
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
        at  
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
        at  
org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeplo
yer.java:903)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at  
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at  
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at  
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:
216)
        at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)
        at org.apache.commons.digester.Rule.end(Rule.java:276)
        at org.apache.commons.digester.Digester.endElement(Digester.java:1058)
        at  
org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.ja
va:76)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown  
Source)
        at  
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unk
nown Source)
        at  
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDis
patcher.dispatch(Unknown Source)
        at  
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unkno
wn Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.apache.commons.digester.Digester.parse(Digester.java:1567)
        at  
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeploy
er.java:488)
        at org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
        at  
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java
:483)
        at  
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
        at  
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:
349)
        at  
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
pport.java:119)
        at  
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
        at  
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
        at  
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
        at  
org.apache.catalina.core.StandardService.start(StandardService.java:
480)
        at  
org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at  
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at  
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)

2006-02-27 09:39:35 StandardContext[/atleap]Closing Spring root  
WebApplicationContext

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@...
For additional commands, e-mail: issues-help@...

[agrebnev]

Hello Mark,

Monday, February 27, 2006, 8:46:43 PM, you wrote:

MJ> It appears that in the default properties.xml atleap rc3 is setup to
MJ> use the ClassicQueryTranslatorFactory; however, when I go to deploy the
MJ> latest version of atleap on tomcat 5.0 using the  
MJ> ClassicQueryTranslatorFactory I get a failure.  I am pasting the stack
MJ> trace below.  Any help I would appreciate very much!

MJ> 2006-02-27 09:38:11
MJ> NamingContextListener[/Catalina/localhost/atleap]:  
   
MJ> org.hibernate.engine.query.HQLQueryPlan.buildParameterMetadata(HQLQueryP
MJ> lan.java:206)
MJ> at
MJ> com.blandware.atleap.persistence.hibernate.core.MenuDAOHibernate.findMen
MJ> uItemByIdentifierAndParentAndOwner(MenuDAOHibernate.java:173)
MJ> at  
MJ> com.blandware.atleap.webapp.listener.StartupListener.contextInitialized(
MJ> StartupListener.java:191)
MJ> at  

Why do you think that the reason is in ClassicQueryTranslatorFactory?

I cannot reproduce this bug.

I think you have some extra hibernate or near libraries in your
classpath (e.g. in env CLASSPATH or in %CATALINA_HOME%\common\lib)


On the other hand you can try to update your
Hibernate version to 3.1.2 e.g. because there is difference

Hibernate 3.1.1
                if ( parameterTranslations.supportsOrdinalParameterMetadata() && locations.length != ordinalParamCount ) {
                        throw new HibernateException( "ordinal parameter mismatch" );
                }
and for ClassicQueryTranslatorFactory it will be false;

Hibernate 3.1rc3 (which in AtLeap0.5rc3)
                if ( locations.length != ordinalParamCount ) {
                        throw new HibernateException( "ordinal parameter mismatch" );
                }

Also see
http://opensource2.atlassian.com/projects/hibernate/browse/HHH-1404
http://opensource2.atlassian.com/projects/hibernate/browse/HHH-1423

--
Best regards,
 Andrey Grebnev                            mailto:andrey.grebnev@...

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@...
For additional commands, e-mail: issues-help@...

[agrebnev]

Hello Andrey,

Tuesday, February 28, 2006, 4:39:56 PM, you wrote:

AG> Hello Mark,

AG> Monday, February 27, 2006, 8:46:43 PM, you wrote:

MJ>> It appears that in the default properties.xml atleap rc3 is setup to
MJ>> use the ClassicQueryTranslatorFactory; however, when I go to deploy the
MJ>> latest version of atleap on tomcat 5.0 using the  
MJ>> ClassicQueryTranslatorFactory I get a failure.  I am pasting the stack
MJ>> trace below.  Any help I would appreciate very much!

MJ>> 2006-02-27 09:38:11
MJ>> NamingContextListener[/Catalina/localhost/atleap]:  
   
MJ>> org.hibernate.engine.query.HQLQueryPlan.buildParameterMetadata(HQLQueryP
MJ>> lan.java:206)
MJ>> at
MJ>> com.blandware.atleap.persistence.hibernate.core.MenuDAOHibernate.findMen
MJ>> uItemByIdentifierAndParentAndOwner(MenuDAOHibernate.java:173)
MJ>> at  
MJ>> com.blandware.atleap.webapp.listener.StartupListener.contextInitialized(
MJ>> StartupListener.java:191)
MJ>> at  

AG> Why do you think that the reason is in ClassicQueryTranslatorFactory?

AG> I cannot reproduce this bug.

AG> I think you have some extra hibernate or near libraries in your
AG> classpath (e.g. in env CLASSPATH or in %CATALINA_HOME%\common\lib)


AG> On the other hand you can try to update your
AG> Hibernate version to 3.1.2 e.g. because there is difference

AG> Hibernate 3.1.1
AG>                 if (
AG> parameterTranslations.supportsOrdinalParameterMetadata() &&
AG> locations.length != ordinalParamCount ) {
AG>                         throw new HibernateException(
AG> "ordinal parameter mismatch" );
AG>                 }
AG> and for ClassicQueryTranslatorFactory it will be false;

AG> Hibernate 3.1rc3 (which in AtLeap0.5rc3)
AG>                 if ( locations.length != ordinalParamCount ) {
AG>                         throw new HibernateException(
AG> "ordinal parameter mismatch" );
AG>                 }

AG> Also see
AG> http://opensource2.atlassian.com/projects/hibernate/browse/HHH-1404
AG> http://opensource2.atlassian.com/projects/hibernate/browse/HHH-1423


Ehhh... look at http://forum.hibernate.org/viewtopic.php?t=950694

--
Best regards,
 Andrey Grebnev                            mailto:andrey.grebnev@...

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@...
For additional commands, e-mail: issues-help@...