Stack Overflow
Stack Overflow

Questions tagged [eclipse-dtp]

Use this tag for questions about the Eclipse Data Tools Platform which provides tools for simplifying database handling.

The Eclipse Data Tools Platform (DTP) provides tools to simplify the handling of databases.

For example the DTP provides an editor for SQL statements or a database browser.

The Data Tools Platform (DTP) project includes extensible frameworks and exemplary tools, enabling a diverse set of plug-in offerings specific to particular data-centric technologies and supported by the DTP ecosystem.

22 questions
10
votes
2 answers

How to disable autocommit in Eclipse Database Tools for Oracle?

I use Eclipse DTP for database queries. The connection is set to autocommit=true by default. I would like to disable autocommit. I read…
anonymous
  • 133
  • 1
  • 8
7
votes
2 answers

How to connect to MySql 8.0 database using Eclipse Database Management Perspective

I wanted to connect to local MySql 8.0 database using Eclipse database tools. But while setting up new database connection profile, I could not find Driver Template for MySql 8.0 . The list only contains Template profile upto MySql JDBC Driver 5.1 .…
Danish Mahmood
  • 487
  • 1
  • 4
  • 9
4
votes
2 answers

How to Connect MySql from Eclipse using Data Source Explorer

I need help. Could you please answer these question? I would like to connect eclipse to my database and I have tried these in eclipse: Window>Show View>Other>Data Source Explorer. After that we get Database Connections under the eclipse and then…
DurgaPrasad Ravula
  • 41
  • 1
  • 1
  • 3
3
votes
2 answers

User-friendly tool to edit databases in Eclipse

Is there any tool in Eclipse comparable with phpMyAdmin? The project is in Java and I want to use H2 database. I have installed DTP but it is not as much user-friendly as phpMyAdmin. I did not find the way to create a table without typing sql query.
bancer
  • 7,475
  • 7
  • 39
  • 58
3
votes
0 answers

Eclipse DTP does not show nvarchar on SQL server

In latest Eclipse (Mars), data sources explorer will not show NVARCHAR types on MS SQL Server data connections. This is true for previous versions as well, along with open-source derivatives such as STS. However, commercial tools such as Rational…
LetsBeFrank
  • 774
  • 11
  • 31
2
votes
2 answers

what driver to use when connecting to Oracle 10 with IBM RAD / Eclipse DTP?

I'm using IBM RAD 7.5.5 (which is basically eclipse 3.4 (ganymede) + plugins). I'm trying to create a connection to Oracle 10 using the "Data Source Explorer" view. When I create a new connection for Oracle, there are three "driver"…
user550738
2
votes
1 answer

eclipse dtp mysql delimiter statement broken.

all. I'm trying to use the eclipse dtp to work on a mySQL DB. Here's the code that's giving an issue: drop function if exists checkTypedness; DELIMITER // create function checkTypedness(nom varchar(255)) returns int reads sql data begin …
Charles McAnany
  • 195
  • 1
  • 2
  • 7
2
votes
2 answers

Eclipse DTP new driver definition

I am trying to connect to Postgresql from Eclipse through Eclipse DTP. I navigated to Window->Preference->Data Management-> Driver Definition After that I chose PostgreSQL and tried to add the driver through the New Driver Definition Template. But…
Anand
  • 21
  • 2
1
vote
0 answers

Get a JDBC query parser instance for use by Eclipse plugin

I've created a simple plugin which successfully uses a DB2 parser from Eclipse's DTP, but it chokes when JDBC syntax such as {d: '2014-07-03'} is used. How can I get a SQLQueryParserManager instance that will handle this syntax? (Currently I'm using…
Brad Mace
  • 27,194
  • 17
  • 102
  • 148
1
vote
0 answers

Extracting SubQuery details using SQLQueryParserManager of Eclipse DTP

I am using eclipse SQLQueryParserManager to extract table name and column names from a sql query. I am getting correct details if I use normal query. But when I use subquery within a query, I am not able to get details of subquery. Here is what I…
Mohit Chawda
  • 53
  • 1
  • 1
  • 8
1
vote
1 answer

Eclipse Data Tools Platform (DTP) Select * limit

I have a DB in Oracle11g and i use Eclipse with Eclipse Data Tools Platform (DTP). I try to select all rows in one table with this select * from ; but it only return 500 rows. There's any way to pass this limitation? Thanks
MarcoM
  • 92
  • 1
  • 10
0
votes
1 answer

Can't connect to Derby database if derby.jar is in Eclipse workspace

I've been trying to create a Derby DB via Eclipse Data Tools Platform and at the beginning I couldn't manage to get it to work.. no matter what I did, I always got the same error: Could not connect to New Derby. Error creating SQL Model Connection…
Alex
  • 301
  • 5
  • 13
0
votes
1 answer

How do I set a login timeout using Eclipse's Data Tools Platform?

I'm trying to set a connection timeout for a project that uses Eclipse's Data Tools Platform. The purpose is to prevent waiting if a database connection takes too long to establish. The project supports several database types. If the project used…
HeroSteve
  • 163
  • 1
  • 6
0
votes
1 answer

getting sun.security.validator.ValidatorException: PKIX path building failed:

Trying to install Eclipse DTP (Data Tools Platform) from Eclipse marketPlace.I am using Eclipse Java Neon. I am getting following exception/error. Unable to read repository at…
Awadesh
  • 3,530
  • 2
  • 20
  • 32
0
votes
1 answer

Eclipse Data Tools Platform (DTP) - MySQL not available

I want to configure MySQL using Data Source Explorer, like here However, MySQL doesn't appear on my list in Eclipse myList How can I fix it ?
arten22
  • 3
  • 2
1
2