Menu ▾ ▴

Acessing Access database from user drive in phpstorm

Help
Afonso Rocha
2020-05-03
2020-05-03

  • Afonso Rocha

    Afonso Rocha - 2020-05-03

    I'm having problem trying to view the tables that are in the Access database (mdb) on my computer in PhpStorm.
    It shows that that it is not supported but its connected and when i try to view a table this baloon pops up saying all theses types of errors.
    What should I do?

    Thank you

    [42581][-5581] UCAExc:::5.0.0-SNAPSHOT unexpected token: AcqVazNat
    java.lang.RuntimeException: org.hsqldb.HsqlException: unexpected token: AcqVazNat
    at org.hsqldb.error.Error.parseError(Unknown Source)
    at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
    at org.hsqldb.ParserBase.checkIsIdentifier(Unknown Source)
    at org.hsqldb.ParserDQL.readTableName(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)
    at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    at net.ucanaccess.jdbc.Execute.executeWrapped(Execute.java:54)
    at net.ucanaccess.jdbc.AbstractExecute.executeBase(AbstractExecute.java:264)
    at net.ucanaccess.jdbc.Execute.execute(Execute.java:44) at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:157)
    RemoteStatementImpl.execute(RemoteStatementImpl.java:78) (no stack trace)

     

    • Marco Amadei

      Marco Amadei - 2020-05-03

      You wrote a wrong sql.
      Cheers Marco

      Il Dom 3 Mag 2020, 02:08 Afonso Rocha afonso101@users.sourceforge.net ha
      scritto:

      I'm having problem trying to view the tables that are in the Access
      database (mdb) on my computer in PhpStorm.
      It shows that that it is not supported but its connected and when i try to
      view a table this baloon pops up saying all theses types of errors.
      What should I do?

      Thank you

      [42581][-5581] UCAExc:::5.0.0-SNAPSHOT unexpected token: AcqVazNat
      java.lang.RuntimeException: org.hsqldb.HsqlException: unexpected token:
      AcqVazNat
      at org.hsqldb.error.Error.parseError(Unknown Source)
      at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
      at org.hsqldb.ParserBase.checkIsIdentifier(Unknown Source)
      at org.hsqldb.ParserDQL.readTableName(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)
      at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
      at net.ucanaccess.jdbc.Execute.executeWrapped(Execute.java:54)
      at
      net.ucanaccess.jdbc.AbstractExecute.executeBase(AbstractExecute.java:264)
      at net.ucanaccess.jdbc.Execute.execute(Execute.java:44) at
      net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:157)
      RemoteStatementImpl.execute(RemoteStatementImpl.java:78) (no stack trace)

      Acessing Access database from user drive in phpstorm
      https://sourceforge.net/p/ucanaccess/discussion/help/thread/04f6874362/?limit=25#cf5b

      Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to
      https://sourceforge.net/p/ucanaccess/discussion/help/

      To unsubscribe from further messages, a project admin can change settings
      at https://sourceforge.net/p/ucanaccess/admin/discussion/forums. Or, if
      this is a mailing list, you can unsubscribe from the mailing list.

       
      alternate

  • Afonso Rocha

    Afonso Rocha - 2020-05-03

    Can you show me the alternative? I can't open it

     

  • Gord Thompson

    Gord Thompson - 2020-05-03

    Try running either console.bat or console.sh from the root folder of the UCanAccess distribution and see if "AcqVazNat" appears in the list of tables.

     

  • Afonso Rocha

    Afonso Rocha - 2020-05-03

    All the tables appear on the console but they are missing some fields too.

     

Log in to post a comment.