Skip to Content.
Sympa Menu

freetds - Re: [freetds] freetds jdbc sqlserver 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "cal kaiwen" <cal_kaiwen AT hotmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] freetds jdbc sqlserver 2000
  • Date: Tue, 25 Feb 2003 09:51:13 +0000

Hi all,

Keep all the SAME configuration, I download freetds_jdbc.snapshot.jar.2.0

Everything WORKS now :), Thank you.
BUT, with this error:-

SQLException occurred: java.sql.SQLException: Protocol confusion. Got a 0x79 packet

I saw this posting somewhere, will try to investigate.:) But at least now I am connected to the database.

Now that I know, I can actually rename
freetds_jdbc.snapshot.jar.2.0 >
freetds_jdbc.jar

A newbie in this area :))

Thank you,
Calvin Pevee



From: "cal kaiwen" <cal_kaiwen AT hotmail.com>
Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
To: freetds AT lists.ibiblio.org
Subject: [freetds] freetds jdbc sqlserver 2000
Date: Tue, 25 Feb 2003 08:22:46 +0000


Hi :)

Please help me with this configuration and the error, thank you.

The version(s) of freetds_jdbc you are using:-


[root@build pevee]# ident freetds_jdbc.jar
freetds_jdbc.jar:
$Id: CallableStatement_1_0.java,v 1.2 2000/01/08 04:25:26 cts Exp $
$Id: CallableStatement_base.java,v 1.3 2000/01/11 03:07:15 cts Exp $
$Id: CancelController.java,v 1.5 1998/11/29 21:11:03 cts Exp $
$Id: Column.java,v 1.3 1999/10/06 19:57:28 cts Exp $
$Id: Columns.java,v 1.3 1999/10/06 19:57:29 cts Exp $
$Id: ConnectionHelper.java,v 1.4 1998/10/08 22:36:22 cts Exp $
$Id: Connection_1_0.java,v 1.1 1999/10/23 08:41:22 cts Exp $
$Id: Connection_base.java,v 1.3 2000/01/11 03:12:35 cts Exp $
$Id: Constructors.java,v 1.3 2000/01/11 04:57:36 cts Exp $
$Id: Context.java,v 1.2 1998/09/26 22:33:13 cts Exp $
$Id: DatabaseMetaData.java,v 1.16 2000/01/08 04:25:26 cts Exp $
$Id: Driver.java,v 1.12 2000/01/08 04:25:27 cts Exp $
$Id: DriverVersion.java,v 1.3 1999/03/09 17:15:49 cts Exp $
$Id: EscapeProcessor.java,v 1.4 1998/11/28 20:58:40 cts Exp $
$Id: MSSqlServerEscapeProcessor.java,v 1.5 1998/11/28 20:59:37 cts Exp $
$Id: PacketColumnInfoResult.java,v 1.2 1998/09/26 22:33:14 cts Exp $
$Id: PacketColumnNamesResult.java,v 1.2 1998/09/26 22:33:14 cts Exp $
$Id: PacketColumnOrderResult.java,v 1.2 1998/09/26 22:33:14 cts Exp $
$Id: PacketControlResult.java,v 1.2 1998/11/28 21:00:13 cts Exp $
$Id: PacketDoneInProcResult.java,v 1.1 1998/10/30 01:58:49 cts Exp $
$Id: PacketEndTokenResult.java,v 1.5 1998/10/30 01:58:50 cts Exp $
$Id: PacketErrorResult.java,v 1.2 1998/09/26 22:33:14 cts Exp $
$Id: PacketMsgResult.java,v 1.2 1998/09/26 22:33:14 cts Exp $
$Id: PacketResult.java,v 1.2 1998/09/26 22:33:14 cts Exp $
$Id: PacketRetStatResult.java,v 1.2 1998/09/26 22:33:15 cts Exp $
$Id: PacketRowResult.java,v 1.3 1998/11/22 01:41:53 cts Exp $
$Id: PacketTabNameResult.java,v 1.1 1998/10/26 07:13:48 cts Exp $
$Id: PacketUnknown.java,v 1.1 1999/10/23 08:59:37 cts Exp $
$Id: ParameterListItem.java,v 1.4 1999/01/30 01:44:00 cts Exp $
$Id: ParameterUtils.java,v 1.8 2000/01/24 20:29:27 cts Exp $
$Id: PreparedStatementHelper.java,v 1.1 1998/10/01 03:15:06 cts Exp $
$Id: PreparedStatement_1_0.java,v 1.1 1999/10/23 08:41:22 cts Exp $
$Id: PreparedStatement_base.java,v 1.4 2000/01/24 20:30:43 cts Exp $
$Id: Procedure.java,v 1.7 1999/02/18 07:22:38 cts Exp $
$Id: ResultSetMetaData.java,v 1.7 1999/10/22 18:47:57 cts Exp $
$Id: ResultSet_1_0.java,v 1.2 2000/01/11 04:57:36 cts Exp $
$Id: ResultSet_1_0_helper.java,v 1.2 2000/01/11 03:08:14 cts Exp $
$Id: ResultSet_base.java,v 1.3 2000/01/24 22:54:03 cts Exp $
$Id: SqlMessage.java,v 1.2 1998/09/26 22:33:15 cts Exp $
$Id: Statement.java,v 1.23 2000/01/11 03:04:18 cts Exp $
$Id: SybaseDriver.java,v 1.6 1999/02/22 20:24:00 cts Exp $
$Id: SybaseEscapeProcessor.java,v 1.2 1998/11/28 20:59:59 cts Exp $
$Id: Tds.java,v 1.49 2000/01/24 20:32:42 cts Exp $
$Id: TdsAsciiInputStream.java,v 1.3 1998/10/13 07:47:44 cts Exp $
$Id: TdsComm.java,v 1.13 1999/08/13 08:58:15 cts Exp $
$Id: TdsConfused.java,v 1.2 1998/09/26 22:33:16 cts Exp $
$Id: TdsDefinitions.java,v 1.8 1999/10/23 08:54:05 cts Exp $
$Id: TdsException.java,v 1.2 1998/09/26 22:33:16 cts Exp $
$Id: Connection_base.java,v 1.3 2000/01/11 03:12:35 cts Exp $
$Id: TdsNotImplemented.java,v 1.2 1998/09/26 22:33:16 cts Exp $
$Id: TdsUnknownPacketSubType.java,v 1.2 1998/09/26 22:33:16 cts Exp $
$Id: TdsUnknownPacketType.java,v 1.6 1999/09/28 16:05:07 cts Exp $
$Id: Tds.java,v 1.49 2000/01/24 20:32:42 cts Exp $
$Id: UniqueId.java,v 1.3 1998/10/13 07:49:58 cts Exp $
$Id: HexDump.java,v 1.1 1998/11/24 06:56:09 cts Exp $
$Id: Logger.java,v 1.2 1999/05/13 18:38:13 cts Exp $


The version(s) of the TDS protocol you are using:-

dbConnect = jdbc:freetds:sqlserver://192.168.250.71:1433/LBX;user=lbs;password=lbs;tds=7.0

// so is 7.0, since I am using SQL Server 2000

The version(s) of the JVM you are using:-

java version "1.4.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_01-b01)
Java HotSpot(TM) Client VM (build 1.4.1_01-b01, mixed mode)


Which DBMS you are using (including version and platform):-

Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600:)



Which platform(s) you are running your client software on:-

Linux build 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown



Whether the problem is present with the latest snapshot:-

I tried reetds_jdbc.snapshot.jar and reetds_jdbc.jar. Both give me the same error. After downloading, what I did is:-

(1) export CLASSPATH=/home/pevee/<jar_file>
(2) copy <jar_file> to /usr/java/j2re1.4.1/lib/ext/.


Please let me add a few informations below :)

dbConnect = jdbc:freetds:sqlserver://192.168.250.71:1433/LBX;user=lbs;password=lbs;tds=7.0

driverClass = com.internetcds.jdbc.tds.Driver


Most importantly, the error which I got is (when trying to connect to db server):-

stderror:- Exception- java.lang.NullPointerException
log file:- 25-02-2003 16:10:29.103 [INFO] [main] Creating new APDb instance
25-02-2003 16:10:29.105 [INFO] [main] Creating database connection
25-02-2003 16:10:29.106 [INFO] [main] JDBC Driver class: com.internetcds.jdbc.tds.Driver
25-02-2003 16:10:29.116 [INFO] [main] DB Connection string: jdbc:freetds:sqlserver://192.168.250.71:1433/LBX;user=lbs;password=lbs;tds=7.0
25-02-2003 16:10:29.198 [ERROR] [main] SQLException occurred: java.sql.SQLException
25-02-2003 16:10:29.199 [ERROR] [main] Failed to initialize database connection, exiting...


PLease let me know if there is anythign else I can provide.

Thank you,
Calvin Pevee








_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus




Archive powered by MHonArc 2.6.24.

Top of Page