We changed our hibernate config from direct connection to the database to using datasource and we have noticed a considerable slow down with our hibernate search result..... 3s search now goes to like 30s.

<property name="connection.datasource">jdbc/datasource</property> and and we get this exception

[#|2011-04-21T15:43:02.460-0500|SEVERE|glassfish3.0.1|com.mavencode.engine.ProductCategoryEngine|_ThreadID=26;_ThreadName=Thread-1;|The log message is null.
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
at sun.reflect.GeneratedMethodAccessor462.invoke(Unknown Source)

Any advise will be appreciated.

Hi,
I'm not sure I understood you. Are you referring to two different issues, or is the exception being thrown and then Search returns in 30 seconds after that?
Are you sure the datasource name is correct and did you test it with a plain Hibernate query?