651 
652             // select query
653             sql = Cstring.toCString("SELECT * FROM EMPLOYEE", scope);
654             rc = sqlite3_exec(dbPtr, sql, callback.baseAddress(), NULL, errMsgPtrPtr);
655 
656             if (rc != 0) {
657                 System.err.println("sqlite3_exec failed: " + rc);
658                 System.err.println("SQL error: " + Cstring.toJavaString(Cpointer.get(errMsgPtrPtr)));
659                 sqlite3_free(Cpointer.get(errMsgPtrPtr));
660             } else {
661                 System.out.println("done");
662             }
663 
664             sqlite3_close(dbPtr);
665         }
666     }
667 }
668 
669 ```
670 
671 ### Compiling and running the libgit2 sample
672 
673 ```sh
674 
675 java -Dforeign.restricted=permit \
676    --add-modules jdk.incubator.foreign \
677    -Djava.library.path=/usr/lib SqliteMain.java
678 
679 ```

651 
652             // select query
653             sql = Cstring.toCString("SELECT * FROM EMPLOYEE", scope);
654             rc = sqlite3_exec(dbPtr, sql, callback.baseAddress(), NULL, errMsgPtrPtr);
655 
656             if (rc != 0) {
657                 System.err.println("sqlite3_exec failed: " + rc);
658                 System.err.println("SQL error: " + Cstring.toJavaString(Cpointer.get(errMsgPtrPtr)));
659                 sqlite3_free(Cpointer.get(errMsgPtrPtr));
660             } else {
661                 System.out.println("done");
662             }
663 
664             sqlite3_close(dbPtr);
665         }
666     }
667 }
668 
669 ```
670 
671 ### Compiling and running the sqlite3 sample
672 
673 ```sh
674 
675 java -Dforeign.restricted=permit \
676    --add-modules jdk.incubator.foreign \
677    -Djava.library.path=/usr/lib SqliteMain.java
678 
679 ```