Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- `<dependencies>
- <!-- https://mvnrepository.com/artifact/net.sf.ucanaccess/ucanaccess -->
- <dependency>
- <groupId>net.sf.ucanaccess</groupId>
- <artifactId>ucanaccess</artifactId>
- <version>4.0.3</version>
- </dependency>
- </dependencies>
- import java.sql.*;
- public class MSAccess {
- public static void main (String args[]) {
- try {
- Connection conn = DriverManager.getConnection
- ("jdbc:ucanaccess://C:/Java_project/Base_access/db1.mdb", null, null);
- Statement statement = conn.createStatement();
- ResultSet resultQuery = statement.executeQuery
- ("SELECT Nazv_org FROM TABLE abonent");
- while (resultQuery.next()) {
- System.out.println(resultQuery.getString(1));
- }
- resultQuery.close();
- conn.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
- Connection conn = DriverManager.getConnection
- ("jdbc:ucanaccess://C:/Java_project/Base_access/db1.mdb");
- Connection conn =DriverManager.getConnection
- ("jdbc:ucanaccess://C:/Java_project/Base_access/db1.mdb", "", "");
- net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.3
- unexpected token: ABONENT required: (
- at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery
- (UcanaccessStatement.java:218)
- at MSAccess.MSAccess.main(MSAccess.java:23)
- Caused by: java.sql.SQLSyntaxErrorException: unexpected token: ABONENT
- required: (
- at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
- at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
- at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
- at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
- at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery
- (UcanaccessStatement.java:216)
- ... 1 more
- Caused by: org.hsqldb.HsqlException: unexpected token: ABONENT required: (
- at org.hsqldb.error.Error.parseError(Unknown Source)
- at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source)
- at org.hsqldb.ParserBase.readThis(Unknown Source)
- at org.hsqldb.ParserDQL.XreadTableFunctionDerivedTable(Unknown Source)
- at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
- at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
- at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
- at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
- at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
- at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
- at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
- at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
- at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
- at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
- at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
- at org.hsqldb.ParserCommand.compilePart(Unknown Source)
- at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
- at org.hsqldb.Session.executeDirectStatement(Unknown Source)
- at org.hsqldb.Session.execute(Unknown Source)
Add Comment
Please, Sign In to add comment