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
Queries are not recognised in SELECT clauses
Andrea Spinelli
2005-08-22 00:00:00.0
Hello,

It seems to me tha the JDBC driver does not recognise queries as valid elements of a SELECT clause.

For instance, if I have a query named qbaz in the Access database, the Java statement
ps = c.prepareStatement("select foo, bar from qbaz");
produces the following error:
java.sql.SQLException: Failed to find table qbaz in database test
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.a.a(Unknown Source)
at com.hxtt.sql.d.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.access.e.(Unknown Source)
at com.hxtt.sql.access.i.a(Unknown Source)
at com.hxtt.sql.a3.a(Unknown Source)
at com.hxtt.sql.cg.a(Unknown Source)
at com.hxtt.sql.cg.a(Unknown Source)
at com.hxtt.sql.cg.a(Unknown Source)
at com.hxtt.sql.a3.a(Unknown Source)
at com.hxtt.sql.a3.a(Unknown Source)
at com.hxtt.sql.y.a(Unknown Source)
at com.hxtt.sql.ch.executeQuery(Unknown Source)
at Prova.main(Prova.java:49)


Similarly, the call
DatabaseMetaData dmd = ... // get metadata
ResultSet tabresult = dmd.getTables( null, null, "%", null );

does not list queries as VIEW's, as they should be, in my opinion.

This is quite an issue, since the query mechanism of MS Access is really powerful.

Any suggestions/possibility to fix?

Thanks in advance
Andrea
Re:Queries are not recognised in SELECT clauses
HXTT Support
2005-08-23 00:00:00.0
>Any suggestions/possibility to fix?
Thanks for your advice. HXTT Access has supported LINKED TABLE to other MS Access tables. One programmer has begun to crack QUERY binary stream. After we have complemented VIEW support for MS Access, we will give you a notification.

Re:Re:Queries are not recognised in SELECT clauses
Andrea Spinelli
2005-08-23 00:00:00.0
Thanks for your prompt response; I wait for your notification. We are considering purchase of your product, but availability of the MS Access queries is really necessary for us.
Thanks again and congratulations for your work!
Re:Re:Re:Queries are not recognised in SELECT clauses
HXTT Support
2005-08-26 00:00:00.0
Please download the latest package which has supported VIEW(MS Query). Most of query syntax should run normally now.
Re:Re:Re:Re:Queries are not recognised in SELECT clauses
Emil Acced
2006-07-27 00:47:03.0
Dear hxtt support
I'm evaluating your jdbc driver and got the following problem by making the query

select * from aView

aView:
SELECT VPERSON.SYSTEM, VPERSON.ENTITY, Mid([ZEITPUNKT].[ZEITPUNKT],7,4) & Mid([ZEITPUNKT].[ZEITPUNKT],4,2) & Mid([ZEITPUNKT].[ZEITPUNKT],1,2) AS EXTDATE.....

unfortunately, the following exception is thrown:
java.sql.SQLException: Lexical error: & Mid([ZEITPUNKT].[ZEITPUNKT],7,4) & Mid([ZEITPUNKT].[ZEITPUNKT],4,2) & Mid([ZEITPUNKT].[ZEITPUNKT],1,2) AS EXTDATE...
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.cr.for(Unknown Source)
at com.hxtt.sql.dt.new(Unknown Source)
at com.hxtt.a.b.f(Unknown Source)
at com.hxtt.sql.bf.k(Unknown Source)
at com.hxtt.sql.ac.if(Unknown Source)
at com.hxtt.sql.c1.(Unknown Source)
at com.hxtt.sql.dy.(Unknown Source)
at com.hxtt.sql.bf.prepareCall(Unknown Source)
at com.hxtt.sql.bf.prepareCall(Unknown Source)
at com.hxtt.sql.bf.prepareCall(Unknown Source)
at com.hxtt.sql.bw.(Unknown Source)
at com.hxtt.sql.access.g.if(Unknown Source)
at com.hxtt.sql.access.g.int(Unknown Source)
at com.hxtt.sql.access.c.a(Unknown Source)
at com.hxtt.concurrent.w.a(Unknown Source)
at com.hxtt.sql.access.z.a(Unknown Source)
at com.hxtt.sql.access.n.a(Unknown Source)
at com.hxtt.sql.bf.if(Unknown Source)
at com.hxtt.sql.c0.a(Unknown Source)
at com.hxtt.sql.c0.a(Unknown Source)
at com.hxtt.sql.bf.a(Unknown Source)
at com.hxtt.sql.bf.a(Unknown Source)
at com.hxtt.sql.ac.a(Unknown Source)
at com.hxtt.sql.ac.a(Unknown Source)
at com.hxtt.sql.ac.executeQuery(Unknown Source)

Are only simple views supported?
Thanks in advance

Emil
Re:Re:Re:Re:Re:Queries are not recognised in SELECT clauses
HXTT Support
2006-07-27 01:10:04.0
In fact, HXTT Access has supported TRANSFORM VIEW and most simple stored procedures (select, insert, update, and delete).

But
>java.sql.SQLException: Lexical error: & Mid([ZEITPUNKT].[ZEITPUNKT],7,4) & Mid
>([ZEITPUNKT].[ZEITPUNKT],4,2) & Mid([ZEITPUNKT].[ZEITPUNKT],1,2) AS EXTDATE...
& operation isn't supported.
Re:Re:Re:Re:Re:Re:Queries are not recognised in SELECT clauses
HXTT Support
2006-07-27 01:51:41.0
The latest package will use "+" token to replace "&" token. Please try.

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