topic Re: H2: Cannot figure out why this create table statement is failing in Alfresco Archive

H2: Cannot figure out why this create table statement is failing

laredotornado — Tue, 27 Oct 2015 21:41:27 GMT

Hi,I'm using the com.h2database:h2:1.4.190 H2 dependency while creating unit tests using Gradle 2.7. I'm using Liquibase as the tool for genreating my database scripts and it is currently generating this SQL (for a create table …)CREATE TABLE PUBLIC.my_prefix_sync_address (id VARCHAR(32) DEFAULT ''

Re: H2: Cannot figure out why this create table statement is failing

jbarrez — Wed, 28 Oct 2015 19:23:36 GMT

I'm not sure, this is an Activiti forum 😉

No more exceptions or something? Must have a cause … no?

Re: H2: Cannot figure out why this create table statement is failing

vasile_dirla — Wed, 28 Oct 2015 21:03:25 GMT

Hi Dave,
what's the default value for latitude and longitude ?

<code>
lattitude INT UNSIGNED DEFAULT ,
longitude INT UNSIGNED DEFAULT ,
</code>

just run an h2 server (embedded server)
<code>
java -jar h2.jar
</code>

open in your browser this url: http://localhost:8082 and then test your query in the web application which will be opened.