While in CallableStatament using in the oracle my procedure
is return no.of columns so in java how can i retrivbe the
data and i wnat to view all data which is reetrive from my
procedure
No Answer is Posted For this Question
Be the First to Post Answer
how can we connect to db without using getConnection() method
How to retrieve warnings in jdbc?
How to execute bulk number of queries at once?
PreparedStatement is a pre compiled statement but where it's pre compiled ?
wahts is mean by primary key and unique key?
What are the different types of JDBC drivers?
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
What is the jdbc rowset?
Describe how the jdbc application works.
dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me
How the information about db(database) can be retrieved?
What are clob and blob data types in jdbc?