[jboss-jira] [JBoss JIRA] (WFLY-6800) Database ignored in Postgres JDBC URL
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)