Hello,
I've been consistently getting the same exception when using CSVREAD to
import file into a database.
The scenario is as follows:
1) Client 1 connects to a db file using URL:
jdbc:h2:~/build_output/mydb;IGNORECASE=TRUE;AUTO_SERVER=TRUE
2) Client 2 connects to a db file using same URL:
jdbc:h2:~/build_output/mydb;IGNORECASE=TRUE;AUTO_SERVER=TRUE
3) Client 2 connects attempts to run the following query:
CREATE TABLE raw_data_ad_performance AS SELECT * FROM
CSVREAD('datafile.csv',null,'caseSensitiveColumnNames=true charset=UTF-8
fieldSeparator=,')
And Client 2 gets an exception:
org.h2.jdbc.JdbcSQLException: Unsupported connection setting
"caseSensitiveColumnNames"; SQL statement:
CREATE TABLE raw_data_ad_performance AS SELECT * FROM
CSVREAD('datafile.csv',null,'caseSensitiveColumnNames=true charset=UTF-8
fieldSeparator=,') [90113-154]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.tools.Csv.setOptions(Csv.java:819)
at org.h2.expression.Function.getValueForColumnList(Function.java:1924)
at org.h2.table.FunctionTable.<init>(FunctionTable.java:63)
at org.h2.command.Parser.readTableFilter(Parser.java:1060)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1669)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1776)
at org.h2.command.Parser.parseSelectSub(Parser.java:1663)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1508)
at org.h2.command.Parser.parseSelect(Parser.java:1496)
at org.h2.command.Parser.parseCreateTable(Parser.java:5028)
at org.h2.command.Parser.parseCreate(Parser.java:3767)
at org.h2.command.Parser.parsePrepared(Parser.java:320)
at org.h2.command.Parser.parse(Parser.java:275)
at org.h2.command.Parser.parse(Parser.java:247)
at org.h2.command.Parser.prepare(Parser.java:201)
at org.h2.command.Parser.prepareCommand(Parser.java:214)
at org.h2.engine.Session.prepareLocal(Session.java:426)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:226)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Thread.java:680)
at org.h2.engine.SessionRemote.done(SessionRemote.java:567)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:67)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:439)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1114)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:265)
...................
I have been able to reproduce this with different clients and on different
database files.
The exception does NOT occur if only Client 2 connects to the database and
runs above CSVREAD function - it works just fine with one client.
Thank you,
Oleg Kozlov
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/H781JlZ1zhwJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
