Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Spring Framework | Web Services | BioInformatics | Java Server Faces | Jboss 3.0 tutorial | Hibernate 3.0 | XML

Tutorial Categories: Ajax | Articles | JSP | Bioinformatics | Database | Free Books | Hibernate | J2EE | J2ME | Java | JavaScript | JDBC | JMS | Linux | MS Technology | PHP | RMI | Web-Services | Servlets | Struts | UML


 

Java Tutorials


 

 

Struts Tutorials

Struts Resources

Visit Forum! Post Questions!
Jobs At RoseIndia.net!

Jdbc Jdbc Mysql SelectRecords

User Comments
Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl
  Blink   Furl   Simpy   Y! MyWeb 

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 

Current Comments

3 comments so far (post your own) View All Comments Latest 10 Comments:

I've done exactly as u said.... and i have the follwoing exception : java.sql.SQLException: ORA-03115: unsupported network datatype or representation
What am i doing wrong?

String sql= "SELECT DriverName,VehicleName,LatitutdeLongitude,EventDateTime " +
"FROM TRACKER_EVENTS te " +
"INNER JOIN DRIVERS d ON d.DriverID=te.DriverID " +
"INNER JOIN VEHICLES v ON v.VehicleID=te.VehicleID " +
"WHERE EventDateTime < to_date(?,'dd/MM/yyyy hh:mi') AND EventDateTime > to_date(?,'dd/MM/yyyy hh:mi') AND VehicleID= 1 " +
"ORDER BY LatitutdeLongitude";
PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1,endDate);
ps.setString(2,startDate);

ResultSet rset=ps.executeQuery(sql);

Posted by Andra on Tuesday, 11.18.08 @ 02:51am | #81775

Thank you for your acknowledgement,
would you please tell me how to write a printable interface programme coding just to connect my java programe and printer.

Posted by Laishram Dayananda Singh on Monday, 03.24.08 @ 17:13pm | #54154

i want to kwow detais what about the usage of prepared statement object.

Posted by laishram dayananda singh on Tuesday, 03.4.08 @ 17:32pm | #51304

Ask programming questions?

 

 

Back to Tutorial

 

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification

Tell A Friend
Your Friend Name

 

 
Browse all Java Tutorials
Java JSP Struts Servlets Hibernate XML
Ajax JDBC EJB MySQL JavaScript JSF
Maven2 Tutorial JEE5 Tutorial Java Threading Tutorial Photoshop Tutorials Linux Technology
Technology Revolutions Eclipse Spring Tutorial Bioinformatics Tutorials Tools SQL
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright 2007. All rights reserved.