problem with SQLite

I am a beginning developer but I can't create a SQLite db in the plugins folder with this code. I tried many things but no result.

This is my code:

Code:java

package me.Geert305.Plugin;
 
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Logger;
 
import lib.PatPeter.SQLibrary.SQLite;
 
import org.bukkit.Bukkit;
import org.bukkit.craftbukkit.libs.jline.internal.Log;
import org.bukkit.plugin.Plugin;
import org.bukkit.plugin.PluginBase;
import org.bukkit.plugin.PluginLogger;
import org.bukkit.plugin.PluginManager;
import org.bukkit.plugin.java.JavaPlugin;
 
 
 
 
public class Mai extends JavaPlugin {
 
        @Override
        public void onEnable(){
            PluginManager manager = this.getServer().getPluginManager();
 
            Connection c = null;
            try {
              Class.forName("org.sqlite.JDBC");
 
              c = DriverManager.getConnection("jdbc:sqlite:" + getServer().getPluginManager().getPlugin("DeDiamond").getDataFolder().toPath().toString() + "/data.db");
              Statement stmt = c.createStatement();
              stmt.executeUpdate("CREATE TABLE IF NOT EXISTS `homes` (`home_naam` varchar(20) NOT NULL,`speler` varchar(20) NOT NULL,`wereld` varchar(20) NOT NULL, `locatiex` int(11) NOT NULL,`locatiey` int(11) NOT NULL,`locatiez` int(11) NOT NULL,KEY `home_naam` (`home_naam`,`speler`))");
            } catch ( Exception e ) {
                System.out.println(e);
            }
 
 
 
            manager.registerEvents(new TNTlistener(), this);
 
            this.getCommand("diajoin").setExecutor(new PlayerComm());
            //this.getCommand("maakhome").setExecutor(new NieuwHome());
            //this.getCommand("gahome").setExecutor(new GaHome());
        }
        public void onDisable() {
 
        }
 
 
}

 

geert305
Can you post your error code? I'm sure SQLite generates a SQLException if something goes wrong.

 

You probably might have to create the database file yourself before you can use it with sqlite.

 

Why are you importing SQLibrary and then using JDBC?