Microsoft Jet 数据库引擎无法打开文件“（未知）”
我正在将关键字上传到数据库中。但我收到错误
java.sql.SQLException: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6998)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7155)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3106)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:355)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:209)
at java.sql.DriverManager.getConnection(DriverManager.java:539)
at java.sql.DriverManager.getConnection(DriverManager.java:211)
at keywordsreader.main(keywordsreader.java:28)
如何解决这种类型的错误...请帮助我..
编辑 - 有关从评论中提取的架构的附加信息
我正在从 excel 文件上传关键字...为此我为 excel 创建了一个 odbc 驱动程序，并给出了 excel 的路径...过去 15 分钟的时间...关键字已正确上传..但这次我遇到了此错误..
i am uploading keywords into the DB. but i am getting the error
java.sql.SQLException: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6998)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7155)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3106)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:355)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:209)
at java.sql.DriverManager.getConnection(DriverManager.java:539)
at java.sql.DriverManager.getConnection(DriverManager.java:211)
at keywordsreader.main(keywordsreader.java:28)
how to reslove this type error...plz help me..
edit - additional info regarding architecture extracted from comment
i am uploading the keywords from the excel file...for this i created a odbc driver for excel and i given the path of the excel... for past 15 min back...the keywords are uploaded properly..but i am geeting this error in this time..
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
你如何加载这些关键字？它显然不是可接受的方式之一（SQL Loader、来自分隔文件的外部表）。这里的细节很重要，因为看起来您的代码或架构中存在错误。您提供的信息越多，您就越有可能获得满意的结果。
编辑
信息仍然不够。显然，您的 EXcel ODBC 和运行 ODBC 的其他进程之间存在一些争用。如果真如你所说...
...那么我的建议是忘记它。但是，如果您确实希望我们帮助解决这个问题......
...您将必须更详细地解释您的架构和流程。
选择权在你。
How are you loading these keywords? It obviously isn't one of the accepted ways (SQL Loader, external tables from a delimited file). The details will matter here, because it looks like you have a bug in your code or your architecture. The more information you provide, the more likely it is you will get a happy outcoem.
edit
Still not enough information. Obviously there is some contention between your EXcel ODBC and the some other process running ODBC. If as you say ...
... then my advice is to forget about it. However, if you really want us to help solve this problem ...
... you are going to have to explain your architecture and process in greater detail.
The choice is yours.