Skip to Content.
Sympa Menu

freetds - Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
  • Date: Sat, 05 Nov 2005 10:40:56 +0100

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

[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]



Archive powered by MHonArc 2.6.24.

Top of Page