[opencms-dev] SQL Server and CONCAT Error

[Georgi Naplatanov]

Hello, Richard.

To use JPA driver with Microsoft SQL Server with sql script schema
generation, just change in the
webapps/opencms/setup/database/mssql/create_db.sql collation to

SQL_Latin1_General_CP1_CI_AS,

to be SQL identifiers case insensitive.

On the other hand, the wrong query for SQL driver is fixed in the cvs,
just look at
http://cvs.opencms.org/viewvc.cgi/opencms/src/org/opencms/db/mssql/query.properties?revision=1.5&view=markup&pathrev=HEAD

Best regards
Georgi


Georgi Naplatanov wrote:
>> Georgi I tried installing the version you recommended and I still have the
>> same problem.
> 
> Which driver have You used - JPA driver or Traditional(SQL) ?
> 
> 
> opencms . wrote:
>> Hi
>>
>> I apologise now if this is in the wrong spot but it's the first time I've
>> used a mailing list thing.
>>
>> Georgi I tried installing the version you recommended and I still have the
>> same problem.
>>
>> java.sql.SQLException: 'CONCAT' is not a recognized built-in function name
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev