Hibernate Community • View topic - Setting OracleDataSource specific properties

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

Setting OracleDataSource specific properties

Page 1 of 1

[ 5 posts ]

Previous topic | Next topic

Author

Message

jmguzmanc

Post subject: Setting OracleDataSource specific properties

Posted: Tue Jul 11, 2006 3:26 pm

Newbie

Joined: Tue Jul 11, 2006 3:10 pm
Posts: 3

Hi

Is there a way to set up an specific OracleDataSource, in persistence.xml (or even in Java Code)?

What I need, is to set a specific ConnectionProperty ("oracle.jdbc.ReadTimeout") for OracleDataSource.

In a programmatic Way, I can do that by calling setConnectionProperties().

Properties cnProps = new Properties();
cnProps.setProperty("oracle.jdbc.ReadTimeout", 10000);

ods = new OracleDataSource();
ods.setConnectionProperties(cnProps);

This is a VERY important parameter (and not very docummented), that prevents thread blocking, when database is non reachable .

How can I set Hibernate to pass this property to OracleDataSource?

Thanks
JM

Top

alesj

Post subject:

Posted: Wed Jul 12, 2006 3:28 am

Expert

Joined: Sat Oct 25, 2003 8:49 am
Posts: 490
Location: Vrhnika, Slovenia

How are you using this DS?
Container managed (which container) or standalone (SE)?

Top

jmguzmanc

Post subject:

Posted: Wed Jul 12, 2006 2:54 pm

Newbie

Joined: Tue Jul 11, 2006 3:10 pm
Posts: 3

I am planning to use this DS, with Hibernate EntityManager, from J2SE.

Top

alesj

Post subject:

Posted: Wed Jul 12, 2006 4:20 pm

Expert

Joined: Sat Oct 25, 2003 8:49 am
Posts: 490
Location: Vrhnika, Slovenia

Write your own connection provider:

Code:

hibernate.connection.provider_class = <your_provider>

Code:

public interface ConnectionProvider {
   /**
    * Initialize the connection provider from given properties.
    * @param props <tt>SessionFactory</tt> properties
    */
   public void configure(Properties props) throws HibernateException;

        ...

Use a configure(Properties properties) method to set up DS and specific property.

Rgds, Ales

Top

jmguzmanc

Post subject:

Posted: Wed Jul 12, 2006 6:58 pm

Newbie

Joined: Tue Jul 11, 2006 3:10 pm
Posts: 3

Great!

I implemented an OracleDatasourceConnectionProvider, that set specific Oracle parameters, from persistence.xml properties.

Thanks a lot.
JM

Top

Page 1 of 1

[ 5 posts ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum