Required services that are not installed:" => ["jboss.naming.context.java.global.jdbc.deneme2DS

Ebuzer Taha Kanat

unread,

Jan 27, 2024, 3:36:01 PM1/27/24

to WildFly

Here is my setup:

DataSourceConfig.java

import jakarta.annotation.sql.DataSourceDefinition;
import jakarta.ejb.Singleton;

@Singleton
@DataSourceDefinition(
    name = "java:global/jdbc/deneme2DS",
    className = "org.h2.jdbcx.JdbcDataSource",
    url = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1",
    user = "sa",
    password = "sa"
)
public class DataSourceConfig {
    // This class can be empty, as it only serves to define the DataSource
    // The DataSource will be automatically registered when this class is loaded
}


persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1"
   xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
                       http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
   <persistence-unit name="primary">
      <!-- Use a portable JNDI name for the datasource -->
      <jta-data-source>java:global/jdbc/deneme2DS</jta-data-source>
      <properties>
         <!-- Properties for Hibernate -->
         <property name="hibernate.hbm2ddl.auto" value="create-drop" />
         <property name="hibernate.show_sql" value="false" />
      </properties>
   </persistence-unit>
</persistence>


here is the log 

20:26:07,298 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "deneme2-ear.ear")]) - failure description: {
    "WFLYCTL0412: Required services that are not installed:" => ["jboss.naming.context.java.global.jdbc.deneme2DS"],
    "WFLYCTL0180: Services with missing/unavailable dependencies" => [
        "jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\".__FIRST_PHASE__ is missing [jboss.naming.context.java.global.jdbc.deneme2DS]",
        "jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\" is missing [jboss.naming.context.java.global.jdbc.deneme2DS]"
    ]
}

where is the problem

Ebuzer Taha Kanat

unread,

Jan 27, 2024, 3:41:14 PM1/27/24

to WildFly

I'm using

jboss/wildfly

Docker image

27 Ocak 2024 Cumartesi tarihinde saat 23:36:01 UTC+3 itibarıyla Ebuzer Taha Kanat şunları yazdı:

Ebuzer Taha Kanat

unread,

Jan 27, 2024, 5:33:45 PM1/27/24

to WildFly

This configuration works for payara but not wildfly here it is:
persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1"
	xmlns="http://xmlns.jcp.org/xml/ns/persistence"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
                       http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
	<persistence-unit name="primary">
		<!-- Use a portable JNDI name for the datasource -->
		<jta-data-source>java:global/jdbc/deneme2DS</jta-data-source>
		<properties>
			

			<property
				name="jakarta.persistence.schema-generation.database.action"
				value="drop-and-create" />
			<property name="jakarta.persistence.sql-load-script-source"
				value="import.sql" />
				<!-- Properties for Hibernate 
			<property name="hibernate.show_sql" value="false" /> -->
		</properties>
	</persistence-unit>
</persistence>

DataSourceConfig class

package deneme2.deneme2.config;

import jakarta.annotation.sql.DataSourceDefinition;
import jakarta.ejb.Singleton;

@Singleton
@DataSourceDefinition(
    name = "java:global/jdbc/deneme2DS",
    className = "org.h2.jdbcx.JdbcDataSource",
    url = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1",
    user = "sa",
    password = "sa"
)
public class DataSourceConfig {
    // This class can be empty, as it only serves to define the DataSource
    // The DataSource will be automatically registered when this class is loaded
}

here is the exception thrown from wildfly

22:29:40,856 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "deneme2-ear.ear")]) - failure description: {

"WFLYCTL0412: Required services that are not installed:" => ["jboss.naming.context.java.global.jdbc.deneme2DS"],
"WFLYCTL0180: Services with missing/unavailable dependencies" => [
"jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\".__FIRST_PHASE__ is missing [jboss.naming.context.java.global.jdbc.deneme2DS]",
"jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\" is missing [jboss.naming.context.java.global.jdbc.deneme2DS]"
]
}

I think it is a bug from Wildfly side.

27 Ocak 2024 Cumartesi tarihinde saat 23:41:14 UTC+3 itibarıyla Ebuzer Taha Kanat şunları yazdı:

Ebuzer Taha Kanat

unread,

Jan 28, 2024, 10:30:09 AM1/28/24

to WildFly

Changed persistence.xml to jpa 3 but same error appears

<?xml version="1.0" encoding="UTF-8"?>

<persistence xmlns="https://jakarta.ee/xml/ns/persistence"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="https://jakarta.ee/xml/ns/persistence https://jakarta.ee/xml/ns/persistence/persistence_3_0.xsd"
	version="3.0">

	<persistence-unit name="primary">
		<!-- Use a portable JNDI name for the datasource -->
		<jta-data-source>java:global/jdbc/deneme2DS</jta-data-source>
		<properties>

			<property
				name="jakarta.persistence.schema-generation.database.action"
				value="drop-and-create" />
			<property name="jakarta.persistence.sql-load-script-source"
				value="import.sql" />
			<!-- Properties for Hibernate <property name="hibernate.show_sql" value="false" 
				/> -->
		</properties>
	</persistence-unit>
</persistence>

28 Ocak 2024 Pazar tarihinde saat 01:33:45 UTC+3 itibarıyla Ebuzer Taha Kanat şunları yazdı:

Ebuzer Taha Kanat

unread,

Jan 28, 2024, 10:48:56 AM1/28/24

to WildFly

I have posted on Stack overflow https://stackoverflow.com/questions/77895371/required-services-that-are-not-installed-jboss-naming-context-java-global

28 Ocak 2024 Pazar tarihinde saat 18:30:09 UTC+3 itibarıyla Ebuzer Taha Kanat şunları yazdı:

Scott Marlow

unread,

Jan 28, 2024, 2:07:53 PM1/28/24

to Ebuzer Taha Kanat, WildFly

Please try adding persistence unit property wildfly.jpa.applicationdatasource and set that to true. https://docs.wildfly.org/31/Developer_Guide.html#persistence-unit-properties shows all of the properties.

--
You received this message because you are subscribed to the Google Groups "WildFly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wildfly+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/f5198db1-7ba8-4fab-9493-d6cb98fff4d5n%40googlegroups.com.

Ebuzer Taha Kanat

unread,

Jan 28, 2024, 3:06:14 PM1/28/24

to WildFly

I have added property here is the final version:

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="https://jakarta.ee/xml/ns/persistence"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="https://jakarta.ee/xml/ns/persistence https://jakarta.ee/xml/ns/persistence/persistence_3_0.xsd"
	version="3.0">
	<persistence-unit name="primary">
		<!-- Use a portable JNDI name for the datasource -->
		<jta-data-source>java:global/jdbc/deneme2DS</jta-data-source>
		<properties>

			<property
				name="jakarta.persistence.schema-generation.database.action"
				value="drop-and-create" />
			<property name="jakarta.persistence.sql-load-script-source"
				value="import.sql" />
			<!-- Properties for Hibernate <property name="hibernate.show_sql" value="false" 
				/> -->

			<property name="wildfly.jpa.applicationdatasource" value="true"/>
		</properties>
	</persistence-unit>
</persistence>

But still same error occurs.

28 Ocak 2024 Pazar tarihinde saat 22:07:53 UTC+3 itibarıyla Scott Marlow şunları yazdı:

Scott Marlow

unread,

Jan 28, 2024, 4:30:31 PM1/28/24

to Ebuzer Taha Kanat, WildFly

The "global" reference sounds wrong. Try "app" instead like name = "java:app/deneme2DS"

An example is here

https://github.com/wildfly/wildfly/blob/main/testsuite/integration/basic/src/test/java/org/jboss/as/test/integration/jpa/datasourcedefinition/SLSB1.java#L29

Scott

To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/5f136f00-aaae-497d-b996-265d9a418f8an%40googlegroups.com.

Ebuzer Taha Kanat

unread,

Jan 28, 2024, 4:41:49 PM1/28/24

to WildFly

It works for payara though. i tried java:app/deneme2DS same error. I think it's a bug from Wildfly side doesn't consider

@DataSourceDefinition

is my guess.
21:38:53,958 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "deneme2-ear.ear")]) - failure description: {
"WFLYCTL0412: Required services that are not installed:" => ["jboss.naming.context.java.app.deneme2-ear.deneme2DS"],

"WFLYCTL0180: Services with missing/unavailable dependencies" => [

"jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\".__FIRST_PHASE__ is missing [jboss.naming.context.java.app.deneme2-ear.deneme2DS]",
"jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\" is missing [jboss.naming.context.java.app.deneme2-ear.deneme2DS]"
]
}

29 Ocak 2024 Pazartesi tarihinde saat 00:30:31 UTC+3 itibarıyla Scott Marlow şunları yazdı:

Scott Marlow

unread,

Jan 28, 2024, 6:27:11 PM1/28/24

to Ebuzer Taha Kanat, WildFly

Please try updating the persistence.xml to also set:

To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/430d361b-3e1c-4475-9888-738d5c451fd5n%40googlegroups.com.

Ebuzer Taha Kanat

unread,

Jan 29, 2024, 9:13:07 AM1/29/24

to WildFly

Still same error

29 Ocak 2024 Pazartesi tarihinde saat 02:27:11 UTC+3 itibarıyla Scott Marlow şunları yazdı:

Scott Marlow

unread,

Jan 29, 2024, 10:04:33 AM1/29/24

to Ebuzer Taha Kanat, WildFly

I tried recreating by modifying a WildFly test to use your changes but the test still passes.

https://github.com/scottmarlow/wildfly/commit/f679080829846fa816d904d7314a7887fbdbdfa5 has my test changes on https://github.com/scottmarlow/wildfly/tree/deneme2DS. I added your DataSourceConfig and modified the test persistence.xml to reference your datasource. Not that it matters but the tests also pass but the important thing is that my test application also deploys.

https://github.com/scottmarlow/wildfly/tree/deneme2DS/testsuite/integration/basic/src/test/java/org/jboss/as/test/integration/jpa/datasourcedefinition contains all of the test files (including your DataSourceConfig).

Are you using WildFly 31?

For reference my test persistence.xml contains:

<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0">
    <persistence-unit name="mypc">
        <jta-data-source> java:app/deneme2DS</jta-data-source>
        <properties>

            <property name="hibernate.hbm2ddl.auto" value="create-drop"/>

            <property name="wildfly.jpa.twophasebootstrap" value="true"/>
            <property name="jboss.as.jpa.classtransformer" value="true"/>

            <property name="wildfly.jpa.applicationdatasource" value="true"/>
        </properties>
    </persistence-unit>
</persistence>

To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/cd5b1e9d-d378-4644-867c-ceddac3111d8n%40googlegroups.com.

Ebuzer Taha Kanat

unread,

Jan 29, 2024, 10:30:56 AM1/29/24

to WildFly

I'm using jboss/wildfly docker image which is version 25.0.0.Final .

I pushed debug branch to repo you can pull if you want to:
https://github.com/urbandroid/graphql-jakarta/tree/debug
I'm trying to create Application Server agnostic starter, properties specific to Wildfly aren't solution for me even though tried them too.

29 Ocak 2024 Pazartesi tarihinde saat 18:04:33 UTC+3 itibarıyla Scott Marlow şunları yazdı:

Ebuzer Taha Kanat

unread,

Jan 29, 2024, 10:46:41 AM1/29/24

to WildFly

I tried Wildfly 31 and i get this error:

15:43:28,682 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-3) MSC000001: Failed to start service jboss.deployment.subunit."deneme2-ear.ear"."deneme2-ejb.jar".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.subunit."deneme2-ear.ear"."deneme2-ejb.jar".INSTALL: WFLYSRV0153: Failed to process phase INSTALL of subdeployment "deneme2-ejb.jar" of deployment "deneme2-ear.ear"
at org.jboss...@23.0.1.Final//org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:179)
at org.jb...@1.5.2.Final//org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1617)
at org.jb...@1.5.2.Final//org.jboss.msc.service.ServiceControllerImpl$StartTask.execute(ServiceControllerImpl.java:1580)
at org.jb...@1.5.2.Final//org.jboss.msc.service.ServiceControllerImpl$ControllerTask.run(ServiceControllerImpl.java:1438)
at org.jbos...@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jbos...@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
at org.jbos...@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
at org.jbos...@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1363)
at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: java.lang.ClassNotFoundException: org.h2.jdbcx.JdbcDataSource from [Module "deployment.deneme2-ear.ear.deneme2-ejb.jar" from Service Module Loader]
at org.jboss.a...@31.0.0.Final//org.jboss.as.connector.deployers.datasource.DataSourceDefinitionInjectionSource.getResourceValue(DataSourceDefinitionInjectionSource.java:161)
at org.jbo...@31.0.0.Final//org.jboss.as.ee.component.deployers.ModuleJndiBindingProcessor.addJndiBinding(ModuleJndiBindingProcessor.java:254)
at org.jbo...@31.0.0.Final//org.jboss.as.ee.component.deployers.ModuleJndiBindingProcessor$1.handle(ModuleJndiBindingProcessor.java:225)
at org.jbo...@31.0.0.Final//org.jboss.as.ee.component.ClassDescriptionTraversal.run(ClassDescriptionTraversal.java:37)
at org.jbo...@31.0.0.Final//org.jboss.as.ee.component.deployers.ModuleJndiBindingProcessor.processClassConfigurations(ModuleJndiBindingProcessor.java:229)
at org.jbo...@31.0.0.Final//org.jboss.as.ee.component.deployers.ModuleJndiBindingProcessor.deploy(ModuleJndiBindingProcessor.java:143)
at org.jboss...@23.0.1.Final//org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:172)
... 8 more
Caused by: java.lang.ClassNotFoundException: org.h2.jdbcx.JdbcDataSource from [Module "deployment.deneme2-ear.ear.deneme2-ejb.jar" from Service Module Loader]
at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:200)
at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:410)
at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)
at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:116)
at org.jboss.a...@31.0.0.Final//org.jboss.as.connector.deployers.datasource.DataSourceDefinitionInjectionSource.getResourceValue(DataSourceDefinitionInjectionSource.java:125)
... 14 more

15:43:29,265 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "deneme2-ear.ear")]) - failure description: {
"WFLYCTL0080: Failed services" => {"jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".INSTALL" => "WFLYSRV0153: Failed to process phase INSTALL of subdeployment \"deneme2-ejb.jar\" of deployment \"deneme2-ear.ear\"
Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: java.lang.ClassNotFoundException: org.h2.jdbcx.JdbcDataSource from [Module \"deployment.deneme2-ear.ear.deneme2-ejb.jar\" from Service Module Loader]
Caused by: java.lang.ClassNotFoundException: org.h2.jdbcx.JdbcDataSource from [Module \"deployment.deneme2-ear.ear.deneme2-ejb.jar\" from Service Module Loader]"},

"WFLYCTL0412: Required services that are not installed:" => [

"jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig",
"jboss.naming.context.java.app.deneme2-ear.deneme2DS",
"jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".deploymentCompleteService",
"jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration",
"jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository",
"jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\"",
"jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".jndiDependencyService",
"jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".beanmanager"

],
"WFLYCTL0180: Services with missing/unavailable dependencies" => [

"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig.InAppClientContainer is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig]",
"service jboss.deployment.unit.\"deneme2-ear.ear\".WeldStartService is missing [jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\", jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".jndiDependencyService]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig.Validator is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository.InAppClientContainer is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig.InstanceName is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository.ValidatorFactory is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig.ValidatorFactory is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.DataSourceConfig]",
"service jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\".__FIRST_PHASE__ is missing [jboss.naming.context.java.app.deneme2-ear.deneme2DS]",
"service jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-web.war\".component.\"jakarta.servlet.jsp.jstl.tlv.ScriptFreeTLV\".START is missing [jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\"]",
"service jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-web.war\".component.\"jakarta.servlet.jsp.jstl.tlv.PermittedTaglibsTLV\".START is missing [jboss.persistenceunit.\"deneme2-ear.ear/deneme2-ejb.jar#primary\"]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration.InstanceName is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration.InAppClientContainer is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository.InstanceName is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository]",
"service jboss.deployment.unit.\"deneme2-ear.ear\".deploymentCompleteService is missing [jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".deploymentCompleteService]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration.Validator is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration.ValidatorFactory is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRegistration]",
"service jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".weld.weldClassIntrospector is missing [jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".beanmanager]",
"service jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository.Validator is missing [jboss.naming.context.java.comp.deneme2-ear.deneme2-ejb.MemberRepository]",
"service jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".batch.artifact.factory is missing [jboss.deployment.subunit.\"deneme2-ear.ear\".\"deneme2-ejb.jar\".beanmanager]"
]
}

29 Ocak 2024 Pazartesi tarihinde saat 18:30:56 UTC+3 itibarıyla Ebuzer Taha Kanat şunları yazdı:

Ebuzer Taha Kanat

unread,

Jan 29, 2024, 11:06:12 AM1/29/24

to WildFly

I solved adding h2 to pom.xml it works now as expected here is the final version of setup:

package deneme2.deneme2.config;

import jakarta.annotation.sql.DataSourceDefinition;
import jakarta.ejb.Singleton;

@Singleton
@DataSourceDefinition(

    name = "java:app/deneme2DS",

    className = "org.h2.jdbcx.JdbcDataSource",
    url = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1",
    user = "sa",
    password = "sa"
)
public class DataSourceConfig {
    // This class can be empty, as it only serves to define the DataSource
    // The DataSource will be automatically registered when this class is loaded
}

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="https://jakarta.ee/xml/ns/persistence"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="https://jakarta.ee/xml/ns/persistence https://jakarta.ee/xml/ns/persistence/persistence_3_0.xsd"
	version="3.0">
	<persistence-unit name="primary">
		<!-- Use a portable JNDI name for the datasource -->

		<jta-data-source>java:app/deneme2DS</jta-data-source>
		<properties>

			<property
				name="jakarta.persistence.schema-generation.database.action"

				value="drop-and-create" />
			<property name="jakarta.persistence.sql-load-script-source"
				value="import.sql" />
			<!-- Properties for Hibernate <property name="hibernate.show_sql" value="false" 
				/> -->
</properties>
	</persistence-unit>
</persistence>

Thank you so much for your help.

29 Ocak 2024 Pazartesi tarihinde saat 18:46:41 UTC+3 itibarıyla Ebuzer Taha Kanat şunları yazdı:

Reply all

Reply to author

Forward