Re: New to SimpleDBM, some problems

[Dibyendu Majumdar]

Hi,

Please could you describe the steps in a bit more detail? I can't tell from below what the issue might be. 

Regards

Dibyendu

On Thursday, 21 March 2013 10:16:40 UTC, Marije de Heus wrote:

Hello,

I'm a student in a database course, and my assignment for this course is to implement Read Uncommitted for SimpleDBM. My question is not about this function in particular, but about using/developing for SimpleDBM in general.

I started by downloading the folders (SimpleDBM-common, ..-database, ..-rss and ..-samples) and built everything with Maven (mvn eclipse:clean and mvn eclipse:eclipse for every folder). Then I tried to run both sample classes in Eclipse. Both caused a popup Selection does not contain a main type so I was unable to test these samples.

Alternatively, I also tried to use the client and server .jars and copied  the code from the User Manual, section Creating a SimpleDBM database. I could run this, but it returned the following error:

SIMPLEDBM-WL0001: Failed to initialize JDK 1.4 logging system due to following error:null

BufferManager Statistics:

bufmgr.fixCount [lastUpdated = Thu Jan 01 01:00:00 CET 1970] = 0

bufmgr.writerSleepInterval [lastUpdated = Thu Mar 21 11:13:31 CET 2013] = 60000

bufmgr.dirtyBuffers [lastUpdated = Thu Jan 01 01:00:00 CET 1970] = 0

bufmgr.cacheHits [lastUpdated = Thu Jan 01 01:00:00 CET 1970] = 0

bufmgr.bufferPoolSize [lastUpdated = Thu Mar 21 11:13:31 CET 2013] = 1500

bufmgr.hashTableSize [lastUpdated = Thu Mar 21 11:13:31 CET 2013] = 1543

I really hope someone can help me. Thanks in advance!

[Marije de Heus]

Hi Dibyendu,

Here are some details:

First case:

- All maven runs (common, database, rss and 2x samples, for each of these I ran "mvn eclipse:clean" and "mvn eclipse:eclipse") were successful 

- I followed http://simpledbm.googlecode.com/hg/simpledbm-docs/docs/html/overview.html#instructions-for-eclipse for the Eclipse instructions

- I verified that each project has a 'J' showing in Eclipse

- I tried to run SimpleDB-samples/btreedemo/src/main/java/org/simpledbm/samples/btreedemo/Main.java and SimpleDB-samples/tupledemo/src/main/java/org/simpledbm/samples/tupledemo/TupleDemo1.java, both gave me a popup 'Selection does not contain a main type'

Second case:

I wrote two classes, Main and SimpleTestCase. This is the code for Main:

public class Main {

public static void main(String[] args){

new SimpleTestCase();

}

}

This is the code for SimpleTestCase

public class SimpleTestCase {

Database db;

Properties properties;

public SimpleTestCase(){

properties = new Properties();

setProperties();

db = DatabaseFactory.getDatabase(properties);

db.start();

try {

insertDataInDatabase();

}

finally {

db.shutdown();

}

}

public void insertDataInDatabase(){

Transaction tra = db.startTransaction(IsolationMode.SERIALIZABLE);

//TODO add data

}

public void setProperties(){

properties.setProperty("log.ctl.1", "ctl.a");

properties.setProperty("log.ctl.2", "ctl.b");

properties.setProperty("log.groups.1.path", ".");

properties.setProperty("log.archive.path", ".");

properties.setProperty("log.group.files", "3");

properties.setProperty("log.file.size", "5242880");

properties.setProperty("log.buffer.size", "5242880");

properties.setProperty("log.buffer.limit", "4");

properties.setProperty("log.flush.interval", "30");

properties.setProperty("log.disableFlushRequests", "true");

properties.setProperty("storage.createMode", "rw");

properties.setProperty("storage.openMode", "rw");

properties.setProperty("storage.flushMode", "noforce");

properties.setProperty("bufferpool.numbuffers", "1500");

properties.setProperty("bufferpool.writerSleepInterval", "60000");

properties.setProperty("transaction.ckpt.interval", "60000");

properties.setProperty("logging.properties.type", "log4j");

properties.setProperty("logging.properties.file",

"classpath:simpledbm.logging.properties");

properties.setProperty("lock.deadlock.detection.interval", "3");

properties.setProperty("storage.basePath",

"demodata/DemoDB");

}

}

The exact console output was given in my first message.

If you still don't have enough information, please let me know what kind of information you need.

Regards,

Marije

[Dibyendu Majumdar]

Hi,

I will check this over the weekend and let you know.

Regards

--
You received this message because you are subscribed to the Google Groups "SimpleDBM User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to simpledbm+...@googlegroups.com.
To post to this group, send an email to simp...@googlegroups.com.
Visit this group at http://groups.google.com/group/simpledbm?hl=en-GB.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Dibyendu Majumdar]

Hi,

Looks like the pom.xml for the sample projects needs to be updated ...

I'll look at fixing this over the weekend.

I imported the main projects into Eclipse without any problems - I hope this was the case with you.

Regards

[Marije de Heus]

Hi,

Yes, I could also import the projects into Eclipse (and all now show a 'J'). Thanks for taking the time to look at it  :)

Rergards,

Marije

[Marije de Heus]

Hi,

I still did not succeed yet, and since my deadline for the course is approaching, I decided to use another database, so you don't need to look at this problem anymore. Thanks for helping out.

Regards,

Marije

[Dibyendu Majumdar]

Ok thanks for letting me know.