[prev in list] [next in list] [prev in thread] [next in thread]
List: freetds
Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
From: Frediano Ziglio <freddyz77 () tin ! it>
Date: 2005-11-05 9:40:56
Message-ID: 1131183656.19517.5.camel () freddy
[Download RAW message or body]
Il giorno ven, 04/11/2005 alle 18.26 +0300, Зверев Виталий Борисович ha
scritto:
> No, if you mean "odbc.c,v 1.395 2005/11/02 12:57:54 freddy77" from CVS,
> it does not solve JdbcOdbc bridging problems with \
> DatabaseMetaData.getSchemas(),DatabaseMetaData.getCatalogs() and so on. Squirell \
> 2.0 is perfect example of their reproducing.
> Sincerely yours.
> -------------------------------------------------------
> Vitaly Zverev, OCP DBA 8&8i
> Oracle E-Business Suite &
> Infiniband Linux Cluster Administrator
> Genesis Ltd., St.Petersburg, Russia
>
Well, I can say that with current version works much better (very easy
installation!!) however is has a problem getting schemas.
Attached a log produced in such way (after narrowing down the problem a
bit):
- open SQuirrel SQL with both odbc and tds dump
- connect to db
- refresh tree object
- delete odbc log
- open a database item (you should see a "<Error>" schema)
- copy the odbc log to another location
In log you can see a SQLGetData call that is clearly wrong (Column
Number is very big...)
[ODBC][10757][SQLGetData.c][224]
Entry:
Statement = 0x93222d8
Column Number = 65535
Target Type = 4 SQL_INTEGER
Buffer Length = 4
Target Value = 0xb1e90be4
StrLen Or Ind = 0xb1e90be0
[ODBC][10757][SQLGetData.c][470]
Exit:[SQL_ERROR]
Buffer = [0]
Strlen Or Ind = 0xb1e90be0 -> 0
DIAG [S1002] [FreeTDS][SQL Server]Column out of range
freddy77
["sql.log" (sql.log)]
[ODBC][10757][SQLGetInfo.c][214]
Entry:
Connection = 0x95dba20
Info Type = SQL_DBMS_NAME (17)
Info Value = 0x93222d8
Buffer Length = 300
StrLen = 0xb1e90c1c
[ODBC][10757][SQLGetInfo.c][528]
Exit:[SQL_SUCCESS]
[ODBC][10757][SQLAllocHandle.c][510]
Entry:
Handle Type = 3
Input Handle = 0x95dba20
[ODBC][10757][SQLAllocHandle.c][872]
Exit:[SQL_SUCCESS]
Output Handle = 0x93222d8
[ODBC][10757][SQLTables.c][200]
Entry:
Statement = 0x93222d8
Catalog Name = [][length = 0 (SQL_NTS)]
Schema Name = [%][length = 1 (SQL_NTS)]
Table Name = [][length = 0 (SQL_NTS)]
Table Type = [NULL]
[ODBC][10757][SQLTables.c][417]
Exit:[SQL_SUCCESS]
[ODBC][10757][SQLNumResultCols.c][149]
Entry:
Statement = 0x93222d8
Column Count = 0xb1e90bf4
[ODBC][10757][SQLNumResultCols.c][234]
Exit:[SQL_SUCCESS]
Count = 0xb1e90bf4 -> 5
[ODBC][10757][SQLFetch.c][158]
Entry:
Statement = 0x93222d8
[ODBC][10757][SQLFetch.c][340]
Exit:[SQL_SUCCESS]
[ODBC][10757][SQLColAttributes.c][267]
Entry:
Statement = 0x93222d8
Column Number = 1
Field Identifier = SQL_DESC_CONCISE_TYPE
Character Attr = (nil)
Buffer Length = 0
String Length = 0xb1e90be6
Numeric Attribute = 0xb1e90be8
[ODBC][10757][SQLColAttributes.c][584]
Exit:[SQL_SUCCESS]
[ODBC][10757][SQLGetData.c][224]
Entry:
Statement = 0x93222d8
Column Number = 65535
Target Type = 4 SQL_INTEGER
Buffer Length = 4
Target Value = 0xb1e90be4
StrLen Or Ind = 0xb1e90be0
[ODBC][10757][SQLGetData.c][470]
Exit:[SQL_ERROR]
Buffer = [0]
Strlen Or Ind = 0xb1e90be0 -> 0
DIAG [S1002] [FreeTDS][SQL Server]Column out of range
[ODBC][10757][SQLError.c][342]
Entry:
Statement = 0x93222d8
SQLState = 0x9324078
Native = 0xb1e90ae8
Message Text = 0x9326078
Buffer Length = 300
Text Len Ptr = 0xb1e90aec
[ODBC][10757][SQLError.c][379]
Exit:[SQL_SUCCESS]
SQLState = S1002
Native = 0xb1e90ae8 -> 0
Message Text = [[unixODBC][FreeTDS][SQL Server]Column out of range]
[ODBC][10757][SQLError.c][342]
Entry:
Statement = 0x93222d8
SQLState = 0x9322200
Native = 0xb1e90ae8
Message Text = 0x9325bd0
Buffer Length = 300
Text Len Ptr = 0xb1e90aec
[ODBC][10757][SQLError.c][379]
Exit:[SQL_NO_DATA]
[ODBC][10757][SQLFetch.c][158]
Entry:
Statement = 0x93222d8
[ODBC][10757][SQLFetch.c][340]
Exit:[SQL_NO_DATA]
[ODBC][10757][SQLFreeStmt.c][140]
Entry:
Statement = 0x93222d8
Option = 1
[ODBC][10757][SQLFreeHandle.c][365]
Entry:
Handle Type = 3
Input Handle = 0x93222d8
[ODBC][10757][SQLFreeHandle.c][462]
Exit:[SQL_SUCCESS]
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic