Java and Microsoft SQL

Hi !

I am experiencing some problems with MSSQL (ver 8.0).

While I can execute sub-select statement directly on a MSSQL server,
I cannot do the same thing in JDBC.

Like the following statement( JDBC throws exception about mismatched
type)

select idcolumn,a,b,c FROM mytable WHERE idcolumn = (SELECT max
(idcolumn) FROM mytable)

I could get the result other way too (like top 1 and descend sort
etc..), but this would be the fastest way and I want to use it.


I am connecting to database server without any settings, just IP,
username and password.

On mysql, I had a several options I could specify in a connect string,
so the server acts different.

Is there any setting I can specify which can help me ? Where can I
read all parameters I can specify when connecting via JDBC to Microsoft
SQL ?

Thx.

wrote...

> I am experiencing some problems with MSSQL (ver 8.0).

Actually, I think the problem you encounter cannot be referred to as a
problem with MSSQL, other than that the use of the equals operator on a
nonscalar value AFAIK isn't a part of the ANSI-standard for SQL...

> While I can execute sub-select statement directly
> on a MSSQL server, I cannot do the same thing in JDBC.
>
> Like the following statement( JDBC throws exception
> about mismatched type)
>
> select idcolumn,a,b,c FROM mytable WHERE idcolumn =
> (SELECT max (idcolumn) FROM mytable)

Have you tried this instead: (?)

select idcolumn,a,b,c
FROM mytable
WHERE idcolumn IN
(SELECT max (idcolumn) FROM mytable)

// Bjorn A