[Building Sakai] Using the SQLITE3 command line for Sakai

[Matthew Jones]

Yea, it's not an sqllite database, it's hsqldb. So you either need to use
the command line hsqldb application, an java db app like sql workbench (
http://www.sql-workbench.net/), squirrelsql, or a lot of closed source
ones that can use jdbc drivers or the swing app that they provide.

Here's some info about confluence, at quick glance it looks about the same.
https://confluence.atlassian.com/display/JIRA/Running+SQL+commands+in+a+HSQL+database

The default user is sa no password.

Ubuntu has the swing app in the *hsqldb-utils package that you can run as **
hsqldb-databasemanager.*


On Mon, May 20, 2013 at 2:41 PM, Charles Severance <csev at umich.edu> wrote:

> 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
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130520/b32220dd/attachment.html