Hi All,
I'm a newbie to hibernate and have some questions.

I've my own ConnectionPool.java. Is it possible to use this class to get connection to database or can i only go with c3p0 or DBCP with the app server? If possible can someone explain how to create the configuration, sessionfactory and session?

I'm also getting the following exception when trying to connect to SQL Server 2000 database from my hibernate console configuration (from eclipse). I'm using weblogic.jdbc.mssqlserver4.Driver (Weblogic Driver)

java.lang.AbstractMethodError
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216)
at org.hibernate.console.ConsoleConfiguration$2.execute(ConsoleConfiguration.java:282)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:56)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:85)
at org.hibernate.console.ConsoleConfiguration.buildSessionFactory(ConsoleConfiguration.java:277)
at org.hibernate.eclipse.console.workbench.LazySessionFactoryAdapter.getChildren(LazySessionFactoryAdapter.java:41)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.getChildren(BasicWorkbenchAdapter.java:88)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:94)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:207)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)

When i ran hibernate in debug mode (using log4j.properties) i got the following debug statement. Not sure if this is the problem:

DEBUG - could not get database version from JDBC metadata
INFO - RDBMS: Microsoft SQL Server, version: Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

The version of jDriver.jar:

Product: BEA Systems type 4 jDriver for SQL Server 7.0
Version: 5.1.0sp12

But it works fine with jtds.jar

Thanks