Hi, Looks like it is MsSql driver issue:
Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'URL' of bean class [com.microsoft.sqlserver.jdbc.SQLServerDriver]: Seemd, URL is generated by driver itself automatically. Try to use other properties. On Sat, Jun 9, 2018 at 12:13 PM, Michaelikus <[email protected]> wrote: > Hi everybody! > > I'm try to config mssql as 3d party persistence for ignite 2.5 > > downloaded mssql jdbc(sqljdbc42.jar) and placed in $IGNITE_HOME/libs > > > <bean id="MSSQL" class="com.microsoft.sqlserver.jdbc.SQLServerDriver"> > <property name="URL" > value="jdbc:sqlserver://sql01:1433;databasename=ingnite- > test1;integratedSecurity=true;user=test1;password=123321"/> > </bean> > > this is located before main ignite bean config. > > > So when i start ignite i get this error: > > class org.apache.ignite.IgniteException: Failed to instantiate Spring XML > application context [springUrl=file:/etc/apache-ignite/cache_mssql.xml, > err=Error creating bean with name 'MSSQL' defined in URL > [file:/etc/apache-ignite/cache_mssql.xml]: Error setting property values; > nested exception is org.springframework.beans. > NotWritablePropertyException: > Invalid property 'URL' of bean class > [com.microsoft.sqlserver.jdbc.SQLServerDriver]: Bean property 'URL' is not > writable or has an invalid setter method. Does the parameter type of the > setter match the return type of the getter?] > at > org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils. > java:990) > at org.apache.ignite.Ignition.start(Ignition.java:355) > at > org.apache.ignite.startup.cmdline.CommandLineStartup. > main(CommandLineStartup.java:301) > Caused by: class org.apache.ignite.IgniteCheckedException: Failed to > instantiate Spring XML application context > [springUrl=file:/etc/apache-ignite/cache_mssql.xml, err=Error creating > bean > with name 'MSSQL' defined in URL [file:/etc/apache-ignite/ > cache_mssql.xml]: > Error setting property values; nested exception is > org.springframework.beans.NotWritablePropertyException: Invalid property > 'URL' of bean class [com.microsoft.sqlserver.jdbc.SQLServerDriver]: Bean > property 'URL' is not writable or has an invalid setter method. Does the > parameter type of the setter match the return type of the getter?] > at > org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl. > applicationContext(IgniteSpringHelperImpl.java:392) > at > org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl. > loadConfigurations(IgniteSpringHelperImpl.java:104) > at > org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl. > loadConfigurations(IgniteSpringHelperImpl.java:98) > at > org.apache.ignite.internal.IgnitionEx.loadConfigurations( > IgnitionEx.java:744) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:945) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:854) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:724) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:693) > at org.apache.ignite.Ignition.start(Ignition.java:352) > ... 1 more > > > Can somebody help me to configure it or give a link on document ? :) > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > -- Best regards, Andrey V. Mashenkov
