3 Replies Latest reply on Jan 18, 2003 5:25 AM by mkulgeorge

    Anyone had this problem?? - TABLE NOT FOUND

    timothy_pang

      Hi there,

      I got a werid problem here...any suggestion is helpful!!

      I am using JBoss2.4.4 and wrote a simply BMP to see how it goes. I tried using MySQL and MS-Access. Both have the same problem when the bean doing the SELECT, it throws Exception says TABLE NOT FOUND....

      I also try the same code on my friend's machine(but he's running postgreSQL), BMP works, no problem occured.

      So, I wrote a simple testing java program on my machine which just using jdbc to query the same databases(both MySQL and Access, things went well, I got the data back from database.

      So, the problem is why my BMP throws exception says TABLE NOT FOUND???

      Thanks

      Timothy

        • 1. Re: Anyone had this problem?? - TABLE NOT FOUND
          suvankar17

          if you are using jdbc-odbc bridge, please check that you have specified the correct connection URL.

          • 2. Re: Anyone had this problem?? - TABLE NOT FOUND
            timothy_pang

            hi,

            I think the URL is correct. Both in MySQL and Access, my java program can query the database. But when I using BMP to query the database, then it says TABLE NOT FOUND.

            Really don't know what's going on....

            Timothy

            • 3. Re: Anyone had this problem?? - TABLE NOT FOUND
              mkulgeorge

              Hi all,
              i have a similar problem,
              regarding the quering a database table using a BMP.

              Query
              -----
              select field1, datefield from table1
              where
              swipe_date =
              (select max(datefield) from table1 where field1 = 'value')
              and field1 = 'value'

              my query look like the one above,
              except those fieldname and values and tables which
              are same as i have named it.

              when i substitute some values to the value
              and query the database it gives me single value
              and that is the desired output

              but my BMP give me a undesirable error
              Error: TABLE NOT FOUND table1

              what is the actuall error??
              can any one explain that??

              i want is very soon.

              Thanks you.