Skip Navigation and Search to Content

Search ConcourseConnect Support - Discussion - Concursive Corporation

Main Content

  • Corporate

ConcourseConnect Support

Need MySql db scripts

Back to Topics

You need to be logged in to post messages.

Not Answered Icon this question is unanswered

Need MySql db scripts

2/19/2010 3:14 AM
Default user photo

By Manu G.

Hello i am new to concourse connect, due to some limitations i can only use MySql as database source, can any one plz guide me how to get db scripts (.sql) files for mysql?

RE: Need MySql db scripts

1. 2/19/2010 1:35 PM
Matt Rajkowski photo
By Matt R.
First, ConcourseConnect only works with PostgreSQL, which is a great reference platform as it has an agreeable license for redistribution, but I see your dilemma.

To get MySQL working, the PostgreSQL scripts would need to be modified for MySQL syntax. That's fairly straightforward and could be accomplished in a few days. Second, though, the application would need some adjustments to work with the MySQL syntax. I've done this before with other projects so I know it can take a week or two of development. After that, lots of QA.

Finally, MySQL would need to be supported in future development and that is why we've cut back on supporting other databases, like MySQL and MS SQL. In the end, it doesn't matter if MySQL is added to the development, but someone either needs to maintain it or pay for it to be maintained since we are quite pleased with PostgreSQL, although MySQL would be a good next candidate.

Does anyone want to sponsor the development and maintenance of MySQL compatibility?

Would you consider having Connect hosted in a PostgreSQL environment?

RE: Need MySql db scripts

2. 2/20/2010 2:04 AM
Default user photo
By Manu G.
Thanks Matt, for the time being i am trying my hands with connect on postgres, :)
Now I am facing another problem:
Installation was smooth and i am able to get to home page but after 2-3 clicks application fails due to following error:

Caused by: java.lang.OutOfMemoryError: PermGen space

Note: I am running the app through eclipse-IDE - WASCE, and following are my jvm settings:
C:\Utils\eclipse-jee-ganymede-win32\eclipse\eclipse.exe -vm "C:\Program Files\Java\jre1.5.0_22\bin" -vmargs -XX:MaxPermSize=512m

Please correct me if i am mistaking at some place

RE: Need MySql db scripts

3. 2/20/2010 11:33 AM
Matt Rajkowski photo
By Matt R.
I haven't used Eclipse and WASCE, but make sure that the memory settings are being set on WASCE and not just Eclipse, which might be the case. I think the default is 64m and you would get that error message if WASCE isn't being configured properly.

For IntelliJ + Tomcat I use:
-Xms256m -Xmx512m -XX:PermSize=64m -XX:MaxPermSize=256m -XX:+UseParNewGC

How to use the Discussion

  1. Select the forum topic or create a new one for your own business or group.
  2. Reply to a question or comment someone has posted.
  3. Press Save.

Who can respond to discussions?

  1. Anyone can respond to a forum topic.
  2. A manager can make a new forum.
  3. Everyone can read the discussion.

Why use the Discussion?

The Discussion area is a great place for networking, getting advice, sharing an opinion or answering questions. The site is populated with topics, called forums, that help visitors ask questions or make comments in an organized manner. Anyone can ask questions or share insights and views about your business or organization. Not only can you answer questions, but this area allows others to answer or comment. This area is the place where people are actively engaged with each other.