InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Jonathon

Try your application with version 3.26. It fixes a problem that sounds 
very similar to this. If that doesn't work then get back to me.

Regards

Pete

----- Original Message -----
From: Jonathan Lai Lam <jlailam@hemtech.co.za>
Date: Thursday, February 8, 2001 10:58 am
Subject: InstantDB: Something not 100% with LEFT OUTER JOIN...

> Hi there .....
> 
> I've ran into this problem, I need to use a LEFT OUTER JOIN, but I 
> seemto be getting a ClassCastException......? I am runing version 
> 3.25 by
> the way.
> 
> Here is the  query and exception:
> 
> select *
>    from NoOfColors LEFT OUTER JOIN JobEstimate ON
> JobEstimate.noOfColorId = NoOfColors.noOfColorId,
>              NoOfColors LEFT OUTER JOIN JobEstimate ON
> JobEstimate.jobTypeId   = NoOfColors.jobTypeId
> 
> scripts/query.txt java.lang.ClassCastException: java.lang.String
> java.sql.SQLException: java.lang.String
>        at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
>        at
> org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235)
>        at
> org.enhydra.instantdb.jdbc.idbStatement.executeQuery
(idbStatement.java:91)
> 
>        at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:587)
>        at java.lang.Thread.run(Thread.java:484)
> 
> When I select count(*) she seems to behave herself..... except for the
> fact that it returns one row even if there is no data in the entire
> database, this I thought was a little irregular eg:
> 
> select count(*)
>    from NoOfColors LEFT OUTER JOIN JobEstimate ON
> JobEstimate.noOfColorId = NoOfColors.noOfColorId,
>              NoOfColors LEFT OUTER JOIN JobEstimate ON
> JobEstimate.jobTypeId   = NoOfColors.jobTypeId
> 
> 
> Here are the create scripts for the two table I  am trying to 
> join, I
> don't  know but maybe this can give you a clue or two.....
> 
> e create table JobEstimate
> (
>    jobEstimateId     int                    not null,
>    jobTypeId         int                    not null,
>    printerId         int                    not null,
>    noOfColorId       int                    not null,
>    sizeId            int                    not null,
>    runOnQty          int                    not null,
>    runOnPrice        numeric(8,2)           not null
> );
> 
> e create table NoOfColors
> (
>    noOfColorId       int                    not null,
>    jobTypeId         int                    not null,
>    descr             varchar(64)            not null
> );
> 
> 
> Hopefully there is enough info here for you to recreate the exception.
> Thanks in advance.....
> 
> Jon
> 
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to 
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the 
> body of the email.
> If you have other questions regarding this mailing list, send 
> email to
> the list admin at owner-instantdb@enhydra.org.
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.