Error: isTableExists: No available connection for database: with Capacitor 4 and SQLite ver: 4.2.2 #344

Sampath-Lokuge · 2022-11-07T16:34:56Z

Hi,

sqlite-configuration.service.ts

async configureSqliteDatabase(): Promise<void> {
    const sqliteConnection = new SQLiteConnection(CapacitorSQLite);

    const checkConnectionsConsistency = await sqliteConnection.checkConnectionsConsistency();

    const isConnection = (await sqliteConnection.isConnection('TaxiMate'))?.result;

    if (checkConnectionsConsistency?.result && isConnection) {
      this.sqliteDbConnection = await sqliteConnection.retrieveConnection('TaxiMate');
    } else {
      this.sqliteDbConnection = await sqliteConnection.createConnection(
        'TaxiMate',
        false,
        'no-encryption',
        1
      );
    }

    await this.sqliteDbConnection.open();

    this.setSqliteDbConnection(this.sqliteDbConnection);
  }

Error:

 Uncaught (in promise): Error: isTableExists: No available connection for database TaxiMate
Error: isTableExists: No available connection for database TaxiMate
    at returnResult (VM3:744:32)
    at win.androidBridge.onmessage (VM3:719:21)
    at resolvePromise (zone.js:1255:1)
    at zone.js:1162:1
    at asyncGeneratorStep (asyncToGenerator.js:6:1)
    at _throw (asyncToGenerator.js:29:1)
    at ZoneDelegate.invoke (zone.js:400:1)
    at Object.onInvoke (core.mjs:26231:33)
    at ZoneDelegate.invoke (zone.js:399:1)
    at Zone.run (zone.js:160:1)
    at zone.js:1318:1
    at ZoneDelegate.invokeTask (zone.js:434:1)

package.json

{
  "name": "TaxiMate",
  "version": "1.5.0",
  "author": "TaxiMate",
  "homepage": "",
  "scripts": {
    "ng": "ng",
    "start": "ng serve",
    "build": "ng build --prod",
    "lint": "ng lint"
  },
  "private": true,
  "dependencies": {
    "@angular/cdk": "14.2.6",
    "@angular/common": "14.2.9",
    "@angular/core": "14.2.9",
    "@angular/forms": "14.2.9",
    "@angular/platform-browser": "14.2.9",
    "@angular/platform-browser-dynamic": "14.2.9",
    "@angular/router": "14.2.9",
    "@capacitor-community/sqlite": "4.0.1",
    "@capacitor-firebase/authentication": "1.2.0",
    "@capacitor/android": "^4.3.0",
    "@capacitor/app": "^4.0.0",
    "@capacitor/camera": "^4.0.0",
    "@capacitor/core": "^4.3.0",
    "@capacitor/haptics": "^4.0.0",
    "@capacitor/ios": "^4.3.0",
    "@capacitor/keyboard": "^4.0.0",
    "@capacitor/network": "^4.0.0",
    "@capacitor/preferences": "^4.0.1",
    "@capacitor/splash-screen": "^4.0.0",
    "@capacitor/status-bar": "^4.0.0",
    "@ionic/angular": "6.3.4",
    "@sentry/angular": "7.13.0",
    "@sentry/capacitor": "0.10.1",
    "@types/lodash": "4.14.178",
    "dayjs": "1.10.7",
    "firebase": "9.6.10",
    "guid-typescript": "1.0.9",
    "lodash": "4.17.21",
    "rxjs": "6.6.0",
    "tslib": "2.2.0",
    "zone.js": "0.11.4"
  },
  "devDependencies": {
    "@angular-devkit/build-angular": "^14.2.8",
    "@angular-eslint/builder": "14.1.2",
    "@angular-eslint/eslint-plugin": "14.1.2",
    "@angular-eslint/eslint-plugin-template": "14.1.2",
    "@angular-eslint/template-parser": "14.1.2",
    "@angular/cli": "14.2.8",
    "@angular/compiler": "14.2.9",
    "@angular/compiler-cli": "14.2.9",
    "@angular/language-service": "14.2.9",
    "@capacitor/cli": "^4.0.0",
    "@ionic/angular-toolkit": "7.0.0",
    "@sentry/cli": "^2.8.1",
    "@types/node": "12.11.1",
    "@typescript-eslint/eslint-plugin": "5.42.0",
    "@typescript-eslint/parser": "5.42.0",
    "eslint": "7.6.0",
    "eslint-plugin-import": "2.22.1",
    "eslint-plugin-jsdoc": "30.7.6",
    "eslint-plugin-prefer-arrow": "1.2.2",
    "prettier": "2.5.1",
    "ts-node": "8.3.0",
    "typescript": "4.8.4"
  },
  "description": "TaxiMate"
}

The above code works fine with 3+ versions. But now it gives the above error with 4+ versions. Please let me know the issue.

I have tried with 4.2.2 too. Same error.
Ionic/Angular native app.

Is this "@capacitor/core": "^4.3.0", issue? i.e. I use that version.

I didn't add any new code with the 4+ version. Do I need to do that?

Thanks!

The text was updated successfully, but these errors were encountered:

jepiqueau · 2022-11-07T18:38:17Z

@Sampath-Lokuge try with the latest version of @capacitor-community/sqlite. I am away from any computer till end of the month.
Look at the code of the angular starter app there is some call to isTableExists and they work.
Have you convert your app from capacitor 3 to 4 according to the ionic recommandations

Sampath-Lokuge · 2022-11-08T07:17:05Z

Still the same error with 4.2.0. Do I need to change my code? i.e. cannot use the below code with this new version? I have used npx cap migrate for 3 to 4 and no errors there. Your thoughts?

Same above error.

package.json

{
  "name": "TaxiMate",
  "version": "1.5.0",
  "author": "TaxiMate",
  "homepage": "",
  "scripts": {
    "ng": "ng",
    "start": "ng serve",
    "build": "ng build --prod",
    "lint": "ng lint"
  },
  "private": true,
  "dependencies": {
    "@angular/cdk": "14.0.0",
    "@angular/common": "14.0.0",
    "@angular/core": "14.0.0",
    "@angular/forms": "14.0.0",
    "@angular/platform-browser": "14.0.0",
    "@angular/platform-browser-dynamic": "14.0.0",
    "@angular/router": "14.0.0",
    "@capacitor-community/sqlite": "4.2.0",
    "@capacitor-firebase/authentication": "1.2.0",
    "@capacitor/android": "^4.2.0",
    "@capacitor/app": "^4.0.0",
    "@capacitor/camera": "^4.0.0",
    "@capacitor/core": "^4.2.0",
    "@capacitor/haptics": "^4.0.0",
    "@capacitor/ios": "^4.2.0",
    "@capacitor/keyboard": "^4.0.0",
    "@capacitor/network": "^4.0.0",
    "@capacitor/preferences": "^4.0.1",
    "@capacitor/splash-screen": "^4.0.0",
    "@capacitor/status-bar": "^4.0.0",
    "@ionic/angular": "6.3.4",
    "@sentry/angular": "7.13.0",
    "@sentry/capacitor": "0.10.1",
    "@types/lodash": "4.14.178",
    "dayjs": "1.10.7",
    "firebase": "9.6.10",
    "guid-typescript": "1.0.9",
    "lodash": "4.17.21",
    "rxjs": "6.6.0",
    "tslib": "2.2.0",
    "zone.js": "0.11.4"
  },
  "devDependencies": {
    "@angular-devkit/build-angular": "^14.0.0",
    "@angular-eslint/builder": "14.1.2",
    "@angular-eslint/eslint-plugin": "14.1.2",
    "@angular-eslint/eslint-plugin-template": "14.1.2",
    "@angular-eslint/template-parser": "14.1.2",
    "@angular/cli": "14.0.0",
    "@angular/compiler": "14.0.0",
    "@angular/compiler-cli": "14.0.0",
    "@angular/language-service": "14.0.0",
    "@capacitor/cli": "^4.2.0",
    "@ionic/angular-toolkit": "6.0.0",
    "@sentry/cli": "^2.8.1",
    "@types/node": "12.11.1",
    "@typescript-eslint/eslint-plugin": "5.42.0",
    "@typescript-eslint/parser": "5.42.0",
    "eslint": "7.6.0",
    "eslint-plugin-import": "2.22.1",
    "eslint-plugin-jsdoc": "30.7.6",
    "eslint-plugin-prefer-arrow": "1.2.2",
    "prettier": "2.5.1",
    "ts-node": "8.3.0",
    "typescript": "4.7.3"
  },
  "description": "TaxiMate"
}

code

async configureSqliteDatabase(): Promise<void> {
   const sqliteConnection = new SQLiteConnection(CapacitorSQLite);

   const checkConnectionsConsistency = await sqliteConnection.checkConnectionsConsistency();

   const isConnection = (await sqliteConnection.isConnection('TaxiMate', false))?.result;

   if (checkConnectionsConsistency?.result && isConnection) {
     this.sqliteDbConnection = await sqliteConnection.retrieveConnection('TaxiMate', false);
   } else {
     this.sqliteDbConnection = await sqliteConnection.createConnection(
       'TaxiMate',
       false,
       'no-encryption',
       1,
       false
     );
   }

   await this.sqliteDbConnection.open();

   this.setSqliteDbConnection(this.sqliteDbConnection);
 }

jepiqueau · 2022-11-08T07:33:11Z

@Sampath-Lokuge i do not see in your code where you call isTableExists. On which platform the error is returned? All of them ?

Sampath-Lokuge · 2022-11-08T07:35:21Z

I have used this const isTable = await this.sqliteDbConnection.isTable('taxiExtras');

Do I need to change that to const isTable = await this.sqliteDbConnection.isTableExists('taxiExtras');

Can I have doc for such changes?

This is a native Android app.

Sampath-Lokuge · 2022-11-08T07:41:18Z

P.S.

I have not used isTableExists with my code. only isTable and all worked nicely with this version "@capacitor-community/sqlite": "3.5.1-2",

Sampath-Lokuge · 2022-11-08T07:53:50Z

P.S. 2

Sorry, we cannot use this const isTable = await this.sqliteDbConnection.isTableExists('taxiExtras'); there too.

Any thoughts, please? Why is that error with 4.2.0?

jepiqueau · 2022-11-08T09:28:35Z

@Sampath-Lokuge it is isTable to be used with this.sqliteDbConnection

Sampath-Lokuge · 2022-11-08T09:34:50Z

Yes private sqliteDbConnection: SQLiteDBConnection;

Sampath-Lokuge · 2022-11-08T10:21:22Z

P.S.

I use this CLI: ionic cap run android -l --host=0.0.0.0

Sampath-Lokuge · 2022-11-08T10:42:58Z

P.S.2

It shows like so: Is this correct? I think the problem is there no?

Actuely the same error with "@capacitor-community/sqlite": "3.5.1-2",

Any reason why this happened suddenly? I have not touched this app for a few months now and no changes too.

Sampath-Lokuge · 2022-11-09T08:02:27Z

Any feedback here, please?

Sampath-Lokuge · 2022-11-09T08:16:56Z

That error shows when it executes this line:

const isTable = await this.sqliteDbConnection.isTable('taxiExtras');

Sampath-Lokuge · 2022-11-14T07:18:04Z

Please see this video too: https://youtu.be/8oWWLAYzxkE

Any clue, please?

jepiqueau · 2022-11-14T07:41:24Z

@Sampath-Lokuge are you using @capacitor-community/http if it is the case change it with the http plugin @capacitor/http. This may solve the issue. At least it did for one developer otherwise you will have to share your code when i am back and i will have a look

Sampath-Lokuge · 2022-11-14T07:56:21Z

No. I use this import { HttpClientModule } from '@angular/common/http';

package.json

{
  "name": "taximate-mobile",
  "version": "0.0.1",
  "author": "Ionic Framework",
  "homepage": "https://ionicframework.com/",
  "scripts": {
    "ng": "ng",
    "start": "ng serve",
    "build": "ng build",
    "test": "ng test",
    "lint": "ng lint",
    "e2e": "ng e2e"
  },
  "private": true,
  "dependencies": {
    "@angular/cdk": "^14.0.0",
    "@angular/common": "^14.0.0",
    "@angular/core": "^14.0.0",
    "@angular/forms": "^14.0.0",
    "@angular/platform-browser": "^14.0.0",
    "@angular/platform-browser-dynamic": "^14.0.0",
    "@angular/router": "^14.0.0",
    "@capacitor-community/sqlite": "^4.2.2",
    "@capacitor/android": "^4.4.0",
    "@capacitor/app": "4.1.0",
    "@capacitor/camera": "^4.1.3",
    "@capacitor/core": "4.4.0",
    "@capacitor/haptics": "4.0.1",
    "@capacitor/keyboard": "4.0.1",
    "@capacitor/network": "^4.0.1",
    "@capacitor/preferences": "^4.0.1",
    "@capacitor/splash-screen": "^4.1.1",
    "@capacitor/status-bar": "4.0.1",
    "@ionic/angular": "^6.1.9",
    "@sentry/angular": "^7.13.0",
    "@sentry/capacitor": "^0.10.1",
    "dayjs": "^1.11.6",
    "guid-typescript": "^1.0.9",
    "ionicons": "^6.0.3",
    "rxjs": "~6.6.0",
    "tslib": "^2.2.0",
    "zone.js": "~0.11.4"
  },
  "devDependencies": {
    "@angular-devkit/build-angular": "^14.0.0",
    "@angular-eslint/builder": "~13.0.1",
    "@angular-eslint/eslint-plugin": "~13.0.1",
    "@angular-eslint/eslint-plugin-template": "~13.0.1",
    "@angular-eslint/template-parser": "~13.0.1",
    "@angular/cli": "^14.0.0",
    "@angular/compiler": "^14.0.0",
    "@angular/compiler-cli": "^14.0.0",
    "@angular/language-service": "^14.0.0",
    "@capacitor/cli": "4.4.0",
    "@ionic/angular-toolkit": "^6.0.0",
    "@types/jasmine": "~3.6.0",
    "@types/jasminewd2": "~2.0.3",
    "@types/node": "^12.11.1",
    "@typescript-eslint/eslint-plugin": "5.3.0",
    "@typescript-eslint/parser": "5.3.0",
    "eslint": "^7.6.0",
    "eslint-plugin-import": "2.22.1",
    "eslint-plugin-jsdoc": "30.7.6",
    "eslint-plugin-prefer-arrow": "1.2.2",
    "jasmine-core": "~3.8.0",
    "jasmine-spec-reporter": "~5.0.0",
    "karma": "~6.3.2",
    "karma-chrome-launcher": "~3.1.0",
    "karma-coverage": "~2.0.3",
    "karma-coverage-istanbul-reporter": "~3.0.2",
    "karma-jasmine": "~4.0.0",
    "karma-jasmine-html-reporter": "^1.5.0",
    "prettier": "^2.7.1",
    "protractor": "~7.0.0",
    "ts-node": "~8.3.0",
    "typescript": "~4.7.3"
  },
  "description": "An Ionic project"
}

Sampath-Lokuge · 2022-11-15T14:19:08Z

I have sent you the source code. Please confirm it. Thanks!

Sampath-Lokuge · 2022-11-17T16:25:28Z

I have sent you a Git invitation for the source code. Please see that. Thanks!

jepiqueau · 2022-11-17T17:50:26Z

@Sampath-Lokuge i do not have receive any invitation

Sampath-Lokuge · 2022-11-17T18:03:09Z

Sent it again. Please see it in the spam folder too.

jepiqueau · 2022-11-19T12:40:51Z

@Sampath-Lokuge can you close the issue if everything is solved on your side

Sampath-Lokuge · 2022-11-19T15:14:19Z

Your this feedback gave me a hint. #338 (comment)

i.e. I have opened 2 connections for old db and new db. So it must be a Singleton one. So I have fixed that and all are working fine with Capacitor 4 and your new plugin version. Thanks a lot for your support.

Sampath-Lokuge changed the title ~~Error: isTableExists: No available connection for database~~ Error: isTableExists: No available connection for database: with Capacitor 4 and ver: 4.2.0 Nov 8, 2022

Sampath-Lokuge changed the title ~~Error: isTableExists: No available connection for database: with Capacitor 4 and ver: 4.2.0~~ Error: isTableExists: No available connection for database: with Capacitor 4 and SQLite ver: 4.2.2 Nov 15, 2022

Sampath-Lokuge closed this as completed Nov 19, 2022

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error: isTableExists: No available connection for database: with Capacitor 4 and SQLite ver: 4.2.2 #344

Error: isTableExists: No available connection for database: with Capacitor 4 and SQLite ver: 4.2.2 #344

Sampath-Lokuge commented Nov 7, 2022 •

edited

Loading

jepiqueau commented Nov 7, 2022

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading

jepiqueau commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading

Sampath-Lokuge commented Nov 8, 2022

jepiqueau commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading

Sampath-Lokuge commented Nov 9, 2022

Sampath-Lokuge commented Nov 9, 2022

Sampath-Lokuge commented Nov 14, 2022

jepiqueau commented Nov 14, 2022

Sampath-Lokuge commented Nov 14, 2022

Sampath-Lokuge commented Nov 15, 2022

Sampath-Lokuge commented Nov 17, 2022

jepiqueau commented Nov 17, 2022

Sampath-Lokuge commented Nov 17, 2022

jepiqueau commented Nov 19, 2022

Sampath-Lokuge commented Nov 19, 2022

Error: isTableExists: No available connection for database: with Capacitor 4 and SQLite ver: 4.2.2 #344

Error: isTableExists: No available connection for database: with Capacitor 4 and SQLite ver: 4.2.2 #344

Comments

Sampath-Lokuge commented Nov 7, 2022 • edited Loading

jepiqueau commented Nov 7, 2022

Sampath-Lokuge commented Nov 8, 2022 • edited Loading

jepiqueau commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022 • edited Loading

Sampath-Lokuge commented Nov 8, 2022 • edited Loading

Sampath-Lokuge commented Nov 8, 2022

jepiqueau commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022

Sampath-Lokuge commented Nov 8, 2022 • edited Loading

Sampath-Lokuge commented Nov 9, 2022

Sampath-Lokuge commented Nov 9, 2022

Sampath-Lokuge commented Nov 14, 2022

jepiqueau commented Nov 14, 2022

Sampath-Lokuge commented Nov 14, 2022

Sampath-Lokuge commented Nov 15, 2022

Sampath-Lokuge commented Nov 17, 2022

jepiqueau commented Nov 17, 2022

Sampath-Lokuge commented Nov 17, 2022

jepiqueau commented Nov 19, 2022

Sampath-Lokuge commented Nov 19, 2022

Sampath-Lokuge commented Nov 7, 2022 •

edited

Loading

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading

Sampath-Lokuge commented Nov 8, 2022 •

edited

Loading