Gandhi, Thank you for the reply. Do you have any documentation on how to accomplish this?
Thanks, Matthew Vita www.matthewvita.com On Sun, Oct 8, 2017 at 3:14 AM, Gandhi Rajan Natarajan < gandhi.natara...@arisglobal.com> wrote: > Hi Mathew, > > I feel using MySQL Db would be better idea than using in-memory HSQLDB. In > fact, this also comes handy when you are planning to deploy ctakes as a web > application as in our case. > > Regards, > Gandhi > > -----Original Message----- > From: Matthew Vita [mailto:matthewvit...@gmail.com] > Sent: Sunday, October 08, 2017 6:02 AM > To: dev@ctakes.apache.org > Subject: HSQLDB out of memory with custom dictionary > > Hi Sean, Tim, cTAKES Community, > > I have put together what I am considering a pretty standard dictionary > with sources from the following: > > > - > > MEDLINEPLUS > - > > MSH > - > > NCI > - > > NDFRT > - > > CHV > - > > CSP > - > > ICPC2P > - > > MEDCIN > - > > SNOMED > - > > RXNORM > - > > ICD10 > > > However, when copied over to cTAKES (handled by the handy Dictionary > Creator GUI) HSQLDB runs out of memory. > > This is my first experience with HSQLDB so you’ll have to excuse my > limited knowledge here. I do understand that it can run either in-memory > and on disk, but I’m not sure how to configure this. > > Here is how I am connecting to it: > > > <dictionary> > > > <name>sno_rx_16abTerms</name> > > <implementationName > >org.apache.ctakes.dictionary.lookup2.dictionary.UmlsJdbcRareWordDiction > >ary</ > implementationName> > > <properties> > > <property key="jdbcDriver" value="org.hsqldb.jdbcDriver" /> > > <property key="jdbcUrl" value= > "jdbc:hsqldb:file:resources/org/apache/ctakes/dictionary/ > lookup/fast/sno_rx_16ab/sno_rx_16ab" > /> > > <property key="jdbcUser" value="sa" /> > > <property key="jdbcPass" value="" /> > > <property key="rareWordTable" value="cui_terms" /> > > <property key="umlsUrl" value=" > https://uts-ws.nlm.nih.gov/restful/isValidUMLSUser" /> > > <property key="umlsVendor" value="NLM-6515182895" /> > > <property key="umlsUser" value="CHANGE_ME" /> > > <property key="umlsPass" value="CHANGE_ME" /> > > </properties> > > </dictionary> > > <dictionary> > > > > Can I configure HSQLDB to be used on disk? If this is not a good approach, > can I spin up MySQL in its place? > > > Sorry if this has asked before. > > > Thanks, > > Matthew Vita > www.matthewvita.com > This email and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. > If you are not the named addressee you should not disseminate, distribute > or copy this e-mail. Please notify the sender or system manager by email > immediately if you have received this e-mail by mistake and delete this > e-mail from your system. If you are not the intended recipient you are > notified that disclosing, copying, distributing or taking any action in > reliance on the contents of this information is strictly prohibited and > against the law. >