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 <
sandeepchaudhary...@gmail.com> 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 h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> 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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
