can you run ./bin/tomee.sh setters -c com.microsoft.sqlserver.jdbc. SQLServerXADataSource
Don't think there is a "Url" config on that class Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://blog-rmannibucau.rhcloud.com> | Old Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory <https://javaeefactory-rmannibucau.rhcloud.com> 2017-03-29 11:11 GMT+02:00 Dignesh <[email protected]>: > Hi, > I am using TomEE 7.0.2 > > I am configuring the XAdatasources in TomEE. I was able to do it > successfully in Oracle and PostgreSQL. I am facing some issues with it in > Sqlserver. > > Below is my resource configuration in tomee.xml file. > > <Resource id="jdbc/dignesh" type="DataSource"> > XaDataSource Xa/ds > UserName **** > Password **** > PasswordCipher **** > </Resource> > > For postgres :- > > <Resource id="Xa/ds" class-name="org.postgresql.xa.PGXADataSource"> > Url ***** > DataSourceCreator = dbcp > </Resource> > > For Oracle :- > <Resource id="XA/Datasource" > class-name="oracle.jdbc.xa.client.OracleXADataSource"> > Url ***** > DataSourceCreator = dbcp > </Resource> > > For SQlserver :- > > <Resource class-name="com.microsoft.sqlserver.jdbc. > SQLServerXADataSource" > id="XA/Datasource"> > Url ***** > DataSourceCreator = dbcp > </Resource> > > So the above configurations work fine in oracle and postgres. In sqlserver > when I start TomEE it is giving me the connection exceptions.When I revert > back to non xadatsource it is working fine. Is there any extra > configuration > that needs to be done in sqlserver or is it the approach which i am using > is > incorrect. can any one please help me on this. > > Below is the error when i start the server > > com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to > the host 10.6.32.25, port 2300 has failed. Error: Connection timed out: > connect. Please verify the connection properties and check that a SQL > Server > instance is running on the host and accepting TCP/IP connections at the > port, and that no firewall is blocking TCP connections to the port. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError( > SQLServerException.java:130) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper( > SQLServerConnection.java:1195) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover( > SQLServerConnection.java:1054) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connect( > SQLServerConnection.java:758) > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect( > SQLServerDriver.java:842) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver( > PooledConnection.java:310) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connect( > PooledConnection.java:203) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection( > ConnectionPool.java:718) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection( > ConnectionPool.java:650) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEConnectionPool.<init>( > TomEEDataSourceCreator.java:221) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.createPool( > TomEEDataSourceCreator.java:154) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.<init>( > TomEEDataSourceCreator.java:131) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator.pool( > TomEEDataSourceCreator.java:68) > at > org.apache.openejb.resource.jdbc.DataSourceFactory.create( > DataSourceFactory.java:216) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:997) > at > org.apache.xbean.recipe.ObjectRecipe.internalCreate(ObjectRecipe.java:276) > at > org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:96) > at > org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:61) > at > org.apache.openejb.assembler.classic.Assembler.doCreateResource(Assembler. > java:2969) > at > org.apache.openejb.assembler.classic.Assembler. > createResource(Assembler.java:2802) > at > org.apache.openejb.assembler.classic.Assembler.buildContainerSystem( > Assembler.java:574) > at > org.apache.openejb.assembler.classic.Assembler.build(Assembler.java:483) > at org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:150) > at org.apache.openejb.OpenEJB.init(OpenEJB.java:307) > at > org.apache.tomee.catalina.TomcatLoader.initialize(TomcatLoader.java:247) > at > org.apache.tomee.catalina.ServerListener.lifecycleEvent( > ServerListener.java:168) > at > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent( > LifecycleBase.java:94) > at > org.apache.catalina.util.LifecycleBase.setStateInternal( > LifecycleBase.java:395) > at > org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:108) > at org.apache.catalina.startup.Catalina.load(Catalina.java:606) > at org.apache.catalina.startup.Catalina.load(Catalina.java:629) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:311) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:494) > media -> 14:27:23,517 ERROR [TomEEDataSourceCreator$TomEEDataSource] > Can't > create DataSource > com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to > the host 10.6.32.25, port 2300 has failed. Error: Connection timed out: > connect. Please verify the connection properties and check that a SQL > Server > instance is running on the host and accepting TCP/IP connections at the > port, and that no firewall is blocking TCP connections to the port. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError( > SQLServerException.java:130) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper( > SQLServerConnection.java:1195) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover( > SQLServerConnection.java:1054) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connect( > SQLServerConnection.java:758) > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect( > SQLServerDriver.java:842) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver( > PooledConnection.java:310) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connect( > PooledConnection.java:203) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection( > ConnectionPool.java:718) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection( > ConnectionPool.java:650) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEConnectionPool.<init>( > TomEEDataSourceCreator.java:221) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.createPool( > TomEEDataSourceCreator.java:154) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.<init>( > TomEEDataSourceCreator.java:131) > at > org.apache.tomee.jdbc.TomEEDataSourceCreator.pool( > TomEEDataSourceCreator.java:68) > at > org.apache.openejb.resource.jdbc.DataSourceFactory.create( > DataSourceFactory.java:216) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:997) > at > org.apache.xbean.recipe.ObjectRecipe.internalCreate(ObjectRecipe.java:276) > at > org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:96) > at > org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:61) > at > org.apache.openejb.assembler.classic.Assembler.doCreateResource(Assembler. > java:2969) > at > org.apache.openejb.assembler.classic.Assembler. > createResource(Assembler.java:2802) > at > org.apache.openejb.assembler.classic.Assembler.buildContainerSystem( > Assembler.java:574) > at > org.apache.openejb.assembler.classic.Assembler.build(Assembler.java:483) > at org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:150) > at org.apache.openejb.OpenEJB.init(OpenEJB.java:307) > at > org.apache.tomee.catalina.TomcatLoader.initialize(TomcatLoader.java:247) > at > org.apache.tomee.catalina.ServerListener.lifecycleEvent( > ServerListener.java:168) > at > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent( > LifecycleBase.java:94) > at > org.apache.catalina.util.LifecycleBase.setStateInternal( > LifecycleBase.java:395) > at > org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:108) > at org.apache.catalina.startup.Catalina.load(Catalina.java:606) > at org.apache.catalina.startup.Catalina.load(Catalina.java:629) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: > 57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:311) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:494) > > > > -- > View this message in context: http://tomee-openejb.979440. > n4.nabble.com/issue-with-XADatasource-in-sqlserver-tp4681379.html > Sent from the TomEE Dev mailing list archive at Nabble.com. >
