[Building Sakai] Using the SQLITE3 command line for Sakai

[Charles Severance]

Wow - of course - it is HSQL - Doh.  And I even had two cups of coffee this morning.  :)

Thanks.

/Chuck

On May 20, 2013, at 2:58 PM, Matthew Jones wrote:

> 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/09954530/attachment.html