Questions tagged [apache-metamodel]

The Apache Metamodel project provides a common interface for discovery, exploration of metadata and querying of different types of data sources.

Project Homepage: https://metamodel.apache.org/

47 questions
6
votes
0 answers

Sybase throws Exception "there is already another cursor with the name XXX" when Executing SELECT Query in multi-threading environment

I am using ApacheMetaModel to Extract the data from Sybase ASE 15.5 database that installed on Windows 7 machine. I am Extracting data into CSV in multi-threading environment. I using these open source libraries
Ashish Pancholi
  • 4,569
  • 13
  • 50
  • 88
4
votes
1 answer

Forward slash in column name throwing an incorrect syntax "/"

I am trying to execute insert query using Apache meta model on a sql server database - Where insert query contains a column name with forward slash(/) in it such as 'col4a/col4b' and query will be created by metamodel as INSERT INTO dbo."table1"…
Geetanjali Jain
  • 402
  • 6
  • 19
4
votes
2 answers

updating an excel file with apache metamodel

I'm trying to incorporate Apache MetaModel into a project and keep running into a weird problem. I update an Excel spreadsheet row in code. The code finds the right row, deletes it, then appends the row (with my update) to the bottom of the…
dlunday
  • 41
  • 2
3
votes
1 answer

Apache Metamodel vs Apache Drill

Apache MetaModel is a data access framework that provides a common interface for the discovery, exploration, and querying of different types of data sources. Apache Drill is a schema-free SQL query engine that delivers real-time insights by removing…
Swappy
  • 63
  • 2
  • 7
3
votes
0 answers

How to write a blob data into a text file (i.e into CSV) and that should be restore back into the oracle database as a BLOB?

I am using ApacheMetaModel to Extract and Restore the data from Oracle database. I am Extracting data into CSV and Restoring the data back from CSV into database. Few Tables has an Clob and Blob data. When Extracting the data from Oracle, I am…
Ashish Pancholi
  • 4,569
  • 13
  • 50
  • 88
3
votes
0 answers

how I execute create view query using DataContext of apache meta modal?

I have created a sample program using the DataContext class to get records from an oracle11g table, and write its data to CSV file. Here is my code for getting table and write into a CSV. UpdateableDataContext dataContext =…
Parita Porwal
  • 180
  • 1
  • 3
  • 15
2
votes
1 answer

how to insert data into csv file using apche meta model?

I am working in java project and i am using apache metamodel to insert data into csv file. Code: public void insertIntoCSVFile(){ File myFile = new File("unexisting_file.csv"); UpdateableDataContext dataContext =…
santosh
  • 435
  • 1
  • 7
  • 24
2
votes
0 answers

How to find if a column is computed column or not using apache metamodel?

I am using SQL Server 2008 R2 with Java Apache metamodel. In SQL Server, I can find if a tables's column is computed or not using the following query:- SELECT * FROM sys.columns WHERE is_computed = 1 AND object_id = OBJECT_ID('YourTableName') But…
Mamta Vyas
  • 93
  • 1
  • 2
  • 9
2
votes
1 answer

To get value of oracle.sql.TIMESTAMPLTZ@70156e7b

I am working on Oracle 11g Enterprises Edition database. We have to get the data from database tables. Database tables have one of these types of columns : TIMESTAMPLTZ TIMESTAMPTZ All other data types and their values are successfully…
Neelam Sharma
  • 2,745
  • 4
  • 32
  • 73
1
vote
1 answer

Apache Metamodel has retired. Alternatives?

Apache Metamodel has moved to the attic. why it is moved and what are the alternatives?
1
vote
0 answers

How to delete date time data from csv using apache metamodel?

I am working on java project in which i am creating csv file using apache metamodel. Code is: public class CsvDemo { private static String tableName = null; private static UpdateableDataContext dataContext = null; public…
santosh
  • 435
  • 1
  • 7
  • 24
1
vote
2 answers

The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database

I am working on java project in which i am using Sybase and Apache Metamodel to get table data and its information.Now "ddl in tran" option is true but still when i get columns details using Apache Metamodel its giving me…
santosh
  • 435
  • 1
  • 7
  • 24
1
vote
0 answers

5.2.0 version of Apache Meta Model failing with required dependency of org.postgresql.util package

I was trying to upgrade the Apache meta model from 4.5.3 to 5.2.0 in my OSGI setup, but it failed since it is looking for org.postgresql.util to be exported by some bundle i.e the 5.2.0 has dependency on org.postgresql.util package.After I provided…
Ratish Bansal
  • 1,982
  • 1
  • 10
  • 19
1
vote
0 answers

Inheritance with Metamodel Java

In my application I have some entities which are extended from User class. User has firstName and lastName fields. There is a search for each entity extended from User. To implement search I'm using Criteria API. As we are talking about the same…
1
vote
1 answer

How can I joins multiple tables in Apache MetaModel?

I need to apply joins on multiple tables in Apache MetaModel. I searched through google but did not find anything related. Can some help me out on this?
niteshpandey
  • 25
  • 2
  • 6
1
2 3 4