On Jun 23, 10:41 pm, Kerry Sainsbury wrote:
> I certainly cannot see an example of it in those links -- am I missing
> something?
No, you're not missing something.
I prefer the way HSQLDB 2.0 does triggers over your suggestion of
adding java into the database.
The built in procedural language i
Hi,
As far as I know HSQLDB don't put the code into the database, use an
classpath:fullName spec for any type of Java routine, and by default,
the static methods of any class that is on the classpath are available
to be used.
Look at: http://hsqldb.org/doc/2.0/guide/sqlroutines-chapt.html#N1259B
Hi Brish,
I don't see that HSQLDB supports having the Java within the database for use
by triggers.
The first link you sent says "A trigger action can be written as a Java
class that implements the org.hsqldb.Trigger interface" and gives and
example of a trigger that uses the class:
create trigg
On Jun 23, 8:50 pm, Kerry Sainsbury wrote:
> I've actually got this mostly implemented, but before I spend any more time
> on it I thought I'd better see if anybody
> thought this added any value -- and if other databases did anything similar
> in a nicer way.
I prefer the way HSQLDB 2.0 does it:
I would LOVE this to be implemented - it would stop me having to put
the trigger classes on the classpath when using the H2 console (which
is a PITA)
On Thu, Jun 24, 2010 at 2:50 PM, Kerry Sainsbury wrote:
> Hi Folks,
> I've been looking at triggers recently and was surprised to see that we
> can
Hi Folks,
I've been looking at triggers recently and was surprised to see that we
can't define Java code to execute as part of a trigger.
Note that we *can* use Java code, but we can't embed it in the trigger
definition like we can with an "ALIAS".
Would it be a good thing if we could store any J
Just to let you know that it's some kind of DNS networking problem related
to the office that I work in. No need to worry at your end :-)
On Wed, Jun 23, 2010 at 5:55 PM, Thomas Mueller <
thomas.tom.muel...@gmail.com> wrote:
> Hi,
>
> It's not down for me (it never was down for me). I recently tr
Hi all, i have some torubles to connect to my tcp remote server.
I'm starting server with this command
java -cp h2-1.2.136.jar org.h2.tools.Server -tcpAllowOthers
Now im trying to connect to this server from a pc in LAN, my url is
this
jdbc:h2:tcp://192.168.0.2:9092/C:\h2db
But i have this error:
Thanks again!
Telnet helped to identify the problem.
There was a mysql daemon running which was installed and used by some
program I use (SqueezeBox). I didn't know that this program would use
mysql and that it would use this port.
Now the benchmark runs and I know that the H2 infrastructure wor
Hi,
>From the exception is looks like another server is already running on
that port. However, I wonder why there is no exception message for
that... I will check.
To solve the problem, could you ensure that no application is
listening on port 9092 before you start the benchmark?
Regards,
Thomas
Hi,
Thanks for your mail!
> Should i open a bug entry ?
No, that's not required. If I can't fix it in the next release
(probably this weekend) then I will open a bug.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to
Hi,
> I could post a list of what I think are the files that are required
> for the change file encryption ability if you want me to.
Yes, sure.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email
This scenario is working with HSQLDB 2.0 too. ( This require to
replace the legacy TEXT type to VARCHAR(254) ).
So, as expected, H2 accept the following insert because the
foreign_key column value is NULL (no value):
INSERT INTO users (id,name,profiles_id2) VALUES
(1,'orphan_user',null);
Next we
The h2 comparison page needs the following updates for HSQLDB 2.0:
Transaction Isolation = yes
Encrypted Database = yes
User defined datatypes = yes
Table Level Locking = yes
Row Level Locking = yes
Multi Version Concurrency = yes
Updatable Result Sets = yes
Information Schema = yes
Custom Aggrega
+1 for honest comparison. It should be updated.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups
Hi,
On 23 июн, 13:08, hendrik wrote:
> On Jun 23, 9:56 am, hendrik wrote:
>
> > Say, I start a transaction on a table, then select and update some
> > stuff on it. For that it will be locked.
> > Now my guess is, H2 will only unlock the table once I commit or
> > rollback the transaction.
>
> >
On Jun 23, 12:48 pm, Wildam Martin wrote:
> On Wed, Jun 23, 2010 at 11:35, Jussi wrote:
> > Something weird is happening, that's for sure. Does .lobs.db indicate
> > nameless database? Isn't those usually named .lobs.db,
> > in this case localDB.lobs.db? We have localDB.lobs.db in the user home
>
Hi,
On the main page, in the feature comparison, it show that HSQLDB does
not support MVCC, while HSQLDB 2.0.0 does in fact support MVCC.
Also HSQLDB does support transaction isolation, at least READ COMMITTED
and SERIALIZABLE. See: http://hsqldb.org/web/features200.html
Also, in the intere
On Wed, Jun 23, 2010 at 11:35, Jussi wrote:
> Something weird is happening, that's for sure. Does .lobs.db indicate
> nameless database? Isn't those usually named .lobs.db,
> in this case localDB.lobs.db? We have localDB.lobs.db in the user home
> directory where the database files are located.
D
On Jun 23, 12:06 pm, Wildam Martin wrote:
> On Wed, Jun 23, 2010 at 10:49, Jussi wrote:
> > [...]
> > When application is closed and started again, everything works ok.
> > However, there appears to be .lobs.db under Program Files\Application
> > folder.
> > [...]
> > I wonder why this .lobs.db i
On Jun 23, 9:56 am, hendrik wrote:
> Say, I start a transaction on a table, then select and update some
> stuff on it. For that it will be locked.
> Now my guess is, H2 will only unlock the table once I commit or
> rollback the transaction.
>
> Correct?
Did some more reading.. seems like my assum
On Wed, Jun 23, 2010 at 10:49, Jussi wrote:
> [...]
> When application is closed and started again, everything works ok.
> However, there appears to be .lobs.db under Program Files\Application
> folder.
> [...]
> I wonder why this .lobs.db is written under Program Files and not in
> the user home
Hi,
we have been using h2 in our project and it has been working very
well. However, in one Windows Vista machine (home edition, 1GB of
memory) there has been some strange problems.
We use h2 with hibernate, and we have a class which has the following
field:
public class Data {
@Column(nullab
Hi,
please excuse the rather general question, but I figured I might as
well ask here as I'm using H2.
Basically, my question is when are tables locked and unlocked?
Say, I start a transaction on a table, then select and update some
stuff on it. For that it will be locked.
Now my guess is, H2 wi
Hi,
I visit the home page a few times a day and never had a problem.
Regards
Christian
On Jun 23, 7:55 am, Thomas Mueller
wrote:
> Hi,
>
> It's not down for me (it never was down for me). I recently try to
> enable HTTP compression (not sure if it works now), maybe this causes
> problems?
>
>
25 matches
Mail list logo
