Re: Missing column FKINDEX_NAME in I_S.CROSS_REFERENCES

Hi and thanks for reading all that stuff :). The problem in principle here is very similar to http://groups.google.com/group/h2-database/t/5a3a1eccac322abc, so I can cut most of the blabla this time. It simply is about architecture: SCRIPT just dumps a structure- reproduction DDL script. But what

Re: column list of CHECK constraints

Hi First of all: for my purposes, the hack works very well, so I personally have no need anymore to "make a point" or something, it's only in the best interest of H2 and its quality. Yes, it is a problem. Imagine the application issues a drop column command. And it fails. What can the applicatio

FILE_LOCK=SERIALIZED versus AUTO_SERVER=TRUE

Since we're experiencingseveral problemswith the SERIALIZED lock mode, we look at alternatives and the AUTO_SERVER mode strikes back. The* *nice explanat

Re: Script execution on database creation

You might provide this as a patch then. Am 16.12.2011 11:20, schrieb olivier: Is there any option to execute a script on database creation ? Like the INIT=... option, but not to be executed a each connection. I need this for the case of an in-memory database to create the tables/ sequences befor

Re: BITMAP index for boosting DB performance?

Hi and thank you for your answer > That might be the case for Intersystems Caché. I don't think it would help a > lot for H2. True, experience with and behaviour of another DBMS cannot be simply translated to H2 right away. Nevertheless, the main advantage of BITMAP indices is of mathematical

Re: Function XMLNODE adds extra whitespace and newlines to content

Hello, I'm still not sure if the parser is going to handle the extra whitespace correct yet, I'm still waiting to find that out. But I don't think the solution would be in escaping the newlines, because this should be undone in the parser and it could be beyond your control. Maybe an option for

Re: Tamper detection

Maybe I'm missing something but.. why is adding a content_hash column to the relevant tables not an option? Yes, you'll have to to compute the hash and check it on the client side. -- Vasile Rotaru -- You received this message because you are subscribed to the Google Groups "H2 Database"

Script execution on database creation

Is there any option to execute a script on database creation ? Like the INIT=... option, but not to be executed a each connection. I need this for the case of an in-memory database to create the tables/ sequences before first use, used behind a connection pool. I have locally patched the h2 sourc

Re: Index is not used in simple select query

Hi, What you could do is: SELECT resource_id FROM sw_stream_resource_assoc order by resource_id; But I see it might make sense to use the index even without "order by". I will add the following feature request: Optimization: "select id from test" should use the index on id even without "orde

Re: Tamper detection

Hi, I guess signing is even slower than encrypting. But if you want, you could write a file system wrapper for this, see also http://h2database.com/html/advanced.html#file_system - similar to the encrypting file system and the split file system. Regards, Thomas -- You received this message bec

Re: Function XMLNODE adds extra whitespace and newlines to content

Hi, That's true. Patches are welcome. I guess the newline should be escaped (using &#x) when using XMLCDATA. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To u

Re: Ireport Vs Netbeans Query

Hi I guess the data is different, or the query is different. Or possibly the database version is different. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To un

Re: column list of CHECK constraints

Hi, > Otherwise, > programmatically dropping columns becomes a gamble as soon as CHECK > constraints are involved. :-(. Well, either it works or it doesn't (in which case you get an exception)... Is it really a problem? Regards, Thomas -- You received this message because you are subscribed to

Re: Missing column FKINDEX_NAME in I_S.CROSS_REFERENCES

Hi, > I am trying to automatically and generically read the structure of a > DB from the INFORMATION_SCHEMA to build up a data structure > representing the DB. Is this just for H2 or for other databases as well? Do other databases provide all the data you need? If yes, what feature is missing in