..somebody help me because i cannot connect to oracle 9i database im using hibernate 3...here is my config file:

<?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">

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<hibernate-configuration >

<session-factory>
<!-- properties -->

<property name="hibernate.connection.username">scott</property>
<property name="hibernate.connection.password">tiger</property>
<property name="hibernate.connection.url">jdbc:oracle:thin@localhost/eman</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.connection.pool_size">1</property>
<property name="hibernate.show_sql">true</property>
<!-- mapping files -->
<mapping resource="ora_spider/Student.hbm.xml"/>

</session-factory>

</hibernate-configuration>

...can somebody help me..pls.tnx.

your connection url is not correct for oracle.

assuming that 'eman' is your SID, you'd do:

jdbc:oracle:thin:@localhost:1521:eman

--hi i try the connection url but it does not work.here is the stack trace...
Exception:
javax.servlet.ServletException: org/hibernate/HibernateException
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.student_jsp._jspService(student_jsp.java:99)
-------------------
root cause:
java.lang.NoClassDefFoundError: org/hibernate/HibernateException
org.apache.jsp.student_jsp._jspService(student_jsp.java:78)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
-------------------------
..what could be other problems cause the error...thnx

....nwei thats for steve...tnx

The NoClassDefFound exception points to that class (org.hibernate.HibernateException) not existing in your classpath.

Since it looks like you're running in a container of some sort (usage of jsps), then I'd check what you have deployed and ensure it is correct.

...i change my config file like this:

<?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 >

<!-- local connection properties -->
<property name="hibernate.connection.url">jdbc:oracle:thin@spyker:1521:eman</property>
<property name="hibernate.connection.driver_class">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.connection.username">eman</property>
<property name="hibernate.connection.password">password</property>
<!-- property name="hibernate.connection.pool_size"></property -->

<!-- dialect for Oracle 9 -->
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>

<property name="hibernate.show_sql">false</property>
<property name="hibernate.use_outer_join">true</property>
<property name="hibernate.transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="jta.UserTransaction">java:comp/UserTransaction</property>

<mapping resource="ora_spider/Student.hbm.xml"/>

</session-factory>
</hibernate-configuration>

----and the error is:

%%% Error Creating SessionFactory %%%%
org.hibernate.HibernateException: Dialect class not found: net.sf.hibernate.dialect.Oracle9Dialect
at org.hibernate.dialect.Dialect.getDialect(Dialect.java:501)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:51)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1497)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1041)

---it seems that the dialect was not foound but hibernate3.jar is in my classpath..pls help..tnx.