I may regret this, but because I used to work for Sita I will be nice :-)
Try removing the definition of the 'TO_DATE' alias that you are creating.
Delete these two lines:
String toDataAlias = "CREATE ALIAS to_date FOR
\"aero.sita.gsl.irisk.core.utils.RiskDataEmbeddedDatabaseFuncti
on.toDate\";\n";
and
tablesAsText = tablesAsText + toDataAlias;
If your "aero.sita.gsl.irisk.core.utils.RiskDataEmbeddedDatabaseFunction.toDate"
method works the same way as the built-in H2 'toDate' method then you are
in luck.
If it doesn't then you'll probably have to change your code that uses
'TO_DATE' in some way that I cannot describe.
Good luck, and say 'Hello' to the guys in Letterkenny if you ever have
anything to do with them :-)
On 4 September 2018 at 18:38, Sandeep Chaudhary <
[email protected]> wrote:
> Hi Sam,
>
> I am facing a issue with with new version of h2 1.4.197
> create alias name already exists
>
> below is my code
> builder.setName(DB_NAME);
>
> InputStream inputStream = this.getClass().getResourceAsStream(SQL_
> REFERRALS_DB_TABLES_FILE);
>
> String toDataAlias = "CREATE ALIAS to_date FOR
> \"aero.sita.gsl.irisk.core.utils.RiskDataEmbeddedDatabaseFuncti
> on.toDate\";\n";
>
> String tablesAsText = new Scanner(inputStream, SQL_CHARSET_NAME).
> useDelimiter(SQL_EOF_DELIMITER).next();
> tablesAsText = StringUtils.replace(tablesAsText, "NOMINVALUE",
> "--NOMINVALUE");
> tablesAsText = StringUtils.replace(tablesAsText, "REFERENCES",
> "--REFERENCES");
> tablesAsText = StringUtils.replace(tablesAsText, "ENABLE", "");
> tablesAsText = StringUtils.replace(tablesAsText, "NOVALIDATE",
> "");
> tablesAsText = StringUtils.replace(tablesAsText, "NOMAXVALUE",
> "--NOMAXVALUE");
> tablesAsText = StringUtils.replace(tablesAsText, "NOORDER",
> "--NOORDER");
> tablesAsText = StringUtils.replace(tablesAsText, "DEFAULT USER
> NOT NULL", "DEFAULT USER() NOT NULL");
> tablesAsText = StringUtils.replace(tablesAsText, "31-DEC-3999",
> "3999-12-31");
> tablesAsText = StringUtils.replace(tablesAsText, "01-DEC-3999",
> "3999-12-01");
> tablesAsText = StringUtils.replace(tablesAsText, " CHAR)", ")");
> tablesAsText = tablesAsText + toDataAlias;
> builder.addScript(tablesAsText);
>
> dataBase = builder.build();
> }
>
> can you tell me how to resolve the issue or what script i have to change
>
> On Wednesday, February 10, 2016 at 5:51:48 PM UTC+5:30, Sam Blume wrote:
>>
>> Hi
>>
>> I've contributed the TO_DATE (and TO_TIMESTAMP) code to H2 and it should
>> be in Version 1.4.191
>> <http://mvnrepository.com/artifact/com.h2database/h2/1.4.191> .
>> But it's not mentioned in the change log. AND it can be removed from
>> the road map as well.
>> Please also add following note (or something similar) to the change log:
>>
>>> Note: If you have programed an alias with that name, you need to delete
>>> that alias first or H2 will complain of having a name clash.
>>
>>
>> Cheers Sam
>>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
