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
jcifs.smb.smbexception
Waclaw
2014-07-21 04:02:28.0
Hi!

I sometimes get the message like:
Jcfis jcifs.smb.SmbException: Access is denied

I connect to database by:
jdbc:access:smb://user:password@host/dir/dd.mdb?lockType=ACCESS

Please check the following:
http://stackoverflow.com/questions/10433119/jcifs-smb-smbexception-access-is-denied-exception-for-smb-directories

Best regards
Waclaw

Re:jcifs.smb.smbexception
HXTT Support
2014-07-21 07:12:13.0
It should have not any relation with SmbFileInputStream for directory. Because your jdbc url is using dd.mdb . You should check your jdbc url to make sure tht your samba path for mdb file is correct, and you're using the correct user/password.
Re:Re:jcifs.smb.smbexception
Waclaw
2014-07-22 01:24:31.0
OK, once again.
Jdbc url, host, path, user/passowrd, etc are correct.
The MS Access files are on the Windows 2003 Server.
I connect to these files from another Windows 2003 Server.
In 99% connects everything is OK, but sometimes I get 'access is denied'.

I connect like that:

String jdbcUrl = "jdbc:access:smb://user:password@host/dir/a.dan";
Properties props = new Properties();
props.put("charSet", "CP1250");
props.put("lockType", "ACCESS");
props.put("versionNumber", "JET4");
props.put("otherExtension", "dan,DAN");
DriverManager.setLoginTimeout(10);
Connection conn = DriverManager.getConnection(jdbcUrl, props);

best regards
Waclaw
Re:Re:Re:jcifs.smb.smbexception
Waclaw
2014-07-22 02:12:50.0
Exception details:

java.sql.SQLException: Failed to load database a:jcifs.smb.SmbException:
Access is denied.
at com.hxtt.global.SQLState.setNextException(Unknown Source)
at com.hxtt.sql.access.m.a(Unknown Source)
at com.hxtt.sql.access.m.if(Unknown Source)
at com.hxtt.sql.access.m.(Unknown Source)
at com.hxtt.sql.access.a0.a(Unknown Source)
at com.hxtt.concurrent.ab.a(Unknown Source)
at com.hxtt.sql.access.m.a(Unknown Source)
at com.hxtt.sql.access.am.a(Unknown Source)
at com.hxtt.concurrent.ab.a(Unknown Source)
at com.hxtt.sql.access.a3.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.b0.a(Unknown Source)
at com.hxtt.sql.d4.a(Unknown Source)
at com.hxtt.sql.d4.a(Unknown Source)
at com.hxtt.sql.df.a(Unknown Source)
at com.hxtt.sql.b0.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.d6.executeQuery(Unknown Source)
at server.SynchroZA$TimerTaskZa.updZA(SynchroZA.java:86)
at server.SynchroZA$TimerTaskZa.run(SynchroZA.java:297)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Re:Re:Re:Re:jcifs.smb.smbexception
HXTT Support
2014-07-22 06:45:12.0
>In 99% connects everything is OK, but sometimes I get 'access is denied'.
Your code is runing as a loop for a long time?
Re:Re:Re:Re:Re:jcifs.smb.smbexception
Waclaw
2014-07-23 01:59:05.0
Thread is running every 30min and running for around 10s.
For every loop connection is established, running something and always closing the connection.
Sometimes the exception is occured in 2nd loop, but sometimes after 2days. There's no rule :(
Re:Re:Re:Re:Re:jcifs.smb.smbexception
Waclaw
2014-07-23 02:11:37.0
And another problem...
There's other program that use these MSAccess files.
I noticed, if the other program is connected there's no problem, but if I connect to MSAccess files as first user (by hxtt), the other users can't connect to these files (they get error #3050).

Re:Re:Re:Re:Re:Re:Re:jcifs.smb.smbexception
HXTT Support
2014-07-23 23:17:28.0
>but if I connect to MSAccess files as first user (by hxtt),
>the other users can't connect to these files (they get error #3050).
Could not lock file. (Error 3050) . It should be a right issue. Because dd.ldb is created by the first user.
Re:Re:Re:Re:Re:Re:Re:Re:jcifs.smb.smbexception
HXTT Support
2014-07-24 03:54:37.0
>In 99% connects everything is OK, but sometimes I get 'access is denied'.
Please download the latest package, which will retry onE time when failed to login in SAMBA.

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