我正在尝试配置Guidewire连接到SQL Server数据库。
我得到以下错误:
guidewire-docker 2021-03-04 14:53:14,957 INFO Configuration SecurityManager finished parsing C:Tomcat9webappspcmodulesconfigurationconfigsecuritysecurity-config.xml
guidewire-docker 2021-03-04 14:53:15,004 INFO Configuration Finished security config.
guidewire-docker 2021-03-04 14:53:15,004 INFO Configuration Parsing C:Tomcat9webappspcmodulesconfigurationconfigconfig.xml for registry. No substitution is supported at that level.
guidewire-docker 2021-03-04 14:53:15,035 INFO Server.RunLevel Starting database PolicyCenterDatabase on env null
guidewire-docker 2021-03-04 14:53:15,145 INFO Server.Database Creating DBCP connection pool.
guidewire-docker 2021-03-04 14:53:15,223 INFO Server.Database JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver, major version: 9, minor version: 2
04-Mar-2021 14:53:15.332 INFO [main] com.google.cloud.sql.core.CoreSocketFactory.connect Connecting to Cloud SQL instance [gft-bike-insurance:europe-west2:guidewire] via SSL socket.
04-Mar-2021 14:53:15.348 INFO [main] com.google.cloud.sql.core.CoreSocketFactory.getInstance First Cloud SQL connection, generating RSA key pair.
04-Mar-2021 14:53:17.120 INFO [main] com.google.cloud.sql.core.CoreSocketFactory.connect Connecting to Cloud SQL instance [gft-bike-insurance:europe-west2:guidewire] via SSL socket.
guidewire-docker 2021-03-04 14:53:17,245 INFO Server.Database Time taken to verify database is up: 149 ms
guidewire-docker 2021-03-04 14:53:17,341 INFO Server.Database Validating main database connections have all required properties
guidewire-docker 2021-03-04 14:53:17,341 INFO Server.Database This database version is SUPPORTED. Supported database versions are (14.00.3008). Actual database version is (14.00.3257).
guidewire-docker 2021-03-04 14:53:17,341 ERROR Server.Database Unsupported database version found: (Microsoft JDBC Driver 9.2 for SQL Server). Supported versions are (9.2.0.0).
guidewire-docker 2021-03-04 14:53:17,356 ERROR Server.RunLevel An exception was thrown while starting a component. Setting runlevel to SHUTDOWN [Unable to validate database or JDBC driver version]
guidewire-docker 2021-03-04 14:53:18,597 INFO Application.Rating.RateTableManagement Creating RTM row cache
guidewire-docker 2021-03-04 14:53:18,613 INFO Application.Rating.RateTableManagement Cache timeout (in nanoseconds): 129600000000000
guidewire-docker 2021-03-04 14:53:18,644 INFO Server.RunLevel Decreased runlevel to 'SHUTDOWN'
guidewire-docker 2021-03-04 14:53:18,644 ERROR Server.RunLevel ***** PolicyCenter unable to start *****
Caused by: gw.pl.exception.GWLifecycleException: Unable to validate database or JDBC driver version
at com.guidewire.pl.system.database.StandardDatabase.verifyDatabaseAndConnections(StandardDatabase.java:602) ~[pl-10.13.6.jar:?]
at com.guidewire.pl.system.database.StandardDatabase.start(StandardDatabase.java:437) ~[pl-10.13.6.jar:?]
at com.guidewire.pl.system.server.InitTab.startDependency(InitTab.java:465) - (com.guidewire.pl.system.database.StandardDatabase@1aef7b9e) ~[pl-10.13.6.jar:?]
at com.guidewire.pl.system.server.InitTab.enterNoDaemons(InitTab.java:814) ~[pl-10.13.6.jar:?]
at com.guidewire.pl.system.server.InitTab.increaseRunLevelTo(InitTab.java:650) ~[pl-10.13.6.jar:?]
Database-config.xml文件:
<database
name="PolicyCenterDatabase"
dbtype="sqlserver">
<dbcp-connection-pool
jdbc-url="jdbc:sqlserver://IP_ADDRESS:1433;DatabaseName=SampleDB;socketFactoryClass=com.google.cloud.sql.sqlserver.SocketFactory;socketFactoryConstructorArg=gft-bike-insurance:europe-west2:guidewire;User=sqlserver;Password=Guidewire@CambridgeLab2021"/>
<upgrade
defer-create-nonessential-indexes="false">
<versiontriggers
dbmsperfinfothreshold="600"/>
</upgrade>
<databasestatistics>
<tablestatistics
name="pc_jobuserroleassign">
<histogramstatistics
name="CreateTime"
numbuckets="75"/>
</tablestatistics>
</databasestatistics>
</database>
有人能提供一些帮助和建议吗?
MS SQL server的次要版本应该与指定的发布版本完全匹配，如果您不以开发模式启动服务器。要以dev模式启动服务器，请使用以下VM参数:
-Dgw.server.mode = dev
这将跳过SQL server版本验证。