-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Thanks for the response. Now everything has sense again :)
Emmanuel Cecchet escribió:
> Hi Ruben,
>
> The console commands must not be terminated by a semicolon. Everything
> you type is passed as is to Statement.execute(). In your case, it will
> try to do Statement.execute("drop table test5;") which of course will
> fail since this is not correct SQL (no table can be named test5;).
> Removing the semicolons should solve your problem.
> The only case where semicolons can be used, it for inline batch
> statements where you try to put multiple SQL statements in a single
> execution. In that case the statements must be separated by semicolons,
> but this practice is strongly discouraged.
>
> Hope this helps,
> Emmanuel
>
>> I just installed sequoia and I am testing it. I am able to execute
>> select statements, create statements but it fails with DROP.
>>
>> I have set up one controller with two backends. I have fully followed
>> the Installation and configuration guide. To replicate data at the send
>> back end I dump / restore. (vacadbdummydummy is the first backend and
>> vacadbdummydummy2 is the second backend)
>>
>> I am using the sequoia SQL client:
>>
>> Create table seems ok:
>> jdbc:sequoia://127.0.0.1:25322/vvacadb (vaca) > CREATE table test5 (i
>> int );
>> Affected rows: 0
>> Query executed in 0 s 90 ms .
>>
>> Log:
>> 15:03:15,799 INFO DatabaseBackend.vvacadb.vacadbdummydummy2 Checking
>> compatibility with existing database schema
>> 15:03:15,833 WARN DatabaseBackend.vvacadb.vacadbdummydummy2 Gathered
>> schema for login "vaca" is not compatible with existing shema. Keeping
>> current schema.
>>
>> Drop table fails:
>> jdbc:sequoia://127.0.0.1:25322/vvacadb (vaca) > DROP table test5;
>> An error occured while executing SQL query
>> (org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
>> Message of cause: Unknown table 'test5;' in this DROP statement 'DROP
>> table test5;')
>>
>> Log:
>> 15:06:07,023 WARN controller.virtualdatabase.vvacadb Distributed
>> request DROP table test5;/ did not remove itself from the total order
>> queue
>> 15:06:07,058 INFO controller.RequestManager.vvacadb Request 24 failed
>> on controller Member(address=/192.168.12.8:50461, uid=vvacadb)
>> (java.sql.SQLException: Unknown table 'test5;' in this DROP statement
>> 'DROP table test5;')
>> 15:06:07,128 INFO virtualdatabase.VirtualDatabaseWorkerThread.vvacadb
>> Error during command execution (Unknown table 'test5;' in this DROP
>> statement 'DROP table test5;')
>>
>> I have no idea about what to try next to get DROP working. I have google
>> and I get nothing.
>>
>> Any ideas?
>>
>>
>> Sequoia version: 2.10.10
>> Postgres version: 8.2
>> Postgres JDBC: 8.2-509
>>
>>
>> Thanks in advance,
>> Ruben
>>
>>
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.6 (GNU/Linux)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>>
>> iD8DBQFJR7cpIo1XmbAXRboRAm1CAJsEY5hqRTVlhJHUdVN+UWJ7hZwN9QCeKoZH
>> HMOgqyd4Qhw6Ph4gaF5UAbw=
>> =3JpU
>> -----END PGP SIGNATURE-----
>> _______________________________________________
>> Sequoia mailing list
>> [email protected]
>> https://forge.continuent.org/mailman/listinfo/sequoia
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJSKYLIo1XmbAXRboRArgyAJ9pgHCzIfrmAwNmYrEOFkbrIbH+QQCfcwQU
9LcwtTWRHIBL4vZRDtuvOCY=
=tf3Z
-----END PGP SIGNATURE-----
begin:vcard
fn:Ruben Rubio
n:Rubio;Ruben
org:Rentalia Holidays S.L
adr;quoted-printable:;;Gran v=C3=ADa 31, 9=C2=BA-1=C2=BA;Madrid;;;Spain
email;internet:[email protected]
tel;work:+34915233104
url:http://www.rentalia.com
version:2.1
end:vcard
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
