On Mar 27, 7:46 pm, Rob <cbm...@[EMAIL PROTECTED]
> wrote:
> On Mar 21, 1:49 am, Sudhakar Chavali <sudhakar.koundi...@[EMAIL PROTECTED]
>
> wrote:
>
>
>
> > Dear all,
>
> > I wanted to understand pros and cons of choosing MS SQL Server in
Java/
> > J2EE environment.
>
I hate the fact that MSSQL still (SS-2005) does not have standard
timestamp, and one has to use
datetime and smalldatetime. There is no sequence type that can
generate ID which is unique across all tables,
and independent of INSERT command.
I hate that VIEW must be created in separate batch (batch is MSSQL and
Sybase, I think, specific).
I hate that it does not accept word COLUMN in ALTER TABLE ADD COLUMN
x.
I was not able to use SS2000 with Squirrel-SQL and Microsoft JDBC
driver, but it worked with JTDS.
I haven't tried MS driver with SS2005.
SQL server own authentication must be enabled to work with JDBC, as
opposite to "Windows authentication".
TCP connections with static ****t must be configured.
I hate the situation when I transfer data from another server and
connection between login name and username
gets broken (stored procedure sp_change_users_login fixes that).
Otherwise it works fine....
DG
|
