FreeTDS Development Group

["cal kaiwen" <cal_kaiwen AT hotmail.com>]

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