英文:
Virtuoso bulk insert failed
问题
我正在使用Windows 11,尝试使用OpenLink Virtuoso Open Source版进行批量插入操作。我遵循了这个指南:https://docs.openlinksw.com/virtuoso/fn_ld_dir_all/。
我已经更新了virtuoso.ini
文件中的DirsAllowed
参数为<path>
,其中<path>
类似于C:\\Users\\user\\Git\\Projects\\rdf_repository
。
但是我仍然遇到了以下错误消息。
该语句执行未返回结果集。
SQLState: 42000
Message: FA003: 由于ini文件中的访问控制,访问被拒绝
是否有替代isql.exe
或Conductor的方法?有没有工具可以导入RDF Turtle或图文件?
谢谢。
英文:
I'm using Windows 11 and I was trying to make a bulk insert with OpenLink Virtuoso Open Source edition. I was following this guide: https://docs.openlinksw.com/virtuoso/fn_ld_dir_all/.
I updated the virtuoso.ini
file with 'a proper' DirsAllowed
parameter (<path>
is something like C:\\Users\\user\\Git\\Projects\\rdf_repository
)
DirsAllowed = ., <path>
But I'm having troubles nonetheless, with the following error message.
> The statement execution did not return a result set.<br>
> SQLState: 42000<br>
> Message: FA003: Access to <path> is denied due to access control in ini file
Is there any alternative to isql.exe
or Conductor? A tool to import RDF Turtle or graph files?
Thanks.
答案1
得分: 2
你提供的内容已翻译如下:
1 你链接的文档页面专注于一个特定的函数,ld_dir_all()
。你可能会在批量加载器指南中找到更好的结果,该指南提到了ld_dir_all()
,但同时还涵盖了其他一些内容。
话虽如此,由于你在INI文件的 DirsAllowed
中遇到了关于 <path>
值的错误,我们可能需要确切地看到你放置的内容以及确切的错误消息,而不是你遮蔽了其中的 <path>
字符串。
这种错误的常见原因是使用一个或多个不适合于Windows的目录值。这个适用于Windows的值可能会提供你需要的线索 --
.;D:\my\favorite\directory
另外请注意,如果你的目录路径包含大小写混合和/或空格字符,你可能需要在每个目录路径(在分号 ;
之间)上加双引号(例如,"D:\my favorite\directory"
)。
在某些环境中,你甚至需要将数据源目录(例如 D:\my\favorite\directory
)添加到你的 %PATH%
环境变量中。
如果上述方法不起作用,或者你担心在公共网络上发布详细信息,你可能更愿意通过我们的网站提交支持案例,而不是在这里或在我们的公共社区论坛上交流。请注意,支持案例的优先处理是为我们的企业版用户和/或持有活跃支持合同的用户保留的,因此虽然我们会回应你,但可能需要一天或更多时间才能回复。
英文:
The documentation page you linked to is specifically focused on a single function, ld_dir_all()
. You may find better results by following this guide to the Bulk Loader, which does mention ld_dir_all()
but covers several other things along the way.
That said, since you're getting an error about the <path>
value you've put in the INI DirsAllowed
, we probably need to see exactly what you've put there, and the exact error message, rather than you masking the <path>
strings in either value.
A common cause of this error is using one or more directory values that are not Windows-appropriate. This Windows-appropriate value may provide the clue you need --
.;D:\my\favorite\directory
Also note that if your directory path includes mixed-case and/or space characters, you may need to wrap each directory path (between semicolons ;
) in double-quotes (e.g., "D:\my favorite\directory").
In some environments, you even need to add the data source directory (e.g., D:\my\favorite\directory
) to your %PATH%
environment variable.
If the above doesn't get you rolling and/or you're concerned about posting details to the public web, you may prefer to open a Support Case through our website, rather than conversing here or on our public Community Forum. Note that priority handling of Support Cases is reserved for users of our Enterprise Edition and/or holding an active support contract, so while we will respond to you, it may take a day or more between our responses.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论