[jboss-jira] [JBoss JIRA] (WFLY-6800) Database ignored in Postgres JDBC URL

[Mickaël Vera (JIRA)]

    [ https://issues.jboss.org/browse/WFLY-6800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262264#comment-13262264 ] 

Mickaël Vera commented on WFLY-6800:
------------------------------------

This issue is the same as this one : WFLY-6200

> 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)