Hi all,

FYI, I'm using JPA via Hibernate with Spring's LocalContainerEntityManagerFactoryBean & my AbstractRoutingDataSource subclass.

It appears that Hibernate is grabbing a connection at initialization time. How would I configure Hibernate so that it does not connect to the database during SessionFactory creation at all?

I have set (among other things)

hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.connection.pool_size=0

but upon SessionFactory creation, it still obtains a connection. I'm thinking it may be for schema validate/update/create/create-drop, depending on the hibernate.hbm2ddl.auto property.

If I'm correct about that, what value I can set hibernate.hbm2ddl.auto to in order to have Hibernate not connect to the database until a Session is created and it's actually needed for a flush or something, effectively telling Hibernate that I know the schema is correct?

Next question, once I can stop Hibernate from getting a connection at SessionFactory creation time: how can I ensure that Hibernate doesn't hold on to any connections at all? Is hibernate.connection.pool_size=0 sufficient?

Thanks,
Matthew

Ok, made some progress:I had to dig (debug) to find hibernate.temp.use_jdbc_metadata_defaults.

I'm still not totally convinced that this is complete. A couple of things, though: I'm not sure that hibernate.temp.use_jdbc_metadata_defaults will be around forever, and the value "none" for
hibernate.hbm2ddl.auto didn't seem to be documented.

Any other suggestions?

-matthew