Guest User

Untitled

a guest
Mar 4th, 2018
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.88 KB | None | 0 0
  1. `<dependencies>
  2. <!-- https://mvnrepository.com/artifact/net.sf.ucanaccess/ucanaccess -->
  3. <dependency>
  4. <groupId>net.sf.ucanaccess</groupId>
  5. <artifactId>ucanaccess</artifactId>
  6. <version>4.0.3</version>
  7. </dependency>
  8. </dependencies>
  9.  
  10. import java.sql.*;
  11.  
  12. public class MSAccess {
  13.  
  14. public static void main (String args[]) {
  15.  
  16. try {
  17. Connection conn = DriverManager.getConnection
  18. ("jdbc:ucanaccess://C:/Java_project/Base_access/db1.mdb", null, null);
  19.  
  20.  
  21. Statement statement = conn.createStatement();
  22. ResultSet resultQuery = statement.executeQuery
  23. ("SELECT Nazv_org FROM TABLE abonent");
  24.  
  25. while (resultQuery.next()) {
  26. System.out.println(resultQuery.getString(1));
  27. }
  28. resultQuery.close();
  29. conn.close();
  30. } catch (Exception e) {
  31. e.printStackTrace();
  32. }
  33. }
  34. }
  35.  
  36. Connection conn = DriverManager.getConnection
  37. ("jdbc:ucanaccess://C:/Java_project/Base_access/db1.mdb");
  38.  
  39. Connection conn =DriverManager.getConnection
  40. ("jdbc:ucanaccess://C:/Java_project/Base_access/db1.mdb", "", "");
  41.  
  42. net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.3
  43. unexpected token: ABONENT required: (
  44.  
  45. at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery
  46. (UcanaccessStatement.java:218)
  47.  
  48. at MSAccess.MSAccess.main(MSAccess.java:23)
  49.  
  50. Caused by: java.sql.SQLSyntaxErrorException: unexpected token: ABONENT
  51. required: (
  52.  
  53. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  54. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  55. at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
  56. at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
  57. at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery
  58. (UcanaccessStatement.java:216)
  59.  
  60. ... 1 more
  61.  
  62. Caused by: org.hsqldb.HsqlException: unexpected token: ABONENT required: (
  63. at org.hsqldb.error.Error.parseError(Unknown Source)
  64. at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source)
  65. at org.hsqldb.ParserBase.readThis(Unknown Source)
  66. at org.hsqldb.ParserDQL.XreadTableFunctionDerivedTable(Unknown Source)
  67. at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
  68. at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
  69. at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
  70. at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
  71. at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
  72. at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
  73. at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
  74. at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
  75. at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
  76. at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
  77. at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
  78. at org.hsqldb.ParserCommand.compilePart(Unknown Source)
  79. at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
  80. at org.hsqldb.Session.executeDirectStatement(Unknown Source)
  81. at org.hsqldb.Session.execute(Unknown Source)
Add Comment
Please, Sign In to add comment