sqlite_exec for insert query is successful, but entry not found in sqlite table

Question

I'm facing a strange issue where in my insert query using sqlite_exec API says successful return value, but when I check in sqlite table I dont see that entry, Below is my code

Insert query : INSERT INTO table_name VALUES (0,1584633967816,1584634000,'dasdasda','1584634000','28641','dasdas','dsadas','dsadsa','/rewrwe','rwerewr','rewrewr','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)

sqlite_exec code block:

sqliteError = sqlite3_exec(pSqlHandle, oSqlQuery.str().c_str(), NULL, NULL, NULL);

        if (sqliteError == SQLITE_OK)
        {
            LOG(DbgLogger, LOG_LEVEL_DEBUG, "Query %s  successful\n",
                oSqlQuery.str().c_str());
            if (pSqlHandle) {
                sqliteError = sqlite3_close(pSqlHandle);
                if (sqliteError != SQLITE_OK) {
                    sqlRet = SQL_API_FAILURE;
                }
                else {
                    pSqlHandle = NULL;
                }
            }
            sqlRet = SQL_API_SUCCESS;
            if (m_useLockFile) {
                //write done, release write lock
                sqlRet = releaseWriteLock();
                /* reset write lock file name */
                bWriteLckAvailable = false;
            }
            break;
        }

I can see print "LOG(DbgLogger, LOG_LEVEL_DEBUG, "Query %s successful\n",)"

But when I do a select from command line on the I dont see any entry as such

eg: select * from table_name where column_name=1584633967816;

Anyone faced similar issue ?