中做些什么
我正在尝试用inmemory H2数据库(mySQL模式(替换常规的MSQLDB进行单位测试。请参阅表的描述
'CREATE TABLE `dummyTable` (
`id` int(11) NOT NULL,
`value1` longtext,
`value2` longtext,
PRIMARY KEY (`id`),
) ENGI
NE=InnoDB DEFAULT CHARSET=utf8'
然后,我尝试将 longtext 字段插入'中。在 mySQL 中,我用逃脱了,插入语句工作正常,但在 H2 db 中,它的投掷后出现了异常。
插入插入dummytable值(6,'ad 's','def'(
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "insert into dummyTable values (6,'ad's','df[*]')"; SQL statement:
insert into dummyTable values (6,'ad's','df') [42000-199]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:451)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.message.DbException.getSyntaxError(DbException.java:229)
at org.h2.command.Parser.getSyntaxError(Parser.java:989)
at org.h2.command.Parser.checkRunOver(Parser.java:5129)
我尝试了另一个插入语句
插入dummytable值(6," ad 's"," df"(
,但以下异常也失败了
org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "ad's" not found; SQL statement:
insert into dummyTable values (6,"ad's","df") [42122-199]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:451
)
可以在H2 db
我通过加倍引用来使它起作用。
例如:插入可达的值(6,'ad''','def'(
这篇文章从sql脚本中插入H2数据库中的长文本,帮助