Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table student(id int, name varchar(50), class varchar(10));
- insert into student values(1,'Akshay','FYCS'),(2,'Narayan','SYCS');
- select * from student;
- package embeddeddb;
- import java.sql.*;
- public class EmbeddedDB
- {
- public static void main(String[] args) throws SQLException, ClassNotFoundException
- {
- Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
- Connection con=DriverManager.getConnection("jdbc:derby:myDB","username","password");
- Statement stmt=con.createStatement();
- ResultSet rs=stmt.executeQuery("select NAME from STUDENT where ID=1");
- rs.next();
- System.out.println(rs.getString(1));
- }
- }
- run:
- Exception in thread "main" java.sql.SQLException: Database 'myDB' not found.
- at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
- at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
- at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
- at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
- at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
- at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
- at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
- at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
- at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
- at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
- at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
- at java.sql.DriverManager.getConnection(DriverManager.java:664)
- at java.sql.DriverManager.getConnection(DriverManager.java:247)
- at embeddeddb.EmbeddedDB.main(EmbeddedDB.java:11)
- Caused by: ERROR XJ004: Database 'myDB' not found.
- at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
- at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
- ... 14 more
- C:UsersDell 7559AppDataLocalNetBeansCache10.0executor-snippetsrun.xml:111: The following error occurred while executing this line:
- C:UsersDell 7559AppDataLocalNetBeansCache10.0executor-snippetsrun.xml:94: Java returned: 1
- BUILD FAILED (total time: 0 seconds)
- Connection con=DriverManager.getConnection("jdbc:derby:myDB","username","password");
Add Comment
Please, Sign In to add comment