Hi there,
No that's not available. But you do get something quite equivalent with
this:
Table table = dataContext.getTableByName("us_south_es_etg");
dataContext.executeUpdate(callback -> {
try (DataSet ds =
dataContext.query().from("us_south").selectAll().execute()) {
while (ds.next()) {
Hello,
Using Metamodel, is it possible to build an INSERT statement that is paired
with a SELECT subquery? For example:
INSERT TABLE `us_south_es_etg`
SELECT
`lon`,
`lat`,
`number`,
`street`,
`unit`,
`city`,
`district`,
`region`,
`postcode`,
`id`,
`hash`
FROM us
Hi Gowri,
Looks like your code is almost there. It's querying the excel file, just
not inserting anything into Postgres. Correct?
You just need to make those insert using the "dc" object (which seems to be
your postgres database):
dc.executeUpdate(callback -> {
callback.insert(...)
});
2018-01
Respected Sir/Madam,
We are implementing Apache Metamodel for getting Excel Sheet Data to
Postgresql Table . I am enclosing here with the code we have written for the
above and the output we got after running the class file on console using
Eclipse Oxygen
Please see the attached file and give