• Post Reply Bookmark Topic Watch Topic
  • New Topic

problem with 2 tables in jdbc  RSS feed

 
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
Boost this thread!