java - JPA/EclipseLink Error in Creating Tables -


i trying create table using eclipselink. java class being used :-

import java.util.date; import javax.persistence.entity; import javax.persistence.generatedvalue; import javax.persistence.generationtype; import javax.persistence.temporal; import javax.persistence.temporaltype; import javax.persistence.id;  @entity public class submissions {   @id  @generatedvalue(strategy = generationtype.identity)  private long id;  private string xid;  private string y;  @temporal(temporaltype.date)  private date udate;  private string level;  private string state;   public submissions() {  }   //all relevant getter , setter functions }

the relevant persistence xml in question follows:- 

<persistence-unit name="submissionids">     <provider>org.eclipse.persistence.jpa.persistenceprovider</provider>     <class>com.obp.selenium.dataobjects.originationsubmissions</class>     <properties>          <property name="javax.persistence.jdbc.driver" value="oracle.jdbc.oracledriver" />         <property name="javax.persistence.jdbc.url"             value="jdbc:oracle:thin:@localhost:1521:orcl" />         <property name="javax.persistence.jdbc.user" value="------" />         <property name="javax.persistence.jdbc.password" value="------" />          <!-- eclipselink should create database schema automatically -->         <property name="eclipselink.ddl-generation" value="create-tables" />         <property name="eclipselink.ddl-generation.output-mode"             value="database" />         <!-- <property name="eclipselink.canonicalmodel.subpackage"             value="originationsubmissions" /> -->     </properties> </persistence-unit>

we use standard method implementing entitymanagerfactory :-

entitymanagerfactory factory = persistence.createentitymanagerfactory("submissionids");     entitymanager em = factory.createentitymanager();     em.gettransaction().begin();     em.gettransaction().commit();     em.close();

however keep getting following errors :-

el warning]: 2017-04-07 14:04:53.768--serversession(1650327539)--exception [eclipselink-4002] (eclipse persistence services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.databaseexception internal exception: java.sql.sqlsyntaxerrorexception: ora-00904: : invalid identifier

error code: 904 call: create table submissions (id number(19) not null, xid varchar2(255) null, y varchar2(255) null, level varchar2(255) null, state varchar2(255) null, udate date null, primary key (id)) query: datamodifyquery(sql="create table submissions (id number(19) not null, xid varchar2(255) null, y varchar2(255) null, level varchar2(255) null, state varchar2(255) null, udate date null, primary key (id))")

avtually eclipse reported bug rises when there reserved word usage can fine here :
https://bugs.eclipse.org/bugs/show_bug.cgi?id=260637.

the problem comes using reserved word dont know dbms, if mysql attributs xid , level reserved word. can find mysql reserved word here : https://dev.mysql.com/doc/refman/5.7/en/keywords.html.

you can se sql code used build tables there column name update of type date

udate date null

so opinion, need watch attribut name on udate


Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

android - Unable to generate FCM token from dynamically instantiated Firebase -

our business logic requires instantiate firebase during runtime. fetch firebase credentials (app id, api key etc.) default firebase location after knowing user's public key , create firebase instance using credentials. this means there 2 firebase instances used within app: the default "index" firebase gives credentials second the actual firebase intend use point forward the second firebase initialised this: firebaseapp app = firebaseapp.initializeapp(<context>, <options>, <app_label>); our problem traditional method of retrieving fcm token using firebaseinstanceidservice , ontokenrefresh() fails since ontokenrefresh() method called first firebase instance. directly calling string token = firebaseinstanceid.getinstance(app).gettoken(); returns null never ready when called. have tried polling test if token generated @ point. no luck. how can generate fcm token reliably firebase instance instantiated during runtime? i...
Read more