Also said that I said it is too simple. In fact, I am a lazy, I don't know, I don't know, I will record the blog as a record. Let's talk about it, the platform (Windows2000 SQLServer2000 MSJDBC WebLogic Eclipse Lomboz), the basic configuration is not introduced, do not understand, please go. Specific steps: 1: First go to Microsoft website under the latest JDBC driver and install, let it support distributed transactions you need to do the following (in the help file) first COPY MSJDBC installation directory / SQLServer JTA / SQLJDBC.DLL to SQL Server installation directory / binn directory below, then open the query analyzer, load the MSJDBC installation directory / SQLSERVER JTA / InstjDBC.SQL and execute, (may need to restart) 2: Build 2 databases in SQL Server, establish 2 table. Then start the WebLogic console, establish 2 Connection Pool points to the two databases, respectively, here to note the Microsoft JDBC driver for Type 4xa, then build 2 Data Source points to the Connection Pool. 3: OK, now we can write the program, build a WAR type Lomoz project in Eclipse, and Server selects WebLogC. Establish a.jsp, here explain, use JTA, only need CText CTX = New InitialContext (HTX); useertransaction tx = (userTransaction) ctx.lookup ("javax.transaction.usertransaction); you can use TX, below A.jsp's example, but this example is not to insert operation to 2 databases, if you want to insert data into 2 databases into the data, turn TX.ROLLBACK () to tx.commit (). A.jsp code is as follows <% @ page language = "java" import = "java.sql. *, java.util. *, javax.naming. *, javax.transaction. *"%>
Lomboz JSP </ Title> </ head> <body bgcolor =" # ffffff "> <% context ctx = null; hashtable htx = new Hashtable (); UserTransaction tx = null; htx.put (Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory"); htx.put (Context.PROVIDER_URL, "t3: // localhost: 7001"); Connection conn = NULL; statement stmt = null; javax.sql.datasource ds = null;</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-107786.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="107786" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.040</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = 'NKwgHT9tmWviGHlO8OKbGCBuTM7e4PWlpZGn4Az4pA38Jru4NRctDYGkLWqBZkKc2SLZt_2F2tY_2FZuYUJZviEfhw_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
