Hello,
I have created a user-defined function with a ResultSet return type,
as documented here:
http://www.h2database.com/html/features.html#user_defined_functions
When I try to look up this function in
select * from information_schema.function_aliases
I get DATA_TYPE = 0, which maps to the JDBC
Hi Thomas,
I understand this rationale. Surely, it's easier to strip spaces when
inserting them, right away. Since the SQL standard leaves this
question somewhat open, I guess that's a viable implementation.
Thanks for the explanation!
Cheers
Lukas
--
You received this message because you are s
Hi
I am currently looking at how ARRAY types could be converted into
tables in H2. In Oracle (or also Postgres), you can have things like
this:
CREATE TYPE numbers AS VARRAY(4) OF NUMBER(7);
SELECT * FROM TABLE(numbers(2, 3, 5, 7, 11));
---
On 30/06/2011 3:11 PM, bart wrote:
However the management of different types of databases is interesting.
My 2 cents: don't bother. You're chasing a false dream (no one has
solved this problem yet). And if you think about it, how often do you
really need to change databases? This is only
First I want to thank you all for your answers
My first motivation to use JaQu is related to this article :
http://itroman.wordpress.com/2010/12/05/why-i-do-hate-hibernate/
I agree with most of what is written.
I'm looking for a simple, reliable tool and JaQu seems to me now the
one with most of th
Thomas Mueller wrote:
I will not implement it currently (no time) but will add it to the
roadmap.
OK, thanks.
I suggest to use the following syntax.
[...]
select a x, sum(b) from test group by x;
I'm forced into using DATABASE_TO_UPPER=FALSE which appears to interfere
with using an alias
Hi,
The main reason was to save storage space while keeping the
implementation simple. If the spaces are added (padding), then either
it needs to be done when inserting (which means the spaces are stored
in the database file, which takes a lot of space), or the number of
spaces needs to be kept in
Hi,
I will not implement it currently (no time) but will add it to the
roadmap. I thought it's invalid SQL, but according to my test it's
supported by at least PostgreSQL and SQLite. It's not supported by
Apache Derby and HSQLDB according to my test.
I suggest to use the following syntax. It is s
Seem to have posted this wrong on the list so I'm sorry if this is a
duplicate.
Since Thomas did not want to go down the path I wanted I never
integrated my stuff with the original Jaqu. I do have however my own
version. I've been using Jaqu for a long time now in small and large
projects.
As I m
Since Thomas did not want to go down the path I wanted I never
integrated my stuff with the original Jaqu. I do have however my own
version. I've been using Jaqu for a long time now in small and large
projects.
As I mentioned in my mail I have adapted it to replace hibernate for me.
It handle
> Maybe it would make sense from those who are interested to fork it...
> I'm not sure if it does make sense, but it would be an option.
I had previously thought about integrating some central features
(especially the natural syntax) in jOOQ (http://www.jooq.org). This
thread here makes me think w
Hi,
Maybe it would make sense from those who are interested to fork it...
I'm not sure if it does make sense, but it would be an option.
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-dat
The patch in issue 286 was merged into trunk in early Spring.
The concurrency patch in issue 298 has NOT been merged, but IMHO should be.
AFAIK, nothing from Shai ever materialized.
JaQu is a nice tool. Its just enough to be useful but not enough to be
complex.
Rather than sitting dormant in SV
Hi,
contributing clean patches would be a little easier if the SVN repo
used svn:eol-style=native [0] on the source files.
Benjamin
[0]
http://svnbook.red-bean.com/nightly/en/svn.advanced.props.file-portability.html#svn.advanced.props.special.eol-style
--
You received this message because y
Hi,
for interop with some production MySQL DB, I have to use
DATABASE_TO_UPPER=FALSE on H2. An unwanted side effect of this setting
is that function names become case-sensitive and fail to resolve
unless given in all upper-case. The following patch extends the logic
seen in isKeyword() to function
I don't know about those issues, but I've been using JaQu in quite a
decent sized project. It is great for doing things quickly. Much quicker
than writing JDBC, but not as powerful as something like hibernate. I
rather prefer using ids and linking using that rather than having it
automatically
Hello,
I'm using H2 in embedded mode to execute unit tests, but my production
DB is MySQL.
Everything works fine except that some SQL statements which work with
MySQL don't with H2. This is the case of the multi-table delete:
http://dev.mysql.com/doc/refman/5.0/en/delete.html
Multiple-table syn
Hi there,
a customer of ours is experiencing regular database exception which I
don't know how to fix.
The exception is:
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.ArrayIndexOutOfBoundsException: 127"; SQL statement:
UPDATE SF_INCIDENT SET sFPatientID = NULL, sFActorID = NULL, TYPE
Hi,
I am seriously considering to use JaQu in a project quite big.
I would like to know the current status of JaQu next to :
- issue 286: Enhancements to JaQu (Patch)
- issue 298: JaQu concurrency patch
- the changes proposed by Shai in this thread
http://groups.google.com/group/h2-database/brows
19 matches
Mail list logo
