Re: [h2] Expression in linked table

Dear Thomas, Any idea or input to solve this issue. Thanks in advance Best regards. Le jeudi 19 novembre 2015 09:58:18 UTC+1, Gwendall Petit a écrit : > > Hi, > > SET @CODE_INSEE='44109'; > > DROP TABLE IF EXISTS MY_SCHEMA.MY_TABLE; > CREATE FORCE LINKED > TABLE MY_SCHEMA.MY_TABLE

Re: [h2] Expression in linked table

Then I'm afraid we don't support that ATM -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send

Re: [h2] Storing of UTF-8 glyphs in H2

Am Freitag, 20. November 2015 14:26:10 UTC+1 schrieb Noel Grandin: > > http://h2database.com/html/grammar.html#script > First of all: thank you Noel Grandin for your help and the quick answers. I tried the following: SCRIPT TO '~/backup_test3.sql' CHARSET 'UTF-8' and this SCRIPT TO

Re: [h2] Expression in linked table

If we (the H2GIS team) find a way to resolve this issue in the H2 code, will you be open to an integration ? Any suggestions ? Regards Gwendall -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] Storing of UTF-8 glyphs in H2

http://h2database.com/html/grammar.html#script -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group,

Re: [h2] Expression in linked table

I'm guessing that you'll have to do the string manipulation in your code. I don't think our CREATE TABLE parser code supports non-constant string expressions. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

Re: [h2] Expression in linked table

Hi, Thanks Noel for your message. Just to be clear, here we are just using the H2 web interface and we want to execute this query in the H2 console context. So there is no code ;-) Regards Gwendall -- You received this message because you are subscribed to the Google Groups "H2 Database"

Re: [h2] SSLHandshakeException after upgrade from jdk1.8.0_45 to jdk1.8.0_52

Hi Manfred, Yes, I experience that from 45 to 51 and java 8u51 remove 1024 bit certificates. I think that is what broke it. I only want the encryption and do not want to have ea client load a certificate, as it all in the intranet. regards, Jess > On 20 Nov 2015, at 09:13, Manfred

Re: [h2] Storing of UTF-8 glyphs in H2

Am Freitag, 20. November 2015 07:34:08 UTC+1 schrieb Noel Grandin: > H2 internally stores character data in UTF8. > Thx for the quick answer. Is there a way to get also a UTF8 db dump instead of replacements like STRINGDECODE('\u ... ? -- You received this message because you are

Re: [h2] Expression in linked table

Sure, patches are always welcome. Start with the Parser class and work down from there. On Fri, 20 Nov 2015 at 16:48, Gwendall Petit wrote: > If we (the H2GIS team) find a way to resolve this issue in the H2 code, > will you be open to an integration ? > Any suggestions

Re: [h2] Storing of UTF-8 glyphs in H2

Well, the database size increases more an more. For e.g.: - The dump size is about 33 MB (with escaped utf-8 chars). When i import this dump in a new, embedded H2 db, the DB-size is about 29 MB. - When i close the db (via H2 web console), the DB-size is about 47 MB. So what happens when closing

Re: [h2] Storing of UTF-8 glyphs in H2

Ah, my apologies that doesn't affect the escaping of the strings. But I don't really understand your problem. Why does the syntax in the dump file matter? It's just a temporary format before you load it into something else. On Fri, 20 Nov 2015 at 16:36, Dieter Blerms wrote:

Re: [h2] Re: Null Compression Algorithm

Why is null compression useful? Just turn compression off and you have same effect. On Thu, 19 Nov 2015 at 18:01, krishna teja wrote: > Hello Thomas, > > Thank you for the reply :) . > No its not for a homework, but i m working on a project in which null > compression is

[h2] Storing of UTF-8 glyphs in H2

Hi, What problem do you want to solve? The "\u" you should only see in the SQL script, not in the actual database file. > The mySQL DB has about 15 MB and the migrated H2 DB has about 45 MB. For H2, did you shrink the database using "shutdown defrag"? > Is there a way to get also a UTF8

[h2] Null Compression Algorithm

Hi, I suggest to use an IDE such as Eclipse and find usages of those methods and classes. Or rename the file and try to compile. Regards, Thomas On Thursday, November 19, 2015, krishna teja > wrote: > Hello

Re: [h2] Storing of UTF-8 glyphs in H2

Am Freitag, 20. November 2015 17:59:21 UTC+1 schrieb Dieter Blerms: > > > So what happens when closing the DB that the file size increases from 29 > MB to 47 MB? > > I think i found out what happens: as the tables are cached tables, the index tables are stored in memory and after closing the

Re: [h2] Storing of UTF-8 glyphs in H2

Am Freitag, 20. November 2015 18:56:56 UTC+1 schrieb Thomas Mueller: > > Hi, > > What problem do you want to solve? > > The "\u" you should only see in the SQL script, not in the actual > database file. > > > The mySQL DB has about 15 MB and the migrated H2 DB has about 45 MB. > > For H2,

[h2] Re: SSLHandshakeException after upgrade from jdk1.8.0_45 to jdk1.8.0_52

Hi Jessarah, I have the same problem. See my post H2 TCP server and SSL: how to use it? https://groups.google.com/forum/#!topic/h2-database/GE4Y9KUDBkA I have tried it first time with Java 8 Update 60 and 66. With the last Java 6/7 versions it runs without any problems. Seems that some of the