me again,
what about alias for Oracle sequence MAXVALUE & MINVALUE?
When will 1.4 of h2 will be released?
thanks
среда, 21 марта 2012 г. 16:38:24 UTC+1 пользователь ZPavel написал:
>
> Sorry, i have solved it :
>
> INIT=create schema if not exists test\;runscript from
> 'classpath:scripts/schema.sql
>
> in which i i put :
>
> drop alias if exists TO_DATE;
> create alias TO_DATE as $$
> java.util.Date toDate(String s, String format) throws Exception {
> return new java.text.SimpleDateFormat("yyyy-MM-dd
> hh:mm:ss.sss").parse(s);
> }
> $$;
>
> you must have 2 parameters in java function as well.
>
> +
>
> среда, 21 марта 2012 г. 14:39:39 UTC+1 пользователь ZPavel написал:
>>
>> Hi,
>> How can i use this sql adding TO_DATE with spring?
>> Thanks
>>
>> вторник, 22 ноября 2011 г. 20:20:35 UTC+1 пользователь Thomas Mueller
>> написал:
>>>
>>> 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 view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/LSXKkkW7e3cJ.
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.
