This is not enough detail to provide any insight into your issue. We would
require the mapping for TaskCalendar, Tasks, as well as code which inserts the
offending data into the database and then issues your query, reproducing the
error you are getting.
On May 10, 2010, at 8:54 AM, dhanil anupurath wrote:
> Hi
>
> This is my class definition
>
> class TaskCalendar(DeclarativeBase):
> __tablename__ = 'task_calendars1'
>
> cal_id = Column(Integer,Sequence('id_seq'), primary_key=True)
> task_id = Column(Integer, ForeignKey('tasks.task_id'))
> dow = Column(Integer)
> month = Column(Integer)
> day = Column(Integer)
> hour = Column(Integer)
> minute = Column(Integer)
>
> task = relation(Task, backref=backref('calendar'))
>
> This is what am trying to do
> tasks=DBSession.query(TaskCalendar).options(eagerload('task'))
>
> The query is as follows
> SELECT task_calendars1.cal_id AS task_calendars1_cal_id,
> task_calendars1.task_id AS task_calendars1_task_id,tasks_1.name AS
> tasks_1_name, tasks_1.entity_id AS tasks_1_entity_id,
> tasks_1.entity_name AS tasks_1_entity_name, tasks_1.context AS
> tasks_1_context
> FROM task_calendars1 LEFT OUTER JOIN tasks tasks_1 ON tasks_1.task_id
> = task_calendars1.task_id
>
> if i remove tasks_1.context this query works fine
> context column is of pickletype datatype in class and Blob in Database
>
> This is the error message:
> ORA-00932: inconsistent datatypes: expected NUMBER got BLOB
>
> Thankful for any suggestions
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
