Guest User

Untitled

a guest
Jan 11th, 2019
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.36 KB | None | 0 0
  1. create table student(id int, name varchar(50), class varchar(10));
  2. insert into student values(1,'Akshay','FYCS'),(2,'Narayan','SYCS');
  3.  
  4. select * from student;
  5.  
  6. package embeddeddb;
  7.  
  8. import java.sql.*;
  9.  
  10. public class EmbeddedDB
  11. {
  12. public static void main(String[] args) throws SQLException, ClassNotFoundException
  13. {
  14. Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
  15. Connection con=DriverManager.getConnection("jdbc:derby:myDB","username","password");
  16. Statement stmt=con.createStatement();
  17.  
  18. ResultSet rs=stmt.executeQuery("select NAME from STUDENT where ID=1");
  19. rs.next();
  20. System.out.println(rs.getString(1));
  21. }
  22. }
  23.  
  24. run:
  25. Exception in thread "main" java.sql.SQLException: Database 'myDB' not found.
  26. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  27. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
  28. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
  29. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
  30. at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
  31. at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
  32. at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
  33. at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
  34. at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
  35. at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
  36. at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
  37. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  38. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  39. at embeddeddb.EmbeddedDB.main(EmbeddedDB.java:11)
  40. Caused by: ERROR XJ004: Database 'myDB' not found.
  41. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
  42. at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
  43. ... 14 more
  44. C:UsersDell 7559AppDataLocalNetBeansCache10.0executor-snippetsrun.xml:111: The following error occurred while executing this line:
  45. C:UsersDell 7559AppDataLocalNetBeansCache10.0executor-snippetsrun.xml:94: Java returned: 1
  46. BUILD FAILED (total time: 0 seconds)
  47.  
  48. Connection con=DriverManager.getConnection("jdbc:derby:myDB","username","password");
Add Comment
Please, Sign In to add comment