db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sonu Vijay <son...@yahoo.com>
Subject Simple Join
Date Fri, 19 Dec 2003 22:45:53 GMT
I need to do a simple select with join.

Select * from Pitcher join Team on Pitcher.TEAM_ID =
TEAM.TEAM_ID ;

Following one of the "Peers How To" tutorials I was
trying to do the following but the program just hangs
at the line:

List pitchers = PitcherPeer.doSelectJoinTeam(c);

and doesn't do anything

--------Code-------------------------------------
        Criteria c = new Criteria();
	(System.out.println"riteria : "+ c);
       List pitchers =
PitcherPeer.doSelectJoinTeam(c);
        Pitcher p1 = (Pitcher)list.get(0);
	Team team = p1.getTeam();
	ystem.out.println("Name of the Pitchers and his team:
"+ p1.getLastName()+" "+p1.getFirstName()+" "
+p1.getTeamId() + " " +team.getTeamName());

----------------------------------------------

Any ideas

Thanks
	

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message