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/