Hi Emmanuel,
After making the changes in log4j.properites file as
suggested by you, following is the complete error:
2008-03-18 19:48:32,187 INFO
controller.core.Controller Sequoia controller (3.0)
2008-03-18 19:48:32,703 INFO
controller.core.Controller Loading configuration file:
/C:/sequoia-3.0-bin/config/controller/controller.xml
2008-03-18 19:48:32,921 INFO
controller.core.Controller JMX is enabled
2008-03-18 19:48:32,953 INFO
controller.core.Controller Starting JMX server on
host: 0.0.0.0:1090
2008-03-18 19:48:35,125 INFO
backup.backupers.OctopusBackuper OctopusBackuper
backup compression is set to true
2008-03-18 19:48:35,125 INFO
controller.backup.BackupManager Registering backuper
Octopus to handle format Octopus v3.4.1 database
neutral dump compressed
2008-03-18 19:48:37,234 INFO
backend.DatabaseBackend.LivestockDB Adding connection
manager for virtual user "iboss"
2008-03-18 19:48:37,281 INFO
controller.RequestManager.Livestock Request manager
will parse requests with the following granularity:
NO_PARSING
2008-03-18 19:48:37,281 WARN
controller.virtualdatabase.Livestock No recovery log
has been configured, enabling backend without
checkpoint.
2008-03-18 19:48:40,234 DEBUG
backend.DatabaseBackend.LivestockDB Connection test
OK.
2008-03-18 19:48:40,234 DEBUG
backend.DatabaseBackend.LivestockDB
Connection.setTransactionIsolation(SERIALIZABLE) test
OK.
2008-03-18 19:48:40,250 DEBUG
backend.DatabaseBackend.LivestockDB
Connection.getMetaData test OK.
2008-03-18 19:48:40,250 INFO
backend.DatabaseBackend.LivestockDB Detected backend
as: Microsoft SQL Server
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.
at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.execute(Unknown
Source)
at
org.continuent.sequoia.controller.backend.DriverCompliance.complianceTest(DriverCompliance.java:209)
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriverCompliance(DatabaseBackend.java:557)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.getAndCheckBackend(VirtualDatabase.java:2059)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableBackend(VirtualDatabase.java:1871)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackends(VirtualDatabase.java:1755)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackendsFromCheckpoint(VirtualDatabase.java:1775)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(Controller.java:290)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:652)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528)
at
org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at
org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:269)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:318)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:220)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:372)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:564)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:308)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at
org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at
org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:121)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:171)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:200)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:232)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:288)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:314)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:759)
2008-03-18 19:48:40,296 WARN
controller.virtualdatabase.Livestock Error while
initalizing database backend LivestockDB
(java.sql.SQLException: Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver is not
Sequoia compliant)
java.sql.SQLException: Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver is not
Sequoia compliant
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriverCompliance(DatabaseBackend.java:560)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.getAndCheckBackend(VirtualDatabase.java:2059)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.forceEnableBackend(VirtualDatabase.java:1871)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackends(VirtualDatabase.java:1755)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.enableAllBackendsFromCheckpoint(VirtualDatabase.java:1775)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(Controller.java:290)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:652)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528)
at
org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at
org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:269)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:318)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:220)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:372)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:564)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:308)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at
org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at
org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:121)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:171)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:200)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:232)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:288)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:314)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:759)
Any how i will try with FreeTDS driver and let you
know the status.
Thanx,
Abdul
--- Emmanuel Cecchet <[EMAIL PROTECTED]> wrote:
> Hi Abdul,
>
> One option would be to use FreeTDS driver as it is
> known to work with
> Sequoia/MS SQL.
> Otherwise to get more information about the root
> cause of the error, you
> will have to set the
>
'org.continuent.sequoia.controller.backend.DatabaseBackend'
> logger in
> log4j.properties to DEBUG.
> Replace:
>
log4j.logger.org.continuent.sequoia.controller.backend.DatabaseBackend=INFO,
>
> Console,Filetrace
> by
>
log4j.logger.org.continuent.sequoia.controller.backend.DatabaseBackend=DEBUG,
>
> Console,Filetrace
>
> Keep us posted with your progress,
> Emmanuel
>
> > Can any one help me in sorting out this issue??
> Still
> > not able to use Sequoia with SQL Server 2005. I m
> in a
> > process to migrate from sql 2000 to sql 2005.
> Because
> > of this issue i am not able to migrate.
> >
> > Regards,
> > Abdul
> >
> > Note: forwarded message attached.
> >
> >
> >
> >
>
____________________________________________________________________________________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search.
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> >
> >
>
------------------------------------------------------------------------
> >
> > Subject:
> > Re: [Sequoia] SQLDriver not compatible with
> Sequoia
> > From:
> > abdul qaiyum <[EMAIL PROTECTED]>
> > Date:
> > Tue, 11 Mar 2008 22:38:54 -0700 (PDT)
> > To:
> > Sequoia general mailing list
> <[email protected]>
> >
> > To:
> > Sequoia general mailing list
> <[email protected]>
> >
> >
> > Hi,
> >
> > Thanx for your reply. I have done the following
> > configuration:
> >
> > <VirtualDatabase name="Livestock">
> > <Backup>
> > <Backuper backuperName="Octopus"
> >
> >
>
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
> > options="zip=true"/>
> > </Backup>
> >
> > <AuthenticationManager>
> > <AdminUser username="admin" password=""/>
> > <VirtualUser vLogin="iboss" vPassword="">
> > <AccessControl defaultPolicy="denyAll">
> > <Accept address="127.0.0.1">
> > </Accept>
> > </AccessControl>
> > </VirtualUser>
> > </AuthenticationManager>
> >
> > <DatabaseBackend name="LivestockDB"
> >
>
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
> >
> >
>
url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Livestock;SelectMethod=Cursor;"
> > connectionTestStatement="Select 1">
> > <ConnectionManager vLogin="iboss"
> rLogin="sa"
> > rPassword="aoLKvVCCwHc=">
> > <VariablePoolConnectionManager
> > initPoolSize="10" minPoolSize="5"
> > maxPoolSize="100" idleTimeout="30"
> > waitTimeout="10"/>
> > </ConnectionManager>
> > </DatabaseBackend>
> >
> > I tried changing the
> >
>
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> > and url="jdbc:sqlserver". In this case it is
> giving
> > the error in loading the drivers.
> >
> > Please let me know,can we use Sequoia with SQL
> Server
> > 2005. If yes, then what should be the
> configuration.
> > Your help will be highly appreciated.
> >
> > Regards,
> > Shaikh Abdul Qaiyum.
> > --- Emmanuel Cecchet <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >> Hi,
> >>
> >>
> >>> java.sql.SQLException: Driver
> >>> com.microsoft.jdbc.sqlserver.SQLServerDriver is
> >>>
> >> not
> >>
> >>> Sequoia compliant
> >>> at
> >>>
> >>>
> >
>
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriverCompliance(DatabaseBackend.java:560)
> >
> >>>
> >>>
> >> This is probably just a configuration problem in
> >> your connection
> >> definition.
> >> You can get that kind of error if the controller
> >> cannot connect to the
> >> backend.
> >>
> >> Do you have other error messages?
> >> How did you configuration your backend?
> >>
> >> Thanks for your interest in Sequoia,
> >> Emmanuel
> >> _______________________________________________
> >> Sequoia mailing list
> >> [email protected]
> >>
> >>
> >
>
https://forge.continuent.org/mailman/listinfo/sequoia
> >
>
>
> --
> 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
>
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
