Skip to content

Simple mule 4 application demonstrating CRUD operations on SQLite file

Notifications You must be signed in to change notification settings

saiteja-madha/mule-sqlite

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Description

This project demonstrates how to establish a connection with an SQLite file (.db) in Mule 4 and perform various SQL operations

Configuring Global Element

  • Add the Database connector as usual, and add the Database config file
  • Change the connection type to Generic Connection
  • Generic Database Connector configuration information
    URL: jdbc:sqlite:[path to your database file] (Example: jdbc:sqlite:c:/database.db)
    Driver Class Name: org.sqlite.JDBC

For the sake of simplicity, you can directly add the path to your .db file in the common.properties file under resources folder

General Debugging

Symptom:

Getting a "java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database" on execution, but 'Test Connection' is fine.

Suggestion:

Check if you have a relative path.
Relative paths, they are in theory supported (and a quick google confirms as such) but where they are relative to is clearly different than other resources in the mule container.

About

Simple mule 4 application demonstrating CRUD operations on SQLite file

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published