Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Error SQL Error: 393216, SQLState: 60000
ygu
2013-10-09 05:05:58.0
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.0
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.0
Still the same issue.
Re:Re:Error SQL Error: 393216, SQLState: 60000
ygu
2013-10-09 08:13:25.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
You can.
Re:Re:Re:Re:Re:Re:Re:Re:Error SQL Error: 393216, SQLState: 60000
ygu
2013-10-11 02:28:29.0
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.0
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.0
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.0
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.0
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.0
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.0
Solved with the fix

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap