Skip to Content

Upgrade Apache Derby version in local HANA Cloud Platform

Hi,

I'm developing my web application using Grails 2.3.4 and I've encountered this issue when deploying my app locally. This issue is caused by the DDL generated by Grails which is not compatible with Apache Derby 10.8.2.2 bundled with HCP SDK (neo-java-web-sdk-1.43.20.3) . The specific error message is:

2014-01-06 16:37:50,688 [Start Level Event Dispatcher] ERROR hbm2ddl.SchemaExport - Unsuccessful: create table foo (id fixed(19,0) not null, version fixed(19,0) not null, address varchar(255) not null, name varchar(255) not null, primary key (id))

2014-01-06 16:37:50,689 [Start Level Event Dispatcher] ERROR hbm2ddl.SchemaExport - Syntax error: Encountered "(" at line 1, column 27.

I tried to run the SQL command above in Apache Derby 10.10.1.1 and worked just fine.

Is there a way to manually upgrade the Derby version in my local HCP server?

Is there a plan to upgrade the bundled Derby to the latest official release?

Thanks in advance!

Marc

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 07, 2014 at 04:00 PM

    Hi Marc,

    Since we have discussed this via e-mail I just want to share the results so that others might also benefit from it. As you mentioned you are using a MaxDB specific feature (https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/SAPDBDialect.java#L50) and targeting a MaxDB database in the cloud the best solution would be to also use a local MaxDB for testing. In Replacing the Local Database it is described how to configure local databases for testing.

    Best Regards,

    Bernd

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.