Topic - HOWTO access sqlite database from within netkernel
Topic - HOWTO access sqlite database from within netkernel Topic - HOWTO access sqlite database from within netkernel
from forum How To
 forum index   my profile   search 
 new topic  post reply 
moderators: pjr tab RandyKahle
HOWTO access sqlite database from within netkernel
Joined: 22-April-2007
Posts: 79
Location: Belgium
Posted: 4-November-2007 10:57
Netkernel comes with HSQLDB as its onboard small database.
There are however several other posibilities for small "no fuss" databases.
My personal favorite one is sqlite.

In order to get sqlite working from within Netkernel you first need the
SQLite JDBC driver. You can find it on http://www.zentus.com/sqlitejdbc/
I've found tested the "Pure Java" one. Drop the jar
(sqlitejdbc-v037-nested at this moment) into the lib directory of your
application (for example in modules\workbench\lib if you want it available
in all the workbench applications.

Reboot Netkernel.

What remains is your configRDBMS.xml which looks like this :
<config>
  <rdbms>
    <jdbcDriver>org.sqlite.JDBC</jdbcDriver>
    <jdbcConnection>jdbc:sqlite:/db/test.db</jdbcConnection>
  </rdbms>
</config>

Didnt I say "no fuss" ? Sqlite has no concept of users or all of that :-). But
it does comply with the SQL standards.

Enjoy.
Gynwer
 new topic  post reply  To find out about new replies to this post as they occur
please subscribe to one of these feeds:
AtomRSS moderate 
© 2003-2006, 1060 Research Limited. 1060 registered trademark, NetKernel trademark of 1060 Research Limited.