20 comments
Comment actions Permalink

Michal Maczka wrote:

Is Team City supporting postgresql or oracle? Or are there any plans for that?


Released versions do not, but TC 3.0 will support PostgreSQL and may be
some other databases.

--
Alexey Gopachenko
JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

0
Comment actions Permalink

Can we get some docs that explain how to set it up. I wasn't able to find any information.

Thanks
Bob

0
Comment actions Permalink

Well I took a stab at it. And so far I'm able to use Postgresql.

I followed same directions as found for mysql, but replaced the changes with specific to postgresql.

http://www.jetbrains.net/confluence/display/TCD3/Installation#Installation-settingupMySql

High Level Steps
1. Get JDBC driver for postgresql -> http://jdbc.postgresql.org/download.html
(I downloaded the 8.3dev-601 JDBC 4 jar file)
2.Update database.properties with database settings. I used jdbc:postgresql://host/database for connection string.
3. Start/restart teamcity

Other than the steps I listed just follow the mysql steps, pretty simple. I wonder if this will work out the box with other databases Oracle?.

So my question is what database specs are required to use Team City with a given database? What makes mysql and postgresql so special that it works with them?

Bob

0
Comment actions Permalink

Bob Henkel wrote:

Well I took a stab at it. And so far I'm able to use Postgresql.

I followed same directions as found for mysql, but replaced the changes with specific to postgresql.

http://www.jetbrains.net/confluence/display/TCD3/Installation#Installation-settingupMySql

High Level Steps
1. Get JDBC driver for postgresql -> http://jdbc.postgresql.org/download.html
(I downloaded the 8.3dev-601 JDBC 4 jar file)
2.Update database.properties with database settings. I used jdbc:postgresql://host/database for connection string.
3. Start/restart teamcity

Other than the steps I listed just follow the mysql steps, pretty simple. I wonder if this will work out the box with other databases Oracle?.

So my question is what database specs are required to use Team City with a given database? What makes mysql and postgresql so special that it works with them?

Bob


TC 3.0 includes changes made specifically to extend the database
support. Currently supported and tested databases are HSQL, MySQL 5+ and
PostgreSQL 8+. It is also verified that Oracle, Sybase and MSSQL is not
currently supported. There are plans to further extend our database
support but no deadlines were set yet.

--
Alexey Gopachenko
JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

0
Comment actions Permalink

Thanks Alexey. Nice that out of the gate you folks are supporting the free databasese that everyone has access to install and make use of.

0
Comment actions Permalink

It would be great to have MSSQL support. I think that most Windows development team would already have a copy of that installed and would prefer it over MySQL - we certainly would. Is there an existing feature request for this in JIRA or should I raise one?

0
Comment actions Permalink

Out of curiousity, what's the use case for changing out the db? Is it just "this db is mandated by corporate policy", or is there something more to it? Is anyone actually querying the db outside of TeamCity? Are there notable performance improvements to be had with dbs other than the standard ship db? I'm not trying to be difficult, it's just that I always figure one of the big benefits of shrink-wrapped applications is that I mostly don't need to care about how they manage their storage.

--Dave Griffith

0
Comment actions Permalink

Hi!

There is a request for Sybase support: http://www.jetbrains.net/jira/browse/TW-1141 and some comments related to MSSQL support, but you can file a separate issue on this.

--
Best regards,

Yegor Yarko
Quality Assurance Engineer
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0
Comment actions Permalink

Familiarity and set-up hassles. At the time I requested Sybase support I
was cursing HSQLDB but couldn't get motivated to set up the
infrastructure required to get the proper version of MySql up and running.

Now everything's installed I don't need it (and probably won't switch
over if it ever happens), but it would have been one less thing to worry
about at setup time.

R

0
Comment actions Permalink

In my case my comany uses Postgresql for other application (e.g. JIRA).
We have all the machinery in places for making backups of postgresql databases and it is just easy to add one more databases to that set up.

Other reason : I don't really trust MySQL :)

0
Comment actions Permalink

HsqlDB is not recommended for production environments, since it's not so
stable as you may expect.
I've faced database corruption, we've lost all of our builds configuration.
Let me say that was not funny.
And that's why we switched to Mysql (And certainly I don't regret my
decission)


"Dave Griffith" <dave.griffith@cnn.com> wrote in message
news:8027970.1194997251897.JavaMail.itn@is.intellij.net...

Out of curiousity, what's the use case for changing out the db? Is it
just "this db is mandated by corporate policy", or is there something more
to it? Is anyone actually querying the db outside of TeamCity? Are there
notable performance improvements to be had with dbs other than the
standard ship db? I'm not trying to be difficult, it's just that I always
figure one of the big benefits of shrink-wrapped applications is that I
mostly don't need to care about how they manage their storage.

>

--Dave Griffith


0
Comment actions Permalink

Gaston M wrote:

HsqlDB is not recommended for production environments, since it's not so
stable as you may expect.
I've faced database corruption, we've lost all of our builds
configuration. Let me say that was not funny.
And that's why we switched to Mysql (And certainly I don't regret my
decission)


Did you have backups? Or was the corruption such that backups couldn't
help you?

0
Comment actions Permalink

Chris Morris wrote:

Gaston M wrote:

>> HsqlDB is not recommended for production environments, since it's not
>> so stable as you may expect.
>> I've faced database corruption, we've lost all of our builds
>> configuration. Let me say that was not funny.
>> And that's why we switched to Mysql (And certainly I don't regret my
>> decission)


Did you have backups? Or was the corruption such that backups couldn't
help you?


The problem is that HsqlDB is not that good at coping with rapidly
growing database. The corruption looks just like it can boot the
database at some point and even back up will not actually help to handle
this. Although TC 3.0 database will be about ten times smaller compared
to same data in 2.x database I strongly suggest you to upgrade to one of
other supported databases.

--
Alexey Gopachenko
JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

0
Comment actions Permalink

Dave,

it's not that I want to change databases. It's just that the corporate standard for -all- databases is Oracle. Period. That's it. Everything is in place to manage data that resides in one of our databases. Support Levels 1, 2, 3 have their own procedures - teamcity would use one of these support levels. There are multiple primary dba's and a set of secondary dba's. They all know oracle and have known oracle since they were a glint in someone's eye.

I can be assured that the data will never be lost, easily returned if anything went wrong, easily secured, easily audited, and an easy approval of the purchase of team-city. Anything less, and I need to go through setting up all this for some new application.. Do I want to do that?

0
Comment actions Permalink

This pretty much describes the setup where I work too.

In fact, TeamCity was recently unilaterally removed from the list of approved software by our vendor management team (without consulting the technical product owners or users) specifically because v2.x would only support HSQLDB or MySQL, neither of which are approved for use at my company.

We've since managed to get this decision reversed, but the vendor management team are adamant that we should find a way to use Oracle for TeamCity's data storage, because Oracle is our corporate standard DB, as with Denis.

Earlier in the thread, it was stated that TeamCity explicitly will not work with Oracle. I'd like to understand why; as I see it, there are 3 things needed to make a DB work:

1. the DDL script to create the TeamCity DB
2. the DML emitted by TeamCity to update the DB
3. a suitable DB driver on TeamCity's classpath

assuming 1. can be modified to be Oracle-friendly if it contains MySQL-specific dialect, and that 3. is trivial, is it 2. that prevents use with Oracle currently?

Or have I missed something else?

0
Comment actions Permalink

In TC 2.1 build configurations don't appear to be stored in the database. Our HSQLDB instance got corrupted because we ran out of disk space, and after an enjoyable morning running around frantic that our build server had fallen over we finally recreated our database from scratch and had lost user config, entered licenses, and build histories. As best I can tell the build configs themselves are kept in data/config, which was unaffected by the bombing of HSQLDB.

John

Message was edited by:
John Tyler

0
Comment actions Permalink

Oracle support is already planned. Please watch
http://www.jetbrains.net/jira/browse/TW-4164

--
Alexey Gopachenko
JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

0
Comment actions Permalink

Excellent!

Added my vote.

0
Comment actions Permalink

Hi, is there any timeline for alternate TeamCity db support? Clearly alot of people are having issues with company mandated databases. i can use Oracle, MS SQL, DB2, and Sybase, yet none of that is supported.

at minimum, will some other db support be added for a future 3.x release? or will it be 4.x only?

Thanks!!

0
Comment actions Permalink

Trevor,

We will try to address Oracle support in the nearest future. There are chances that it will be included into TeamCity 3.1 (which is planned to be released in February). However, if the support will take more time then we estimate now, it will be delivered in one of post-3.1 releases, hopefully, one of 3.x.

--
Best regards,

Yegor Yarko
Project Manager
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0

Please sign in to leave a comment.