netbeans IDE: how to delete data source

Question

I have a Java Web application that contains a Persistence unit. In this persistence unit I can select an existing data source or create a new data source. When I run this web application on the build in glassfish server, the data source is created on the build in glassfish server. Also a connection pool is created.

I can delete the data source and / or connection pool on the build in glassfish server. This does not delete the data source from the Netbeans IDE. When I run the web application again, the data sources and connection pools are recreated.

How can I delete the data source and connection pools in the netbeans IDE? I can't find this functionality anywhere.

I want to delete the existing data sources and connection pools because I have an problem with a new data source / connection pool. To make sure that there is no mix up happening somewhere between the data sources / connection pools I want to remove the old ones that I am not using anymore.

score 8 · Answer 1 · answered Sep 07 '12 at 10:06

8

You have to go to services window (Ctrl + 5) and expand Severs > GlassFish Server (version) > Resources > JDBC Resources and locate the unnecessary data sources. Right click and select Unregister. This will remove appearing it in all the Netbeans Projects.

answered Sep 07 '12 at 10:06

Buddhika Ariyaratne

2,339
6
51
88

score 5 · Accepted Answer · answered Mar 07 '12 at 13:43

5

The file you are looking for is called glassfish-resources.xml (or sun-resources.xml). It stores all the server resources that are deployed with your application. It can be found in the setup directory of your project (in Netbeans "Files" tag).

answered Mar 07 '12 at 13:43

Matt Handy

29,855
2
89
112

score 1 · Answer 3 · answered Sep 20 '13 at 15:10

1

NetBeans takes the Data Sources from the GlassFish. You can find/edit the domain.xml. Alternatively, you can edit via GF's admin console.

answered Sep 20 '13 at 15:10

X Yang

11
1

deleting in the glassfish admin console worked for me, this can be accessed through the GUI – Joel Clark Nov 23 '13 at 03:46

Ambily · Answer 4 · 2013-10-28T07:09:01.647

1

Go to context.xml and remove the line containing "Resource" entry .

Then remove the corresponding "resource-ref" entry from web.xml.

Then clean and build the project.

This has solved the data source problem for me.

edited Oct 28 '13 at 07:09

answered Oct 26 '13 at 05:29

Ambily

11
2

score 0 · Answer 5 · answered Jun 11 '15 at 16:54

I am using netbeans 8.0.2

In projects tab of left most panel search your project tree. There is a node other resources. Traverse this node please. glassfish-resources.xml is a leaf there under the setup. I found all the jdbc and other resources there.

Means Other Resources -> setup -> glassfish-resources.xml

enter image description here

netbeans IDE: how to delete data source

5 Answers5