Solved (found alternative) SQLibary: Need some Help

Hey I have problems in my Plugin.
When I run it I get the following error:

Code:

13:12:54 [INFO] [lottery] Enabling lottery v0.1
13:12:54 [SCHWERWIEGEND] Error occurred while enabling lottery v0.1 (Is it up to date?)
java.lang.NullPointerException
    at me.darcade.lottery.SQLitehandler.init(SQLitehandler.java:21)
    at me.darcade.lottery.lottery.onEnable(lottery.java:34)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
    at org.bukkit.craftbukkit.v1_6_R2.CraftServer.loadPlugin(CraftServer.java:282)
    at org.bukkit.craftbukkit.v1_6_R2.CraftServer.enablePlugins(CraftServer.java:264)
    at net.minecraft.server.v1_6_R2.MinecraftServer.l(MinecraftServer.java:313)
    at net.minecraft.server.v1_6_R2.MinecraftServer.f(MinecraftServer.java:290)
    at net.minecraft.server.v1_6_R2.MinecraftServer.a(MinecraftServer.java:250)
    at net.minecraft.server.v1_6_R2.DedicatedServer.init(DedicatedServer.java:151)
    at net.minecraft.server.v1_6_R2.MinecraftServer.run(MinecraftServer.java:391)
    at net.minecraft.server.v1_6_R2.ThreadServerApplication.run(SourceFile:582)
13:12:54 [INFO] [SQLibrary] Enabling SQLibrary v4.2
13:12:54 [INFO] SQLibrary loaded.

Here is where I call the function:

Code:java

    @Override
    public void onEnable() {
        sqlitehandler.init(); //<--- Here it tells me is the error
 
        PluginDescriptionFile descFile = this.getDescription();
        this.createConfig();
 
        System.out.println("[PLUGINNAME] plugin enabled!");
        System.out.println("Plugin Version: " + descFile.getVersion());
    }

Here is the Class:

Code:java

package me.darcade.lottery;
 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Logger;
 
import org.bukkit.Bukkit;
import org.bukkit.plugin.java.JavaPlugin;
 
import lib.PatPeter.SQLibrary.SQLite;
 
public class SQLitehandler extends JavaPlugin {
 
    public SQLite sqlite;
    static final Logger log = Bukkit.getLogger();
 
    private ResultSet result;
 
    public void init() {
        sqlite = new SQLite(log, "lottery", this.getDataFolder()
                .getAbsolutePath(), "lotterydb", ".sqlite");
 
        if (!sqlite.isOpen()) {
            sqlite.open();
        }
        return;
    }
 
    public ResultSet doquery(String query) {
 
        try {
            result = sqlite.query(query);
        } catch (SQLException e1) {
            // TODO Auto-generated catch block
            e1.printStackTrace();
        }
 
        return result;
    }
}
 

 

xdarcade
Since you haven't given us the entire code making it impossible for us to help you I'm going to guess your problem.

Your sqlitehandler-reference is null since you haven't created a new Sqlitehandler-object.

 

Did you ever create sqlitehandler?

 

I created the object:

Code:java

package me.darcade.lottery;
 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Calendar;
import java.util.List;
import java.util.Random;
import java.util.logging.Logger;
 
import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.inventory.ItemStack;
import org.bukkit.plugin.PluginDescriptionFile;
import org.bukkit.plugin.java.JavaPlugin;
 
import lib.PatPeter.SQLibrary.SQLite;
import me.darcade.lottery.SQLitehandler;
 
public class lottery extends JavaPlugin {
 
    SQLitehandler sqlitehandler = new SQLitehandler(); //<-------- HERE  
    String rowcount;
 
    @Override
    public void onDisable() {
 
 
 
        sqlitehandler.sqlite.close();
        System.out.println("Lottery plugin disabled!");
 
    }
 
    @Override
    public void onEnable() {
 
        sqlitehandler.init();
        sqlitehandler
                .doquery("CREATE TABLE IF NOT EXISTS lotterytable (username TEXT , lastlottery NUMERIC, PRIMARY KEY(username));");
 
        PluginDescriptionFile descFile = this.getDescription();
        this.createConfig();
 
        System.out.println("[Lottery] plugin enabled!");
        System.out.println("Plugin Version: " + descFile.getVersion());
    }

EDIT:


SOLVED I just used the sqlite api from java by using this tutorial
http://www.tutorialspoint.com/sqlite/sqlite_java.htm

EDIT by Moderator: merged posts, please use the edit button instead of double posting.