We're migrating from MySQL to PostgreSQL and, um, this is weird. It
seems that Postgre expects the query string to be a regular ascii
string, not unicode. Could someone please explain this limitation?
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "db.py", line 271, in auth_site
site = get_site_by_name(unicode(name))
File "db.py", line 250, in get_site_by_name
return Site.byName(name)
File "<string>", line 1, in <lambda>
File "/usr/lib/python2.4/site-packages/sqlobject/main.py", line
1252, in _SO_fetchAlternateID
result, obj = cls._findAlternateID(name, dbName, value, connection)
File "/usr/lib/python2.4/site-packages/sqlobject/main.py", line
1248, in _findAlternateID
value), None
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py",
line 579, in _SO_selectOneAlt
return self.queryOne("SELECT %s FROM %s WHERE %s = %s" %
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py",
line 346, in queryOne
return self._runWithConnection(self._queryOne, s)
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py",
line 217, in _runWithConnection
val = meth(conn, *args)
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py",
line 339, in _queryOne
self._executeRetry(conn, c, s)
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py",
line 295, in _executeRetry
return cursor.execute(query)
TypeError: argument 1 must be str, not unicode
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
