Quick HOWTO to set up a MSSQL 2000 Datasource in Tomcat

This is a small HOWTO that will help you get a DataSource with the MSSQL 2000 database using the official MS JDBC drivers and the Tomcat container.

1. Copy the files: msutil.jar mssqlserver.jar and msbase.jar to a directory that will be visible to your java environment; A good one would be the_path_to_your_SDK/jre/lib/ext/
It might be good idea to put them in the containers libs as well and your web application lib folder... you never know :) Just remember to keep all of them in sync.
2. Log into your Tomcat administration utility (probably http://localhost:8080/admin/) and log in.
3. Go to Service > Host > your_web_app_context
4. Go to Data Sources and create a new data source setting these parameters:
JNDI Name: 
jdbc/mssql
Data Source URL: 
jdbc:microsoft:sqlserver://localhost:1433;databaseName=db_name
JDBC Driver Class: 
com.microsoft.jdbc.sqlserver.SQLServerDriver

then fill the user name and password fields. I don't know yet how to determine what are the best connection settings so that's up to you. If you have some advice, please leave some comments.
5. Then you switch to some java coding, go to the place where you'd be putting the Class.forName and DriverManager.getConnection() bits and replace them with something like:
DataSource ds=null;
try{
InitialContext ctx= new InitialContext();
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mssql");
Connection connection = ds.getConnection();
catch (Exception e){
throw new NotFoundDBException("Blah blah blah" + e);
}

NotFoundDBException is a class I wrote to handle the exception, you'll have to come up with your own :)
that's it, I think.

Comments

Post a Comment

Popular posts from this blog

Relaxing SSL validation for JaxWS

I've recently had the need to access a web service developed in .Net and signed with a self signed certificate. I've decided to use the JaxWS and the Metro stack to develop the client and run it on Java6. As a plus, the service was protected with username and password. The service was exposed on an IP address and I repetedly had problems in establishing a connection. In the end, thanks to this article, it was obvious that the certificate was not created with the alternative name attribute but it was not an option to change the certificate as the web service was already used by other consumers (.net clients don't suffer by this issue). So, on my quest to relax the validation, I've found out this article and code snippet, which did not compile at first (I guess package names were changed in JDK6) so I've did some trivial refactoring and now, after invoking the static methods in the client code, the SSL connection gets validated with no problems. Hope it helps and th...
Read more

Kaspersky Anti Virus 6 and Subversion problems

I've spent a good part of my day today in trying to understand why I can't checkout our subversion repository. I was getting this: svn: REPORT of '/svn/repos/!svn/vcc/default': 400 Bad Request google searches would make you think it's a proxy issue but I don't use or need one so after a lot of trial and errors I've found out that if you use Kaspersky Anti-Virus 6 it seems that if you use the Web Anti-Virus options with the recommended settings and you have the "Scan HTTP traffic" option on you end up with the problem above. It seems Kaspersky doesn't like the HTTP packets subversion uses so they get blocked. I really like Kaspersky and I recommend it to all but I hope they will address this issue as soon as possible as subversion is becoming the main open source VCS system. Any tips on this issue are welcome.
Read more

Search and Replace in ODT using AODL

Recently I needed to create a way to search and replace a word in a OpenOffice OpenDocument ODT. It would seem the project itself already has a library AODL (take care, at least two other project pages but with older code) that exposes the format model but I didn't find any utility methods like search and replace functionality. I've created two versions of the method, one a old-style, imperative approach, and the other, a LINQ version. As I'm still new to LINQ it would seem that the classical approach produces a more efficient code. Anyone care to chip in and make a faster algorithm? In this particular version I'm just going for simple string equality, I didn't want to go with other StringComparison methods (just look at the Equals overload method). public static void SearchAndReplaceString(TextDocument document, string searchText, string replaceText) { var content = document.Content; foreach (var item in content) ...
Read more