jdbc sql exception.

Ads
 

jdbc sql exception.

import java.sql.*;

import java.io.*; class InsertEx { public static void main(String args[])throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:ora","system","tiger"); Statement stmt=con.createStatement(); DataInputStream din=new DataInputStream(System.in); while(true) { System.out.println("Enter Employee number"); String s=din.readLine(); int no=Integer.parseInt(s); System.out.println("Enter Employee name"); String name=din.readLine(); System.out.println("Enter Employee salary"); s=din.readLine(); Float sal=Float.parseFloat(s); System.out.println("Enter Employee address"); String addr=din.readLine(); int count=stmt.executeUpdate("insert into myemp values("+no+",'"+name+",'"+sal+",'"+addr+"')"); if(count>0) System.out.println("Insert record successfully"); else System.out.println("record not Insert"); System.out.println("enter another record[yes/no]:"); String choice=din.readLine(); if(!choice.equalsIgnoreCase("yes")); break; } } } Error is:

E:>javac InsertEx.java Note: InsertEx.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details.

E:>java InsertEx Enter Employee number 1 Enter Employee name ravi Enter Employee salary 9000 Enter Employee address hyd Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC driver for Or acle][Oracle]ORA-00917: missing comma at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source) at InsertEx.main(InsertEx.java:23)

View Answers

August 27, 2011 at 1:03 PM

import java.io.*; 
import java.sql.*;
class InsertEx{
    public static void main(String args[])throws Exception { 
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection("jdbc:odbc:student","","");
        Statement stmt=con.createStatement(); 
        BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
        boolean status=false;
        do{
            System.out.println("Enter Employee number");
            int no=Integer.parseInt(br.readLine()); 
            System.out.println("Enter Employee name");
            String name=br.readLine(); 
            System.out.println("Enter Employee address");
            String addr=br.readLine();
            System.out.println("Enter Employee salary");
            int sal=Integer.parseInt(br.readLine()); 

            int count=stmt.executeUpdate("insert into employee(empid,name,address,salary)  values("+no+",'"+name+"','"+addr+"',"+sal+")");
            if(count>0)
            System.out.println("Insert record successfully");
            else
            System.out.println("record not Insert"); 
            System.out.println("enter another record[yes/no]:");
            String choice=br.readLine();
            if(!choice.equalsIgnoreCase("yes")){
            status=true;
            }
            }
            while(!status);
            }
            }

August 27, 2011 at 2:47 PM

For the above code, do the following:

Follow these steps:

1)Go to the start>>Control Panel>>Administrative Tools>> data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

We have a dsn named 'student'.

Ads









Related Tutorials/Questions & Answers:
jdbc sql exception.
jdbc sql exception.  import java.sql.*; import java.io.*; class InsertEx { public static void main(String args[])throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc
jdbc odbc sql server exception
jdbc odbc sql server exception  Hi, I am trying to use sql server with java jdbc odbc but I am getting this exception java.sql.SQLException: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '@P1
Advertisements
SQL Exception
SQL Exception  I want stores data in to the databse table but it can't be stores it shows an error about sql exception. blackberry.html <...("jdbc:odbc:asset"); String Qry = "INSERT INTO blackberry&
sql-jdbc
sql-jdbc  how to execute select query using prepared statement
SQL exception, Exhausted ResultSet
SQL exception, Exhausted ResultSet  javax.servlet.ServletException: java.sql.SQLException: Exhausted Resultset iam getting this error messege whenever i run my code. what would be the possible reasons
JDBC Exception
JDBC Exception      ... the execution of program. Exception Occurred in JDBC Connectivity when a connection... with ExampleThe Tutorial illustrates an example from JDBC Exception
".txt" to sql with JDBC
".txt" to sql with JDBC  how to insert ".txt" into sql result[BLOB] with JDBC
JDBC- SQL spatio-temporal query
JDBC- SQL spatio-temporal query  Any one give me a JDBC sql query for my spatio temporal query? Trajectory table OBJID PLACE 7 H 8 Q 9 W 10... as shown in above. I want a spatio-temporal query using JDBC-SQL to retrieve
JDBC- SQL spatio-temporal query
JDBC- SQL spatio-temporal query  Any one give me a JDBC sql query for my spatio temporal query? Trajectory table OBJID PLACE 7 H 8 Q 9 W 10... as shown in above. I want a spatio-temporal query using JDBC-SQL to retrieve
SQL STATEMENT in JDBC in NETBEANS IDE
SQL STATEMENT in JDBC in NETBEANS IDE  Iam using NETBEANS IDE. Iam developing a bank application. Using JDBC in SERVLETS For the withdraw function, "bal" and "ano" are user inputs when i wrote like, st.executeQuery("UPDATE
Version of com.foundationdb>fdb-sql-layer-jdbc dependency
List of Version of com.foundationdb>fdb-sql-layer-jdbc dependency
Maven Dependency fdb-sql-layer-jdbc >> 1.9-1-jdbc4
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-1-jdbc4 in your project
Maven Dependency fdb-sql-layer-jdbc >> 1.9-1-jdbc41
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-1-jdbc41 in your project
Maven Dependency fdb-sql-layer-jdbc >> 1.9-3-jdbc4
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-3-jdbc4 in your project
Maven Dependency fdb-sql-layer-jdbc >> 1.9-3-jdbc41
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-3-jdbc41 in your project
Maven Dependency fdb-sql-layer-jdbc >> 1.9-4-jdbc4
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-4-jdbc4 in your project
Maven Dependency fdb-sql-layer-jdbc >> 1.9-4-jdbc41
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-4-jdbc41 in your project
Maven Dependency fdb-sql-layer-jdbc >> 1.9-5-jdbc4
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-5-jdbc4 in your project
Maven Dependency fdb-sql-layer-jdbc >> 1.9-5-jdbc41
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version1.9-5-jdbc41 in your project
Maven Dependency fdb-sql-layer-jdbc >> 2.0-0-jdbc4
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version2.0-0-jdbc4 in your project
Maven Dependency fdb-sql-layer-jdbc >> 2.0-0-jdbc41
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version2.0-0-jdbc41 in your project
Maven Dependency fdb-sql-layer-jdbc >> 2.0-1-jdbc4
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version2.0-1-jdbc4 in your project
Maven Dependency fdb-sql-layer-jdbc >> 2.0-1-jdbc41
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version2.0-1-jdbc41 in your project
Maven Dependency fdb-sql-layer-jdbc >> 2.1-0-jdbc4
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version2.1-0-jdbc4 in your project
Maven Dependency fdb-sql-layer-jdbc >> 2.1-0-jdbc41
You should include the dependency code given in this page to add Maven Dependency of com.foundationdb >> fdb-sql-layer-jdbc version2.1-0-jdbc41 in your project
JDBC Batch Example With SQL Insert Statement
JDBC Batch Example With SQL Insert Statement: In this tutorial, we are discuss about insert SQL statement with the jdbc batch. First of all, we...;com.mysql.jdbc.Driver"); connection = DriverManager.getConnection ("jdbc
JDBC Batch Example With SQL Update Statement
JDBC Batch Example With SQL Update Statement: In this tutorial, we are discuss about update SQL statement with the jdbc batch. Now we will create a java...;com.mysql.jdbc.Driver"); connection = DriverManager.getConnection( "jdbc:mysql
exception
exception  wHEN RUNTIME EXCEPTION CLASS IS SUB OF EXCEPTION CLASS HOW CAN'T HANDLE UNCHECKED EXCEPTION
JDBC Batch Example With SQL Select Statement
JDBC Batch Example With SQL Select Statement: In this example, we are discuss about SQL select statement with JDBC batch process. We will create SQL...;    static final String url = "jdbc
exception
exception  Identify the reason for SQLException exception, which..."); Connection con = DriverManager.getConnection("jdbc:mysql://localhost..."); ps.executeUpdate(); } catch(Exception e
JDBC
JDBC code to save a data in the database  I need a code to save... the connection between java and mysql using JDBC and saves the data into the database...!"); Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String db

Ads