Re: [SignServer-develop] Signserver support for MSSQL

[Markus K. <ma...@pr...>]

On 11/05/2015 02:28 PM, Martin Rublik wrote:
> Dear all,
> 
> Recently I tried to run signserver with MSSQL database backend. I had some
> issues but I believe I managed to solve them. As far as I understand current
> version of signserver is missing java hibernate support for MSSQL (especially
> cesecore-orm-mssql.xml in
> signserver/modules/SignServer-Entities/src/main/resources/META-INF) thus it is
> unable to deploy correctly (on JBoss) even though it compiles.
> 
> I prepared the orm files based on information from mysql, I can also provide
> information on MSSQL JDBC installation a integration with JBoss.
> 
> Would anyone be interested?
> 
> Kind regards
> 
> Martin Rublik
Hi Martin,

That is interesting information.

We haven't seen that much interest for MSSQL though, but if you have
something that is working we are open for contributions in that area as
well. We could for sure add the orm files and maybe some instructions
either as a separate howto document or in to the installation guide if
you provide this.

We will probably not, at least at this point, have the resources to set
up a proper automated test job for MSSQL, but we could mark the
instructions to be "community maintained" or similar and when we make
database changes we would make a best effort try to also update the orm
files for MSSQL.

How does that sound?


Best regards,
Markus
PrimeKey Solutions

PrimeKey Solutions offers a commercial EJBCA & SignServer support
subscription and training. Please see www.primekey.se or contact
in...@pr... for more information.
https://www.primekey.se/Services/Support/
https://www.primekey.se/Services/Training/