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
|
>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.
|
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!
|
|
Please download the latest package which has supported VIEW(MS Query). Most of query syntax should run normally now.
|
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
|
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.
|
|
The latest package will use "+" token to replace "&" token. Please try.
|
Main
webmaster@hxtt.com