Re: Tomcat and MsSQL - Resolved

[Frank von Daak <fr...@kpage.de>]

Hi,

after a very long search, I've found the solution for my problem.

I've installed tomcat4 directly from debian (.deb)
This installation has activatet the security-manager per default - and this 
caused the problem.

I've had to grant access to the IP and Port of the SQL-Server in the security 
manager.
After this I was able to open a Socket, but the driver still doesn't work, 
becaus of missing file permissions ([Microsoft][SQLServer 2000 Driver 
for JDBC]Error opening/loading com.microsoft.util.transliteration.properties.)

I've decided to deactivate the security manager - and now, everything is 
working well !

Greetings,
Frank


Am Samstag, 30. August 2003 12:33 schrieb Christopher Williams:
> Question: Are you certain that SQL Server is listening on port 1433? I've
> seen it using port 1141.  Use the SQL Server network utility to check the
> TCP port.
>
> ----- Original Message -----
> From: "Frank von Daak" <fr...@kpage.de>
> To: <to...@jakarta.apache.org>
> Sent: Saturday, August 30, 2003 10:51 AM
> Subject: Tomcat and MsSQL
>
> > Hi,
> >
> >
> > maybe, someone of you can help me...
> >
> > I try to port a webapplication from asp to java...
> >
> > First, I have used Websphere for this and everything worked ok, but then
> > I decided to use tomcat4 (both under debian-linux)
> >
> > My problem is the connection to a MSSQL-Database.
> >
> > As JDBC-Driver I'm using the  "Microsoft SQL Server 2000 Driver for
> > JDBC", which has an official linux-support. And I cn say, that it is
> > working very well with websphere...
> >
> > When I use the same jsp-files under tomcat, I get the following error,
>
> when
>
> > trying to connect the sql-server:
> >
> > [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
> >
> >
> > I have copied the 3 files "msbase.jar", "mssqlserver.jar" and
> > "msutil.jar"
>
> to
>
> > $CATALINA_HOME/common/lib and it seems, that tomcat can find them (as the
> > error message says)
> >
> > Here is the code, that I use to connect to the database:
> >
> > --------------------------------------------------
> >
> > <%@ page language="java" import="javax.sql.DataSource,java.sql.*"%>
> > <%
> >
> > Connection db_con;
> > Statement db;
> >
> > try {
> >   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
> > } catch (ClassNotFoundException e) {
> >   out.println("<h1>Der Datenbanktreiber konnte nicht gefunden werden:" +
> > e
>
> +
>
> > e.getMessage() + "</h1>" );
> > }
> >
> > String con = "jdbc:microsoft:sqlserver://192.168.0.199:1433;User=sa;
> > Password=bla;DatabaseName=testdb";
> >
> > try {
> >   db_con = DriverManager.getConnection (con);
> > } catch ( SQLException se ) {
> >   out.println("Exception...(" + se.getMessage() + ")<br>-->");
> > }
> > %>
> >
> > ------------------------------------------------------
> >
> >
> > What do I have to do, to get it working with tomcat ?
> >
> >
> > Thank you very much for your help !!!
> >
> > Greetings,
> > Frank
> >
> > --
> > Name: Frank von Daak
> > eMail: frank.fun@kpage.de Homepage: http://www.kpage.de
> > eMail:  siteadmin@linux-dev.de Homepage: http://www.linux-dev.de
> > "If Bill Gates had a nickel for every time Windows crashed...
> >     - oh wait, he does."
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

-- 
Name:	Frank von Daak
eMail:	frank.fun@kpage.de	Homepage: http://www.kpage.de
eMail:  siteadmin@linux-dev.de	Homepage: http://www.linux-dev.de
"If Bill Gates had a nickel for every time Windows crashed...
    - oh wait, he does."