Valid datatypes for <database data-type="...">

What data-types are available to the <database> tag? The manual says the type can be "any valid JDBC database type"--does this mean any type understood by the underlying JDBC driver? (Or does Teamsite do some type mapping? That is, is it possible to change databases without changing the data-type?)

Michael

Find more posts tagged with

Comments

Adam Stoller

I believe they have to be datatypes that the receiving DB understands. Like if you start off with a DB that uses "DATE" and then switch to a DB that only understands "DATETIME" - you'd probably have to change the entry in the config. I'm not 100% sure of this - but I think that's the case. So as long as the two DB's understand the same datatype you won't have to make changes.

Someone else will probably confirm or correct me though....

--fish
(Interwoven Senior Technical Consultant)

Migrateduser

Depends on the database you are changing to because not all vendors have the exact datatypes for example MS SQL Server has DATETIME instead of DATE , TEXT instead of CLOB etc...
One alternative is to create a synonym for these types for the specif database so that the existing config files can work