Sunday, July 13, 2008

Java db McKoi install and usage

1. download McKoi from http://mckoi.com/database/.
2. unzip McKoi
3. cd unzip McKoi folder and modify db.conf file
4. run command under terminal:
$> java -jar mckoidb.jar -create dbuser secret
$> java -jar mckoidb.jar
$> java -classpath mckoidb.jar com.mckoi.tools.JDBCQueryTool -u dbuser -p secret
5. in prompt JDBCQueryTool, test below sql:
CREATE TABLE Greetings (Message CHAR(20))
INSERT INTO Greetings VALUES ('Hello, World!')
SELECT * FROM Greetings

No comments :