Hi all,
I would like to know if the precision specified for a table column's
type (as in e.g. "FOO VARCHAR(42)") has an impact on the size of the
database. Is the database file larger if I leave out any such
constraints (provided that the data is the same as in a database with
constraints)? Also i
> How can I truncate the log without starting the database over from> scratch?
CHECKPOINT http://www.h2database.com/html/grammar.html#checkpoint and
probably http://www.h2database.com/html/grammar.html#set_max_log_size
At least in my case, when time to create an index is about 50sec and
every index
On Nov 29, 2011, at 18:28 , Noel Grandin wrote:
> Implement the Trigger interface and check the oldRow vs newRow
> parameters to see which fields have changed.
This is the workaround:
public class UpdateLastModifiedTrigger extends TriggerAdapter {
public static final String COLUMN_ID = "ID
Hi,
I have run the Jaqu SamplesTest (memory db) and it runs OK as installed,
But if the db in the test method is changed to a file based one, the test fails due to index problem
with Clobs.
Seems that memory dbs are handled differently to file based in Jaqu.
Regards
Paul Fraser
--
You receiv
In general, when you implement an event listener, you're supposed to be careful
to avoid triggering the event again.
So, yes, your use-case is tricky to implement, but it's sufficiently rare that
it's not worth complicating the Trigger
API for it.
Christian Bauer wrote:
> On Nov 29, 2011, at 1
On Nov 30, 2011, at 14:39 , Noel Grandin wrote:
> So, yes, your use-case is tricky to implement, but it's sufficiently rare
> that it's not worth complicating the Trigger
> API for it.
Seriously? This is the ONLY trigger example in a whole 800 page book I'm
writing about persistence and you t
Christian, you could implement your use case also as a before trigger.
There you could simply put your modified timestamp into the newRow array
and H2 will consider that as part of the update.
Can you give an exact definition to your term "current command"?
Or maybe the scope of current command
On Nov 30, 2011, at 15:17 , Rami Ojares wrote:
> Christian, you could implement your use case also as a before trigger.
> There you could simply put your modified timestamp into the newRow array and
> H2 will consider that as part of the update.
I didn't know modifying the given arrays was supp
Hi group!
We have a working query (working on oracle that is) which throws the
above SQL error in H2 v1.3.154. The query is designed to return two
values from a subquery. This seems to be defunct in H2.
The query is:
select * from organization as org
where (org.id, org.timestamp) in
( s
Christian wrote:
"I didn't know modifying the given arrays was supported. Still, dealing
with raw arrays is brittle as I'd have to rely on the DDL order of
columns ... The adapter at least lets me use the ResultSet API and
column names to read the data."
I agree with you completely. And that
Do you have an example of another database that implements this feature?
And yes, that's not a typical use-case for a trigger (coming from someone who
has been building relational database
backed products > 10 years).
Christian Bauer wrote:
> On Nov 30, 2011, at 14:39 , Noel Grandin wrote:
>
>>
H2 does not currently support that style of IN query.
You're welcome to log a feature request.
Karsten Krieg wrote:
> Hi group!
>
> We have a working query (working on oracle that is) which throws the
> above SQL error in H2 v1.3.154. The query is designed to return two
> values from a subquery.
On Nov 30, 2011, at 16:25 , Rami Ojares wrote:
> I agree with you completely. And that is why I implemented my own
> TriggerAdapter.
Looks good, these enhancements should be added to the existing TriggerAdapter
in H2.
--
You received this message because you are subscribed to the Google Grou
Hi,
To Rami Ojares: those additions look nice! There might be a few
smaller changes I would like to do (probably remove primaryKeyColumns,
DbObjectName; add test cases), but I'm sure we can work that out.
Would you be willing to contribute it to H2? If yes then I suggest we
work on a patch and onc
Hi,
> 2) My second issue is that of a long start up time
I guess there is a connection with an open transaction (an uncommitted
change) that is blocking the transaction log to shrink. Or multiple
connections. This would also explain why it gets slower over time. To find
out, you could use:
j
Hi,
Thanks! It sound like a problem in JSTL-SQL. I believe other databases
behave in the same way as H2. The toString() method is not supposed to read
the whole string, because that might cause I/O (toString methods should not
cause side effects and should be very fast, because they are called by
Sure thing.
The primary keys are not used anywhere in the adapter so they can just
be removed.
I think I have needed that info in some of my triggers and thus put it
there for easy access.
Although primary keys do not change often it is still theoretically
possible and to have them
there would
Hi Thomas,
Please update http://www.h2database.com/html/features.html#other_logging
to mention that the logger name is "h2database". I spent a long time
trying to figure out why using "org.h2.message.TraceWriterAdapter"
didn't work. Eventually I ran across this old Javadoc that mentioned
it:
http
Is it possible to get PAGE_SIZE information from system catalog ?
Thanks!
Chiiwen
--
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 unsubscribe from this group, send email to
19 matches
Mail list logo
