jtds

How to connect to SQL Server using activerecord, JDBC, JTDS and Integrated Security

As per the above, I've tried: establish_connection(:adapter => "jdbcmssql", :url => "jdbc:jtds:sqlserver://myserver:1433/mydatabase;domain='mynetwork';", :username => 'user', :password=>'pass' ) establish_connection(:adapter => "jdbcmssql", :url => 'jdbc:jtds:sqlserver://myserver:1433/mydatabase;domain="mynetwork";user="mynetwork\user...

NullPointerException with CallableStatement.getResultSet()

Hello, I have a stored proc in SQL Server 2005, which looks like the following (simplified) CREATE PROCEDURE FOO @PARAMS AS BEGIN -- STEP 1: POPULATE tmp_table DECLARE @tmp_table TABLE (...) INSERT INTO @tmp_table SELECT * FROM BAR -- STEP 2: USE @tmp_table FOR FINAL SELECT SELECT abc, pqr FROM BAZ JOIN @tmp_table...

How can I execute a stored procedure with JDBC / jTDS without using a transaction?

We run a website written in Java that uses JDBC with jTDS to access an SQL Server database. Our database contains a complex stored procedure that typically takes 10 minutes to run. The stored procedure works fine if we execute it directly (say from SQL Server Management Studio) because it does not run in a transaction. But if we execute...

JTDS Driver: Could not find a Java charset equivalent to collation 2C04D01000.

Looking a solution for strange JTDS error message: Could not find a Java charset equivalent to collation 2C04D01000. I tried to pass file.encoding and user.encoding parameters without any success. ...

JTDS and JBOSS JDBC Connection Pool Problem, any solution? Maybe a custom ValidConnectionChecker?

Hello, I'm facing a weird production problem. Environment is the following: JBOSS 4.0.2 SQL Server 2005 Driver JTDS 1.2.5 From time to time the following szenario occurs. A SQL command fails to Excute with java.sql.SQLException: I/O Error: Read timed out (I can live with that, if it just happens twice a day or so) But from ...

Hibernate sql exception when table empty.

The following code causes an exception when the Job table has no rows. public List<Job> getAll(int currentPage, int pageSize) { return this.sessionFactory.getCurrentSession() .createCriteria(Job.class).addOrder(Order.asc("id")) .setFirstResult(currentPage * pageSize).setMaxResults(pageSize) .setFetchSize(page...

JAVA JDBC Jtds problem to establish a conection

guys i'm with a Hell Problem!! :| i want to make a access to my sql database than is placed in ASUS\MSSQLSERVER1 and database names "Test" with access to user teste with password teste in java code i coded this: @Test public void TesteTemp() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundExceptio...