Could database mirroring make an application fail?

Hello!
We have a Java application where some things are indicating that it can not
run against a SQL Server 2005 database when database mirroring is enabled.
We're getting an error message in the application.
SQLState:HY000 ErrorCode:0 [DataDirect][SQLServer JDBC
Driver][DataDirect][SQLServer JDBC Driver]Unhandled token type: Unknown
token: 0x54
java.sql.SQLException: [DataDirect][SQLServer JDBC
Driver][DataDirect][SQLServer JDBC Driver]Unhandled token type: Unknown
token: 0x54
In Profiler we can see a successfull login and then nothing more.
Is SQL Server returning some extra information if database mirroring is
enabled that could make a badly coded application / driver fail?
Best regards
Ola
It could be possible, however I don't think so. The mirroring uses service
broker to send the transactions to the remote machine.
Unless the java application is receiving the mirror partner information and
doesn't know what to do with it.
I would recommend getting a network sniffer and then having the app log into
a non-mirrored database, then a morrored database and see what the differenes
in the actual network traffic are. If you could post back your results it
may be helpfull to others.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Ola Hallengren" wrote:

> Hello!
> We have a Java application where some things are indicating that it can not
> run against a SQL Server 2005 database when database mirroring is enabled.
> We're getting an error message in the application.
> SQLState:HY000 ErrorCode:0 [DataDirect][SQLServer JDBC
> Driver][DataDirect][SQLServer JDBC Driver]Unhandled token type: Unknown
> token: 0x54
> java.sql.SQLException: [DataDirect][SQLServer JDBC
> Driver][DataDirect][SQLServer JDBC Driver]Unhandled token type: Unknown
> token: 0x54
> In Profiler we can see a successfull login and then nothing more.
> Is SQL Server returning some extra information if database mirroring is
> enabled that could make a badly coded application / driver fail?
> Best regards
> Ola