首页 \ 问答 \ HSQLDB忽略大小写(HSQLDB ignore case)

HSQLDB忽略大小写(HSQLDB ignore case)

 在java中使用此代码：  
Connection c = jdbcDriver.getConnection("jdbc:hsqldb:mem:test;sql.ignore_case=true", null);
Statement stmt = c.createStatement();
stmt.executeUpdate("CREATE TABLE \"TEST\"(ID INT)");
stmt.executeQuery("SELECT id FROM \"test\";");
 
 抛出org.hsqldb.HsqlException  
Exception in thread "main" java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: test
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
at Test.main(Test.java:15)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: test
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.ParserDQL.readTableName(Unknown Source)
at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 3 more
 
 但为什么？ 我说ignore_case=true ！  
 请看这个链接： http ： //hsqldb.org/doc/guide/dbproperties-chapt.html#N15A0A 

Having this code in java: 
Connection c = jdbcDriver.getConnection("jdbc:hsqldb:mem:test;sql.ignore_case=true", null);
Statement stmt = c.createStatement();
stmt.executeUpdate("CREATE TABLE \"TEST\"(ID INT)");
stmt.executeQuery("SELECT id FROM \"test\";");
 
Throws a org.hsqldb.HsqlException 
Exception in thread "main" java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: test
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
at Test.main(Test.java:15)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: test
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.ParserDQL.readTableName(Unknown Source)
at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 3 more
 
But why? I said ignore_case=true! 
See this link: http://hsqldb.org/doc/guide/dbproperties-chapt.html#N15A0A

原文：https://stackoverflow.com/questions/47536402

更新时间：2022-04-10 22:04

最满意答案

 它不像我想要的那么简单，但是在vbAccelerator上有一个很好的类调用ShellLink.cs  
 此代码使用互操作性，但不依赖于WSH。  
 使用这个类，创建快捷方式的代码是：  
private static void configStep_addShortcutToStartupGroup()
{
    using (ShellLink shortcut = new ShellLink())
    {
        shortcut.Target = Application.ExecutablePath;
        shortcut.WorkingDirectory = Path.GetDirectoryName(Application.ExecutablePath);
        shortcut.Description = "My Shorcut Name Here";
        shortcut.DisplayMode = ShellLink.LinkDisplayMode.edmNormal;
        shortcut.Save(STARTUP_SHORTCUT_FILEPATH);
    }
}

It's not as simple as I'd have liked, but there is a great class call ShellLink.cs at vbAccelerator 
This code uses interop, but does not rely on WSH. 
Using this class, the code to create the shortcut is: 
private static void configStep_addShortcutToStartupGroup()
{
    using (ShellLink shortcut = new ShellLink())
    {
        shortcut.Target = Application.ExecutablePath;
        shortcut.WorkingDirectory = Path.GetDirectoryName(Application.ExecutablePath);
        shortcut.Description = "My Shorcut Name Here";
        shortcut.DisplayMode = ShellLink.LinkDisplayMode.edmNormal;
        shortcut.Save(STARTUP_SHORTCUT_FILEPATH);
    }
}

HSQLDB忽略大小写(HSQLDB ignore case)

最满意答案

相关问答

将应用程序快捷方式固定到Windows（7,8）任务栏(Pinning an application shortcut to the Windows (7,8) taskbar)[2022-03-04]

下列中不属于面向对象的编程语言的是?[2022-05-30]

在目录中创建应用程序快捷方式(Creating application shortcut in a directory)[2022-06-25]

WIX只创建了目录中的最后一个快捷方式(WIX only last shortcut in Directory is being created)[2022-08-04]

确定首先安装哪个快捷方式(Determine which shortcut is installed first)[2022-11-21]

通过IShellLink创建目录的快捷方式(Create shortcut to directory via IShellLink)[2022-07-18]

是否有可能从Python executalbe访问启动快捷方式目录？(Is it possible to access the launching shortcut directory from a Python executalbe?)[2022-12-11]

Linux更改目录快捷方式(Linux Change directory shortcut)[2023-06-30]

如何更改程序的运行目录 - 通过在exe快捷方式中设置它？(How can I change the running directory of a program - by setting it in the exe shortcut?)[2022-04-15]

WIX - 在已安装的文件夹中创建卸载快捷方式(WIX - Creating an uninstall shortcut inside installed folder)[2022-07-31]

相关文章

最新问答