Deploy postgres driver with application [-> no copy to modules directory]

[a.bader]

I should be able to deploy a .war file, which uses a postgres datasource. But since I have no access to the wildfly's directory and neither to the CLI, I wonder how I can bring Wildfly to use the jdbc driver for the postgres datasource (I can configure the datasource either with a xxx-ds.xml or via standalone.xml). So is it possible to include it in the applications war file and how? Or what can I do in such situation?

Thanks for your help!

[mayerw01]

In a stanalone environment you may install the driver jar as a regular deployment

[a.bader]

Thanks, Wolfgang, for your answer. Yes indeed, this is also possible. But this uses also a second action outside of own application. So I really wonder, why we cannot include the jdbc driver jar in the own application?! Or can we?

[zhurlik]

I am not sure maybe it makes sense to look at JMX to be able to manage subsystems...

[mayerw01]

Yes, of course you can include your jdbc driver in your war file. But since the datasource is defined in JBoss you will have to configure the driver in JBoss if you want to use the datasource (eg via JPA). But indeed there is no need to use the datasource. You may also use the JDBC driver driver directly (loading the driver via Class.forName() and DriverManager.getConnection()). This should also work.

[a.bader]

We can also define a datasource by including a xxx-ds.xml file. So we can decouple datasource config from JBoss. But it seems that with this datasource definition in a xxx-ds.xml file, only drivers from modules directory or already deployed drivers will be taken. So it would be nice, if we could point in the xxx-ds.xml to a jdbc driver in own .war. Can we?

[mayerw01]

I understand your problem is not to add the datasource definition but to configure the driver.

You will first have to add the driver via cli (/subsystem=datasources/jdbc-driver=postgresql:add(driver-name=...)

But you cannot add the driver as long as the driver is not deployed to JBoss.

[a.bader]

Thanks Wolfgang. I feared to get this answer...