:::: gangserver's blog ::::

1. Oracle JDBC driver 12.2.0.1 (ojdbc8.jar) download https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html 2. ojdbc8.jar Nexus 3.23.x Upload Nexus login : http://localhost:8081 Sign in left menu [Upload] Click -> [maven-releases] click - File : [Browse] ojdbc8.jar select - Extension : jar - Group ID : com.oracle.jdbc - Artifact ID : ojdbc8 - Version : 12.2.0.1 [Upload] 3. pom...

MariaDB 10.3 login error $ mariadb -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' $ sudo mariadb -u root -p (or sudo mysql -u root -p) after login MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'PassW0rd'; Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.001 sec) re-..

Oracle Install Directory : C:\app\oracle\product\12.2.0\dbhome_1 listener.ora edit C:\app\oracle\product\12.2.0\dbhome_1\network\admin\listener.ora Before SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\app\oracle\product\12.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.2.0\dbhome_1\bin\oraclr12.dll") ) ) LISTENER = (D..

$ sudo apt-get install software-properties-common $ sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 $ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.nodesdirect.com/mariadb/repo/10.4/ubuntu bionic main' $ sudo apt update $ sudo apt install mariadb-server $ sudo vi /etc/apt/sources.list.d/MariaDB.list # MariaDB 10.4 repository list ..

MariaDB 10.4 yum repository $ sudo vi /etc/yum.repos.d/MariaDB.repo ---------------------------------------------------------------------------------------- # MariaDB 10.4 CentOS repository list - created 2019-11-20 13:09 UTC # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.4/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY..

begin transaction ( or begin tran ) 작업1 작업2 . . . 성공시 commit tran ( or commit ) 실패시 rollback tran ( or rollback )