[INACTIVE] SQLite and MySQL Tutorial/Library

This is my onEnable:

Code:

public void onEnable() {
        if (!Settings.exists()) {
            makeSettings(Settings);
        }
        PluginManager pm = getServer().getPluginManager();
        pm.registerEvent(Event.Type.BLOCK_BREAK, blockListener, Priority.Normal, this);
        pm.registerEvent(Event.Type.BLOCK_PLACE, blockListener, Priority.Normal, this);
        pm.registerEvent(Event.Type.PLAYER_JOIN, playerListener, Priority.Normal, this);
        pm.registerEvent(Event.Type.ENTITY_DAMAGE, entityListener, Priority.Normal, this);
        loadSettings();
        if(useSql.equalsIgnoreCase("true")){
            dbManager = new sqlCore(this.log, this.logPrefix, "skillz", "plugins/Skillz");
            dbManager.initialize();
            if (!dbManager.checkTable("skillz")) {
                String query = "CREATE  TABLE skillz (  'id' INTEGER PRIMARY KEY,  'player' VARCHAR(80) NOT NULL ,  " +
                        "'skill' TEXT NOT NULL ,  'xp' TEXT NOT NULL ,  'level' TEXT NOT NULL);";
                dbManager.createTable(query);
            }
        }
        
        new File(maindir).mkdir();
        new File(maindir+"users/").mkdir();
        new File(maindir+"Skillz/").mkdir();
        File dir = new File(maindir+ "Skillz/");
        File filename[] = dir.listFiles();        
        for (File f : filename){
            String fn = f.getName();
            log.info("Loaded file " + fn);
        }
        
        
        log.info("Skillz Enabled!");
    }

And this is the error:

Code:

146 recipes
16 achievements
07:40:29 [INFO] Starting minecraft server version Beta 1.5_02
07:40:29 [INFO] Loading properties
07:40:29 [INFO] Starting Minecraft server on *:25564
07:40:29 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
07:40:29 [WARNING] The server will make no attempt to authenticate usernames. Beware.
07:40:29 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect w
ith any username they choose.
07:40:29 [WARNING] To change this, set "online-mode" to "true" in the server.settings file.
07:40:29 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-753-g34e310c-b803jnks (MC: 1.5_02)
07:40:29 [INFO] Preparing level "world"
07:40:29 [INFO] Preparing start region
07:40:30 [INFO] Loaded Essentials build 2.2.5 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
07:40:30 [INFO] GroupManager - INFO - Scheduled Data Saving is set for every 10 minutes!
07:40:30 [INFO] GroupManager version 1.0(alpha-5) is enabled!
07:40:30 [INFO] Fake Permissions version 2.5.1 is enabled!
07:40:30 [INFO] [FastObby] v2.0 enabled!
07:40:30 [INFO] [iConomy] Logging is currently disabled.
07:40:31 [INFO] [iConomy] v5.0 (Eruanna) loaded.
07:40:31 [INFO] [iConomy] Developed by: [Nijikokun]
07:40:31 [INFO] [iConomy] hooked into Permissions.
07:40:31 [INFO] [Repair] enabled!
07:40:31 [SEVERE] [Skillz] SQLite exception on initialize java.sql.SQLException: [SQLITE_CANTOPEN]  Unable to open the database file (out of
 memory)
07:40:31 [SEVERE] [Skillz] SQLite exception on initialize java.sql.SQLException: [SQLITE_CANTOPEN]  Unable to open the database file (out of
 memory)
07:40:31 [SEVERE] Error occurred while enabling Skillz v1.62 (Is it up to date?): null
java.lang.NullPointerException
        at nl.lolmen.sqllitelib.DatabaseHandler.checkTable(DatabaseHandler.java:144)
        at nl.lolmen.sqllitelib.sqlCore.checkTable(sqlCore.java:82)
        at nl.lolmen.Skillz.Skillz.onEnable(Skillz.java:71)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:125)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:750)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:253)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:132)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:110)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:265)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
07:40:31 [INFO] [Sortal] version 3.4 is enabled!
07:40:31 [INFO] Done (0.138s)! For help, type "help" or "?"

Very odd indeed, send me the source in a zip so that I can test it

Will do when I get home

@alta189 here it is: http://dl.dropbox.com/u/7365249/src.zip

@alta189 anything yet?

I just got home Will look at it soon.

Yaay

@alta189 thx for this ill be using it a lot. I didn't know how to bring the project in it so i just turned into a .jar on a link anyone can download through java for a easy install of plugin .
http://dl.dropbox.com/u/18853223/SQL Lite lib.jar

lol, bringing it in was in the second video

Hey Alta, it's finished
What'd you think?

@alta189 Im testing if it works at school now
EDIT: Nope, same error here.

Ok, did a little testing, I am getting the same error. I am going to see what I can do to find it

Anything found? I needz it so I can realease part 2 of Skillz =D

It's called SQLite, not SQL Lite. Making a tutorial is great, but it really helps to get the name right

Calm down dude

Absolutely Amazing

I feel like using that for my banner as well now I like it so much, I'd change the name obviously

lol

I would suggest to wait till I upload the new version, which should be soon. Sorry I had alot of work to get done today, I am releasing the new Library soon, but alot has changed, sort of. Workin on a tutorial now to go with it

I don't think that it should be in a jar... You need to included it. look at the second video or wait until the new tutorial is out.

How can you store block information in the files? Does x,y,z sound legit? It seems kinda iffy to me

@Jayjay110 X in one row, Y in one row, Z in one row. Make it Integers.

is that the safest way to do it? Isnt there a better way

You can also saved it all with a comma between in a text field, thatonly takes up one space

EDIT:
Nvm I figured I save the block data, then get it on loading the plugin

Sure you have to say each piece of data in a column. Also @Lolmewn the new version is going to come out today with MySQL support. Also it should fix a lot of errors, but before I release it I want finish the tutorial

pre-release for me? I need it to finish my stuffz

WOOOT

Will be out in about 5 hours.

WOOOT WOOOT