Hi Ilkan,
For some reason there was a serializer missing for Clobs (see
https://forge.continuent.org/jira/browse/SEQUOIA-690).
I just committed the missing code for Sequoia 2.10 and 4.0.
Thanks for your feedback,
Emmanuel
I configured sequoia 2.10.9 and did a simple statement with sql client
on one of my tables.
jdbc:sequoia://192.168.107.129:25322/vora (u_ts) > select * from
systemeinstellungen
org.continuent.sequoia.common.exceptions.NotImplementedException:
Backend driver gave an object of an unsupported java
type:_*oracle.sql.CLOB*_, at colum number 4 of name KONTAKTINFO not
implemented
at
org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException.compatibilityWrapperHack(ControllerCoreException.java:83)
at
org.continuent.sequoia.driver.Connection.statementExecuteQuery(Connection.java:2801)
at
org.continuent.sequoia.driver.Statement.executeQuery(Statement.java:522)
at
org.continuent.sequoia.driver.PreparedStatement.executeQuery(PreparedStatement.java:168)
at
org.continuent.sequoia.console.text.module.VirtualDatabaseConsole.execSQL(VirtualDatabaseConsole.java:159)
at
org.continuent.sequoia.console.text.module.VirtualDatabaseConsole.handlePrompt(VirtualDatabaseConsole.java:251)
at
org.continuent.sequoia.console.text.commands.controller.Connect.parse(Connect.java:56)
at
org.continuent.sequoia.console.text.commands.ConsoleCommand.execute(ConsoleCommand.java:107)
at
org.continuent.sequoia.console.text.module.AbstractConsoleModule.handleCommandLine(AbstractConsoleModule.java:375)
at
org.continuent.sequoia.console.text.module.AbstractConsoleModule.handlePrompt(AbstractConsoleModule.java:313)
at
org.continuent.sequoia.console.text.Console.handlePrompt(Console.java:246)
at
org.continuent.sequoia.console.text.ConsoleLauncher.startTextConsole(ConsoleLauncher.java:254)
at
org.continuent.sequoia.console.text.ConsoleLauncher.main(ConsoleLauncher.java:167)
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException:
Backend driver gave an object of an unsupported java
type:oracle.sql.CLOB, at colum number 4 of name KONTAKTINFO not
implemented
I referred the user guide an found this:
"CLOB is a built-in type that stores a Character Large Object as a
column value in a row of a database table. By
default drivers implement Clob using an SQL locator (CLOB), which
means that a Clob object contains a logical
15Sequoia User’s Guide
pointer to the SQL CLOB data rather than the data itself. A Clob
object is valid for the duration of the
transaction in which it was created.
Clobs in Sequoia are handled like strings. You can refer to the
section of code below to make good usage of
clobs. This code is part of the Sequoia test suite.
String clob = "I am a clob";
ps = con.prepareStatement("insert into ... values(...,?)");
ps.setString(1, clob);
ps.executeUpdate();
// Test retrieval
String ret;
ps = con.prepareStatement("Select * from ... where id=...");
rs = ps.executeQuery();
rs.first();
clob = rs.getClob("name");
ret = clob.getSubString((long) 0, (int) clob.length());"
Does Sequoia supports CLOBs or not?
Thanks
Ilkan
<<...>> <<...>>
*/Ilkan Akcakaya/*
Auel EDV-Beratung GmbH
Wendentorwall 10 & 26
38100 Braunschweig
Tel: 05 31-2 43 93 -0
Fax: 05 31-2 43 93 -33
_http://www.auel.de_
------------------------------------------------------------------------
_______________________________________________
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
