Hi,
I've implemented a DatabaseEventListener; When the database engine
calls DatabaseEventListener#init(url) the url parameter passed into
the method is null.
Is this intentional? I need the correct database connection url
because I need to create a few function alias when the in-memory
database
I can call startup script by adding INIT=RUNSCRIPT FROM 'blah.sql' in
the connection string. But still interesting to see why the URL is
null
On May 2, 5:21 pm, Anthony wrote:
> Hi,
>
> I've implemented a DatabaseEventListener; When thedatabaseengine
> calls DatabaseEventListener#init(url) the ur
Hello,
As a workaround try first to perform TRUNCATE TABLE and then DROP
TABLE.
Regards
Rado
On May 1, 1:00 pm, Wunderbar wrote:
> Hello to everyone,
>
> I observed that DROP TABLE is very slow when it affects a large table.
> The database consists of hundreds of tables, of which about the
> la
To me it seems that org.h2.engine.Session.log(Session.java:613) -
code: http://bit.ly/mhYhOT - is crucial here.
int lockMode = database.getLockMode();
if (lockMode != Constants.LOCK_MODE_OFF && !database.isMultiVersion())
{
String tableType = log.getTable().getTableType();
if (locks.indexO
Hi
Reading the roadmap you list this "JSON parser and functions".
What is the plan here? How should it work?
/Andreas
--
Andreas Henningsson
"Vanligt sunt förnuft är inte särkilt vanligt." -- Voltaire
--
You received this message because you are subscribed to the Google Groups "H2
Database"
ROW_NUMBER() OVER([ORDER BY columnName]).
I just want to add to this item in the road map. When doing this item
make sure also PARTITION BY work.
Example from MS SQL Server:
SELECT FirstName, LastName, ROW_NUMBER() OVER(PARTITION BY PostalCode
ORDER BY SalesYTD DESC) AS 'Row Number', SalesYTD, P
Still looking at the road map.
Do you really want the database schema to change without knowing it?
/Andreas
--
Andreas Henningsson
"Vanligt sunt förnuft är inte särkilt vanligt." -- Voltaire
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
T
Its not a schema change, it will only apply to result sets i.e. if a
computation in a select would result in an overflow, the result column
gets automatically promoted to the next larger numeric type.
On Mon, May 2, 2011 at 11:38, Andreas Henningsson
wrote:
> Still looking at the road map.
>
> Do
pls do refer to the attached file.
when the data size is more than 2 lac records and if we try to save a record
it take more than 3000 mille seconds
--
Keep in Touch
Prakash
prakashkut...@gmail.com
--
You received this message because you are subscribed to the Google Groups "H2
Database" grou
I see..
that sounds more ok to me.
/Andreas
On Mon, May 2, 2011 at 3:43 PM, Noel Grandin wrote:
> Its not a schema change, it will only apply to result sets i.e. if a
> computation in a select would result in an overflow, the result column
> gets automatically promoted to the next larger numeri
On Monday, May 2, 2011 3:53:47 PM UTC+2, Andreas Henningsson wrote:
> On Mon, May 2, 2011 at 3:43 PM, Noel Grandin wrote:
> > Its not a schema change, it will only apply to result sets i.e. if a
> > computation in a select would result in an overflow, the result column
> > gets automatically promo
The original problem from where this discussion comes from is that type
INTEGER
has been split into many types (SMALLINT, INT, BIGINT...) because of
historical implementation concerns.
Java has made the same archaic mistake (short, int, long...).
The best solution would be to have an Integer t
We are looking for someone who can help us tune our internal H2 db which we
use as a cache loader.
Any export takers.
Thanks,
Jason Tesser
dotCMS Lead Development Manager
1-305-858-1422
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to
On Monday, May 2, 2011 5:20:01 PM UTC+2, Rami Ojares wrote:
> The original problem from where this discussion comes from is that type
> INTEGER
> has been split into many types (SMALLINT, INT, BIGINT...) because of
> historical implementation concerns.
Whatever the original problem may be, it's no
On 2.5.2011 18:39, Maaartin G wrote:
On Monday, May 2, 2011 5:20:01 PM UTC+2, Rami Ojares wrote:
> The original problem from where this discussion comes from is that type
> INTEGER
> has been split into many types (SMALLINT, INT, BIGINT...) because of
> historical implementation concerns.
Whatev
Is there a good reason not to use the built-in pooling?
I am using DBCP but there is a deadlock issue with it.
We get/return a lot of connections.
I am thinking of trying the org.h2.jdbcx.JdbcConnectionPool pool.
Any thoughts?
Thanks,
Jason Tesser
dotCMS Lead Development Manager
1-305-858-1422
Hi,
I can't really explain currently how the database came into this
state, but I found a way to automatically correct it. So the next
version of H2 will be able to open this database and run the ALTER
TABLE statement.
But I would like to understand how the database came into this state,
so I hav
Hi,
I added this problem to the documentation, could you verify whether
this is correct?
== Error Code Incompatibility ==
There is an incompatibility with the Spring JdbcTemplate and H2
version 1.3.154 and newer, because of a change in the error code. This
will cause the JdbcTemplate to not dete
This is what I've done for my project
public void exportH2v1_1Database() throws SQLException{
org.h2.upgrade.v1_1.tools.Script.execute("jdbc:h2v1_1:"+oldDBPath,
"username", "password", oldDBSQLPath);
System.out.println(
Stri
Answering my own question..
I was able to get the database name using Internal H2 API
String databaseName = ((Session)
((JdbcConnection)conn).getSession()).getDatabase().getName();
On May 2, 1:20 pm, Anthony wrote:
> Hi,
>
> Is there a way to get a unique database or catalog name?
>
> eg:
> jd
I doubt if any are here... but it would be good to know if any would
do so. Do wait a few days and see.
Regards,
Thotheolh.
On May 2, 11:30 pm, Jason Tesser wrote:
> We are looking for someone who can help us tune our internal H2 db which we
> use as a cache loader.
>
> Any export takers.
>
> Th
21 matches
Mail list logo