web stats
table name KEYS conflicts with mysql keyword - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2006, 06:59 AM
ercynth ercynth is offline
What's HL7?
 
Join Date: Oct 2006
Posts: 3
ercynth
Default table name KEYS conflicts with mysql keyword

Hi,

I was trying to setup mirth with mysql starting with the data definitions. mysql 5.0 did not like the table name KEYS, and so i added the database qualifier mirth.KEYS to create the table. i am getting an exception though in ConfigurationController class (i should have seen this coming) everytime table KEYS is selected because the code does not contain the qualifier. other than modifying the code, is there an easier way to resolve this conflict, say a switch in mysql?

thanks a bunch!

Erwin Pader
Health Management Associates, Inc.
Naples, FL
Reply With Quote
  #2  
Old 10-20-2006, 01:35 PM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default Re: table name KEYS conflicts with mysql keyword

Are you looking at replacing the internal Mirth Hypersonic DB with MySQL?
__________________
Chris Lang
Reply With Quote
  #3  
Old 10-20-2006, 08:49 PM
ercynth ercynth is offline
What's HL7?
 
Join Date: Oct 2006
Posts: 3
ercynth
Default Re: table name KEYS conflicts with mysql keyword

Chris,

yes i am. btw, i had to comment out the closing of the db connection in Connection class for resultset to work. it blew up on me (resultset closed exception) when it was attempting to read the encrypted key. sounds like hypersonic's driver does not care if conn is closed before a getting the resultset.

a few more things:

LONGVAR does not work with MySQL so i used varchar.
DDL for generated sequence id syntax is different in MySQL
one of the tables had a varchar key length of 4000 which MySQL did not like. had to trim it down to 1000



Reply With Quote
  #4  
Old 10-23-2006, 10:39 PM
mnowlin mnowlin is offline
OBX.3 Kenobi
 
Join Date: Sep 2006
Posts: 142
mnowlin is an unknown quantity at this point
Default Re: table name KEYS conflicts with mysql keyword

On a related note, I'm looking at replacing HSQLDB with PostgreSQL for several reasons. Haven't tried anything yet, but am interested... Any suggested reading material?

mike
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SFTP with keys dbanach Support 0 09-22-2008 11:59 AM
Huge message table trymirth Support 7 06-05-2008 01:21 AM
detect increase in table size ktaveirn Support 3 06-14-2007 06:10 AM
How can I insert a date with Mirth to an Informix DB table? alvarodb Support 4 10-11-2006 08:15 AM
How can I insert a null value with Mirth to an Informix DB table? alvarodb Support 1 10-11-2006 08:11 AM


All times are GMT -8. The time now is 04:19 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation