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
Connection
Henry Widd
2006-11-23 06:54:33.0
Hi, I am having trouble with the connection URL. Firstly, I want to connect using a system dsn, but cannot get HXTT to work with that:

e.g.: for dsn named MS_DB hxtt.url=jdbc:access:/MS_DB does not work. What is the syntax please?

If I cannot do that, I will connect via the filename, but do not want to use a drive letter. I can connect using line 1 below, but not line 2 which contains the full UNC path

1. hxtt.url=jdbc:access:/f:/gs_china/ipodb/Multiple IPO.mdb?charSet=UTF-16
2. hxtt.url=jdbc:access:/\\eqitln03s/tech/china/podb/Multiple.mdb?charSet=UTF-16

Another thing I want to do is this select, which works with Sun's driver:

select Date() as sysDate, Time() as sysTime;

When I do that with HXTT, I am told there is a syntax error, so what should be the correct query for getting the system date?

Thanks for your help.

Henry
Re:Connection
HXTT Support
2006-11-23 07:25:32.0
>e.g.: for dsn named MS_DB hxtt.url=jdbc:access:/MS_DB does not work. What is
> the syntax please?
HXTT Access needn't any dsn, and can run on any platform with Java.

>1. hxtt.url=jdbc:access:/f:/gs_china/ipodb/Multiple IPO.mdb?charSet=UTF-16
You can use "jdbc:access:/f:/gs_china/ipodb/" too. You needn't to set charSet=UTF-16 since HXTT Access supports unicode.

>2. hxtt.url=jdbc:access:/\\eqitln03s/tech/china/podb/Multiple.mdb?charSet=UTF-16
You need to use a free JDBC url, "jdbc:access:/" or "jdbc:access:///". Then you can use some full UNC path names in SQL to visit your servers. For instance:
select * from "\\eqitln03s/tech/china/podb/Multiple.mdb".test;


>Another thing I want to do is this select, which works with Sun's driver:
>select Date() as sysDate, Time() as sysTime;
For instance:
?date();
? time();
select top 1 Date() as sysDate, Time() as sysTime form atable;

BTW, you can use date(), time() as insertvalue, for instance, insert into atable (acolumn,bcolumn) values(date(),time());

Re:Re:Connection
HXTT Support
2006-11-23 07:37:59.0
You can use
select * from (VALUES date(),time()) AS tableName(sysDate,sysTime );
too.
Re:Re:Re:Connection
HXTT Support
2006-11-23 07:40:41.0
select * from (VALUES curdate(),curtime()) AS tableName(sysDate,sysTime );

will be a preferable sql:)
Re:Re:Re:Re:Connection
Henry Widd
2006-11-23 10:18:17.0
Thanks for the help. On connecting via a free url ("jdbc:access:/" ) - I am a bit concerned about how my DataSource is going to manage connection pooling. Presumably it won't create a pool so will have to make a new connection each time.

Are you also saying that there is not way to connect via DSN?

Thanks
Re:Re:Re:Re:Re:Connection
HXTT Support
2006-11-23 17:30:44.0
>I am a bit concerned about how my DataSource is going to manage connection
> pooling. Presumably it won't create a pool so will have to make a new
> connection each time.
OS will do the necessary file cache. It hasn't any difference for you to use free url or normal embedded url. Network file cache is slower than disk file, you should use embedded url( or remote url with AccessServer) if all of your database files is at eqitln03s host.
Re:Re:Re:Re:Re:Re:Connection
Henry Widd
2006-11-23 22:21:58.0
ok - Now I'm trying out a date query using the full unc path but getting an error. If I do not include the quotes I get a grammar error, rather than this one.

[select top 1 Date() as sysDate, Time() as sysTime from "\\eqitln03s\tech\china\ipodb\Multiple IP.mdb".tblSubscription;]; SQL state [60000]; error code [393216]; java.lang.NullPointerException
at com.hxtt.global.c.(Unknown Source)
at com.hxtt.concurrent.aa.(Unknown Source

Please help. BTW, in the most recent date query that was suggested, where would I include the UNC path?
Re:Re:Re:Re:Re:Re:Re:Connection
HXTT Support
2006-11-24 00:23:40.0
Passed test with: select top 1 Date() as sysDate, Time() as sysTime from "\\localhost\f$\mdbfiles\db1.mdb".hxtt2;
Are you using a latest package?

> in the most recent date query that was suggested, where would I include the UNC path?
>>select * from (VALUES curdate(),curtime()) AS tableName(sysDate,sysTime );
You needn't because VALUES tables is memory table:)

Re:Re:Re:Re:Re:Re:Re:Re:Connection
Henry Widd
2006-11-24 00:39:12.0
I am using "Access JDBC 3.0 Package" downloaded yesterday and my query still does not work.

The reason I do not want to use the drive letter in the connection string is that I am running my program as a service - which even running as a particular user does not have that drive mapped, but if I log in and run from the command line there is no problem. Can I confirm that there is definitely no way of putting the unc in the connection string or using dsn? Otherwise I am going to be unable to run this program as a service.

Thanks
Re:Re:Re:Re:Re:Re:Re:Re:Connection
HXTT Support
2006-11-24 01:02:25.0
> but if I log in and run from the command line there is no problem.
>Otherwise I am going to be unable to run this program as a service.
It's a security issue for network file share. What's your appplication server? If you run it in ColdFusion with correct user right, it won't be issue.

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