Thanx Emmanuel.
I tried something else and it is working now.Following
changes i made:
1) Drivername =
"com.microsoft.sqlserver.jdbc.SQLServerDriver"
2)url=
jdbc:sqlserver://127.0.0.1:1433;DatabaseName=Livestock;
The property of SelectMethod i have removed from url.
copied sqljdc1.1.jar file to driver folder of sequoia.
After doing these changes controller is loading
without any errors.
But i m getting one message which was not coming
earlier:
"WARN backend.DatabaseBackend.LivestockDB
Statement.getGeneratedKeys not supported"
can you tell me what is this message and whether there
will be any impact due to this message?
Regards,
Abdul
--- Emmanuel Cecchet <[EMAIL PROTECTED]> wrote:
> Hi,
> > After making the changes in log4j.properites file
> as
> > suggested by you, following is the complete error:
> >
> > 2008-03-18 19:48:40,296 ERROR
> > backend.DatabaseBackend.LivestockDB Test statement
> > Select 1 is invalid (Select 1)
> > java.sql.SQLException: [Microsoft][SQLServer 2000
> > Driver for JDBC][SQLServer]The incoming tabular
> data
> > stream (TDS) remote procedure call (RPC) protocol
> > stream is incorrect. Parameter 1 (""): Data type
> 0x38
> > is unknown.
> >
> The message says it all. You connection test
> statement is invalid.
> Looks like 'select 1' does not work with your
> config, I looked into the
> examples for MS SQL in the Sequoia distribution and
> it looks like you
> can use 'select type from master.dbo.syscharsets'
>
> Hope this helps,
> Emmanuel
>
> --
> Emmanuel Cecchet - Research scientist
> EPFL - LABOS/DSLAB - IN.N 317
> Phone: +41-21-693-7558
>
> _______________________________________________
> Sequoia mailing list
> [email protected]
>
https://forge.continuent.org/mailman/listinfo/sequoia
>
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
