Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-09 05:05:58 |
Hi,
We are using hxtt version 5.1.169 for an ms access database and we are getting the following error with this request (the request works in access):
11:36:59,022 INFO [stdout] (http--10.129.2.201-9090-6) Hibernate: select distinct property1_.name as col_0_0_, property1_.attribute as col_1_0_, property1_.defaultProperty as col_2_0_ from T_USER user0_ inner join Property property1_ on user0_.property_id=property1_.id where user0_.id in (?)
11:36:59,022 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--10.129.2.201-9090-6) SQL Error: 393216, SQLState: 60000
11:36:59,022 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--10.129.2.201-9090-6) java.lang.ArrayIndexOutOfBoundsException: 1
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.ah.if(Unknown Source)
at com.hxtt.sql.a5.a(Unknown Source)
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bz.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.d5.executeQuery(Unknown Source)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy127.executeQuery(Unknown Source)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1978)
at org.hibernate.loader.Loader.doQuery(Loader.java:829)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
at org.hibernate.loader.Loader.doList(Loader.java:2463)
at org.hibernate.loader.Loader.doList(Loader.java:2449)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2279)
at org.hibernate.loader.Loader.list(Loader.java:2274)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1115)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:252)
at org.jboss.as.jpa.container.QueryNonTxInvocationDetacher.getResultList(QueryNonTxInvocationDetacher.java:58)
Could you please advise?
Regards
|
Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-09 07:07:33 |
|
Failed to recur your issue with v5.1.173 . Please donwload it.
|
Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-09 08:10:29 |
|
Still the same issue.
|
Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-09 08:13:25 |
Here is the hibernate equivalent if it might help
SELECT DISTINCT new com.entity.Property (t.name, t.attribute, t.defaultProperty)
FROM User u
JOIN u.property t
WHERE u.id IN :idUsers
|
Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-09 17:26:23 |
|
Still failed to recur your issue. Please email us your database sample.
|
Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-10 03:16:45 |
Hi,
I've sent to support@hxtt.com a sample web application, the query and the mdb file.
Thanks in advance.
Regards
|
Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-10 06:50:40 |
Did you manage to get the application started?
|
Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-10 07:13:59 |
|
Get it, but met some issues to start it. I have changed the host name from atribute into localhost. But met a "javax.el.PropertyNotFoundException: /index.xhtml" Are you using JDK1.7.X? I'm using JDK1.6.0, so that maybe it's the issue key. I'm tring to rebuild the access.app.war file.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-10 07:54:53 |
Indeed, we are using JDK 1.7 update 25, not sure it makes a difference in this case.
Can you tell me what proprerty is not found?
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-10 08:09:19 |
javax.el.PropertyNotFoundException: /index.xhtml @18,83 value="#{memberRegistration.firstName}": Target Unreachable, identifier 'memberRegistration' resolved to null: javax.el.PropertyNotFoundException: /index.xhtml @18,83 value="#{memberRegistration.firstName}": Target Unreachable, identifier 'memberRegistration' resolved to null
at com.sun.faces.facelets.el.TagValueExpression.getType(TagValueExpression.java:100)
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-10 08:09:56 |
|
I have used JDK1.7.X now.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-10 08:26:13 |
|
Checked. No any class file in access.app.war\WEB-INF\classes\
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-10 09:20:29 |
|
I've sent a new war archive this time with the classes.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-10 09:23:19 |
|
Thanks. I have rebuilt it and recur your issue. The issue will be checked tomorrow.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-10 20:49:57 |
|
2013-10-11 fixed an ArrayIndexOutOfBoundsException bug for prepared parameter since 2013-08-09.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-11 00:54:24 |
|
can we download the fixed version?
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-11 01:49:32 |
|
You can.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-11 02:28:29 |
|
Solved. Thank you very much.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-14 08:51:03 |
Hi,
We get the same error this time with the following stack trace:
15:20:48,659 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-SSM-00637.mph.morpho.com-10.129.2.201-9090-1) SQL Error: 393216, SQLState: 60000
15:20:48,674 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-SSM-00637.mph.morpho.com-10.129.2.201-9090-1) java.lang.ClassCastException: com.hxtt.sql.dx cannot be cast to [Ljava.lang.Object;
at com.hxtt.sql.b3.a(Unknown Source)
at com.hxtt.e.m.if(Unknown Source)
at com.hxtt.e.m.do(Unknown Source)
at com.hxtt.sql.ct.a(Unknown Source)
at com.hxtt.sql.ct.a(Unknown Source)
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.bz.a(Unknown Source)
at com.hxtt.sql.bz.a(Unknown Source)
at com.hxtt.sql.bz.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.d5.executeQuery(Unknown Source)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy127.executeQuery(Unknown Source)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1978)
at org.hibernate.loader.Loader.doQuery(Loader.java:829)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
at org.hibernate.loader.Loader.doList(Loader.java:2463)
at org.hibernate.loader.Loader.doList(Loader.java:2449)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2279)
at org.hibernate.loader.Loader.list(Loader.java:2274)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1115)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:252)
at org.jboss.as.jpa.container.QueryNonTxInvocationDetacher.getResultList(QueryNonTxInvocationDetacher.java:58)
It seems to happen when the prepared statement parameter is a list.
For instance:
"WHERE user.id IN :idUsers"
and idUsers is a List
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-14 20:27:59 |
Failed to recur your issue throuh modifing the following code:
public
Object business_get_matricule(
) {
final Query query =
em.createNamedQuery("business_get_matricule");
List vs=new ArrayList(5);
vs.add(new Long(10L));
vs.add(new Long(11L));
query.setParameter("id",vs );
// query.setParameter("id", 10L);
query.getResultList();
return query.getResultList().isEmpty() ? null : query.getResultList().get(0);
}
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-17 17:41:22 |
|
Pleae let us know more detailed information to recur your issue. Thanks.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-18 08:24:30 |
|
Sent an email with sample app to support.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
HXTT Support |
2013-10-19 22:15:40 |
|
2013-10-19 fixed a table order adjustment seldom bug for when utilizes component index match partly for JOIN sql since 2013-06-29.
|
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000 |
ygu |
2013-10-21 07:08:28 |
|
Solved with the fix
|
Main
webmaster@hxtt.com