Ishidi Lokusebenzela le-SQL kanye Neklayenti Lombuzo le-Oracle / MySQL kanye ne-MSSQL Database
KUBALULEKILE
Lolu hlelo lokusebenza lwakhiwe njengethuluzi eliyimfihlo lokufinyelela kusizindalwazi kusuka kumadivayisi e-Android.
Ngokuyinhloko, ukuthuthukiswa kwakuklanyelwe izizindalwazi ze-Oracle.
Inikezwa mahhala futhi ayisho ukuncintisana namathuluzi ochwepheshe.
Asikho iwaranti enikeziwe nganoma yimuphi umonakalo ongavela ekuphathweni kwalolu hlelo lokusebenza.
Ukusetshenziswa kwalolu hlelo lokusebenza kusengozini yakho.
Njengoba lolu hlelo lokusebenza lugcina idatha yalo ohlelweni lwefayela futhi ngenxa yalokho lunomsebenzi wesiphequluli sefayela, lolu hlelo lokusebenza ludinga ukufinyelela kuzo zonke izinkomba ohlelweni lwefayela.
Lokhu kusebenza kunikeza ithuba lokugcina ama-SQL akho nedatha ekhethiwe kunoma iyiphi inkomba kanye nokungenisa ama-SQL adalwe ngaphandle kusihleli sohlelo lokusebenza ukuze ukwazi ukwenza imibuzo eyinkimbinkimbi okunzima ukuyidala ngohlelo lokusebenza lwe-Android.
Uhlelo lwami lokusebenza ngeke lufunde, luguqule, lususe noma lusebenzise noma iyiphi idatha yakho ohlelweni lwamafayela nganoma iyiphi indlela ngaphandle kwemvume yakho.
Ku-Android 10 nangaphezulu I-Filemanager yami yangaphakathi manje isithathelwa indawo yi-Standard Android Open and Save File Functions, ngoba i-Google ayikuvumeli "ukuphatha wonke amafayela" kuhlelo lwami lokusebenza. ngalokhu angisadingi "ukuphatha wonke amafayela" kodwa ezinye izici zilahlekile mayelana nalolu shintsho njengokusetha uhla lwemibhalo oluzenzakalelayo nezinto ezinjalo.
Imisebenzi Esemqoka yalolu hlelo lokusebenza:
- dala izitatimende ze-sql
- imigqa yesethi yemiphumela engenamkhawulo
- Usayizi wesethi yomphumela unqunyelwe inkumbulo yakho kuphela
- gcina/layisha izitatimende ze-sql ku/kusuka kumafayela ombhalo
- lungisa amakholomu kusethi yomphumela
- hlunga amakholomu kusethi yomphumela
- sebenzisa okuguquguqukayo okuguquguqukayo okufana nokokufaka
- ukugqama kwe-syntax
- sql ubuhle
- dala chaza izinhlelo
- Thumela idatha ku-csv
- thekelisa futhi ukopishe idatha ebhodini lokunamathisela
- ukukhohlisa sql njengokuthi 'faka' noma 'buyekeza'
I-RoSQL kufanele isetshenziswe kunethiwekhi evikelekile njengenethiwekhi ye-vpn noma inethiwekhi yendawo evikelekile, ngoba ithrafikhi ayibethelwanga !
I-MSSQL isetshenziswa kuphela ku-Android 5 nangaphezulu, hhayi i-Android 4.4.
Ku-Android 11 noma ngaphezulu unikeze ifayela lohlelo lokusebenza izimvume zokufunda nokubhala kuzilungiselelo zefoni yakho ye-android. bona amalungelo ohlelo lokusebenza ocingweni lwakho. kubonakala kuhlukile ukusethela amafoni ahlukene/izinguqulo ze-android.
Kunenkinga (ORA-12705) nge-NLS (Oracle neklayenti elincanyana) kwamanye amazwe. uma ifoni noma ithebulethi yakho inolimi (isibonelo isiCyrillic), olungasekelwe, ungazama ukushintsha indawo kuwindi lezilungiselelo ukuze ibe "US" (ibhokisi lokuhlola loxhumano oluzenzakalelayo lwase-US). kubonakala kuyinkinga ye-oracle express, ekuhlolweni okunemininingwane egciniwe ye-oracle/yebhizinisi anginawo la maphutha okuxhuma.
leli klayenti le-oracle sql lisebenzisa ukuxhumana okuqondile okuncanyana kwe-v8 kwe-Android 4.4 naphansi kanye nokuxhumana okuqondile okuncanyana kwe-v11 kwe-android 5 nangaphezulu kusizindalwazi sakho!
- Umsebenzisi we-Android 5 nangaphezulu akusadingeki asethe imodi yokuvumelana engu-8 ye-Oracle
- Umsebenzisi we-Android 4.4 nangaphansi kufanele asethe imodi yokuhambisana engu-8 (oracle10 nangaphezulu) njengoba kuchazwe ngezansi:
ngoxhumo lwe-Oracle12c sicela usethe kokuthi sqlnet.ini (Iseva) SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
kumininingwane egciniwe ilingana ne-oracle10g noma i-11g: SQLNET.ALLOWED_LOGON_VERSION=8
ungalanda inguqulo ye-Android 4.4 nangaphansi, kodwa ngeke isanakekelwa.
uma i-db-admin yakho ingakuvumeli ukuxhumana okuqondile okuqondile (v8 noma v11) kusuka kuKlayenti, lolu hlelo lokusebenza alukwazi ukuxhuma kusizindalwazi sakho se-oracle!
ukuxhumana okuhloliwe: i-oracle9i, i-oracle10g, i-oracle11g, i-oracle12c, i-mysql 5.5, iseva ye-mssql 2016
Kubuyekezwe ngo-
Aga 6, 2025