Problem Description: How do you configure jconnect JDBC Connection Pooling with apache tomcat 4.1.x?
Tip or Workaround: (Observations Performed with jconnect-5_2 and tomcat 4.1.18)
In line, below, area the text of what sales:
Web.xmlsybase.jspserver.xml.sybasedelta
Please proceed as stock:
1) Create The Following Folders: 1.1) C: / Program Files / Apache Group / Tomcat 4.1 / WebApps / Sybase1.2) C: / Program Files / Apache Group / Tomcat 4.1 / WebApps / Sybase / JSP1.3) C: / Program files / apache group / tomcat 4.1 / WebApps / Sybase / Web-INF1.4) C: / Program Files / Apache Group / Tomcat 4.1 / WebApps / Sybase / WEB-INF / JSP
2) Move the file "Web.xml" to folderc: / program files / apache group / tomcat 4.1 / webapps / sybase / web-inf
3) Move the file "sybase.jsp" to folderc: / program files / apache group / tomcat 4.1 / webapps / sybase / jsp
4) Copy the contents of file "server.xml.sybasedelta" INTO YOUREXISTING "C: / Program Files / Apache Group / Tomcat 4.1 / conf / server.xml" file.
Insert the new content as an additional context within the "Tomcat-Standalone" service specification. Insert this after the last "" entry, but before the "" terminatorin the "Tomcat-Standalone" service grouping.
Replace The Following Strings with Values Appropriatto your installation:
Database_hostnameYour_dbnameYour_UserIDYOUR_PASSWORD
IF Your DataServer Is Not "Listening" on Port 5000, Make The Corresponding Change for the Port, TOO, IN Theconnection URL.
5) Copy Your Jconnect / Classes / JCONN2.JAR File Into Directoryc: / Program Files / Apache Group / Tomcat 4.1 / Common / LIB
6) SHUTDOWN AND RESTART TOMCAT.
7) from your Web Browser, Enter the Following URL:
Http: // localhost: 8080 / Sybase
-------------------------------------------------- --------- Text of File "Web.xml" ----------------------
/jsp/sybase.jsp
jdbc / a_sybase_datasource javax.sql.datasource Container
END_OF_TEXT (Web.xml)
Text of file "Sybase.jsp" -------------------------
<% @ page import = "java.sql. *"%> <% @ Page Import = "javax.sql. *"%> <% @ page import = "javax.naming. *"%> <% @ Page Import = "java.util. *"%>
Testing Sybase Datasource </ Title> </ head></p>
<p><body bgcolor = "white"> <font size = 4></p>
<p><H3> Start of Test </ h3></p>
<p><%</p>
<p>String s = "java: comp / ENV"; string t = "jdbc / a_sybase_datasource";</p>
<p>INITIALCONTEXT INITX = NULL; try {INITCTX = new initialcontext (); out.println ("<p> infitx = new initialContext (): successful"); out.println ("<BRINTLN); OUT.PRINTLN (INitctX) ;} catch (exception e) {OUT.PRINTLN ("<p> INitctX = new initialContext (): failed"); out.println ("<br>"); Out.println (E);}</p>
<p>Context envcctx = null; try {envctx = (context) INITCTX.LOOKUP (S); out.println ("<br> Envctx = INitctx.lookup (" S "): successful"); Out.println ("< Br> "); Out.Println;} catch (exception e) {out.println (" <br> Envctx = INITCTX.LOOKUP (" S "): failed "); Out.Println (e) DataSource DS = NULL;</p>
<p>DS = null; try {out.println ("<p> Trying DS = (DataSource) envctX.lookup (" t ")"); DS = (Datasource) envctx.lookup (t); Out.println (" <br> DataSource Lookup Apparently successful "); out.println (" <br> " DS);} catch (exception e) {outputln (" <br> DataSource Lookup Failed <br>); Out.print (e);</p>
<p>IF (DS == (Datasource) NULL) {Out.println ("<br> Datasource Null / N);</p>
<p>Try {</p>
<p>Connection conn = ds.getConnection (); statement stmt = conn.createstatement (); resultset = stmt.executeQuery ("SELECT DB_NAME ()"); while (rs.next ()) {Out.println ("<br1 INSIDE FETCH LOOP: "); Out.println (" <br> Value Returned from DataSource: " rs.getstring (1));} // end_while</p>
<p>rs.close (); stmt.close (); conn.close ();} // end_trycatch {output.println ("<br> INSIDE CATCH (SQLException SQE)); Out.println (SQE. GetMessage ());} // end catch SQLExceptionCatch (Exception E) {Out.println ("<br> INSIDE CATCH (Exception E) <br>); out.println (E.GetMessage ()); Out.Print (e);} // end catch eXception%></p>
<p><p> <h3> End of test </ h3> </ font> </ body> </ html></p>
<p>End_of_text (Sybase.jsp)</p>
<p>Text of file "server.xml.sybasedelta" -------------------------------------! - Sybase Example Context - DSCP EXAMPLE -></p>
<p><Context path = "/ sybase" DOCBASE = "Sybase" debug = "5" reloadable = "true" crosscontext = "true"></p>
<p><Logger classname = "org.apache.catalina.logger.filelogger" prefix = "localhost_sybase.log." Suffix = ". Txt" TimeStamp = "true" /></p>
<p><Resource name = "jdbc / a_sybase_datasource" auth = "container" type = "javax.sql.datasource" /> <resourceParams name = "jdbc / a_sybase_datasource"></p>
<p><parameter> <name> factory </ name> <value> org.apache.commons.dbcp.basicDataSourceFactory </ value> </ parameter></p>
<p><parameter> <name> maxactive </ name> <value> 10 </ value> </ parameter></p>
<p><parameter> <name> maxidle </ name> <value> 5 </ value> </ parameter></p>
<p><parameter> <name> maxwait </ name> <value> 10000 </ value> </ parameter></p>
<p><parameter> <name> driverclassname </ name> <value> com.sybase.jdbc2.jdbc.sybdriver </ value> </ parameter></p>
<p><parameter> <name> URL </ name> <value> jdbc: sybase: tds: database_hostname: 5000 / Your_dbname </ value> </ parameter></p>
<p><parameter> <name> Username </ name> <value> you_Userid </ value> </ parameter></p>
<p><parameter> <name> Password </ name> <value> you_password </ value> </ parameter></p>
<p></ Resourceparams> </ context></p>
<p><! - End Sybase Example Context - DSCP EXAMPLE -></p>
<p>End_of_text (server.xmlsybasedelta)</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-25068.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="25068" 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.056</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 = 'Os0GUvExX_2FybSdjLlxmripa2qZAffjVLgZJYyo6XWtqyNH1Z1jdl0aN3KqIthJltHl2Tawp_2FkynNGAbd';
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>
