java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ';'.

Coderanch | dhwani mathur | 10 years ago
  1. 0

    Passing data from text file to table.

    Coderanch | 10 years ago | dhwani mathur
    java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ';'.
  2. 0

    SQL server 2000 -> JDBC Date Time Format Problem

    Google Groups | 1 decade ago | mukesh bhakta
    java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL S erver]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
  3. 0

    Java + MSAccess + access function

    Google Groups | 10 years ago | Belgarath
    java.sql.SQLException: [Microsoft][Pilote ODBC Microsoft Access] Fonction 'TempsOuvre' non définie dans l'expression.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL server 2000 -> JDBC Date Time Format Problem

    Google Groups | 1 decade ago | mukesh bhakta
    java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL S erver]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
  6. 0

    "build test" fails on msaccess at RolapResultTest.testAll(). The stack trace is at the bottom Some observations: - If we replace the existing access mdb file with the one from zip archive the tests work for a run immediately after replacement - If we mark the db readonly from the datasource configuration dialog the tests are bypassed hence there is no failure Richard, please let me know if any further information is required Thanks, -Ajit Stack trace: [java] [1440] ........................................ [java] [1480] ........................... [java] There was 1 error: [java] 1) testAll(mondrian.rolap.RolapResultTest)mondrian.olap.MondrianException: Mondrian Error:Internal error: Po pulating member cache with members for [[D1].[Name]]; sql=[select `D1`.`name` as `c0` from `D1` as `D1` group by `D1`.`n ame` order by `D1`.`name` ASC] [java] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:760) [java] at mondrian.olap.Util.newInternal(Util.java:1187) [java] at mondrian.olap.Util.newError(Util.java:1203) [java] at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) [java] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138) [java] at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285) [java] at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:330) [java] at mondrian.rolap.SqlTupleReader.readTuples(SqlTupleReader.java:443) [java] at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:431) [java] at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:422) [java] at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:411) [java] at mondrian.rolap.SqlMemberSource.getRootMembers(SqlMemberSource.java:448) [java] at mondrian.rolap.SmartMemberReader.getRootMembers(SmartMemberReader.java:161) [java] at mondrian.rolap.RolapUtil.lookupMemberInternal(RolapUtil.java:129) [java] at mondrian.rolap.RolapUtil.lookupMember(RolapUtil.java:98) [java] at mondrian.rolap.SmartMemberReader.lookupMember(SmartMemberReader.java:253) [java] at mondrian.rolap.RolapHierarchy.init(RolapHierarchy.java:298) [java] at mondrian.rolap.RolapDimension.init(RolapDimension.java:194) [java] at mondrian.rolap.RolapCube.init(RolapCube.java:1072) [java] at mondrian.rolap.RolapCube.<init>(RolapCube.java:262) [java] at mondrian.rolap.RolapSchema.load(RolapSchema.java:436) [java] at mondrian.rolap.RolapSchema.load(RolapSchema.java:335) [java] at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216) [java] at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:79) [java] at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:904) [java] at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:715) [java] at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) [java] at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) [java] at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) [java] at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) [java] at mondrian.test.TestContext.getFoodMartConnection(TestContext.java:211) [java] at mondrian.test.TestContext.getConnection(TestContext.java:192) [java] at mondrian.test.TestContext.executeQuery(TestContext.java:424) [java] at mondrian.test.TestContext.assertQueryReturns(TestContext.java:662) [java] at mondrian.rolap.RolapResultTest.testAll(RolapResultTest.java:100) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:130) [java] at java.lang.Thread.run(Thread.java:595) [java] Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engin e cannot find the input table or query 'D1'. Make sure it exists and that its name is spelled correctly. [java] at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) [java] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) [java] at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111) [java] at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) [java] at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253) [java] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:188) [java] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) [java] ... 46 more [java] FAILURES!!! [java] Tests run: 1507, Failures: 0, Errors: 1

    Pentaho BI Platform Tracking | 9 years ago | ajit_joglekar
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Po pulating member cache with members for [[D1].[Name]]; sql=[select `D1`.`name` as `c0` from `D1` as `D1` group by `D1`.`n ame` order by `D1`.`name` ASC]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ';'.

      at sun.jdbc.odbc.JdbcOdbc.createSQLException()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeQuery
      1. sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
      2. sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
      3. sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
      4. sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
      5. sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
      5 frames
    3. client.com.kolkata
      ReadingText.main
      1. client.com.kolkata.Read.ReadingText.main(ReadingText.java:38)
      1 frame