Share on Google+Share on Google+

nainshi jain
HOW TO RUN JDBC PRORAM ON JDK1.5.0
1 Answer(s)      6 years and a month ago
Posted in : JDBC
import java.sql.*; 
import java.util.*; 
class MyDbCode3*
 {
public static void main(String [] args) 
{ 
try `print("code sample");`
{ `print("code sample");`
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
}
 catch(ClassNotFoundException cnf)
 { 
System.out.println("Cannot load the Driver");
 System.exit(1); 
} 
Scanner kb=new Scanner(System.in);
 int id;
 System.out.println("Enter bookid:"); 
id=kb.nextInt();
 try 
{
 Connection conn=DriverManager.getConnection("jdbc:odbc:advdsn1","student","myself"); Statement st=conn.createStatement(); 
String qry="Update mybooks set price=price+1000 where bookid="+id; System.out.println(qry); int x=st.executeUpdate(qry); System.out.println("Rows effected="+x);
 conn.close();
 }
catch(SQLException sq) 
{ 
System.out.println("Sql Error:"+sq.getMessage());
 }
 }
 }
****for running this program i am using jdk1.5.0`*print("code sample");*`
I have created Dsn Successfully ,table also has been created successfully and when i compiled this program then it compiled successfully ,but when i run it ,it gives following error->
C:\Program Files\Java\jdk1.5.0\bin>java MyDbCode3 Enter bookid: 101 Sql Error:[Microsoft][ODBC Driver Manager] Data source name not found and no def ault driver specified
i want to know what is the problem? and how can i run it successfully? please give me a satisfieng answer ,bcz i am not satisfied by ur previous answer...
thank u ....****
View Answers
Post***

Ads

View Answers

March 28, 2011 at 5:23 PM


1)create database and table 2)write the java code 3)provide ODBC connection 4)execute your code...










Related Tutorials/Questions & Answers:
HOW TO RUN JDBC PRORAM ON JDK1.5.0
HOW TO RUN JDBC PRORAM ON JDK1.5.0  import java.sql.*; import... driver specified i want to know what is the problem? and how can i run... { Connection conn=DriverManager.getConnection("jdbc:odbc:advdsn1","student","myself
How Jdbc program can be run??
How Jdbc program can be run??  import java.sql.*; import java.util.... to know what is the problem? and how can i run it successfully? please give me... { Connection conn=DriverManager.getConnection("jdbc:odbc:advdsn1","student","myself
Advertisements
how to run jdbc program in linux-ubuntu?
how to run jdbc program in linux-ubuntu?   how to run jdbc program in linux-ubuntu
how to run jdbc program in linux-ubuntu?
how to run jdbc program in linux-ubuntu?  how to run jdbc program in linux-ubuntu?   hi firstly download the jdk on your system using terminal or go to softwear management then download openjdk-6 or commandline
how to run jdbc in jsp program - JSP-Servlet
how to run jdbc in jsp program  i want to use sql server 2005 in jsp program to store data.i know how to run simple program but this program i tried my best i am not able to do so.please give me the answer of this as soon
jdbc run time error - JDBC
jdbc run time error  i m creating the table using thin driver it is showing the following run time error: Exception in thread "main...=DriverManager.getConnection("jdbc:opracle:thin:@ptpl:1521:oracle","scott","tiger
how to run rmi program
how to run rmi program  how to run rmi program
java run time error - JDBC
java run time error  when i m running for batch execution program in jdbc i m facing this kind of runtime error as Exception in thread "main...=DriverManager.getConnection("jdbc:oracle:thin:@ptpl:1521:oracle","scott","tiger
how to run applet - Applet
how to run applet   Hi everybody i am using connecting jdbc in applet program. this is executed successfully with appletviewer command >... how can i execute in browser ? Thanks in advance thanks for seeing my
not able to run in gcj file - JDBC
not able to run in gcj file   We have a java program in Linux environment, which hits DB for some data and encode the same. We need to compile... to run the java program it says that Classes12.Jar?s oracle Driver missing. We
how to run this program?
how to run this program?  how to run java swing program   Java Swing program runs same as a simple java program. There is no difference... with javac and run with java command, same as a simple java program. Learn Swing
how to run servlet
how to run servlet  Servlet run procedure for J2EE Software   Hi Friend, Please visit the following links: http://www.roseindia.net/servlets/introductiontoconfigrationservlet.shtml http://www.roseindia.net/servlets
how to run - Java Beginners
how to run   how to run java program... brifely  Hi... to execute or run the program. For ex, If you have the following java program... file on the command prompt using: "javac HelloWorld.java". And then run it using
How to compile and run the JSP
How to compile and run the JSP  Hi Kindly tell me how to run and compile JSP small Program using Tomcat as webserver. I created small program HELLO JSP in HTML and compile the program but it is saying Class o r interface
how to run java program
how to run java program  i have jar file. in jar i have so many classes.in one of file i want modify .after modifying file i want replce in jar. please help me to how to generate class and how to replace
How to run? - Hibernate
How to run?  Hiiiiiiiiiiiii friend.. i am Magesh, doing MCA at Madurai in Tamilnadu. i know little bit about Jsp,Servlet.. But my friends are told hibernate is a new entry to Java. so plz try to tell how to use
java run time error in loading the driver - JDBC
java run time error in loading the driver  when i mrunning...:jdbc.driver.OracleDriver the code was as follows: please suggest me how it can... JDBC driver's JAR file in your classpath and check it Thanks
how to run a vlc player in jsp
how to run a vlc player in jsp  how to run a vlc player in jsp
how to run a .exe file in jsp
how to run a .exe file in jsp  i want code for to run a .exe file in jsp
how to run servlet - JSP-Servlet
how to run servlet  pls give me comlete procedure to run the servlet on apache-tomcat 6.0.16 how can i set my classpath, java_home etc. also where i have to save my servlet program and how it compile and then run on web browser
how to run ejb3.0 with jboss4.0.2 - EJB
how to run ejb3.0 with jboss4.0.2  i can install jdk5.0,ant1.7and jboss4.0.2 but i didn't known how run the ejb bean plz help me for my promble
how to run ejb3.0 with jboss4.0.2 - EJB
how to run ejb3.0 with jboss4.0.2  i can install jdk5.0,ant1.7and jboss4.0.2 but i didn't known how run the ejb bean plz help me for my promble
How to find run time in SQL.
How to find run time in SQL.  I have 10 backend jobs in sql which runs at different time intervals. Sample data is shown below Table name:- Job_Run... 22/10/2010 17:30:00 I want to find the run time of both the jobs. (i.e when i run
how to run jsp appication in eclipse
how to run jsp appication in eclipse  after setting the tomcat in eclipse, i m trying to run jsp page, but the pop up has come that "selection did not contain any resources that can run on server". plase tell me i m new to handle
how to compile and run servlet program
how to compile and run servlet program   hello sir/mam i hve installed tomcat5.5 version and also have jdk1.6.0_14 installed but not able to run it or compile i m doing it first tyme pls help me in sorting out this problem. i hve
how to run a applet from browser
how to run a applet from browser  hi, iam sending the code of an applet. it is working in cmd prompt,but not working from browser. <APPLET CODE... Random(); try { String connectionURL = "jdbc:mysql://localhost:3306/mysql
How to run a servlet
How to Run a Servlet       To run a servlet one should follow the steps illustrated below:  Download... enter. If everything is correct your servlet will run.  
How to compile and run Java program
How to compile and run Java program  How to compile and Java program from command prompt on my windows 7 computer? Thanks   Hi... is not installed your computer, learn how to install and configure Java on windows 7
how to compile and run struts application - Struts
how to compile and run struts application  how to compile and run struts program(ex :actionform,actionclass) from command line or in editplus 3
How to run program in new opened cmd
How to run program in new opened cmd  Hello i have made a program in java to open command prompt, then how to run my left of the program in the new opened command prompt
How to Run First Java Bean Program ?
How to Run First Java Bean Program ?  Hi My Dear Friend I can run... But Now I need that How to run Java Bean Now I have BDK1.1 But still don't know that how run this... I have this bdk dir... \bdk1_1\beans\beanbox
Tutorials   
Java Spring Hibernate Struts Training how to retrieve text and images from mysql database and show on html page using jsp servlet How to install Neo4j on Ubuntu 15.10? please help me in these prog MYSQL - mysql copy table to another table example by creating new table solution for mapping hibernate and pojos from net beans through database Connect GWT application with Oracle inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store This code have created jTable that connected with a database.every cell of last column have a button.But this button doesn't work properly.Where is the error java program Java Database Program jdbc Database connection class in a live project ..?? What is JDBC architecture? Unable to Create DSN for excel to ms access importing data and edit that data Database Scrolling Buttons how to use foreign key in java How to delete content of a log file from linux terminal? JSP-Oracle connectivity Student Management System Java code for Saving Marathi (Indian local language ) in Mysql and retrieving the same crud operations with foreign key constraint. I really need help with this assignment question Please help me out Please Backup Failed Mysqldump Got Errno 28 On Write Upgrade MySQL 5.1 to 5.5 in cpanel mysqldump all databases com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jpa.sequence' doesn't exist persistence xml class element persistence.xml for MySQL MySQL JDBC Driver pom dependency code Blob column jdk6 and oracle 8i connexion oracle 8i et jdk6 java [ cannot retrive date from sql ] why?? Order Entry System How to threow timeout exception when DB is not responding How to threow timeout exception when DB is not responding This is the employee form to add data to mysql database but I got error of NullPointerException, Is this write code please give me feedback as soon as possible make a method which takes user name & pwd as parameter & validate them against the database. If the corresponding user exist return true otherwise false. prabhakar validating credentials and displaying error message in login .jsp if not valid JDBC jdbc jdbc code register servlet vibhu connectiondetails from vibhu

Ads

 
Advertisement null

Ads