DB2 database issue with Clob types

[Boris Aramis Aguilar Rodríguez]

<class pyodbc.Error'> ('ODBC data type -99 is not supported. Cannot read column LDTEXT.', 'HY000')

Hi, Im currently accesing a DB2 database (readonly) that is used by another application, my connection string is as follows:

db_tivoli = DAL('db2:pyodbc://driver=DB2;hostname=24.50.5.5;database=MAXDB71;uid=on_usr;pwd=pass.;port=50005', pool_size=1, db_codec='latin1', migrate=False)

and everything was going fine until I added a clobdata type to web2py data code

And now I'm getting the error I referenced above (sorry I couldnt paste it in order, Im on my phone) Any hints I would appreciate it :)

[Paolo Valleri]

you should provide us more info...

which web2py type are you using that is mapped to CLOB field?

web2py/pyodbc version

Paolo

[Boris Aramis Aguilar Rodríguez]

Hi, web2py data type is text; 

I see in this post: https://groups.google.com/forum/#!searchin/web2py/ODBC$20data$20type$20-99/web2py/6xxz8KXBXCY/pcpdiPQh1K4J

that it is the normal behavior of web2py, to map text-clob on IBM DB2 databases. 

Also on the same post they propose a solution editing db2cli.ini file but I don't know how to configure db2cli.ini (I mean, I know how to open it, where it is but I don't understand which alias should I put on the file)

Any help I will really appreciate it.

Thanks!

[Boris Aramis Aguilar Rodríguez]

I've just fixed it :D

The thing is that those parameters (that fix up the issue with clob types and pyodbc) can be passed trough the web2py connection string, so it is now as follows:

db_tivoli = DAL('db2:pyodbc://driver=DB2;hostname=IP_OR_HOSTNAME;database=DATABASENAME;\

                uid=USER;pwd=PASSWORD;port=50005;LONGDATACOMPAT=1;LOBMAXCOLUMNSIZE=10485875',

                migrate=False, pool_size=0, attempts=1)

I'm so happy :)

[Paolo Valleri]

well done

 Paolo

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/525AqDpOpio/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.