I have opened a console client to a controller and conencted to the
virtual database. And I have some weird behaviour
Why seems to fail several times a select and then is executed? or why
the select works and not the insert? I have tested those queries in
a SQL client and work.
What could be missconfigured in my controller/virtual database?
Thanks in advance
Alfonso
jdbc:sequoia://aolias.indra.es/ITECBAN_DB (itecban) > select * from
prbgrid.people
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Query 18 is not in the list of currently scheduled
queries)
jdbc:sequoia://aolias.indra.es/ITECBAN_DB (itecban) > select * from
prbgrid.people
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Query 19 is not in the list of currently scheduled
queries)
jdbc:sequoia://aolias.indra.es/ITECBAN_DB (itecban) > select * from
prbgrid.people
+------------------------+---------------------------+---------------------------+
| ID | FIRST_NAME | SECOND_NAME
|
+------------------------+---------------------------+---------------------------+
| 19 | Carmelo | Coton
|
| 34 | Felipe | Lotas
|
| 35 | Felipe | Lotas
|
| 36 | Felipe | Lotas
|
| 37 | Felipe | Lotas
|
| 38 | Felipe | Lotas
|
| 6 | Roger | Whitney
|
| 7 | Roger | Whitney
|
| 8 | Carmelo | Coton
|
| 9 | Manolito | Gafotas
|
| 10 | Manolito | Gafotas
|
| 11 | Manolito | Gafotas
|
| 12 | Manolito | Gafotas
|
+------------------------+---------------------------+---------------------------+
Query executed in 0 s 10 ms .
jdbc:sequoia://aolias.indra.es/ITECBAN_DB (itecban) > insert into
prbgrid.people (first_name, second_name, id) values ('Felipe',
'Lotas', people_seq.nextval)
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unknown table 'prbgrid.people' in this INSERT
statement: 'insert into prbgrid.people (first_name, second_name, id)
values ('Felipe', 'Lotas', people_seq.nextval)')
jdbc:sequoia://aolias.indra.es/ITECBAN_DB (itecban) >
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
