Hello,
I have a problem when I load data into H2 from CSV using (something
like bulk load)
insert into myTable select * from csvread (...)
I get following message:
SQ:Exception : SQL state: 90021 org.h2.jdbc.JdbcSQLException: Data
conversion error converting PRAGUE [90021-107] ErrorCode:
Hi Thomas,
I ran the program. This was the result:
awt.toolkit=sun.awt.windows.WToolkit
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=\
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
It surprised me that the sum over 0 rows comes to null and not zero.
DROP TABLE IF EXISTS x;
CREATE TABLE x (val INTEGER);
SELECT sum(val) FROM x;
I checked and it does the same in mysql, but was wondering
a) why is it like this? if its because of a standard, again why is the
standard like
Hi,
This is strange, I don't know what the reason could be. I have a
similar result (well the IP is different - that's normal) but it works
for me and probably most others.
There is a workaround: set the system property h2.bindAddress to
localhost or (probably even better) 127.0.0.1.
java
Hi Thomas,
I tried the workaround. In the printout I now get:
h2.bindAddress=localhost
but the error remains the same (also with using 127.0.0.1).
When I run the console program, everything seems to be working fine when i
select the h2 server. I can run the example queries
and access the
Hi,
I tried the workaround. In the printout I now get:
h2.bindAddress=localhost
The workaround doesn't do anything for the TestNetwork program, it is
only for the H2 Console. In the Console you shouldn't get that output
When I run the console program, everything seems to be working fine
Hi Thomas,
Just tested with the latest trunk r1234 and although this fixes the
NPE's, I receive
an OutOfMemory upon redeploy:
java.lang.OutOfMemoryError: Java heap space
org.h2.command.CommandRemote.prepare(CommandRemote.java:82)
Hi Thomas,
sorry, my mistake.
I tried the workaround the way you indicated. It works like a charm! Thanks
a lot for your help!
Cheers,
Bart
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups H2
Database group.
To
Considering the following program :
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class SimpleTest {
public static void main(String[] args) throws SQLException {