Re: JDBC / ODBC problem

goli wrote:
> Hi,
> I posted a message about a problem in UNION query.
>
http://groups-beta.google.com/group/comp.lang.java.programmer/browse_frm/thread/f76e504d58ad7d47/310c36512df95818?q=sql+union+in+java&rnum=1#310c36512df95818
>
(snip)

> Is it an ODBC or JDBC problem ?
> Is it the ResultSet class problem ?
> Maybe I get the results wrong. I use "while resultSet.next() { .. }

Sorry I don't have time to dig into your code but I would not be
surprised if you find bugs in databases, JDBC or ODBC drivers. Actually
I would be surprised if you didn't find any ;-|

I'll presume your code is correct and there is a bug beyond your direct
control, often the only recourse is to find a work around or
alternative. Do the query differently.

I'm using Oracle and one of its JDBC drivers and I find plenty of
problems. Today I need to code a query with MINUS, my confidence that
it'll actually work is pretty low. I'm automatically thinking of
alternatives.

Cheers,
Alex

.

Relevant Pages

  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > I don't get the "Database has been placed in a state by ... Access runs the query and will prompt for any ... > my ODBC entry and click the "Configure" button, ... >>using OLEDB, it uses a more exclusive mode than it really ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... I was able to find the MS Query button and locate my ... in both is ODBC. ... >> be certain that I am using the OLEDB method? ... >from the list of possible connection options. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... This is not passthrough query sql. ... and should be translated into ODBC SQL. ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simple query executes fast but renders slow...
    ... After you restart Access and run your query, JET will write an extensive log ... "SQL Queries for Mere Mortals" ... >>Then I wrote queries and reports based on the local ... So, ODBC, right? ...
    (microsoft.public.access.queries)