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

SystemCommand cfm

 

 <cftry>
// use java utility SystemCommand which kills task properly after timeout
// and throw an Exception then
<cfset cmd = createObject("java","au.com.webcode.util.SystemCommand").init()>
<cfset command = "cmd.exe /C #mkvdk_exe_script# >> #resultLog# 2>&1">
<cfset envp = arraynew(1)>
<cfset timeoutAsAString = "3600000">
<cfset cwd = "F:\logfile\application\searchlog\mkvdk\doc\">
<cfset result = cmd.execute(command, envp, timeoutAsAString, cwd)>
<cfcatch>
<!--- ignore timeout and continue, to allow index the next batch --->
</cfcatch>
</cftry>

 

Fix Windows 10 Windows Media Player

Album Info Search fails with Website not found

Start regedit.exe
Navigate to “Computer\HKEY_CURRENT_USER\Software\Microsoft\MediaPlayer\TunerConfig”
Look for PREFERREDMETADATAPROVIDER – it should have a value “pmpMusicMatch”
Edit the setting PREFERREDMETADATAPROVIDER, and clear the value so you have a blank value
Save / exit regedit.exe
Restart Windows Media Player, you should be restored back to fai.music.metaservices.microsoft.com