facebook
  1. MyEclipse Archived
    2.  > 
  2. Database Tools (DB Explorer, Hibernate, etc.)

Q: Using MyEclipse Database View – ODBC errors

  1. MyEclipse Archived
    2.  > 
  2. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 15 posts - 1 through 15 (of 16 total)
1 2
  • Author
    Posts
  • January 25, 2007 at 5:19 pm #265167 Reply

    adam_j_bradley
    Member

    I’m receiving the following errors when trying to connect using the jdbc:odbc bridge

    —snip—
    startup 12e8-2ff8 ENTER SQLTablesW
    HSTMT 05F71BB0
    WCHAR * 0x05F719F0 [ -3] “%\ 0”
    SWORD -3
    WCHAR * 0x05F71B00 [ -3] “\ 0”
    SWORD -3
    WCHAR * 0x05F71B18 [ -3] “\ 0”
    SWORD -3
    WCHAR * 0x00000000 [ -3] <empty string>
    SWORD -3

    startup 12e8-2ff8 EXIT SQLTablesW with return code -1 (SQL_ERROR)
    HSTMT 05F71BB0
    WCHAR * 0x05F719F0 [ -3] “%\ 0”
    SWORD -3
    WCHAR * 0x05F71B00 [ -3] “\ 0”
    SWORD -3
    WCHAR * 0x05F71B18 [ -3] “\ 0”
    SWORD -3
    WCHAR * 0x00000000 [ -3] <empty string>
    SWORD -3

    DIAG [26000] [MYOB ODBC]Invalid SQL statement identifier (0)

    startup 12e8-2ff8 ENTER SQLErrorW
    HENV 00000000
    HDBC 00000000
    HSTMT 05F71BB0
    WCHAR * 0x05DCF864 (NYI)
    SDWORD * 0x05DCF8AC
    WCHAR * 0x05DCF464
    SWORD 300
    SWORD * 0x05DCF8A8

    startup 12e8-2ff8 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
    HENV 00000000
    HDBC 00000000
    HSTMT 05F71BB0
    WCHAR * 0x05DCF864 (NYI)
    SDWORD * 0x05DCF8AC (0)
    WCHAR * 0x05DCF464 [ 43] “[MYOB ODBC]Invalid SQL statement identifier”
    SWORD 300
    SWORD * 0x05DCF8A8 (43)

    startup 12e8-2ff8 ENTER SQLErrorW
    HENV 00000000
    HDBC 00000000
    HSTMT 05F71BB0
    WCHAR * 0x05DCF864 (NYI)
    SDWORD * 0x05DCF8AC
    WCHAR * 0x05DCF464
    SWORD 300
    SWORD * 0x05DCF8A8

    startup 12e8-2ff8 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
    HENV 00000000
    HDBC 00000000
    HSTMT 05F71BB0
    WCHAR * 0x05DCF864 (NYI)
    SDWORD * 0x05DCF8AC
    WCHAR * 0x05DCF464
    SWORD 300
    SWORD * 0x05DCF8A8

    startup 12e8-2ff8 ENTER SQLFreeStmt
    HSTMT 05F71BB0
    UWORD 1 <SQL_DROP>

    startup 12e8-2ff8 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
    HSTMT 05F71BB0
    UWORD 1 <SQL_DROP>

    —snip—

    Any ideas?
    Thanks!
    Adam

    January 25, 2007 at 5:40 pm #265169 Reply

    Haris Peco
    Member

    Adam,

    JDBC/ODBC bridge haven’t good support in MyEclipse.It is better that you use true JDBC driver.
    What is your database ?

    Regards,

    January 25, 2007 at 7:53 pm #265170 Reply

    adam_j_bradley
    Member

    The database is OpenRDA via the JDBC-ODBC bridge

    1:52:43,093 INFO DriverManagerConnectionProvider:80 – using driver: sun.jdbc.odbc.JdbcOdbcDriver at URL: jdbc:odbc:Acme;HOST_EXE_PATH=C:\myob15\MYOB.exe;ACCESS_TYPE=READ_WRITE
    11:52:43,093 INFO DriverManagerConnectionProvider:86 – connection properties: {user=Administrator, password=****}
    CLI : [TID: 2818]:[Fri Jan 26 11:52:43 2007] rdacstmt.c:99: *** rda_cliAllocStmt: connection is not opened
    SQLD: [TID: 2818]:[Fri Jan 26 11:52:44 2007] damdrv.c:4760: Driver:MYOB did not register the setInfo function. Option is being ignored
    11:52:44,703 INFO SettingsFactory:81 – RDBMS: OpenRDA, version: 5.00.63.0
    11:52:44,703 INFO SettingsFactory:82 – JDBC driver: JDBC-ODBC Bridge (odbcmyob), version: 2.0001 (5.7.0000)

    January 26, 2007 at 10:47 am #265214 Reply

    Haris Peco
    Member

    Adam,

    We haven’t tested with your databases.Please could you try simple application form this thread https://www.genuitec.com/forums/topic/problems-on-browsing-an-informix-database/#post-265202
    Is there true JDBC driver for your database ?

    Regards,

    January 28, 2007 at 7:21 pm #265266 Reply

    adam_j_bradley
    Member

    Peco,

    I ran your sample code and it returned the following. I’ve been told there is no JDBC driver for this database.
    Adam

    —snip—
    CLI : [TID: 24E4]:[Mon Jan 29 11:18:07 2007] rdacstmt.c:99: *** rda_cliAllocStmt: connection is not opened
    SQLD: [TID: 24E4]:[Mon Jan 29 11:18:09 2007] damdrv.c:4760: Driver:MYOB did not register the setInfo function. Option is being ignored
    AccountActivities
    AccountBudgets
    ActivitySalesHistory
    ActivitySlipInvoiced
    BankDeposits
    BillingRateUsed
    BuildComponents
    BuiltItems
    CardActivities
    CardTypes
    CreditRefunds
    Currency
    CustomerPaymentLines
    DepositStatus
    EmploymentBasis
    InvoiceType
    ItemPurchasesHistory
    ItemSalesHistory
    LineType
    PriceLevels
    PurchasesHistory
    ReconciliationStatus
    ReportingMethod
    SalesHistory
    SalespersonHistory
    TaxCodes
    TaxCodeConsolidations
    TaxCodeTypes
    TaxInformation
    TaxInformationConsolidations
    Terms
    TermsOfPayment
    SupplierDeposits
    SupplierFinanceCharges
    SupplierPaymentLines
    Cards
    Address
    Activities
    BankDepositLines
    BasisTypes
    Deductions
    EmployerExpenseTypes
    Entitlements
    Identifiers
    ItemPrices
    Items
    PayBasis
    PayrollTaxes
    PersonalCards
    SupplierPayments
    Wages
    AccountingBasis
    BASInformation
    CalculationMethod
    Comments
    ContactLog
    CostCentreAccountActivities
    CostCentreAccounts
    CostCentreJournalRecords
    CostCentres
    CustomerDiscountLines
    CustomLists
    DeductionHistory
    EmployerExpenseHistory
    EmployerExpenses
    EntitlementCarryOver
    EntitlementHistory
    Frequencies
    ReferralSources
    InventoryAdjustments
    InventoryTransfers
    ItemMovement
    ItemOpeningBalance
    JobAccounts
    JobAccountActivities
    JobJournalRecords
    Jobs
    JobBudgets
    JournalSets
    JournalTypes
    PaymentMethods
    PayrollTaxHistory
    Rounding
    SettledCredits
    SettledCreditLines
    SettledDebits
    SettledDebitLines
    ShippingMethods
    TaxScales
    SupplierDiscounts
    SupplierDiscountLines
    WageDollarHistory
    WageHourHistory
    Users
    AccountClassification
    Accounts
    AccountType
    CashFlowClassifications
    CategoryTypes
    ContributionTypes
    CustomerDeposits
    CustomerDiscounts
    CustomerFinanceCharges
    CustomerPayments
    DebitRefunds
    ElectronicPayments
    ElectronicPaymentLines
    PaySuperannuationLines
    PaySuperannuation
    SubAccountTypes
    Superannuation
    SuperannuationFunds
    SuperannuationHistory
    ValueTypes
    Import_Accounts
    Import_Activities
    Import_Activity_Slips
    Import_Consolidated_TaxCodes
    Import_Customer_Cards
    Import_General_Journals
    Import_Employee_Cards
    Import_Item_Purchases
    Import_Item_Sales
    Import_Items
    Import_Jobs
    Import_Miscellaneous_Purchases
    Import_Miscellaneous_Sales
    Import_NonConsolidated_TaxCodes
    Import_Pay_Bills
    Import_Personal_Cards
    Import_Professional_Purchases
    Import_Professional_Sales
    Import_Receive_Money
    Import_Receive_Payments
    Import_Service_Sales
    Import_Service_Purchases
    Import_Spend_Money
    Import_Supplier_Cards
    Import_TimeBilling_Sales
    Import_Transaction_Journals
    ActivitySlips
    AuditTrail
    AuditTypes
    BankingDetails
    Customers
    DataFileInformation
    Employees
    EmploymentClassifications
    GeneralJournals
    GeneralJournalLines
    ImportErrors
    ImportWarnings
    InventoryAdjustmentLines
    InventoryTransferLines
    InvoiceDelivery
    ItemPurchaseLines
    ItemSaleLines
    JournalRecords
    LimitTypes
    LinkedAccounts
    MiscPurchaseLines
    MiscSaleLines
    MoneyReceived
    MoneyReceivedLines
    MoneySpentLines
    MoneySpent
    InternalODBCErrors
    PaymentTypes
    PayrollInformation
    ProfessionalSaleLines
    ProfessionalPurchaseLines
    PurchaseLines
    Purchases
    RecurringPay
    Sales
    SaleLines
    ServicePurchaseLines
    ServiceSaleLines
    Status
    TimeBillingSaleLines
    TransferMoney
    Suppliers
    WritePaycheque
    WritePaychequeLines
    ItemPurchaseLinesAll
    ItemSaleLinesAll
    MiscPurchaseLinesAll
    MiscSaleLinesAll
    ProfessionalSaleLinesAll
    ProfessionalPurchaseLinesAll
    PurchaseLinesAll
    SaleLinesAll
    ServicePurchaseLinesAll
    ServiceSaleLinesAll
    TimeBillingSaleLinesAll
    CLI : [TID: 24E4]:[Mon Jan 29 11:18:09 2007] rdachenv.c:342: rda_cliFreeEnv() 1 connection handles still exist under this environment handle

    January 28, 2007 at 8:21 pm #265267 Reply

    Haris Peco
    Member

    Adam,

    It looks that your driver support JDBC partial.It is hard for me tell more about your issue without access to database and driver.
    Is it open source database ?

    Regards,

    January 28, 2007 at 9:02 pm #265268 Reply

    adam_j_bradley
    Member

    ODBC debug revealed the following

    Get Info All:
    fInfoType, pcbInfoValue, rgbInfoValue
    SQL_ACCESSIBLE_PROCEDURES=20, 1, “Y”
    SQL_ACCESSIBLE_TABLES=19, 1, “Y”
    SQL_ACTIVE_CONNECTIONS=0, 2, 0
    SQL_ACTIVE_ENVIRONMENTS=116, 2, 0
    SQL_ACTIVE_STATEMENTS=1, 2, 0
    SQL_ALTER_DOMAIN=117, 4, 0x00000000
    SQL_ALTER_TABLE=86, 4, 0x000093EB = SQL_AT_ADD_COLUMN
    | SQL_AT_DROP_COLUMN | SQL_AT_ADD_CONSTRAINT | SQL_AT_ADD_COLUMN_SINGLE
    | SQL_AT_ADD_COLUMN_DEFAULT | SQL_AT_ADD_COLUMN_COLLATION | SQL_AT_SET_COLUMN_DEFAULT
    | SQL_AT_DROP_COLUMN_DEFAULT | SQL_AT_ADD_TABLE_CONSTRAINT | SQL_AT_CONSTRAINT_NAME_DEFINITION
    SQL_SQL_CONFORMANCE=118, 4, SQL_SC_SQL92_ENTRY = 1
    SQL_DATETIME_LITERALS=119, 4, 0x00000000
    SQL_ASYNC_MODE=10021,
    SQL_BATCH_ROW_COUNT=120, 4, 0x00000000
    SQL_BATCH_SUPPORT=121, 4, 0x00000000
    SQL_BOOKMARK_PERSISTENCE=82, 4, 0x00000000
    SQL_CATALOG_LOCATION=114, 2, SQL_CL_START = 1
    SQL_CATALOG_NAME=10003, 0, “Y”
    SQL_CATALOG_NAME_SEPARATOR=41, 1, “.”
    SQL_CATALOG_TERM=42, 8, “database”
    SQL_CATALOG_USAGE=92, 4, 0x00000007 = SQL_CU_DML_STATEMENTS | SQL_CU_PROCEDURE_INVOCATION | SQL_CU_TABLE_DEFINITION
    SQL_COLLATION_SEQ=10004, 10, “ISO 8859-1”
    SQL_COLUMN_ALIAS=87, 1, “Y”
    SQL_CONCAT_NULL_BEHAVIOR=22, 2, SQL_CB_NULL = 0
    SQL_CONVERT_BIGINT=53, 4, 0x00000000
    SQL_CONVERT_BINARY=54, 4, 0x00000000
    SQL_CONVERT_BIT=55, 4, 0x00000000
    SQL_CONVERT_CHAR=56, 4, 0x00000000
    SQL_CONVERT_DATE=57, 4, 0x00000000
    SQL_CONVERT_DECIMAL=58, 4, 0x00000000
    SQL_CONVERT_DOUBLE=59, 4, 0x00000000
    SQL_CONVERT_FLOAT=60, 4, 0x00000000
    SQL_CONVERT_FUNCTIONS=48, 4, 0x00000000
    SQL_CONVERT_INTEGER=61, 4, 0x00000000
    SQL_CONVERT_INTERVAL_YEAR_MONTH=124, 4, 0x00000000
    SQL_CONVERT_INTERVAL_DAY_TIME=123, 4, 0x00000000
    SQL_CONVERT_LONGVARBINARY=71, 4, 0x00000000
    SQL_CONVERT_LONGVARCHAR=62, 4, 0x00000000
    SQL_CONVERT_NUMERIC=63, 4, 0x00000000
    SQL_CONVERT_REAL=64, 4, 0x00000000
    SQL_CONVERT_SMALLINT=65, 4, 0x00000000
    SQL_CONVERT_TIME=66, 4, 0x00000000
    SQL_CONVERT_TIMESTAMP=67, 4, 0x00000000
    SQL_CONVERT_TINYINT=68, 4, 0x00000000
    SQL_CONVERT_VARBINARY=69, 4, 0x00000000
    SQL_CONVERT_VARCHAR=70, 4, 0x00000000
    SQL_CONVERT_WCHAR=122, 4, 0x00000000
    SQL_CONVERT_WLONGVARCHAR=125, 4, 0x00000000
    SQL_CONVERT_WVARCHAR=126, 4, 0x00000000
    SQL_CORRELATION_NAME=74, 2, SQL_CN_ANY = 2
    SQL_CREATE_ASSERTION=127, 4, 0x00000000
    SQL_CREATE_CHARACTER_SET=128, 4, 0x00000000
    SQL_CREATE_COLLATION=129, 4, 0x00000000
    SQL_CREATE_DOMAIN=130, 4, 0x00000000
    SQL_CREATE_SCHEMA=131, 4, 0x00000000
    SQL_CREATE_TABLE=132, 4, 0x00000001 = SQL_CT_CREATE_TABLE
    SQL_CREATE_TRANSLATION=133, 4, 0x00000000
    SQL_CREATE_VIEW=134, 4, 0x00000001 = SQL_CV_CREATE_VIEW
    SQL_CURSOR_COMMIT_BEHAVIOR=23, 2, SQL_CB_PRESERVE = 2
    SQL_CURSOR_ROLLBACK_BEHAVIOR=24, 2, SQL_CB_PRESERVE = 2
    SQL_CURSOR_SENSITIVITY=10001, 4, SQL_SENSITIVE = 2
    SQL_DATA_SOURCE_NAME=2, 13, “ClearWaterNew”
    SQL_DATA_SOURCE_READ_ONLY=25, 1, “N”
    SQL_DATABASE_NAME=16, 6, “SCHEMA”
    SQL_DBMS_NAME=17, 7, “OpenRDA”
    SQL_DBMS_VER=18, 9, “5.00.63.0”
    SQL_DEFAULT_TXN_ISOLATION=26, 4, SQL_TXN_READ_COMMITTED = 2
    SQL_DESCRIBE_PARAMETER=10002, 0, “Y”
    SQL_DM_VER=171, 15, “03.52.1117.0000”
    SQL_DRIVER_HDBC=3, 4, 0x000B0008
    SQL_DRIVER_HDESC=135, 4, 0x01840E80
    SQL_DRIVER_HENV=4, 4, 0x0008E428
    SQL_DRIVER_HLIB=76, 4, 0x01090000
    SQL_DRIVER_HSTMT=5, 4, 0x000AA368
    SQL_DRIVER_NAME=6, 8, “odbcmyob”
    SQL_DRIVER_ODBC_VER=77, 5, “03.51”
    SQL_DRIVER_VER=7, 8, “5.7.0000”
    SQL_DROP_ASSERTION=136, 4, 0x00000000
    SQL_DROP_CHARACTER_SET=137, 4, 0x00000000
    SQL_DROP_COLLATION=138, 4, 0x00000000
    SQL_DROP_DOMAIN=139, 4, 0x00000000
    SQL_DROP_SCHEMA=140, 4, 0x00000000
    SQL_DROP_TABLE=141, 4, 0x00000001 = SQL_DT_DROP_TABLE
    SQL_DROP_TRANSLATION=142, 4, 0x00000000
    SQL_DROP_VIEW=143, 4, 0x00000001 = SQL_DV_DROP_VIEW
    SQL_DYNAMIC_CURSOR_ATTRIBUTES1=144, 4, 0x00000000
    SQL_DYNAMIC_CURSOR_ATTRIBUTES2=145, 4, 0x00000000
    SQL_EXPRESSIONS_IN_ORDERBY=27, 1, “Y”
    SQL_FETCH_DIRECTION=8, 4, 0x00000001 = SQL_FD_FETCH_NEXT
    SQL_FILE_USAGE=84, 2, SQL_FILE_NOT_SUPPORTED = 0
    SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1=146, 4, 0x00000001 = SQL_CA1_NEXT
    SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2=147, 4, 0x00000000
    SQL_GETDATA_EXTENSIONS=81, 4, 0x00000003 = SQL_GD_ANY_COLUMN | SQL_GD_ANY_ORDER
    SQL_GROUP_BY=88, 2, SQL_GB_GROUP_BY_CONTAINS_SELECT = 2
    SQL_IDENTIFIER_CASE=28, 2, SQL_IC_MIXED = 4
    SQL_IDENTIFIER_QUOTE_CHAR=29, 1, “””
    SQL_INDEX_KEYWORDS=148, 4, 0x00000003 = SQL_IK_ASC | SQL_IK_DESC
    SQL_INFO_SCHEMA_VIEWS=149, 4, 0x00000000
    SQL_INTEGRITY=73, 1, “N”
    SQL_KEYSET_CURSOR_ATTRIBUTES1=150, 4, 0x00000000
    SQL_KEYSET_CURSOR_ATTRIBUTES2=151, 4, 0x00000000
    SQL_KEYWORDS=89, 15, “HINT,IDENTIFIED”
    SQL_LIKE_ESCAPE_CLAUSE=113, 1, “Y”
    SQL_LOCK_TYPES=78, 4, 0x00000000
    SQL_MAX_ASYNC_CONCURRENT_STATEMENTS=10022, 4, 0
    SQL_MAX_BINARY_LITERAL_LEN=112, 4, 8192
    SQL_MAX_CATALOG_NAME_LEN=34, 2, 128
    SQL_MAX_CHAR_LITERAL_LEN=108, 4, 8192
    SQL_MAX_COLUMN_NAME_LEN=30, 2, 128
    SQL_MAX_COLUMNS_IN_GROUP_BY=97, 2, 0
    SQL_MAX_COLUMNS_IN_INDEX=98, 2, 0
    SQL_MAX_COLUMNS_IN_ORDER_BY=99, 2, 0
    SQL_MAX_COLUMNS_IN_SELECT=100, 2, 0
    SQL_MAX_COLUMNS_IN_TABLE=101, 2, 0
    SQL_MAX_CONCURRENT_ACTIVITIES=1, 2, 0
    SQL_MAX_CURSOR_NAME_LEN=31, 2, 128
    SQL_MAX_DRIVER_CONNECTIONS=0, 2, 0
    SQL_MAX_IDENTIFIER_LEN=10005, 2, 128
    SQL_MAX_INDEX_SIZE=102, 4, 73
    SQL_MAX_PROCEDURE_NAME_LEN=33, 2, 128
    SQL_MAX_ROW_SIZE=104, 4, 0
    SQL_MAX_ROW_SIZE_INCLUDES_LONG=103, 1, “N”
    SQL_MAX_SCHEMA_NAME_LEN=32, 2, 128
    SQL_MAX_STATEMENT_LEN=105, 4, 32768
    SQL_MAX_TABLE_NAME_LEN=35, 2, 128
    SQL_MAX_TABLES_IN_SELECT=106, 2, 0
    SQL_MAX_USER_NAME_LEN=107, 2, 32
    SQL_MAX_OWNER_NAME_LEN=32, 2, 128
    SQL_MAX_QUALIFIER_NAME_LEN=34, 2, 128
    SQL_MULT_RESULT_SETS=36, 1, “Y”
    SQL_MULTIPLE_ACTIVE_TXN=37, 1, “Y”
    SQL_NEED_LONG_DATA_LEN=111, 1, “N”
    SQL_NON_NULLABLE_COLUMNS=75, 2, SQL_NNC_NON_NULL = 1
    SQL_NULL_COLLATION=85, 2, SQL_NC_LOW = 1
    SQL_NUMERIC_FUNCTIONS=49, 4, 0x00FFFFFF = SQL_FN_NUM_ABS
    | SQL_FN_NUM_ACOS | SQL_FN_NUM_ASIN | SQL_FN_NUM_ATAN | SQL_FN_NUM_ATAN2
    | SQL_FN_NUM_CEILING | SQL_FN_NUM_COS | SQL_FN_NUM_COT | SQL_FN_NUM_EXP | SQL_FN_NUM_FLOOR
    | SQL_FN_NUM_LOG | SQL_FN_NUM_MOD | SQL_FN_NUM_SIGN | SQL_FN_NUM_SIN | SQL_FN_NUM_SQRT
    | SQL_FN_NUM_TAN | SQL_FN_NUM_PI | SQL_FN_NUM_RAND | SQL_FN_NUM_DEGREES
    | SQL_FN_NUM_LOG10 | SQL_FN_NUM_POWER | SQL_FN_NUM_RADIANS | SQL_FN_NUM_ROUND
    | SQL_FN_NUM_TRUNCATE
    SQL_ODBC_API_CONFORMANCE=9, 2, SQL_OAC_LEVEL1 = 1
    SQL_ODBC_INTERFACE_CONFORMANCE=152, 4, SQL_OIC_CORE = 1
    SQL_ODBC_SAG_CLI_CONFORMANCE=12, 2, SQL_OSCC_COMPLIANT = 1
    SQL_ODBC_SQL_CONFORMANCE=15, 2, SQL_OSC_CORE = 1
    SQL_ODBC_SQL_OPT_IEF=73, 1, “N”
    SQL_ODBC_VER=10, 10, “03.52.0000”
    SQL_OJ_CAPABILITIES=115, 4, 0x00000049 = SQL_OJ_LEFT | SQL_OJ_NESTED | SQL_OJ_ALL_COMPARISON_OPS
    SQL_OUTER_JOINS=38, 1, “Y”
    SQL_OWNER_TERM=39, 5, “owner”
    SQL_ORDER_BY_COLUMNS_IN_SELECT=90, 1, “N”
    SQL_OWNER_USAGE=91, 4, 0x0000000F = SQL_OU_DML_STATEMENTS | SQL_OU_PROCEDURE_INVOCATION | SQL_OU_TABLE_DEFINITION | SQL_OU_INDEX_DEFINITION
    SQL_PARAM_ARRAY_ROW_COUNTS=153, 4, SQL_PARC_NO_BATCH = 2
    SQL_PARAM_ARRAY_SELECTS=154, 4, SQL_PAS_NO_BATCH = 2
    SQL_POS_OPERATIONS=79, 4, 0x00000000
    SQL_POSITIONED_STATEMENTS=80, 4, 0x00000000
    SQL_PROCEDURE_TERM=40, 9, “procedure”
    SQL_PROCEDURES=21, 1, “Y”
    SQL_QUALIFIER_USAGE=92, 4, 0x00000007 = SQL_CU_DML_STATEMENTS | SQL_CU_PROCEDURE_INVOCATION | SQL_CU_TABLE_DEFINITION
    SQL_QUOTED_IDENTIFIER_CASE=93, 2, SQL_IC_MIXED = 4
    SQL_QUALIFIER_NAME_SEPARATOR=41, 1, “.”
    SQL_QUALIFIER_TERM=42, 8, “database”
    SQL_QUALIFIER_LOCATION=114, 2, SQL_CL_START = 1
    SQL_ROW_UPDATES=11, 1, “N”
    SQL_SCHEMA_TERM=39, 5, “owner”
    SQL_SCHEMA_USAGE=91, 4, 0x0000000F = SQL_OU_DML_STATEMENTS
    | SQL_OU_PROCEDURE_INVOCATION | SQL_OU_TABLE_DEFINITION | SQL_OU_INDEX_DEFINITION
    SQL_SCROLL_OPTIONS=44, 4, 0x00000001 = SQL_SO_FORWARD_ONLY
    SQL_SCROLL_CONCURRENCY=43, 4, 0x00000009 = SQL_SCCO_READ_ONLY
    | SQL_SCCO_OPT_VALUES
    SQL_SEARCH_PATTERN_ESCAPE=14, 1, “\”
    SQL_SERVER_NAME=13, 13, “ClearWaterNew”
    SQL_SPECIAL_CHARACTERS=94, 8, “*(){}|:;”
    SQL_SQL92_DATETIME_FUNCTIONS=155, 4, 0x00000007 = SQL_SDF_CURRENT_DATE | SQL_SDF_CURRENT_TIME | SQL_SDF_CURRENT_TIMESTAMP
    SQL_SQL92_FOREIGN_KEY_DELETE_RULE=156, 4, 0x00000002 = SQL_SFKD_NO_ACTION
    SQL_SQL92_FOREIGN_KEY_UPDATE_RULE=157, 4, 0x00000002 = SQL_SFKU_NO_ACTION
    SQL_SQL92_GRANT=158, 4, 0x00000C70 = SQL_SG_WITH_GRANT_OPTION
    | SQL_SG_DELETE_TABLE | SQL_SG_INSERT_TABLE | SQL_SG_SELECT_TABLE | SQL_SG_UPDATE_TABLE
    SQL_SQL92_NUMERIC_VALUE_FUNCTIONS=159, 4, 0x0000003F = SQL_SNVF_BIT_LENGTH | SQL_SNVF_CHAR_LENGTH | SQL_SNVF_CHARACTER_LENGTH | SQL_SNVF_EXTRACT
    | SQL_SNVF_OCTET_LENGTH | SQL_SNVF_POSITION
    SQL_SQL92_PREDICATES=160, 4, 0x00003F07 = SQL_SP_EXISTS
    | SQL_SP_ISNOTNULL | SQL_SP_ISNULL | SQL_SP_UNIQUE | SQL_SP_LIKE | SQL_SP_IN
    | SQL_SP_BETWEEN | SQL_SP_COMPARISON | SQL_SP_QUANTIFIED_COMPARISON
    SQL_SQL92_RELATIONAL_JOIN_OPERATORS=161, 4, 0x00000250 = SQL_SRJO_INNER_JOIN | SQL_SRJO_LEFT_OUTER_JOIN | SQL_SRJO_UNION_JOIN
    SQL_SQL92_REVOKE=162, 4, 0x00000C70 = SQL_SR_GRANT_OPTION_FOR
    | SQL_SR_CASCADE | SQL_SR_RESTRICT | SQL_SR_REFERENCES_TABLE | SQL_SR_REFERENCES_COLUMN
    SQL_SQL92_ROW_VALUE_CONSTRUCTOR=163, 4, 0x0000000B = SQL_SRVC_VALUE_EXPRESSION | SQL_SRVC_NULL | SQL_SRVC_ROW_SUBQUERY
    SQL_SQL92_STRING_FUNCTIONS=164, 4, 0x000000EE = SQL_SSF_LOWER
    | SQL_SSF_UPPER | SQL_SSF_SUBSTRING | SQL_SSF_TRIM_BOTH | SQL_SSF_TRIM_LEADING
    | SQL_SSF_TRIM_TRAILING
    SQL_SQL92_VALUE_EXPRESSIONS=165, 4, 0x00000000
    SQL_STANDARD_CLI_CONFORMANCE=166, 4, 0x00000001 = SQL_SCC_XOPEN_CLI_VERSION1
    SQL_STATIC_CURSOR_ATTRIBUTES1=167, 4, 0x00000001 = SQL_CA1_NEXT
    SQL_STATIC_CURSOR_ATTRIBUTES2=168, 4, 0x00000000
    SQL_STATIC_SENSITIVITY=83, 4, 0x00000000
    SQL_STRING_FUNCTIONS=50, 4, 0x00FC7FFF = SQL_FN_STR_CONCAT
    | SQL_FN_STR_INSERT | SQL_FN_STR_LEFT | SQL_FN_STR_LTRIM | SQL_FN_STR_LENGTH
    | SQL_FN_STR_LOCATE | SQL_FN_STR_LCASE | SQL_FN_STR_REPEAT | SQL_FN_STR_REPLACE
    | SQL_FN_STR_RIGHT | SQL_FN_STR_RTRIM | SQL_FN_STR_SUBSTRING | SQL_FN_STR_UCASE
    | SQL_FN_STR_ASCII | SQL_FN_STR_CHAR | SQL_FN_STR_SPACE | SQL_FN_STR_BIT_LENGTH
    | SQL_FN_STR_CHAR_LENGTH | SQL_FN_STR_CHARACTER_LENGTH | SQL_FN_STR_OCTET_LENGTH
    | SQL_FN_STR_POSITION
    SQL_SUBQUERIES=95, 4, 0x0000001F = SQL_SQ_COMPARISON
    | SQL_SQ_EXISTS | SQL_SQ_IN | SQL_SQ_QUANTIFIED | SQL_SQ_CORRELATED_SUBQUERIES
    SQL_SYSTEM_FUNCTIONS=51, 4, 0x00000003 = SQL_FN_SYS_USERNAME
    | SQL_FN_SYS_DBNAME
    SQL_TABLE_TERM=45, 5, “table”
    SQL_TIMEDATE_ADD_INTERVALS=109, 4, 0x00000000
    SQL_TIMEDATE_DIFF_INTERVALS=110, 4, 0x00000000
    SQL_TIMEDATE_FUNCTIONS=52, 4, 0x00099FFF = SQL_FN_TD_NOW
    | SQL_FN_TD_CURDATE | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR
    | SQL_FN_TD_MONTH | SQL_FN_TD_QUARTER | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR
    | SQL_FN_TD_CURTIME | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_SECOND
    | SQL_FN_TD_DAYNAME | SQL_FN_TD_MONTHNAME | SQL_FN_TD_CURRENT_TIMESTAMP
    SQL_TXN_CAPABLE=46, 2, SQL_TC_ALL = 2
    SQL_TXN_ISOLATION_OPTION=72, 4, 0x00000007 = SQL_TXN_READ_UNCOMMITTED | SQL_TXN_READ_COMMITTED | SQL_TXN_REPEATABLE_READ
    SQL_UNION=96, 4, 0x00000003 = SQL_U_UNION | SQL_U_UNION_ALL
    SQL_USER_NAME=47, 0, “”
    SQL_XOPEN_CLI_YEAR=10000, 4, “1995”

    January 28, 2007 at 9:26 pm #265269 Reply

    Haris Peco
    Member

    Adam,

    I’m sorry, but I can’t conclude what is problem from ODBC debug information.I suppose that JDBC-ODBC bridge doesn’t support some function which we need (it can be problem in ODBC or JDBC driver).It is possible that I can tell more if I got access to your database and driver.

    Regards,

    January 28, 2007 at 9:42 pm #265270 Reply

    adam_j_bradley
    Member

    I’m using the jdbc:odbc bridge driver – is it possible to retrieve the contents of the “DB Connection Info window” ? I’m sure this would give you all the information you need.

    Regards,
    Adam

    January 28, 2007 at 9:51 pm #265271 Reply

    Haris Peco
    Member

    Adam,

    I’m not sure, but if you can send me DB Connection Info and your log file (Window>Show View>Other>PDE Runtime>Error log View or
    Help>About Eclipse SDk>Configuration Details>Show Error Log)

    Regards,

    January 29, 2007 at 2:28 am #265275 Reply

    adam_j_bradley
    Member

    java.sql.SQLException: [MYOB ODBC]Invalid SQL statement identifier
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLTables(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getCatalogs(Unknown Source)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCatalogs(SQLDatabaseMetaData.java:356)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.initializeDatabaseModel(DatabaseModel.java:115)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.initializeMetaData(DatabaseModel.java:61)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.<init>(DatabaseModel.java:52)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeNode.<init>(SessionTreeNode.java:71)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeModel.createSessionTreeNode(SessionTreeModel.java:128)
    at com.genuitec.eclipse.sqlexplorer.actions.RetrievingTableDataProgress$RetrieveData.run(RetrievingTableDataProgress.java:48)
    at java.lang.Thread.run(Unknown Source)

    January 29, 2007 at 4:11 am #265277 Reply

    Haris Peco
    Member

    If you got list of tables using my example then it is possible that exists workaround for your database.
    Anyway, I’m not sure without testing.MyEclipse DB Explorer will work with mostly JDBC compliant databases, but your JDBC driver
    have some strange behaviour.Your log shows that JDBC driver throws exception for simple JDBC’s getTables method.
    Sorry, but I can’t help more without testing with your database.

    Regards,

    January 29, 2007 at 9:49 am #265285 Reply

    adam_j_bradley
    Member

    Peco,

    Success! I’ve installed the latest version of the ODBC driver and am now able to get a list of Tables, however, when I use the DB Browser
    I now receive

    —snip—
    java.lang.NullPointerException
    at com.genuitec.eclipse.sqlexplorer.model.CatalogNode.getSchemas(CatalogNode.java:114)
    at com.genuitec.eclipse.sqlexplorer.model.CatalogNode.fastLoad(CatalogNode.java:137)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeNode.initializeDatabaseModel(SessionTreeNode.java:99)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeNode.<init>(SessionTreeNode.java:72)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeModel.createSessionTreeNode(SessionTreeModel.java:128)
    at com.genuitec.eclipse.sqlexplorer.actions.RetrievingTableDataProgress$RetrieveData.run(RetrievingTableDataProgress.java:48)
    at java.lang.Thread.run(Unknown Source)
    —snip—

    And in my ODBC trace I get

    —snip—
    <UNICODE>[TID: 4224], \openodbc\src\ewocata.c:276: SQLTablesW Sql statement : <SELECT DISTINCT NULL AS TABLE_QUALIFIER, TABLE_OWNER, NULL AS TABLE_NAME, NULL AS TABLE_TYPE, NULL AS REMARKS FROM OA_TABLES WHERE TABLE_OWNER LIKE ‘%’ ORDER BY TABLE_OWNER>
    <UNICODE>[TID: 4224]:<Unicode Trace:Hex>
    0: 53 00 51 00 4c 00 54 00 61 00 62 00 6c 00 65 00 | S.Q.L.T.a.b.l.e.
    10: 73 00 57 00 20 00 53 00 71 00 6c 00 20 00 73 00 | s.W. .S.q.l. .s.
    20: 74 00 61 00 74 00 65 00 6d 00 65 00 6e 00 74 00 | t.a.t.e.m.e.n.t.
    30: 20 00 3a 00 20 00 3c 00 53 00 45 00 4c 00 45 00 | .:. .<.S.E.L.E.
    40: 43 00 54 00 20 00 44 00 49 00 53 00 54 00 49 00 | C.T. .D.I.S.T.I.
    50: 4e 00 43 00 54 00 20 00 4e 00 55 00 4c 00 4c 00 | N.C.T. .N.U.L.L.
    60: 20 00 41 00 53 00 20 00 54 00 41 00 42 00 4c 00 | .A.S. .T.A.B.L.
    70: 45 00 5f 00 51 00 55 00 41 00 4c 00 49 00 46 00 | E._.Q.U.A.L.I.F.
    80: 49 00 45 00 52 00 2c 00 20 00 54 00 41 00 42 00 | I.E.R.,. .T.A.B.
    90: 4c 00 45 00 5f 00 4f 00 57 00 4e 00 45 00 52 00 | L.E._.O.W.N.E.R.
    a0: 2c 00 20 00 4e 00 55 00 4c 00 4c 00 20 00 41 00 | ,. .N.U.L.L. .A.
    b0: 53 00 20 00 54 00 41 00 42 00 4c 00 45 00 5f 00 | S. .T.A.B.L.E._.
    c0: 4e 00 41 00 4d 00 45 00 2c 00 20 00 4e 00 55 00 | N.A.M.E.,. .N.U.
    d0: 4c 00 4c 00 20 00 41 00 53 00 20 00 54 00 41 00 | L.L. .A.S. .T.A.
    e0: 42 00 4c 00 45 00 5f 00 54 00 59 00 50 00 45 00 | B.L.E._.T.Y.P.E.
    f0: 2c 00 20 00 4e 00 55 00 4c 00 4c 00 20 00 41 00 | ,. .N.U.L.L. .A.
    100: 53 00 20 00 52 00 45 00 4d 00 41 00 52 00 4b 00 | S. .R.E.M.A.R.K.
    110: 53 00 20 00 46 00 52 00 4f 00 4d 00 20 00 4f 00 | S. .F.R.O.M. .O.
    120: 41 00 5f 00 54 00 41 00 42 00 4c 00 45 00 53 00 | A._.T.A.B.L.E.S.
    130: 20 00 57 00 48 00 45 00 52 00 45 00 20 00 54 00 | .W.H.E.R.E. .T.
    140: 41 00 42 00 4c 00 45 00 5f 00 4f 00 57 00 4e 00 | A.B.L.E._.O.W.N.
    150: 45 00 52 00 20 00 4c 00 49 00 4b 00 45 00 20 00 | E.R. .L.I.K.E. .
    160: 27 00 25 00 27 00 20 00 4f 00 52 00 44 00 45 00 | ‘.%.’. .O.R.D.E.
    170: 52 00 20 00 42 00 59 00 20 00 54 00 41 00 42 00 | R. .B.Y. .T.A.B.
    180: 4c 00 45 00 5f 00 4f 00 57 00 4e 00 45 00 52 00 | L.E._.O.W.N.E.R.
    190: 3e 00 0a 00 | >…
    [TID: 4224], ewocata.c:291: SQLTablesW: rda_cliExecute failed
    [TID = 4224]:SQLTablesW: returns SQL_ERROR
    [TID: 4224], ewodata.c:290: SQLState=2, ErrorMsg=I
    [TID = 4224]:SQLErrorW called:
    henv=<NULL>
    hdbc=<NULL>
    hstmt=00106190
    szSqlState=0486F870
    pfNativeError=0486F44C
    wszErrorMsg=0486F464
    cbErrorMsgMax=512
    pcbErrorMsg=0486F45C
    [TID = 4224]:SQLErrorW: returns SQL_SUCCESS
    szSqlState=26000
    <Unicode Trace:Hex>
    0: 20 00 20 00 20 00 73 00 7a 00 53 00 71 00 6c 00 | . . .s.z.S.q.l.
    10: 53 00 74 00 61 00 74 00 65 00 3d 00 32 00 36 00 | S.t.a.t.e.=.2.6.
    20: 30 00 30 00 30 00 0a 00 | 0.0.0…
    pfNativeError=0
    szErrorMsg=
    [MYOB ODBC]Invalid SQL statement identifier
    <Unicode Trace:Hex>
    0: 20 00 5b 00 4d 00 59 00 4f 00 42 00 20 00 4f 00 | .[.M.Y.O.B. .O.
    10: 44 00 42 00 43 00 5d 00 49 00 6e 00 76 00 61 00 | D.B.C.].I.n.v.a.
    20: 6c 00 69 00 64 00 20 00 53 00 51 00 4c 00 20 00 | l.i.d. .S.Q.L. .
    30: 73 00 74 00 61 00 74 00 65 00 6d 00 65 00 6e 00 | s.t.a.t.e.m.e.n.
    40: 74 00 20 00 69 00 64 00 65 00 6e 00 74 00 69 00 | t. .i.d.e.n.t.i.
    50: 66 00 69 00 65 00 72 00 0a 00 | f.i.e.r…
    pcbErrorMsg=43
    [TID = 4224]:SQLErrorW called:
    henv=<NULL>
    hdbc=<NULL>
    hstmt=00106190
    szSqlState=0486F870
    pfNativeError=0486F44C
    wszErrorMsg=0486F464
    cbErrorMsgMax=512
    pcbErrorMsg=0486F45C
    [TID = 4224]:SQLErrorW: returns SQL_NO_DATA
    szSqlState=00000
    <Unicode Trace:Hex>
    0: 20 00 20 00 20 00 73 00 7a 00 53 00 71 00 6c 00 | . . .s.z.S.q.l.
    10: 53 00 74 00 61 00 74 00 65 00 3d 00 30 00 30 00 | S.t.a.t.e.=.0.0.
    20: 30 00 30 00 30 00 0a 00 | 0.0.0…
    pfNativeError=0
    szErrorMsg=
    —snip—

    Interestingly, if I run the SQL command directly I get two results, MYOB and SYSTEM (MYOB is the Schema I’m after)

    Adam

    January 29, 2007 at 9:59 am #265286 Reply

    adam_j_bradley
    Member

    Looks like when I provide the correct credentials (duh)

    —snip—
    I get java.sql.SQLException: [MYOB ODBC]Invalid SQL statement identifier
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLTables(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getSchemas(Unknown Source)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:242)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.initializeDatabaseModel(DatabaseModel.java:86)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.initializeMetaData(DatabaseModel.java:61)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.<init>(DatabaseModel.java:52)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeNode.<init>(SessionTreeNode.java:71)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeModel.createSessionTreeNode(SessionTreeModel.java:128)
    at com.genuitec.eclipse.sqlexplorer.actions.RetrievingTableDataProgress$RetrieveData.run(RetrievingTableDataProgress.java:48)
    at java.lang.Thread.run(Unknown Source)
    —snip—

    Which looks to be thrown as a result of the query

    SELECT DISTINCT NULL AS TABLE_QUALIFIER, TABLE_OWNER, NULL AS TABLE_NAME, NULL AS TABLE_TYPE, NULL AS REMARKS FROM OA_TABLES WHERE TABLE_OWNER LIKE ‘%’ ORDER BY TABLE_OWNER

    I’m at a bit of a loss. I might set up a VM and grant you access to this!
    Adam

    January 29, 2007 at 9:59 am #265287 Reply

    adam_j_bradley
    Member

    Looks like when I provide the correct credentials (duh)

    —snip—
    I get java.sql.SQLException: [MYOB ODBC]Invalid SQL statement identifier
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLTables(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getSchemas(Unknown Source)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:242)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.initializeDatabaseModel(DatabaseModel.java:86)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.initializeMetaData(DatabaseModel.java:61)
    at com.genuitec.eclipse.sqlexplorer.model.DatabaseModel.<init>(DatabaseModel.java:52)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeNode.<init>(SessionTreeNode.java:71)
    at com.genuitec.eclipse.sqlexplorer.model.SessionTreeModel.createSessionTreeNode(SessionTreeModel.java:128)
    at com.genuitec.eclipse.sqlexplorer.actions.RetrievingTableDataProgress$RetrieveData.run(RetrievingTableDataProgress.java:48)
    at java.lang.Thread.run(Unknown Source)
    —snip—

    Which looks to be thrown as a result of the query

    SELECT DISTINCT NULL AS TABLE_QUALIFIER, TABLE_OWNER, NULL AS TABLE_NAME, NULL AS TABLE_TYPE, NULL AS REMARKS FROM OA_TABLES WHERE TABLE_OWNER LIKE ‘%’ ORDER BY TABLE_OWNER

    I’m at a bit of a loss. I might set up a VM and grant you access to this!
    Adam

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 16 total)
1 2
Reply To: Q: Using MyEclipse Database View – ODBC errors

You must be logged in to post in the forum log in