[h2] Re: H2
Thank you for the advice. I also found the limitations section i did not see earlier. Ok i have come in to 6 6u dell server machines. I will use one to create a system that will relegate commands to the others. 1 master unit coordinating 5 slaves. And i have at least 20T storage space combined by various raided drives. Each server will have only enough space to carry its workload. The rest of my drives will be raided in a system that will be used as network storage for all systems. This system will use MASSIVE databases of permutations to build an encryption system that will truly have every possible out come possible of every cipher i know. Now This is really an experiment in learning servers but also using the means i have to properly accomplish what i want to accomplish. For instance a 16 byte rail/column cipher only creates 2 of the possible 20922789888000 by supplanting rail column infrastructure i can make from any 16 chars 20922789888000 different ciphertexts. And that is only 1 cipher i end the end will use more than 20. Each being build upon by permutes to maximize their functionality. What i wanted to know is this a feasible solution to my need. Now that said the end project will not need to contain the full databases. I will sell one encryption solution and by basing the outcome of the ciphers on db's of permutations that i can change the index of the record i can sell the same software multiple times and no sold compiled unit will create the same cipher text with the same given key. In the end i need to only include in the compiled app a VERY small subset of the total EVERY possible but first i need it all. then as i sell units i can pick say 10-100k records to put as an EMBEDED db that will allow that unit to make enough keys that the company could never possible run out all i have to to is document what i have used b4 and never use exactly what i did use before. then i can sell this over and over with 1 set of code able to be implemented over and over. So my real question this is evidently not realistic for my main need and i will look further. But from what i have read this solution has worked for a project that held 2 billion records embedded and that is about exactly what i want to give a sold unit. So is this a good solution for an embedded db containing 2b records. i questioned the top of my needs first to get feed back of my large problem, now i ask about my small problem. Ty for the response and insight and further advice. On Monday, January 23, 2017 at 2:51:25 PM UTC-6, Christian MICHON wrote: > > Let's say best case you would have enough disk space and you could achieve > 10k inserts per second continuously in embedded mode. > > Then please calculate how many years would be needed to initiate your > database... > > Christian > > -- 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 email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] H2
After a cursory glance I did not see The boundaries listed in documentation I need the store 27 trillion records with this database support it -- 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 email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Re: File corruption with nioMemLZF
One more problem :( : It happens rarely and unpredictable Caused by: java.lang.ClassCastException: org.h2.value.ValueNull cannot be cast to org.h2.value.ValueArray at org.h2.mvstore.db.MVPrimaryIndex$MVStoreCursor.get(MVPrimaryIndex.java:402) at org.h2.mvstore.db.MVPrimaryIndex$MVStoreCursor.getSearchRow(MVPrimaryIndex.java:412) at org.h2.index.IndexCursor.getSearchRow(IndexCursor.java:293) at org.h2.table.TableFilter.next(TableFilter.java:499) at org.h2.command.dml.Select.queryGroup(Select.java:336) at org.h2.command.dml.Select.queryWithoutCache(Select.java:650) at org.h2.command.dml.Query.query(Query.java:341) at org.h2.command.dml.Query.query(Query.java:309) at org.h2.command.dml.Query.query(Query.java:36) at org.h2.command.ddl.Analyze.analyzeTable(Analyze.java:115) at org.h2.mvstore.db.MVTable.analyzeIfRequired(MVTable.java:738) at org.h2.mvstore.db.MVTable.addRow(MVTable.java:725) at org.h2.table.Table.updateRows(Table.java:483) at org.h2.command.dml.Update.update(Update.java:145) at org.h2.command.CommandContainer.update(CommandContainer.java:98) at org.h2.command.Command.executeUpdate(Command.java:258) On Monday, January 23, 2017 at 9:55:38 AM UTC, Noel Grandin wrote: > > I have committed a cache-sizing feature for this filesystem > -- 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 email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: Connection Properties
A few years later, but more details: My property is passed into org.h2.Driver#connect inside the info Properties object. org.h2.engine.ConnectionInfo#readProperties ignores this. org.h2.engine.Engine#openSession could be modified to handle these and set them as properties Cheers Jon On Friday, 20 July 2012 16:58:35 UTC+1, Thomas Mueller Graf wrote: > > Hi, > > I don't know how commons-dbcp works internally. Maybe it ignores it, > because H2 doesn't support it, or H2 ignores it? If that's the case I guess > there is no way to exact the setting as it never arrieved in H2. But you > could set a session variable in the database URL, as follows: > > jdbc:h2:~/test;init=set @abc='123' > > and then query the setting using > > select @abc; > > Regards, > Thomas > > > > > > > "BasicDataSource and calling #addConnectionProperty to see appName which > SqlServer displays as ProgramName when running sp_who2 >> >> >> Ideally I'd like to be able to query that value using SELECT VALUE FROM >> INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'appName' rather than using >> reflection to access connectionProperties within BasicDataSource >> >> >> On Friday, 13 July 2012 18:32:04 UTC+1, Thomas Mueller wrote: >>> >>> Hi, >>> >>> > In this case I'm trying to access a property I've passed through >>> >>> Sorry I don't understand. >>> >>> Regards, >>> Thomas >>> >> -- >> 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/-/Sxa6ZKiIfwYJ. >> To post to this group, send email to h2-database@googlegroups.com. >> To unsubscribe from this group, send email to >> h2-database+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > -- 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 email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Re: File corruption with nioMemLZF
I have committed a cache-sizing feature for this filesystem -- 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 email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.