API tools faq
paste
Guest User

Untitled

a guest
Aug 22nd, 2018
154
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.78 KB | None | 0 0
raw download clone embed print report
  1. profiles:
  2. active: prod
  3. datasource:
  4. driverClassName: oracle.jdbc.OracleDriver
  5. dataSourceClassName: oracle.jdbc.pool.OracleDataSource
  6. url: jdbc:oracle:thin:@127.0.01:49161:xe
  7. databaseName:
  8. serverName:
  9. username: vpp_owner
  10. password: vpp_owner
  11.  
  12. jpa:
  13. database-platform: org.hibernate.dialect.Oracle10GDialect
  14. database: ORACLE
  15. openInView: false
  16. show_sql: true
  17. generate-ddl: false
  18. hibernate:
  19. ddl-auto: none
  20. naming-strategy: org.hibernate.cfg.EJB3NamingStrategy
  21. properties:
  22. hibernate.cache.use_second_level_cache: true
  23. hibernate.cache.use_query_cache: false
  24. hibernate.generate_statistics: false
  25. hibernate.cache.region.factory_class: org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory
  26.  
  27. Caused by: liquibase.exception.DatabaseException: ORA-00984: column not allowed here
  28. [Failed SQL: CREATE TABLE VPP_OWNER.JHI_USER (id NUMBER(38, 0) DEFAULT SEQ_USER.NEXTVAL NOT NULL, login VARCHAR2(50) NOT NULL, "PASSWORD" VARCHAR2(60), first_n
  29. ame VARCHAR2(50), last_name VARCHAR2(50), email VARCHAR2(100), activated NUMBER(1) NOT NULL, lang_key VARCHAR2(5), activation_key VARCHAR2(20), reset_key VARCHA
  30. R2(20), created_by VARCHAR2(50) NOT NULL, created_date TIMESTAMP DEFAULT sysdate NOT NULL, reset_date TIMESTAMP, last_modified_by VARCHAR2(50), last_modified_da
  31. te TIMESTAMP, CONSTRAINT PK_JHI_USER PRIMARY KEY (id), UNIQUE (email), UNIQUE (login))]
  32. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  33. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  34. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  35. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  36. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  37. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  38. ... 115 more
  39. Caused by: java.sql.SQLSyntaxErrorException: ORA-00984: column not allowed here
  40.  
  41. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  42. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  43. at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
  44. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
  45. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
  46. at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
  47. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
  48. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
  49. at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
  50. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
  51. at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1792)
  52. at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1745)
  53. at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:334)
  54. at com.zaxxer.hikari.proxy.StatementProxy.execute(StatementProxy.java:83)
  55. at com.zaxxer.hikari.proxy.StatementJavassistProxy.execute(StatementJavassistProxy.java)
  56. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  57. ... 120 more
  58.  
  59. diff --git a/src/main/resources/config/liquibase/changelog/00000000000000_initial_schema.xml b/src/main/resources/config/liquibase/changelog/00000000000000_initial_schema.xml
  60. index dbdae03..702d0ba 100644
  61. --- a/src/main/resources/config/liquibase/changelog/00000000000000_initial_schema.xml
  62. +++ b/src/main/resources/config/liquibase/changelog/00000000000000_initial_schema.xml
  63. @@ -22,7 +22,7 @@
  64. <changeSet id="00000000000001" author="jhipster">
  65. <createSequence sequenceName="SEQ_USER" startValue="1000" incrementBy="1"/>
  66. <createTable tableName="JHI_USER">
  67. - <column name="id" type="bigint" autoIncrement="${autoIncrement}" defaultValueComputed="SEQ_USER.NEXTVAL">
  68. + <column name="id" type="bigint" autoIncrement="${autoIncrement}">
  69. <constraints primaryKey="true" nullable="false"/>
  70. </column>
  71. <column name="login" type="varchar(50)">
  72. @@ -52,7 +52,7 @@
  73. <column name="last_modified_by" type="varchar(50)"/>
  74. <column name="last_modified_date" type="timestamp"/>
  75. </createTable>
  76. -
  77. +
  78. <createTable tableName="JHI_AUTHORITY">
  79. <column name="name" type="varchar(50)">
  80. <constraints primaryKey="true" nullable="false"/>
  81. @@ -119,10 +119,10 @@
  82. file="config/liquibase/users_authorities.csv"
  83. separator=";"
  84. tableName="JHI_USER_AUTHORITY"/>
  85. -
  86. +
  87. <createSequence sequenceName="SEQ_PERSISTENT_AUDIT_EVENT" startValue="1000" incrementBy="1"/>
  88. <createTable tableName="JHI_PERSISTENT_AUDIT_EVENT">
  89. - <column name="event_id" type="bigint" autoIncrement="${autoIncrement}" defaultValueComputed="SEQ_PERSISTENT_AUDIT_EVENT.NEXTVAL">
  90. + <column name="event_id" type="bigint" autoIncrement="${autoIncrement}" >
  91. <constraints primaryKey="true" nullable="false"/>
  92. </column>
  93. <column name="principal" type="varchar(255)">
  94. @@ -162,5 +162,37 @@
  95. referencedColumnNames="event_id"
  96. referencedTableName="JHI_PERSISTENT_AUDIT_EVENT"/>
  97. </changeSet>
  98. -
  99. +
  100. + <changeSet id="defaultValueComputedOnAutoIncrementFields" author="cirovladimir" dbms="mysql,h2,postgresql">
  101. + <addDefaultValue tableName="JHI_USER"
  102. + columnName="id" columnDataType="bigint" defaultValueComputed="SEQ_USER.NEXTVAL"/>
  103. + <addDefaultValue tableName="JHI_PERSISTENT_AUDIT_EVENT"
  104. + columnName="event_id" columnDataType="bigint" defaultValueComputed="SEQ_PERSISTENT_AUDIT_EVENT.NEXTVAL"/>
  105. + </changeSet>
  106. +
  107. + <changeSet id="triggerOnAutoIncrementFields" author="cirovladimir" dbms="oracle">
  108. + <createProcedure>
  109. + CREATE OR REPLACE TRIGGER TRG_JHI_USER_ID
  110. + BEFORE INSERT
  111. + ON JHI_USER
  112. + FOR EACH ROW
  113. + DECLARE
  114. + BEGIN
  115. + SELECT SEQ_USER.NEXTVAL INTO :NEW.ID FROM DUAL;
  116. + END TRG_JHI_USER_ID;
  117. + </createProcedure>
  118. + <createProcedure>
  119. + CREATE OR REPLACE TRIGGER TRG_PERSISTENT_AUDIT_EVENT_ID
  120. + BEFORE INSERT
  121. + ON JHI_PERSISTENT_AUDIT_EVENT
  122. + FOR EACH ROW
  123. + DECLARE
  124. + BEGIN
  125. + SELECT SEQ_PERSISTENT_AUDIT_EVENT.NEXTVAL INTO :NEW.EVENT_ID FROM DUAL;
  126. + END TRG_PERSISTENT_AUDIT_EVENT_ID;
  127. + </createProcedure>
  128. + </changeSet>
  129. +
  130. +
  131. +
  132. </databaseChangeLog>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!