Hi,
Even though our code runs fine, there are still some functions missing
> which are used in customization, e.g. 'Function "TO_DATE" not found' .
>
There is a sample implementation in org/h2/test/todo/tools.sql:
-- TO_DATE
create alias TO_DATE as $$
java.util.Date toDate(String s) throws Exception {
return new java.text.SimpleDateFormat("yyyy.MM.dd").parse(s);
}
$$;
-- TO_CHAR
drop alias if exists TO_CHAR;
create alias TO_CHAR as $$
String toChar(BigDecimal x, String pattern) throws Exception {
return new java.text.DecimalFormat(pattern).format(x);
}
> For using H2 as drop-in replacement we would like to add those Oracle
> specific functions when running in Oracle mode. Maybe we could create
> an add-on jar for this.
>
Yes, I also thought about such a feature. Currently there is no such 'plug'
feature, but it does make sense to add it.
What about a class that is loaded depending on the mode, and initializes
the functions. For example, a class org.h2.mode.Oracle with a static
init(Connection conn) method. This method is called when the Oracle mode is
enabled.
1. Who would like to join the effort of creating this drop-in
> replacement for Oracle ?
>
My plan is not 100% compatibility (that would be extremely hard), but
better compatibility would be nice.
3. Is there already some a Wiki for H2 development ?
>
Currently not. Let's see if this is required. I do like wikis, but
they quickly tend to be outdated and not maintained. I prefer to just
update the regular documentation instead.
> What we can provide
If it's OK for you to provide it as open source, then sure we can discuss
about that.
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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
