ERROR (java.sql.SQLException)

Asked Feb 14 '18 at 12:19

Active Feb 14 '18 at 12:19

Viewed 260 times

i am tryin to use sqlite-jdbc in android but give me error when trying to connect to database. below my code .

   Class .forName("org.sqlite.JDBC").newInstance();
        c = DriverManager.getConnection("jdbc:sqlite:category1.db");
    } catch ( Exception e ) {
        System.err.println( e.getClass().getName() + ": " + e.getMessage() );

    }
    Log.w(TAG,"#######{}{}{}{}{*Opened database successfully");
    System.out.println("Opened database successfully");

this the error when run app.

W/System.err: java.sql.SQLException: opening db: 'category1.db': open failed: EROFS (Read-only file system)

asked Feb 14 '18 at 12:19

mohammedragabmohammedborik

Where is `category1.db` located on your device? – Michael Dodd Feb 14 '18 at 12:21
@MichaelDodd i am not specified it it will create automatic when not found – mohammedragabmohammedborik Feb 14 '18 at 12:22
If the database not created within your app's sandbox using `getFilesDir()` or similar storage-related methods, then your app will not have write access. – Michael Dodd Feb 14 '18 at 12:25
@MichaelDodd can you give me more details or example how to do it i am not have experience – mohammedragabmohammedborik Feb 14 '18 at 12:28
It depends. Can you post the bit of code where you're defining where `category1.db` is created? – Michael Dodd Feb 14 '18 at 12:35
@MichaelDodd i only test connection i need to create category1.db in my mobile app till now i not wirte acode – mohammedragabmohammedborik Feb 14 '18 at 12:38

ERROR (java.sql.SQLException)

0 Answers0