[Building Sakai] Using the SQLITE3 command line for Sakai

Charles Severance csev at umich.edu
Mon May 20 11:41:38 PDT 2013


Hi all,

I am trying to use the sqlite3 command like with Sakai - I have the default property like this:

url at javax.sql.BaseDataSource=jdbc:hsqldb:file:${sakai.home}db/sakai.db

I do this:

sqlite3 db/sakai.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /root/sakai-full/apache-tomcat-7.0.21/sakai/db/sakai.db   
sqlite> .tables
sqlite> 

What am I missing - is there something like "use" in MySql that I am missing?

Thanks in advance (and yes - I should be using MySql)..

/Chuck




More information about the sakai-dev mailing list