Mickaël Vera created WFLY-6800: ---------------------------------- Summary: Database ignored in Postgres JDBC URL Key: WFLY-6800 URL: https://issues.jboss.org/browse/WFLY-6800 Project: WildFly Issue Type: Bug Components: JPA / Hibernate Affects Versions: 10.0.0.Final Environment: java 8 windows 7 postgresql 9.4 Reporter: Mickaël Vera Assignee: Scott Marlow I created a data source like this {code:xml} <datasource jndi-name="java:jboss/datasources/crawlRuntimeDS" pool-name="crawlRuntimePool" enabled="true" use-java-context="true"> <connection-url>jdbc:postgresql://localhost:5432/runtimedb</connection-url> <driver>postgresDD</driver> <security> <user-name>postgres</user-name> <password>postgres</password> </security> </datasource> {code} {code:xml} I reference it in a persistent unit: <persistence-unit name="crawl-runtime-pu"> <jta-data-source>java:jboss/datasources/crawlRuntimeDS</jta-data-source> <class>org.mvera.webscrap.model.crawl.runtime.CrawlEntity</class> <class>org.mvera.webscrap.model.crawl.runtime.PageCrawlStatusEntity</class> <exclude-unlisted-classes>true</exclude-unlisted-classes> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" /> <property name="hibernate.show_sql" value="true" /> <property name="hibernate.format_sql" value="true" /> <property name="javax.persistence.schema-generation.database.action" value="none" /> <property name="javax.persistence.schema-generation.scripts.action" value="drop-and-create" /> <property name="javax.persistence.schema-generation.scripts.create-target" value="D:/mvera/crawl-runtime-pu-create.sql" /> <property name="javax.persistence.schema-generation.scripts.drop-target" value="D:/mvera/crawl-runtime-pu-drop.sql" /> </properties> </persistence-unit> {code} I thought for a moment that all was working right. My data was persisted and I could read it from within an EJB using this datasource. But then I discovered that my data was not persisted at all in the database "crawlRuntimeDS" specified on the jdbc URL of the datasource but in the database "postgres" (a default database created during install of postgres). This is a real problem as my application uses serveral databases (several persistence units). The workaround today is to put all entities in the same "postgres" database. In the datasource, I can put any name as the database name, it is ignored, even if the database doesn't exist. -- This message was sent by Atlassian JIRA (v6.4.11#64026)