oracle11g - Cannot initialize database while using an Oracle for jhipster application -

-

i'm trying use oracle database jhipster development in production mode. database configuration is

profiles:     active: prod datasource:     driverclassname: oracle.jdbc.oracledriver     datasourceclassname: oracle.jdbc.pool.oracledatasource     url: jdbc:oracle:thin:@127.0.01:49161:xe     databasename:     servername:      username: vpp_owner     password: vpp_owner  jpa:     database-platform: org.hibernate.dialect.oracle10gdialect     database: oracle     openinview: false     show_sql: true     generate-ddl: false     hibernate:         ddl-auto: none         naming-strategy: org.hibernate.cfg.ejb3namingstrategy     properties:         hibernate.cache.use_second_level_cache: true         hibernate.cache.use_query_cache: false         hibernate.generate_statistics: false         hibernate.cache.region.factory_class: org.hibernate.cache.ehcache.singletonehcacheregionfactory

the oracle server , running , i'am able connect database given credentials. after mvn -pprod mvn-boot:run got following sqlexception 

caused by: liquibase.exception.databaseexception: ora-00984: column not allowed here  [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 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 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 te timestamp, constraint pk_jhi_user primary key (id), unique (email), unique (login))]         @ liquibase.executor.jvm.jdbcexecutor$executestatementcallback.doinstatement(jdbcexecutor.java:316)         @ liquibase.executor.jvm.jdbcexecutor.execute(jdbcexecutor.java:55)         @ liquibase.executor.jvm.jdbcexecutor.execute(jdbcexecutor.java:122)         @ liquibase.database.abstractjdbcdatabase.execute(abstractjdbcdatabase.java:1247)         @ liquibase.database.abstractjdbcdatabase.executestatements(abstractjdbcdatabase.java:1230)         @ liquibase.changelog.changeset.execute(changeset.java:548)         ... 115 more caused by: java.sql.sqlsyntaxerrorexception: ora-00984: column not allowed here          @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:450)         @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:399)         @ oracle.jdbc.driver.t4c8oall.processerror(t4c8oall.java:1059)         @ oracle.jdbc.driver.t4cttifun.receive(t4cttifun.java:522)         @ oracle.jdbc.driver.t4cttifun.dorpc(t4cttifun.java:257)         @ oracle.jdbc.driver.t4c8oall.dooall(t4c8oall.java:587)         @ oracle.jdbc.driver.t4cstatement.dooall8(t4cstatement.java:210)         @ oracle.jdbc.driver.t4cstatement.dooall8(t4cstatement.java:30)         @ oracle.jdbc.driver.t4cstatement.executeforrows(t4cstatement.java:931)         @ oracle.jdbc.driver.oraclestatement.doexecutewithtimeout(oraclestatement.java:1150)         @ oracle.jdbc.driver.oraclestatement.executeinternal(oraclestatement.java:1792)         @ oracle.jdbc.driver.oraclestatement.execute(oraclestatement.java:1745)         @ oracle.jdbc.driver.oraclestatementwrapper.execute(oraclestatementwrapper.java:334)         @ com.zaxxer.hikari.proxy.statementproxy.execute(statementproxy.java:83)         @ com.zaxxer.hikari.proxy.statementjavassistproxy.execute(statementjavassistproxy.java)         @ liquibase.executor.jvm.jdbcexecutor$executestatementcallback.doinstatement(jdbcexecutor.java:314)         ... 120 more

the problem seems default seq_user.nextval not null expression.

any hints hat going wrong ?

i'm using jhipster 2.19.0 , oracle 11g.

this not possible oracle 11g.

from documentation here: http://docs.oracle.com/cd/b28359_01/server.111/b28286/statements_7002.htm#sthref7262

a default expression cannot contain references pl/sql functions or other columns, pseudocolumns currval, nextval, level, prior, , rownum, or date constants not specified.

such statement usable oracle 12c or higher:

https://oracle-base.com/articles/12c/default-values-for-table-columns-enhancements-12cr1


Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d...
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea...
Read more

python - build a suggestions list using fuzzywuzzy -

-
i building suggestion engine database. i'm using fuzzywuzzy module match user input string existing database shown below. if request.method == "get": display_dict = {} user_input = request.get["user_input"] # user input match_dict = {} food_items_obj = food_items.objects.all() # fetch objects table items in food_items_obj : match = fuzz.ratio(user_input.lower(),items.name.lower()) # try match user input existing names match_dict[match] = items.name # put 1 dictionary matched_dict = ordereddict(sorted(match_dict.items(),reverse = true)) # sort dictionary if max(matched_dict.keys()) == 100: # if exact match put in dict , return display_dict[100] = matched_dict[100] else : # if not found try best matching words.. ###########this part need help! ############# k,v in matched_dict.items(): if user_input in v : display_dict[k]...
Read more