You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Charles N. Harvey III" <ch...@alloy.com> on 2004/06/09 22:56:55 UTC
query being cut off
Hello again.
I have PopQuiz extending Quiz with the "super" reference descriptor on
the id of PopQuiz. This wasn't happening the other day. I am obviously
doing something wrong but I can't seem to find it yet. Here is what I
get in my error:
SELECT B0.pop_quiz_id FROM POP_QUIZ B0 INNER JOIN QUIZ B1 ON B0.pop_quiz_id=B1.q
It shoud be:
SELECT B0.pop_quiz_id FROM POP_QUIZ B0 INNER JOIN QUIZ B1 ON B0.pop_quiz_id=B1.quiz_id
See the difference? "quiz_id" is getting cut off. Can't really explain that
one. I'll do some more testing and remove some code, I'm probably just crazy.
I have an aspect in place to intercept QuizCriteria.new() (which subclasses Criteria).
So it shouldn't affect this query. But when I comment out the aspect I don't get
this problem. What would cause a query to bet cut short? Any idea.
Thanks again.
Charlie
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: query being cut off
Posted by "Charles N. Harvey III" <ch...@alloy.com>.
Argh, its because MySql doesn't support subqueries. Lame. They have it
now in 4.1
but we are still using 3.x. Looks like I'll do some funky joins or get
the sub
collection with good ol' java.
Charlie
Charles N. Harvey III said the following on 6/10/2004 9:56 AM:
> If anyone was concerned (probably not) it is not the query that is
> being shortened,
> only the error message. I think its something with the MySql driver
> that the
> message it reports back is only a certain number of characters. Its
> pretty annoying
> because I think my error is much farther along in the string. Maybe
> I'll ask someone
> at mysql.com.
>
>
> Charlie
>
>
> Charles N. Harvey III said the following on 6/9/2004 4:56 PM:
>
>> Hello again.
>> I have PopQuiz extending Quiz with the "super" reference descriptor on
>> the id of PopQuiz. This wasn't happening the other day. I am obviously
>> doing something wrong but I can't seem to find it yet. Here is what I
>> get in my error:
>>
>> SELECT B0.pop_quiz_id FROM POP_QUIZ B0 INNER JOIN QUIZ B1 ON
>> B0.pop_quiz_id=B1.q
>>
>>
>> It shoud be:
>>
>> SELECT B0.pop_quiz_id FROM POP_QUIZ B0 INNER JOIN QUIZ B1 ON
>> B0.pop_quiz_id=B1.quiz_id
>>
>>
>> See the difference? "quiz_id" is getting cut off. Can't really
>> explain that
>> one. I'll do some more testing and remove some code, I'm probably
>> just crazy.
>>
>> I have an aspect in place to intercept QuizCriteria.new() (which
>> subclasses Criteria).
>> So it shouldn't affect this query. But when I comment out the aspect
>> I don't get
>> this problem. What would cause a query to bet cut short? Any idea.
>>
>> Thanks again.
>>
>>
>> Charlie
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: query being cut off
Posted by "Charles N. Harvey III" <ch...@alloy.com>.
If anyone was concerned (probably not) it is not the query that is being
shortened,
only the error message. I think its something with the MySql driver
that the
message it reports back is only a certain number of characters. Its
pretty annoying
because I think my error is much farther along in the string. Maybe
I'll ask someone
at mysql.com.
Charlie
Charles N. Harvey III said the following on 6/9/2004 4:56 PM:
> Hello again.
> I have PopQuiz extending Quiz with the "super" reference descriptor on
> the id of PopQuiz. This wasn't happening the other day. I am obviously
> doing something wrong but I can't seem to find it yet. Here is what I
> get in my error:
>
> SELECT B0.pop_quiz_id FROM POP_QUIZ B0 INNER JOIN QUIZ B1 ON
> B0.pop_quiz_id=B1.q
>
>
> It shoud be:
>
> SELECT B0.pop_quiz_id FROM POP_QUIZ B0 INNER JOIN QUIZ B1 ON
> B0.pop_quiz_id=B1.quiz_id
>
>
> See the difference? "quiz_id" is getting cut off. Can't really
> explain that
> one. I'll do some more testing and remove some code, I'm probably
> just crazy.
>
> I have an aspect in place to intercept QuizCriteria.new() (which
> subclasses Criteria).
> So it shouldn't affect this query. But when I comment out the aspect
> I don't get
> this problem. What would cause a query to bet cut short? Any idea.
>
> Thanks again.
>
>
> Charlie
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org