[Building Sakai] Using the SQLITE3 command line for Sakai

[Noah Botimer]

I've had surprisingly good results with the built-in GUI in the jar my simplest case needs. Just have to find it in one of the hundred places on your dev machine and get the paths right.

http://stackoverflow.com/questions/4990864/best-sql-browser-for-hsqldb

Thanks,
-Noah

On May 20, 2013, at 3:39 PM, Charles Severance wrote:

> 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"
>> 
> 
> _______________________________________________
> 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/20130521/0695bf4c/attachment.html