Tags » Jtds

Connect Oracle SQLDeveloper to MS Server

I did it using the jtds drivers.

Just chek about the drivers and download them from http://jtds.sourceforge.net/

And then follow the steps of this video: http://www.oracle.com/technetwork/developer-tools/sql-developer/sql-server-connection-viewlet-swf-089886.html

It can be esier.



Connecting to SQL Server from Java

Almost every time I try to connect to SQL Server from Java I end up hacking something together, like copy-pasting the connection string from an old project; then again, more often than not I end up getting some sort of error and spending quite sometime Googling. 843 more words


Using Oracle SQL developer as a GUI front-end for MS SQL server

In my previous post I described how to use OpenOffice Base as a MS SQL server GUI front-end. On some occasions I have experienced OObase to hang when executing queries or otherwise communicating with the SQL server. 302 more words


Connecting to MS SQL server from OpenOffice Base using jTDS JDBC driver on linux

I have been using the Microsoft Enterprise Manager to connect to MS SQL server in order to test SQL queries before being used in applications etc. 304 more words


JIRA and SQL Server 2005. Login failed even when mixed authentication is applied

I had a lot of trouble in configuring JIRA with SQL Server 2005. All settings in entityengine.xml and server.xml were made according to the “Connecting JIRA to SQL Server 2005″ pdf manual supplied by Atlassian. 82 more words

SQL Server

CallableStatements, JdbcTemplate and jTDS

I’ve been using the jTDS driver to connect to our SQL Server database. We have a stored procedure which I needed to call. In this project I would normally use iBATIS, but this particular call required the features of JdbcTemplate and CallableStatements (there are good reasons which I won’t go into now!) 116 more words

General J2EE

Java - Conexão banco de dados

Para conectar no banco de dados, basta utilizar a classe abaixo:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectionFactory {
    private String url = “jdbc:jtds:sqlserver://servidor/base”; 158 more words