\apache-maven-3.6.3\bin\mvn install:install-file -DgroupId=com.ofrick.libs -DartifactId=ojdbc6 -Dversion=11.2.0.4.0 -Dfile=C:\Temp\ojdbc6-11.2.0.4.0.jar -DgeneratePom=true -Dpackaging=jar
Monthly Archives: December 2019
package.jdo
if id is not needed as a number in the application
<class name=”Author” table=”MERIT_AUTHOR”>
<datastore-identity strategy=”sequence” sequence=”AUTHOR_ID_SEQ” column=”AUTHOR_ID”/>
<field name=”firstName”>
<column name=”FIRSTNAME”/>
</field>
<field name=”lastName”>
<column name=”LASTNAME”/>
</field>
<field name=”userName”>
<column name=”USERNAME”/>
</field>
<field name=”posts” mapped-by=”author”>
<collection element-type=”entity.Post”/>
</field>
</class>
to use the id
<sequence name=”WEBSESSION_ID_SEQ” datastore-sequence=”MERIT_WEBSESSION_SEQ” strategy=”noncontiguous” allocation-size=”1″ initial-value=”1″/>
<class name=”WebSession”>
<field name=”id” primary-key=”true” value-strategy=”sequence” sequence=”WEBSESSION_ID_SEQ”/>
</class>
Oracle XE
Development Environment:
Install Oracle XE
on CentOS, check tmpfs in /etc/fstab
none /dev/shm tmpfs defaults,size=2G 0 0
df -h /dev/shm
CONNECT AS SYSDBA
Username: SYSTEM
SELECT
username,
default_tablespace,
profile,
authentication_type
FROM
dba_users
WHERE
account_status = ‘OPEN’;
SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;
CREATE USER john IDENTIFIED BY passwordhere DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
GRANT CREATE SESSION TO john;
GRANT CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE SEQUENCE TO john