I'm playing around with H2 for the first time, using jdbc.
I created a table where the column titles are mixed case, but they are
showing up in the H2 table viewer as all caps. Is this normal?
Thanks.
--
You received this message because you are subscribed to the Google Groups "H2
Database" gr
Hi,
This is normal. By default all names are case insensitive and in upper
case. You can use double quotes if you want to preserve case like
"columnName" or you can define system property h2.identifiersToUpper
to false.
On 11 окт, 11:02, puzzler wrote:
> I'm playing around with H2 for the first t
Hi all,
I am getting error: 'Exception: org.h2.jdbc.JdbcSQLException: Sequence
"SYSTEM_SEQUENCE_06AAA995_D69E_470F_A1B3_451D330A4C6B" not found; SQL
statement' when I try to connect to my database and the connection
fails. So even if I wanted to create the missing sequence I can not.
Is there any w
On Oct 11, 12:16 am, Sergi Vladykin wrote:
> Hi,
> This is normal. By default all names are case insensitive and in upper
> case. You can use double quotes if you want to preserve case like
> "columnName" or you can define system property h2.identifiersToUpper
> to false.
How do you set the syste
Thanks, Thomas, I will ensure that we upgrade to the latest version.
I actually got this customer's database file and opened it using the
latest stable version (1.2.142), but I was still unable to run the
queries in question. However, I am assuming that there is some
corruption issue in the file?
Hi
I have some simple questions.
1. have u used index.
2. when you run a query do you use sub-queries.
3. when you run a query do you use joins.
4. what is your data size.
5. could you give some details as to how many columns you use per table.
Thanking you
Regds - K. Prakash
On Wed, Sep 29, 201
See
http://h2database.com/javadoc/org/h2/constant/SysProperties.html#h2.identifiersToUpper
It is just a plain java system property which you can set as command
line argument like
java -Dh2.identifiersToUpper=false ..
or if you use h2 as an embedded database you can set in your code
before h2
The webPort may be configured in the file
"C:\Dokumente und Einstellungen\myAccountName
\.h2.server.properties".
But what about the tcpPort?
Is there any chance to change the default tcpPort value 9092 to
something else if running the database server as a windows service?
How can I use the opti
Hi All,
It is possible to log in the web console directly via the command
line ? Right now, I can launch the web console with the provided h2.sh/
bat or running the org.h2.tools.Console but then I have to set the
db's URL, user and password by hand... Is there a way to provide this
to the command
Hi,
El 11/10/10 03:44, HJ escribió:
> Thank you very much for your answer. Indeed your way works fine.
> Instead of 70MB for 4 such texts i need slightly more then 30MB.
> But if I store this text as a normal text to a file then the size is
> 20MB. If i compress it in java and save it to a fi
Hi,
I am back and tried the Recover tool with -trace:
Created file: /home/uli/dbtest/test.h2.sql
Error: org.h2.message.DbException: IO Exception: "java.io.IOException:
Negative seek offset"; "/home/uli/dbtest/test.h2.db" [90031-143]
org.h2.message.DbException: IO Exception: "java.io.IOException:
It seems that there is a solution to my problem:
In the file "C:\Programme\H2.install.dir\service\wrapper.conf" I added
the last line at the end of the following section and restarted the
Windows service "H2 Database Engine Service":
# Application parameters. Add parameters as needed starting fro
Hi,
> Well yeah,changes which you wuld have like to be made if you wanted to make
> h2 more efficient.
So the question is: can H2 be made more efficient? Yes, I know about a
few changes that would potentially improve performance a bit, however
currently I don't plan to implement them (no time).
Hi,
For the query:
select '2' > '10' a ,'12' > '-13' b ,'1 ' > '-' c , ')12' > '(13' d,
')12'> '(12' e;
I get:
a t
b t
c t
d t
e t
I guess the difference is that I use client encoding "UNICODE":
SHOW client_encoding;
Regards,
Thomas
--
You received this message
Hi,
The H2 Console is a browser based tool, not a console based tool.
There is a command line tool, the Shell tool:
http://h2database.com/html/tutorial.html#shell_tool
Is that what you are looking for?
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups
Hi,
Hm, the there is a bug in the Recover tool. It doesn't work for files
larger than 2 GB. It's a simple integer overflow... I will fix it in
the next release.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this gro
Thomas, I use UNICODE encoding in all cases too.
And the base OS is UNICODE (UTF-8) itself.
El 11/10/10 14:42, Thomas Mueller escribió:For the query:
> select '2' > '10' a ,'12' > '-13' b ,'1 ' > '-' c , ')12' > '(13' d,')12'>
> '(12' e;
> I get:
> a t
> b t
> c t
> d t
> e
Hi,
50 minutes are needed to open the connection after an unexpected VM
shutdown with MVCC=TRUE, 30 seconds without this parameter. Something
is going wrong in index rebuild in MVCC mode.
Application seems to loop on redo method in pageStore class.
Here are some context details:
Version used : 1.
I was finally able to reproduce the problems and was able to narrow it
down to simple queries.
The problem occurs when there is a join query across a view and
another table with a WHERE clause referencing the table:
select some_view.id from some_view inner join some_table on
some_view.some_id=som
19 matches
Mail list logo