Hi there I have been reading some posts about this recurrent error, but I do not know how solve it.
I am running MySql 5.0.24a-9 Sequoia 2.10.1 DataBase creation script Instead of TEXT I tried as well with VARCHAR(100), but I have the same problem CREATE TABLE LogTable ( log_id BIGINT NOT NULL UNIQUE, vlogin TEXT NOT NULL, ssql TEXT NOT NULL, auto_conn_tran CHAR(1) NOT NULL, transaction_id BIGINT NOT NULL, request_id BIGINT, exec_time BIGINT, update_count INT, PRIMARY KEY (log_id) ); CREATE TABLE CheckpointTable ( name TEXT NOT NULL, log_id BIGINT ); CREATE TABLE BackendTable ( database_name TEXT NOT NULL, backend_name TEXT NOT NULL, backend_state INTEGER, checkpoint_name TEXT NOT NULL ); CREATE TABLE DumpTable ( dump_name TEXT NOT NULL, dump_date TIMESTAMP, dump_path TEXT NOT NULL, dump_format TEXT NOT NULL, checkpoint_name TEXT NOT NULL, backend_name TEXT NOT NULL, tables TEXT NOT NULL ); ################################################ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.1//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.1.dtd";> <SEQUOIA> <VirtualDatabase name="ITECBAN_DB"> <Monitoring> <SQLMonitoring defaultMonitoring="off"> <SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/> </SQLMonitoring> </Monitoring> <AuthenticationManager> <!-- Administrador para la consola de adminsitracion --> <Admin> <User username="admin" password="admin"/> </Admin> <!-- Usuario virtual que usa nuestra aplicacion cliente para acceder a la bbdd virtual--> <VirtualUsers> <VirtualLogin vLogin="itecban" vPassword="itecban"/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="aolias.indra.es" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://aolias.indra.es/ITECBAN_DB" connectionTestStatement="select 1"> <ConnectionManager vLogin="itecban" rLogin="itecbanITECBAN_DB" rPassword="itecban"> <VariablePoolConnectionManager initPoolSize="40"/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <SingleDBScheduler level="passThrough"/> </RequestScheduler> <RequestCache> <MetadataCache/> <ParsingCache/> <ResultCache granularity="table"/> </RequestCache> <LoadBalancer> <SingleDB/> </LoadBalancer> <RecoveryLog driver="org.continuent.sequoia.driver.Driver" url="jdbc:cjdbc://aolias.indra.es/ITECBAN_RECOVERY_DB" login="itecban" password="itecban"> <RecoveryLogTable tableName="LogTable" sqlColumnName="ssql"/> <CheckpointTable tableName="CheckpointTable"/> <BackendTable tableName="BackendTable"/> <DumpTable tableName="DumpTable"/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA> ################################################ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 1.0//EN" "http://www.objectweb.org/c-jdbc/dtds/c-jdbc-2.10.1.dtd";> <SEQUOIA> <VirtualDatabase name="ITECBAN_RECOVERY_DB"> <AuthenticationManager> <Admin> <User username="admin" password="admin"/> </Admin> <VirtualUsers> <VirtualLogin vLogin="itecban" vPassword="itecban"/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="ITECBAN_RECOVERY_DB" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://aolias.indra.es/ITECBAN_RECOVERY_DB" connectionTestStatement="select 1"> <ConnectionManager vLogin="itecban" rLogin="itecban" rPassword="itecban"> <VariablePoolConnectionManager initPoolSize="5"/> </ConnectionManager> </DatabaseBackend> <RequestManager caseSensitiveParsing="false"> <RequestScheduler> <SingleDBScheduler level="passThrough"/> </RequestScheduler> <LoadBalancer> <SingleDB/> </LoadBalancer> </RequestManager> </VirtualDatabase> </SEQUOIA> ################################################ <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER 2.10.1//EN" "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.1.dtd";> <SEQUOIA-CONTROLLER> <Controller port="25322"> <Report hideSensitiveData="true" generateOnShutdown="true" generateOnFatal="true" enableFileLogging="true" /> <JmxSettings> <RmiJmxAdaptor/> </JmxSettings> <VirtualDatabase configFile="itecban-recovery-mysql.xml" virtualDatabaseName="ITECBAN_RECOVERY_DB"/> <VirtualDatabase configFile="itecban-mysql.xml" virtualDatabaseName="ITECBAN_DB"/> </Controller> </SEQUOIA-CONTROLLER> ################################################ Thanks in advance Alfonso _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
