How to setup Tomcat 7 Postgresql datasource for Hibernate?

Question

For some reasons I've to fine-tune the jdbc connecton, and I've found, the context.xml is the way I can do that. ( http://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html#PostgreSQL )

So, I create context.xml:

<Context>
<Resource
    name="jdbc/connectorDs"
    auth="Container"
    type="javax.sql.DataSource"
    driverClassName="org.postgresql.Driver"
    url="jdbc:postgresql://localhost/somedb"
    username="pguser"
    password="pgpw"
    maxActive="20"
    maxIdle="10"
    maxWait="-1" />
</Context>

Add some config to web.xml:

<resource-ref>
    <description>postgreSQL Datasource example</description>
    <res-ref-name>jdbc/connectorDs</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

And modify the hibernate.cfg.xml:

<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.connection.datasource">java:jdbc/connectorDs</property>

<!-- THE ORIGINAL CONFIG -->
<!-- <property name="connection.url">jdbc:postgresql://localhost/somedb</property> -->
<!-- <property name="connection.username">pguser</property> -->
<!-- <property name="connection.password">pgpw</property> -->

But this kind of konfig doesn't work: SEVERE: Initial SessionFactory creation failed.org.hibernate.HibernateException: Could not find datasource. I suppose the dataource not exist or the datasource connection string java:jdbc/connectorDs is not proper. Anybody has any experience with it? How to set my connection propertly, or how to set additional properties on connection?

Thanks in advance.

Gab · Accepted Answer · 2013-04-11 11:27:02Z

2

try

<property name="hibernate.connection.datasource">java:comp/env/jdbc/OracleDS</property>

I don't think you need to declare datasource in both web.xml and server.xml. Try to remove the web.xml one if it still don't run

answered Apr 11, 2013 at 11:27

Gab

8,3504 gold badges43 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

azendh Over a year ago

Works fine without web.xml config code. Thanks both of you.

Daniel1979 · Accepted Answer · 2013-04-11 11:24:20Z

2

In hibernate.cfg.xml, try replacing

<property name="hibernate.connection.datasource">java:jdbc/connectorDs</property>

with

<property name="hibernate.connection.datasource">java:/comp/env/jdbc/connectorDs</property>

answered Apr 11, 2013 at 11:24

Daniel1979

14.1k7 gold badges59 silver badges72 bronze badges

Collectives™ on Stack Overflow

How to setup Tomcat 7 Postgresql datasource for Hibernate?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related