Tuesday, 15 April 2014

sql server - MSSQL with Jboss -


I'm trying to configure MSSQL with jebos. I'm an exception, where it says, "JDBC managed connection Unable to obtain

I have put sqljdbc_auth.dll and jboss \ server \ lib sqljdbc_xa.dl in the below config I have given in mssql -ds.xml

< Previous> & lt; Datasources & gt; & Lt; Xa-Data Source & gt; & Lt ;! - JNDI name of the data source, with reference to "java: /" - & gt; & Lt ;! - Datasource is not available outside the virtual machine - & gt; & Lt; JNDI-Name & gt; JDBC / DS / mssqlDS & lt; / JNDI-Name & gt; & Lt ;! - Unable to enable interleaving & lt; Interleaving / & gt; - & gt; & Lt; IsSameRM-override-price & gt; False & lt; / IsSameRM-override-price & gt; & Lt ;! - Database connection settings - & gt; & Lt; -! & Lt; Xa-Data Source Category & gt; Com.microsoft.sqlserver.jdbc.SQLServerXADataSource & lt; / Xa-Data source range & gt; & Lt; Xa-data source-asset name = "URL" & gt; JDBC: sqlserver: // IP: 1433; DatabaseName = dev_sql & lt; / Xa-Data Source-Property & gt; - & gt; & Lt ;! - Optional way of configuration - & gt; & Lt; Xa-data source-asset name = "server name" & gt; Com.microsoft.sqlserver.jdbc.SQLServerXADataSource & lt; / Xa-Data Source-Property & gt; & Lt; Xa-datasource-property name = "database name" & gt; Dev_sql & lt; / Xa-datasource-property & gt; & Lt; Xa-data source-property name = "user" & gt; Sa & lt; / Xa-datasource-property & gt; & Lt; Xa-datasource-property name = "password" & gt; Sql! 23 & lt; / Xa-datasource-property & gt; & Lt; Xa-datasource-property name = "SelectMethod" & gt; Cursor & lt; / Xa-datasource-property & gt; & Lt; -! The PingDatabase method uses the pool org.jboss.resource.adapter.jdbc.ValidConnectionChecker to check it out before a connection is still valid - & gt; & Lt; Valid-connection-checker-square-name & gt; Org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker & lt; / Valid-connection-checker-square-name & gt; & Lt ;! - SQL Server checks error code and messages for fatal errors - & gt; & Lt; Exception-sorter-square-name & gt; Org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter & lt; / Exception-sorter-square-name & gt; & Lt ;! - XA Datasource can not reuse a connection outside a transaction that is listed in a global transaction and vice versa - & gt; & Lt; No-tx-separate pool / & gt; & Lt; -! Session & lt default date format set, new connection-sql & gt; Change session set nls_date_format = 'FXDD-Mon-YYYY' optimizer_mode = 'ALL_ROWS' & lt; / New-relation-SQL & gt; - & gt; & Lt ;! - Similarly- standardjbosscmp-jdbc.xml (optional) in - mapping - & gt; & Lt; Metadata & gt; & Lt; Type-Mapping & gt; MS SQLSERVER2000 & lt; / Type-mapping & gt; & Lt; / Metadata & gt; & Lt ;! - Database connection pooling setting - & gt; & Lt; Minimum-size pool & gt; 10 & lt; / Min-pool size & gt; & Lt; Max-pool size & gt; 120 & lt; / Max-size pool & gt; & Lt; Idle-time-end minute & gt; 15 & lt; / Inactive-timeout minutes & gt; & Lt; / Xa-Data Source & gt; & Lt; / Datasources & gt;

I tried to use TX with the structure below

   

Any leads?

Stack trace stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException (JspServletWrapper.java:498) org.apache.jasper.servlet .jspServletWrapper.service (JspServletWrapper.java:411) org .apache.jasper.servlet.JspServlet.serviceJspFile (JspServlet.java:326) org.apache.jasper.servlet.JspServlet.service (JspServlet.java:253) javax.servlet .http.HttpServlet.service (HttpServlet.java:847 ) Com.chess.elcm.i9n.client.ViewHandler.gotoNextView (seeHandler.Java 367) ..client.ViewHandler.gotoNextPage (seeHandler.Java .78) ..LCM.i9n.client.Controller.service (Controller.JavaFx) Javax.servlet.http.HttpServlet.service (HttpServlet.java:847)

root cause business exception: in communicating with datasource Able.


No comments:

Post a Comment