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.
