Escaping reserved database keywords with spring-test-dbunit

How do I escape SQL Server keywords using [Spring-test-dbunit framework][1]? In my `@DatabaseSetup("sampleData.xml")` file, I have a table called `File` which is a reserved keyword in SQL Server. In order for the queries to run successfully on SQL Server, the reserved keyword would need to be encapsulated with square brackets (`[File]`). From https://stackoverflow.com/questions/8633372/expoting-dataset-to-a-xml-file-giving-error-in-dbunit, I see that this can be done in dbunit by setting a pattern escape config. I don't know where or how to put this config when using Spring-test-dbunit. Where/how do I tell the spring-test-dbunit framework to properly escape database keywords when inserting the test data into the db using the provided xml feed? If you would like to see code, let me know what excerpts I should post and i would be happy to do so. [1]: http://springtestdbunit.github.io/spring-test-dbunit/

以上就是Escaping reserved database keywords with spring-test-dbunit的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » JavaScript 答疑

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏