...i cannot execute insert in oracle 9i R2..im using hibernate v3...here is my config file:

<hibernate-configuration>
<session-factory >

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

<!-- dialect for Oracle 9 -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<mapping resource="ora_spider/Student.hbm.xml"/>

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

...and here the stack trace:

---------------------------------
2282 [http-8070-Processor25] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:118)

Should be oracle.jdbc.OracleDriver or oracle.jdbc.driver.OracleDriver

Is incorrect. The value of the property should be your Oracle JDBC driver as supplied by oracle. Something like com.oracle.jdbc you'll have to check your docs for the exact class.

.....i try to change my driver class like this:
<property name="hibernate.connection.driver_class">
oracle.jdbc.OracleDriver
</property>

but it give me an error:
-------------
828 [http-8070-Processor25] FATAL org.hibernate.connection.DriverManagerConnectionProvider - JDBC Driver class not found: oracle.jdbc.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)

...and same for oracle.jdbc.driver.OracleDriver...can anyone give me a working config file for oracle 9i R2 database using hibernate v3...tnx

Did you place the actual driver archive in ${CATALINA_HOME}/shared/lib or under WEB-INF/lib?

Also note that if your driver archive have zip extension you may need to rename it to jar. I recall that Tomcat did not pick archives with zip extension automatically.

...i put hibernate v3 to WEB-INF/lib...i can connect to MySQL putting hibernate v3 to WEB-INF/lib and the driver_class for MySQL is com.mysql.Driver...

You need the Oracle JDBC Driver in your classpath or in WEB-INF/lib

The driver is called classes12.jar and you will get it on Oracle's Homepage.

Additionally i think you need a colon right here:

<property name="hibernate.connection.url">jdbc:oracle:thin:@spykers:1521:eman</property>

Otherwise you will get an error. AFAIK this colon is a must!

Semmerl
...ei thankz a lot for the help..now i can connect to Oracle Database :)

Jack

If my answer was helpful, please rate me!! Thx!

Semmerl

...ok i will rate..can u help me with pagination on my webpage...im using a taglib but it has no effect at all...if you u have an example much better..tnx a lot...

Jack

Are you using Java Server Faces or what Web Framework?

...im using hibernate..

Yeah I know (otherwise you won't be here :))
But if I don't understand you false, you want to display the data on a webpage.
So what do you use to display data on webpages? JSF, Struts, JSP?
Or what else to you mean with pagination?

...JSP only...this my code to display page but it is not effecient:

<%
int startRs = 0,endRs = 0,maxRs = 10,minRs,mod;
String ex1 = request.getParameter("start");
String ex2 = request.getParameter("end");
String act = request.getParameter("act");
if( ex1 == null & ex2 == null & act == null){
ex1="";ex2="";act="";
}

int cp = 1;
if( aitem.size() > maxRs){
for(int cout = 0 ;cout < aitem.size(); cout+=10){
%>
<a href="searchitem.jsp?start=<%= cout %>&end=<%= maxRs %>&act=yes"><%= cp %></a>
<%
cp++;
maxRs+=10;
}
}
if(act.equals("yes")){
startRs = Integer.parseInt(ex1);
endRs = Integer.parseInt(ex2);
}else{
if(maxRs > aitem.size()){
startRs = 0;
endRs = aitem.size();
}
}

%>

</label>
</td>
</tr>
</table>
<!----------------- start of the listing of Search Result of items ---------------------------------------------->

<table width="100%">
<tr class="formlabel" bgcolor="#006699">
<td width="12%">Picture</td>
<td>Item</td>
<td width="27%">Price</td>
<td width="16%">Days Left</td>
</tr>

<%
for (int x= startRs; x < endRs ; x++)
{
spider.Items t = (spider.Items) aitem.get(x);

%>

<tr>
<td><a href="itemdetails.jsp?itemid=<%= t.getId()%>&status=<%= t.getStatus() %>">
<img src="<%= t.getPicture() %>" height="35" width="50">
</a>
</td>
<td class="searchtext" width="45%"><%= t.getItemIdfc() %></td>
<td class="searchtext"><%= t.getPrice() %>&nbsp;
<a href="itemdetails.jsp?itemid=<%= t.getId()%>&status=<%= t.getStatus() %>" style="color:#0000FF">
<%if(t.getStatus().equals("sale-pending")){ %>
BuyItNow
<%}else{%>
BidNow
<%}%>
</a>
</td>
<td class="searchtext" align="center"><%= days %></td>
</tr>

<%
count++;
}
}
%>

<tr>
<td class="cell-header" colspan="4" align="right">
<label class="formlabel"><%= count %>&nbsp;Match found</label>
</td>

</tr>

</table>
----any idea how i can improve the pagination..tnx..

Pagination such that like google search results like:

1 2 3 4 5 6 7 8 9 Next

when you clickl 2 it will display second 10 result from the database and so on..