Advertisement
Guest User

Untitled

a guest
Mar 21st, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. public class Main {
  2.  
  3. public static void main(String[] args) throws SQLException {
  4. final String driver="org.apache.derby.jdbc.EmbeddedDriver";
  5. final String url="jdbc:derby:db/testdb";
  6.  
  7. try {
  8. Class.forName(driver);
  9. Connection connection=DriverManager.getConnection(url);
  10.  
  11. //connection.createStatement().execute("create table channels(channel varchar(20),topic varchar(20))");
  12. // connection.createStatement().execute("insert into channels (channel,topic) values('hbo','action')");
  13. // System.out.println("saved");
  14. PreparedStatement preStmt=connection.prepareStatement("select * from channels");
  15. ResultSet set=null;
  16. set=preStmt.executeQuery();
  17.  
  18. while(set.next()){
  19.  
  20.  
  21. System.out.print(set.getString(1));
  22. System.out.println(set.getString(2));
  23.  
  24. }
  25.  
  26. } catch (ClassNotFoundException e) {
  27.  
  28. e.printStackTrace();
  29. }
  30.  
  31. }
  32.  
  33. Exception in thread "main" SQL Exception: Database 'db/testdb' not found.
  34. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  35. at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
  36. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Sourc
  37.  
  38. cd D:Projectderbydb
  39. set JAVA_HOME=C:/Program Files/Java/jdk1.8.0_92
  40. set DERBY_HOME=C:/Program Files/Java/jdk1.8.0_92/db
  41. set PATH=%PATH%;%DERBY_HOME%/bin
  42.  
  43. D:Projectderbydb>ij
  44. ij version 10.11
  45. ij> CONNECT 'jdbc:derby:testdb;create=true';
  46.  
  47. ij> CREATE TABLE cart (
  48. item VARCHAR(50),
  49. price DECIMAL (10,5),
  50. dt TIMESTAMP,
  51. primary key (item)
  52. );
  53. ij> select * from cart;
  54.  
  55. C:Usersoraclesoon>ij
  56. ij version 10.11
  57. ij> CONNECT 'jdbc:derby:D:\Project\derbydb\testdb';
  58. ij> select * from cart;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement