Databases
StackOverflow2013
Postsdbo
POPlay framework 2.0.1 keeps trying to evolve wrong database type
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPlay framework 2.0.1 keeps trying to evolve wrong database type
    primarykey
    data
    text
    <p>I'm working on play 2.0.1 application deployed on openshift DIY-application. I'm having troble with the database because play keeps trying to evolve the wrong database. I have a mysql database and play creates an H2 database evolution script. Here are the scripts.</p> <p>What he is trying to create</p> <pre><code>create table gif ( id bigint not null, title varchar(255), add_date timestamp, gif_url varchar(255), img_source varchar(5000), web_id varchar(255), found_on varchar(255), thumbnail varchar(255), version integer not null, constraint pk_gif primary key (id)) ; create table task ( id bigint not null, action varchar(255), queue integer, type varchar(255), object_id bigint, params varchar(255), working_on boolean, version integer not null, constraint pk_task primary key (id)) ; create sequence gif_seq; create sequence task_seq; </code></pre> <p>What it should create</p> <pre><code># --- Created by Ebean DDL # To stop Ebean DDL generation, remove this comment and start using Evolutions # --- !Ups create table gif ( id bigint auto_increment not null, title varchar(255), add_date datetime, gif_url varchar(255), img_source varchar(5000), web_id varchar(255), found_on varchar(255), thumbnail varchar(255), version integer not null, constraint pk_gif primary key (id)) ; create table task ( id bigint auto_increment not null, action varchar(255), queue integer, type varchar(255), object_id bigint, params varchar(255), working_on tinyint(1) default 0, version integer not null, constraint pk_task primary key (id)) ; </code></pre> <p>My application.conf</p> <pre><code># This is the main configuration file for the application running on openshift. # ~~~~~ include "application" # Secret key # ~~~~~ # The secret key is used to secure cryptographics functions. # If you deploy your application to several instances be sure to use the same key! application.secret="TsLWj4[^1N&lt;7lkdhfaiusjdpoifnsaodfEkyPDTO[dnh&lt;7_R[j;cN0:lGK6Mm`0048C@3PK]4KR6HobL" # Openshift database configuration # ~~~~~ # You can declare as many datasources as you want. # By convention, the default datasource is named `default` # db.default.driver=com.mysql.jdbc.Driver db.default.url="jdbc:mysql://"${OPENSHIFT_DB_HOST}":"${OPENSHIFT_DB_PORT}/${OPENSHIFT_APP_NAME} db.default.user=${OPENSHIFT_DB_USERNAME} db.default.password=${OPENSHIFT_DB_PASSWORD} #db.default.driver=org.h2.Driver #db.default.url="jdbc:h2:mem:play" #db.default.user=sa #db.default.password="" # # You can expose this datasource via JNDI if needed (Useful for JPA) # db.default.jndiName=DefaultDS ebean.default= "models.*" #Akka akka.default-dispatcher.fork-join-executor.pool-size-max = 64 akka.actor.debug.receive = on # Logger # ~~~~~ # You can also configure logback (http://logback.qos.ch/), by providing a logger.xml file in the conf directory . # Root logger: logger.root=ERROR # Logger used by the framework: logger.play=INFO # Logger provided to your application: logger.application=DEBUG # openshift action_hooks scripts configuration # ~~~~~ openshift.play.params="-DapplyEvolutions.default=true" </code></pre> <p>I execute it with this code:</p> <pre> target/start \ -Dhttp.port=8080 \ -Dhttp.address=${OPENSHIFT_INTERNAL_IP} \ -Dconfig.resource=openshift.conf </pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStrashgod
    1. USMaurizio Pozzobon
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPlay framework 2.0.1 keeps trying to evolve wrong database type
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPlay framework 2.0.1 keeps trying to evolve wrong database type
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POPlay framework 2.0.1 keeps trying to evolve wrong database type
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo the difference is just the `auto_increment` used / not used for the `primary key`? This isn't specific to MySQL or H2 (both databases support both).
      singulars
      1. POPlay framework 2.0.1 keeps trying to evolve wrong database type
      1. USThomas Mueller
    2. COthe problem is that 'create sequence' is not supported by MySQL so it "crashes" when play tries to evolve the db
      singulars
      1. POPlay framework 2.0.1 keeps trying to evolve wrong database type
      1. USMaurizio Pozzobon
    3. COwhat's the name and path of your evolution file for mysql ?
      singulars
      1. POPlay framework 2.0.1 keeps trying to evolve wrong database type
      1. USnico_ekito
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload