[jbosstools-issues] [JBoss JIRA] (JBDS-2852) Database/source/connection Usability

[Max Rydahl Andersen (JIRA)]

    [ https://issues.jboss.org/browse/JBDS-2852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12968362#comment-12968362 ] 

Max Rydahl Andersen commented on JBDS-2852:
-------------------------------------------

okey so Teiids' solution requires Teiid to be installed - not something that we can unfortunately reuse or rely on.

For now I see that we are very close on having DTP be the "hub" of these things in Eclipse because of the following:
1) hibernate, seam, etc. projects support DTP
2) forge now expose DTP connections in forge 2 
3) datasource wizard creates datasource files based on DTP info

The last thing missing is that we can take a DTP connection and setup in EAP/AS7 via management API
AND take a datasource as defined in EAP/AS7 and make a dtp connection out of it.

This data is available here:
http://wildscribe.github.io/Wildfly/8.0.0.Final/subsystem/datasources/data-source/ExampleDS/index.html

[~akazakov] is this something we could look at integrating into the datasource wizard?
and/or [~rob.stryker] could we expose these more directly under EAP servers as nodes one could use/setup?

> Database/source/connection Usability
> ------------------------------------
>
>                 Key: JBDS-2852
>                 URL: https://issues.jboss.org/browse/JBDS-2852
>             Project: Developer Studio (JBoss Developer Studio)
>          Issue Type: Epic
>      Security Level: Public(Everyone can see) 
>          Components: integration, requirements
>            Reporter: Burr Sutter
>              Labels: QE_JBDS80_needinfo
>
> Connecting to a database from within JBDS/Eclipse is a multi-step, multi-screen, potentially error-prone challenge.    
> Forge is involved as it can generate entities from schema
> Datasources are needed in/on AS/Wildfly/EAP in order for the project deploy
> Persistence.xml may needed to be tweaked for the datasource
> End-user would like to navigate the schema in the DTP/Hibernate Tools, interactively review the data and there was once a feature for viewing an ORM diagram that I seem to have forgotten how it is displayed.
> What happens when a project that needs a database connection is imported into the IDE? 
> This was partially addressed with
> https://issues.jboss.org/browse/JBIDE-15263
> Let's see if we can continue to improve the workflow by reducing steps, making it more obvious what steps are required (e.g. hey developer, get the mysql driver .jar), auto generating the -ds.xml, with a decent explanation for the end-user to follow.



--
This message was sent by Atlassian JIRA
(v6.2.3#6260)