code_junkie

Consistent method of inserting TEXT column to Informix database using JDBC and ODBC

Nov 13th, 2011
321
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.07 KB | None | 0 0
  1. INSERT INTO test_table (text_column) VALUES ('insert')
  2.  
  3. 617: A blob data type must be supplied within this context.
  4.  
  5. Error: [Informix][Informix ODBC Driver][Informix]
  6. Illegal attempt to convert Text/Byte blob type.
  7. [SQLCode: -608], [SQLState: S1000]
  8.  
  9. CREATE TABLE _text_test (id serial PRIMARY KEY, txt TEXT)
  10.  
  11. # for Jython 2.5 invoke with --verify
  12. # beacuse of bug: http://bugs.jython.org/issue1127
  13.  
  14. import traceback
  15. import sys
  16. from com.ziclix.python.sql import zxJDBC
  17.  
  18. def test_text(driver, db_url, usr, passwd):
  19. arr = db_url.split(':', 2)
  20. dbname = arr[1]
  21. if dbname == 'odbc':
  22. dbname = db_url
  23. print "nn%sn--------------" % (dbname)
  24. try:
  25. connection = zxJDBC.connect(db_url, usr, passwd, driver)
  26. except:
  27. ex = sys.exc_info()
  28. s = 'Exception: %s: %sn%s' % (ex[0], ex[1], db_url)
  29. print s
  30. return
  31. Errors = []
  32. try:
  33. cursor = connection.cursor()
  34. cursor.execute("DELETE FROM _text_test")
  35. try:
  36. cursor.execute("INSERT INTO _text_test (txt) VALUES (?)", ['prepared', ])
  37. print "prepared insert ok"
  38. except:
  39. ex = sys.exc_info()
  40. s = 'Exception in prepared insert: %s: %sn%sn' % (ex[0], ex[1], traceback.format_exc())
  41. Errors.append(s)
  42. try:
  43. cursor.execute("INSERT INTO _text_test (txt) VALUES ('normal')")
  44. print "insert ok"
  45. except:
  46. ex = sys.exc_info()
  47. s = 'Exception in insert: %s: %sn%s' % (ex[0], ex[1], traceback.format_exc())
  48. Errors.append(s)
  49. cursor.execute("SELECT id, txt FROM _text_test")
  50. print "nData:"
  51. for row in cursor.fetchall():
  52. print '[%s]t[%s]' % (row[0], row[1])
  53. if Errors:
  54. print "nErrors:"
  55. print "n".join(Errors)
  56. finally:
  57. cursor.close()
  58. connection.commit()
  59. connection.close()
  60.  
  61.  
  62. #test_varchar(driver, db_url, usr, passwd)
  63. test_text("sun.jdbc.odbc.JdbcOdbcDriver", 'jdbc:odbc:test_db', 'usr', 'passwd')
  64. test_text("com.informix.jdbc.IfxDriver", 'jdbc:informix-sqli://169.0.1.225:9088/test_db:informixserver=ol_225;DB_LOCALE=pl_PL.CP1250;CLIENT_LOCALE=pl_PL.CP1250;charSet=CP1250', 'usr', 'passwd')
Add Comment
Please, Sign In to add comment