Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem with 2 tables in jdbc

 
Slim Dasch
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I try to execute the following select and it doesn't work. The problem is that I have to make a select using 2 tables from 2 different databases. Could anyone tell me how to do that with jdbc ?
the select:

the JDBC instruction:

the error message


Internal Servlet Error:
javax.servlet.ServletException: S0022: 'codutl' is an incorrect colum name.


Thanx in advance,
Slim Dasch
 
Craig Demyanovich
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So far as I know, you must work with the tables over separate JDBC connections, one for each database, and concatenate the results. Also, this question has been asked before; try searching the forum for "two tables" to see some relevant results.
 
Slim Dasch
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanx !
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic