Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver

843859May 31 2010 — edited Nov 20 2014
I am getting this exception and I am using the hibernate cofig file: I have kept the jtds jar in the classpath. Still the same exception...
# <?xml version="1.0" encoding="UTF-8"?>  
# <!DOCTYPE hibernate-configuration PUBLIC  
#         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"  
#         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">  
# <hibernate-configuration>  
#   <session-factory>  
#     <!-- Database data source -->  
# <!--     <property name="hibernate.connection.datasource">java:/comp/env/jdbc/iclose-messenger-broker-ds</property>  -->  
#   
#     <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbcx.JtdsXAConnection</property>  
#     <property name="hibernate.connection.username">sa</property>  
#     <property name="hibernate.connection.password">sa</property>  
#     <property name="hibernate.connection.url">jdbc:jtds:sqlserver://192.168.90.182/iclose-messenger-broker;appName=iclose-messenger</property>    
#       
#     <!-- MySQL -->  
#     <!-- <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>-->  
#     <!-- MS SQL Server -->  
#     <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>   
#   
#     <!-- Enable Hibernate's automatic session context management -->  
#     <property name="hibernate.current_session_context_class">thread</property>  
#   
#     <!-- Disable the second-level cache -->  
#     <property name="hibernate.cache.use_second_level_cache">false</property>  
#     <property name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</property>  
#   
#     <!-- Debugging -->  
#     <property name="hibernate.show_sql">false</property>  
#     <property name="hibernate.format_sql">false</property>  
#   
#   </session-factory>  
# </hibernate-configuration> 
# 2010-05-31 19:45:27,902  WARN LocaleUtils:55 - Locale name in faces-config.xml null or empty, setting locale to default locale : en_US  
# 2010-05-31 19:45:28,746  WARN SettingsFactory:117 - Could not obtain connection metadata  
# java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://192.168.90.182/iclose-messenger-broker;appName=iclose-messenger  
#     at java.sql.DriverManager.getConnection(DriverManager.java:602)  
#     at java.sql.DriverManager.getConnection(DriverManager.java:154)  
#     at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)  
#     at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)  
#     at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)  
#     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)  
#     at org.parlinkie.msgsvr.core.dao.DaoSession.buildHibernateSession(DaoSession.java:205)  
#     at org.parlinkie.msgsvr.core.dao.DaoSession.<clinit>(DaoSession.java:143)  
#     at org.parlinkie.msgsvr.connector.acord.AcordSoapServlet.initProcessing(AcordSoapServlet.java:182)  
#     at org.parlinkie.msgsvr.connector.acord.AcordSoapServlet.init(AcordSoapServlet.java:165)  
#     at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)  
#     at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)  
#     at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)  
#     at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)  
#     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)  
#     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)  
#     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)  
#     at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)  
#     at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)  
#     at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)  
#     at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)  
#     at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)  
#     at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)  
#     at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)  
#     at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)  
#     at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)  
#     at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)  
#     at org.apache.catalina.core.StandardService.start(StandardService.java:448)  
#     at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)  
#     at org.apache.catalina.startup.Catalina.start(Catalina.java:552)  
#     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
#     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)  
#     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)  
#     at java.lang.reflect.Method.invoke(Method.java:597)  
#     at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)  
#     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)  
# 2010-05-31 19:45:30,011  WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: 08001    
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2010
Added on May 31 2010
2 comments
899 views