Strange Hibernate Exception

Nitzer_Ebb · **Posted:** Tue Aug 09, 2005 8:44 am

Hi all,

no need to mention I'm a very new Hibernate user, failing to resolve this easy issue :

Code:

net.sf.hibernate.HibernateException: JDBC Driver class not found: com.sybase.jdbc2.jdbc.SybDriver  
   at net.sf.hibernate.connection.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:69)
   at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83)
   at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:65)
   at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1155)
   at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:789)

If I have included all the necessary JAR:s to my classpath, how can I get this error ?

Best regards
/Andreas

pksiv · **Posted:** Tue Aug 09, 2005 8:47 am

Nitzer_Ebb wrote:

Hi all,

no need to mention I'm a very new Hibernate user, failing to resolve this easy issue :

Code:

net.sf.hibernate.HibernateException: JDBC Driver class not found: com.sybase.jdbc2.jdbc.SybDriver  
   at net.sf.hibernate.connection.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:69)
   at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83)
   at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:65)
   at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1155)
   at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:789)

If I have included all the necessary JAR:s to my classpath, how can I get this error ?

Best regards
/Andreas

You obviously haven't included the jar containing the Sybase driveer in your classpath.

Nitzer_Ebb · **Posted:** Tue Aug 09, 2005 8:59 am

Hi again,

I have checked my classpath many times, and I'm quite sure it's correct. I will try to get the classpath at runtime, maybe the classes are loaded in some strange order.

Best regards
/Andreas

pksiv · **Posted:** Tue Aug 09, 2005 9:04 am

Nitzer_Ebb wrote:

Hi again,

I have checked my classpath many times, and I'm quite sure it's correct. I will try to get the classpath at runtime, maybe the classes are loaded in some strange order.

Best regards
/Andreas

I would also make sure that the jar that you believe has the Sybase Driver in it does has a class with the name specified inside it.

Nitzer_Ebb · **Posted:** Tue Aug 09, 2005 9:13 am

The class it can't found exists in the JAR. That has been checked.

Best regards
/Andreas

steckemetz · **Posted:** Tue Aug 09, 2005 9:23 am

Try something like this:

Code:

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

If the class is really in the classpath.
It will work.

katukas · **Joined:** Tue Aug 09, 2005 9:09 am **Posts:** 3

Maybe hibernate expects different driver? When you select dialect you have to include driver for that database. For example if I use Oracle I have to put oracle drivers in my class path. I don't know how do Hibernate knows exact name for the Oracle but it woked fine for me.

Nitzer_Ebb · **Posted:** Tue Aug 09, 2005 9:31 am

steckemetz wrote:

Try something like this:

Code:

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

If the class is really in the classpath.
It will work.

Tested that.It worked fine, i.e no exception thrown.

Best regards
/Andreas

Nitzer_Ebb · **Posted:** Tue Aug 09, 2005 9:33 am

katukas wrote:

Maybe hibernate expects different driver? When you select dialect you have to include driver for that database. For example if I use Oracle I have to put oracle drivers in my class path. I don't know how do Hibernate knows exact name for the Oracle but it woked fine for me.

Have done that also. Here is my hibernate.properties file ( excerpt from it ) :

Code:

hibernate.dialect net.sf.hibernate.dialect.SybaseDialect   
hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver  
hibernate.connection.username testUser
hibernate.connection.password testPassword
hibernate.connection.url jdbc:sybase:Tds:localhost:2639/test_db

Best regards
/Andreas

atorres · **Posted:** Tue Aug 09, 2005 2:34 pm

Try the hibernate.cfg.xml configuration.
Maybe a space or something in the
"com.sybase.jdbc2.jdbc.SybDriver" on the property file.
Never tried Sybase with hibernate, but sure it does not require an specific driver ... it will use the string entered in the prop/cfg file.

Good Luck