2020-12-29

Spring JPA

 


怀疑问的发现:


Seems able to join another entity(table) by using reference below:

  1. SELECT P.C.attribute FROM Parent AS P;
  2. SELECT PCattribute FROM Parent AS P;





2020-12-28

5.1 Bluetooth 1800 DPI Bluetooth Wireless Mute Slim Mouse For Ipad Android Tablet Laptop Smart Phones

 


5.1 Bluetooth 1800 DPI Bluetooth Wireless Mute Slim Mouse For Ipad Android Tablet Laptop Smart Phones




On: 20210115_pm023246
Suspect Windows updates causing mouse become weird.
Mouse pointer shaking itself.
Then Bluetooth disconnected.
Switching light red and blue, reconnected by unplug and replug battery, but mouse pointer still moving itself.
After a while/few seconds, Switching light red and blue again.
Replace battery then seems to be ok for now.



__________________________________________________

Item details:

Ori image size: 8.33"


 





If you guys are looking for a bluetooth mouse, you can try to buy this.

https://shopee.com.my/product/55631460/5713472008


Less than RM 21 (included shipping as on 20201225_pm070207)

  1. Quiet buttons, with quiet scroll.

  2. Swift and even mouse bottom surface (compare with prolink mouse).

  3. Required ONLY ONE AA battery, ONLY 1.

  4. With an external battery, means no worry after the device's built-in battery dies.

  5. Thin mouse build up, less tired if using thik mouse.



5.1 Bluetooth 1800 DPI Bluetooth Wireless Mute Slim Mouse For Ipad Android Tablet Laptop Smart Phones



2020-12-23

Review: i7S-TWS Stereo

 

https://billson.blogspot.com/2020/12/review-i7s-tws-stereo.html






Fully charged before try:





Left - 90 mins auto off
Right 100 mins auto off










2020-12-16

SVN maven project without .setting folder

 

SVN
Check out Maven Projects from SCM





eclipse
Ctrl + N

Project from SVN
- provide SVN url, Finish.

Check Out As
- Check out as project configured using the New Project Wizard, Finish.

Check out Maven Projects from SCM
Target Location
- provide SVN url, Finish.



2020-12-14

Maven artifact scope at runtime

 
Source URL: https://stackoverflow.com/a/12273576



runtime is useful for dependencies required for unit tests and at runtime, but not at compile time. This may typically be dynamically loaded code, such as JDBC drivers, which are not directly referenced in the program code.

Setting dependency to runtime ensure that there isn't an accidental dependency on the code, and also keeps the dependency from being transitive. So that, for example, if module A has a runtime dependency on library X, and module B depends on module A, it does not inherit the dependency on library X. Using "provided" or "compile" would cause B to depend on X.







2020-12-11

ToBeContinue: Eclipse Git - Create as bare repository

 







Differents:



Bare Repository won't be available in the list of Repository during Share Project below:

Public: Eclipse Git - Create as bare repository






Create as bare repository

Created Folder structure:




















2020-11-20

[Archived] RMCO区才可以无限制乘车人数

 




 吉打州的学校不知道有复课么?
 如果没有新的宣布就继续关到本年度学年结束

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000754330096575&reply_comment_id=2000777010094307




 车上还是一样坐3个人吗?还是几个都可以呢?
 解除了恢复到RMCO就没有限制乘车人数

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000765456762129&reply_comment_id=2000775016761173




 提早结束的意思是说一切都能如常了,补习也能开店了?
 甲吉柔登结束CMCO后 #继续RMCO!补习的部分等地方政府宣布

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000750993430242&reply_comment_id=2000755873429754


结束了幼儿园和安亲班可以开了是吗?
等地方政府宣布

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000749023430439&reply_comment_id=2000759090096099


那么还有限制一辆车只能三人坐吗?还是也解除了呢?
一车三人只有CMCO才实行,RMCO就没有此限制了

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000754710096537&reply_comment_id=2000758890096119




傍晚好 巴辖 有吗
峇株也是解除cmco,回到rmco

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000756270096381&reply_comment_id=2000762520095756


Johor 是不是明天起就结束了,还是说是RMCO呢?
是的,回到RMCO的SOP!

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000758030096205&reply_comment_id=2000760253429316



麻坡可以去马六甲了的意思吗
是的,可以,回到RMCO的SOP!

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000751290096879&reply_comment_id=2000756393429702



请问补习班和安亲班可以开回了吗?
等地方政府宣布

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000755786763096&reply_comment_id=2000762070095801



请问柔佛洲解封了,餐馆油站之类的营业时间就变回之前了吗?可以营业至12am?
明天开始

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000766053428736&reply_comment_id=2000769120095096


那这样是开学了吗?
如果没有新的宣布就继续关到本年度学年结束

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000751750096833&reply_comment_id=2000776673427674


可以开学了吗
如果没有新的宣布就继续关到本年度学年结束

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000754370096571&reply_comment_id=2000776806760994




一桌可以坐几个人了???
根据RMCO的SOP就没有几个人,但必须保持距离即可

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000759850096023&reply_comment_id=2000775923427749












——————————





那么是说22号开始车就可以坐四个人了咯?
RMCO区才可以无限制乘车人数

https://www.facebook.com/victorteocl/posts/2000747223430619?comment_id=2000767480095260&reply_comment_id=2000773753427966


















2020-11-06

Finding: will npm install get back node_modules I deleted

 

Googled: Angular clear node_modules

my local Angular projects, can I just remove node_modules folder, and will get back just run npm install right?


Double checked, yes, will get back the folder.


But node_modules folder different size compare with:

the node_modules folder before delete (generated by ng new)

the node_modules folder generated after npm install











local untracked file is gone after git pull

 Git version:

PortableGit-2.28.0-64-bit.7z


Case:

Did a Git Stash in Visual Studio Code, before commit i did git  pull, then my changes and new files all gone.


Read article saying that git stash won't "add" new files(untracked)

https://www.cnblogs.com/zndxall/archive/2018/09/04/9586088.html

But luckily still able get back all files(changes + new/untracked files) by git stash pop.














2020-10-29

[Solved] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

 

Googled: "spring.datasource.url" "Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure" "Caused by: java.net.ConnectException: Connection refused: connect"

But has no solutions.

Situation was: SpringBoot Microservice failed to launch due to error above.

MySql version was 8.0.22


Found that my repository was develop on MySql version 8.0.15


After revert back to MySql version 8.0.15, no more Communications link failure error.






But hit another issue 

mysql 8.0.15 "java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed"


Need to revise spring.datasource.url by append database connection string

&allowPublicKeyRetrieval=true


Then service is up.










2020-09-20

[Gave up] Oppo S1 Mini

[Gave up]: I gave up to patch this issue for this customized device, but hope these info I found could lead u somewhere.


Main issue:

  • Unfortunately, the process com.google.process.gapps has stopped.
  • Unfortunately, Google Play Store has stopped.



Model number: S1 mini

Android version: 7.0

Baseband version: 2019.3.1

Kernel version 3.4.67 | Builder@C1 #51 | sat Jul 4 21:58:27 CST 2020

Build number: q9_m432_b15_wx_r3_V0.9_20200704

Custom build version: 1593871116


Factory version:
Google Play services: 5.0.89 (1307510-034)
Google Play Store: 14.1.48-all [0] [PR] 239702733
Google Services Framework: 3.3.3-1288895


Google Services Framework: 3.3.3-1288895
Google Play services: 5.0.89 (1307510-034)
Google Play Store: 14.1.48-all [0] [PR] 239702733


Saw 6GB RAM installed in device info/setting, but using Device Info HW 4.28.1 showing different thing.


Install Sequence from previous Mi 9 experience:
Framework
Play Service
Play Store










https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-7-0-release/google-services-framework-7-0-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-7-0-3037786-release/google-services-framework-7-0-3037786-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-12-6-85-release/google-play-services-12-6-85-000300-197041431-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-play-store/google-play-store-21-9-47-release/google-play-store-21-9-47-21-0-pr-331897675-android-apk-download/


https://play.google.com/store/apps/details?id=com.google.android.gms


https://www.apkmirror.com/apk/google-inc/google-play-store/google-play-store-12-6-13-release/google-play-store-12-6-13-all-0-pr-221870828-android-apk-download/


All apk won't be able to install, except Google Play services, installed but not working





https://www.deviceinfo.me/

Android version: 4.4.2 (Build: KOT49H) (32-bit)

Android WebView version: 30.0 (32-bit) (Engine: Blink)

Browser Build Number / Identifier: 2003-01-07

User Agent: i Mozilla/5.0 (Linux; Android 4.4.2; S1 mini Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/30.0.0.0 Mobile Safari/537.36

 


https://whatdevice.app/

Unknown Android device

Operating system: Android 4.4.2

Architecture: armv7l

Language: en-US

 


armeabi-v7a

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-36-14-release/google-play-services-20-36-14-000300-331796208-android-apk-download/ 

 Although change to architecture of v7, still the same, able to installed, but loop stopping.

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034) 

Found info to get version GOOGLE PLAY SERVICES 12.2.21 from URL: 

https://www.apksquare.com/google-play-services-apk-for-android-4-4-2-kitkat-download-new-version/

how to update Google Play Services app manually

Google Play services: version 12.2.21 (070-188803320)

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-12-2-21-release/google-play-services-12-2-21-070-188803320-android-apk-download/ 

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034) 

 

Google Play services: version 20.33.15

Found info of Google Play services: version 20.33.15 (120400-330018294) from URL: https://google-play-services.apk.gold/android-4.4.2

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-33-15-release/google-play-services-20-33-15-000700-330018294-android-apk-download/

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034)

 armeabi-v7a

 https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-33-15-release/google-play-services-20-33-15-000300-330018294-android-apk-download/

Installed, but loop stopping.

Revert back to factory version, 5.0.89 (1307510-034)

240dpi

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-20-33-15-release/google-play-services-20-33-15-000304-330018294-android-apk-download/




 

Google Play services: version 4.4.48

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-4-4-48-3-release/google-play-services-4-4-48-1150368-038-android-apk-download/


https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-6-5-85-17-release/google-play-services-6-5-85-1589008-070-android-apk-download/ 


https://www.apkmirror.com/apk/google-inc/google-play-store/google-play-store-21-9-47-release/google-play-store-21-9-47-16-0-pr-331897675-android-apk-download/





Factory version with sequence from YouTube printscreen:


Google Services Framework:
3.3.3-1288895

Google Account Manager:
4.4.4-1227136
not sure

Google Play services:
5.0.89 (1307510-034)


Google Calendar Sync:


Google Contacts Sync:


Finally
Google Play Store:
14.1.48-all [0] [PR] 239702733
not sure




Google Services Framework 4.4.2-1289630 (Android 4.4+)

https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-4-4-2-1289630-release/google-services-framework-4-4-2-1289630-android-apk-download/#file

https://www.apkmirror.com/apk/google-inc/google-services-framework/google-services-framework-4-4-2-1289630-release/google-services-framework-4-4-2-1289630-android-apk-download/download/ 




Google Play services 10.0.84 (034-137749526) (034)

https://www.apkmirror.com/apk/google-inc/google-play-services/google-play-services-10-0-84-release/google-play-services-10-0-84-034-137749526-android-apk-download/download/ 


Google Calendar Sync 4.4-927798 (Android 4.0.3+)

Google Calendar Sync 5.2.3-99827563-release (Android 4.0.3+)






>adb.exe shell logcat *:E






E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/cutils-trace( 3069): Error opening trace file: No such file or directory (2)
E/dalvikvm( 3055): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes2.zip'
E/dalvikvm( 3055): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes3.zip'
E/AndroidRuntime( 3055): FATAL EXCEPTION: main
E/AndroidRuntime( 3055): Process: com.android.vending, PID: 3055
E/AndroidRuntime( 3055): java.lang.NoClassDefFoundError: ieq
E/AndroidRuntime( 3055):        at dso.<init>(SourceFile)
E/AndroidRuntime( 3055):        at dgb.bj(SourceFile:3)
E/AndroidRuntime( 3055):        at dgb.aQ(SourceFile:9)
E/AndroidRuntime( 3055):        at djd.onCreate(SourceFile)
E/AndroidRuntime( 3055):        at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1007)
E/AndroidRuntime( 3055):        at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4541)
E/AndroidRuntime( 3055):        at android.app.ActivityThread.access$1500(ActivityThread.java:151)
E/AndroidRuntime( 3055):        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1381)
E/AndroidRuntime( 3055):        at android.os.Handler.dispatchMessage(Handler.java:110)
E/AndroidRuntime( 3055):        at android.os.Looper.loop(Looper.java:193)
E/AndroidRuntime( 3055):        at android.app.ActivityThread.main(ActivityThread.java:5299)
E/AndroidRuntime( 3055):        at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime( 3055):        at java.lang.reflect.Method.invoke(Method.java:515)
E/AndroidRuntime( 3055):        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:825)
E/AndroidRuntime( 3055):        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
E/AndroidRuntime( 3055):        at dalvik.system.NativeStart.main(Native Method)
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/WindowManager(  677): Starting window AppWindowToken{426cea30 token=Token{420ed1b8 ActivityRecord{4241c4e8 u0 com.android.vending/.AssetBrowserActivity t17}}} timed out























E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/cutils-trace( 3096): Error opening trace file: No such file or directory (2)
E/dalvikvm( 3082): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes2.zip'
E/dalvikvm( 3082): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes3.zip'
E/AndroidRuntime( 3082): FATAL EXCEPTION: main
E/AndroidRuntime( 3082): Process: com.android.vending, PID: 3082
E/AndroidRuntime( 3082): java.lang.NoClassDefFoundError: ieq
E/AndroidRuntime( 3082):        at dso.<init>(SourceFile)
E/AndroidRuntime( 3082):        at dgb.bj(SourceFile:3)
E/AndroidRuntime( 3082):        at dgb.aQ(SourceFile:9)
E/AndroidRuntime( 3082):        at djd.onCreate(SourceFile)
E/AndroidRuntime( 3082):        at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1007)
E/AndroidRuntime( 3082):        at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4541)
E/AndroidRuntime( 3082):        at android.app.ActivityThread.access$1500(ActivityThread.java:151)
E/AndroidRuntime( 3082):        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1381)
E/AndroidRuntime( 3082):        at android.os.Handler.dispatchMessage(Handler.java:110)
E/AndroidRuntime( 3082):        at android.os.Looper.loop(Looper.java:193)
E/AndroidRuntime( 3082):        at android.app.ActivityThread.main(ActivityThread.java:5299)
E/AndroidRuntime( 3082):        at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime( 3082):        at java.lang.reflect.Method.invoke(Method.java:515)
E/AndroidRuntime( 3082):        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:825)
E/AndroidRuntime( 3082):        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
E/AndroidRuntime( 3082):        at dalvik.system.NativeStart.main(Native Method)
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory
E/        (  677): Could not open '/data/data/hotplug/cmd'
E/        (  677): error : 2, No such file or directory





WhatsApp Messenger 2.20.198.15 (arm-v7a) (Android 4.1+)





2020-09-18

Visual Studio Code cannot detect installed git

 


Open Visual Studio Code

File > Preference > Settings

or

Ctrl + , 

 

in Search Settings: git.path


Click edit in settings.json, and edit as below, end with git.exe







2020-08-28

Fixed: Microsoft Office 2013 Pro Plus 15. microsoft office can't find your license for this application. a repair attempt was unsuccessful

 



Source URL: https://www.heidoc.net/joomla/technology-science/microsoft/79-create-an-office-2013,-2016-and-365-offline-installer-with-the-office-deployment-tool

Refer to:

  1. https://superuser.com/questions/42788/is-it-possible-to-execute-a-file-after-extraction-from-a-7-zip-self-extracting-a
  2. http://ntsblog.homedev.com.au/index.php/2015/05/14/self-extracting-archive-runs-setup-exe-7zip-sfx-switch/


Microsoft Office 2013 Deployment Tool
The Office 2013 Deployment Tool allows the administrator to customize and manage Office 2013 Click-to-Run deployments. This tool will help adminstrators to manage installations sources, product/language combinations, and deployment configuration options for Office Click-to-Run.

Download above and save as: officedeploymenttool_x86_5031-1000.exe

Double click run it, then extract:

  1. setup.exe
  2. configuration.xml
Edit configuration.xml to become below.


download template configuration.xml from heidoc.net.


modified to 

<Configuration>
<Add OfficeClientEdition="64">
<Product ID="ProPlusRetail">
<Language ID="en-us"/>
</Product>
</Add>
<Updates Enabled="TRUE"/>
<Display Level="Full" AcceptEULA="TRUE"/>
</Configuration>




Run

setup /download configuration.xml


will download as below:



select files below, right click and add to 7zip archive.












;!@Install@!UTF-8!
Title="ProPlusRetail x64"
BeginPrompt="Do you want to install ProPlusRetail x64?"
RunProgram="setup.exe /configure configuration.xml"
;!@InstallEnd@!





copy /b 7zSD.sfx + config.txt + ProPlusRetail_x64.7z ProPlusRetail_x64.exe

 

copy /b 7zSD.sfx + config.txt + ProPlusRetail_x64.7z ProPlusRetail_x64.exe
7zSD.sfx
config.txt
ProPlusRetail_x64.7z
        1 file(s) copied.








Successful build exe, but never try to install


End up fix the main issue by install from ProfessionalRetail.img, download from url below:

Open url below in new window(verified still able to download@20211204_pm093826):


Microsoft Office 2013 (15.0.4433.1508)

32bit & 64 bit:

http://officeredir.microsoft.com/r/rlidO15C2RMediaDownload?p1=db&p2=en-US&p3=ProfessionalRetail

default setup for 32 bit in ProfessionalRetail.img




For 64 bit,  in ProfessionalRetail.img/office/setup64





What are x86 and x64 editions?

Running the x64 (64 bit) edition also requires an x64 Windows edition. The advantage of Office x64 is a bit better performance. Disadvantage is that it doesn't support most third party plugins and add-ons. Microsoft actually discourages the use of the x64 editions. So unless you're absolutely sure you need an x64 edition, you should choose x86 (32 bit).

Download Office 2013 Backup Images from Microsoft

The following links point to the official download server officecdn.microsoft.com. Instead of ISO they come as IMG images. These files are pure backup media, and can't be installed without a retail product key.

The IMG images are not the same as the "Single Image" downloads that used to be available from Digital River, but offline versions of the streaming "Click-to-Run" version, with all disadvantages associated with that. If your required download is not included here (such as Office 2013 Professional Plus) please proceed to the download instructions here.

...