aspose file tools
The moose likes JDBC and the fly likes No results in query using JDBC, works in Db Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "No results in query using JDBC, works in Db" Watch "No results in query using JDBC, works in Db" New topic
Author

No results in query using JDBC, works in Db

Zak Nixon
Ranch Hand

Joined: Sep 27, 2003
Posts: 126
I am using MySQL as my db.
I have a table called test, with columns (pkId,testId,testRun)
I need to get the highest number from the testRun column based on the testId.

I place this query in my DB query executor :



It works.

When I place it in my JDBC select statement, it returns no matching rows.

Is there something particular about this query that allows JDBC not to work ?

Thanks

Zak
Zak Nixon
Ranch Hand

Joined: Sep 27, 2003
Posts: 126
I found my problem, and it was nothing
to do with the query.

Regards,

Zak Nixon
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: No results in query using JDBC, works in Db
 
Similar Threads
Will this code work fine?
Query works in DB, but not with JDBC (MS version)
which is more efficient wait() and notify() or join() for this scenario?
JDBC Connection Pooling
eager fetching of lazy formulas via criteria api