• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

No results in query using JDBC, works in Db

 
Zak Nixon
Ranch Hand
Posts: 126
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 126
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found my problem, and it was nothing
to do with the query.

Regards,

Zak Nixon
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic