org.h2.jdbc.JdbcSQLException: Column "EMP_NO" not found; SQL > statement: > CREATE TABLE "EmployeesCache".Employees (_key OTHER NOT NULL,_val > OTHER,empNo OTHER,birthDate DATE,firstName OTHER,lastName OTHER,gender > OTHER,hireDate DATE) engine > "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine" > [42122-175] at > org.h2.message.DbException.getJdbcSQLException(DbException.java:332)

nabble.com | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Apache Ignite Users - Exception while using primary key with “underscore” character in apache ignite

    nabble.com | 8 months ago
    org.h2.jdbc.JdbcSQLException: Column "EMP_NO" not found; SQL > statement: > CREATE TABLE "EmployeesCache".Employees (_key OTHER NOT NULL,_val > OTHER,empNo OTHER,birthDate DATE,firstName OTHER,lastName OTHER,gender > OTHER,hireDate DATE) engine > "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine" > [42122-175] at > org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
  2. 0

    Exception while using primary key with "underscore" character in apache ignite

    Stack Overflow | 1 year ago | MicahelSeb
    org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor [name=Employees, fields={empNo=class java.lang.Object, birthDate=class java.sql.Date, firstName=class java.lang.Object, lastName=class java.lang.Object, gender=class java.lang.Object, hireDate=class java.sql.Date}, indexes={PRIMARY=IndexDescriptor [type=SORTED]}, fullTextIdx=null, keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false, registered=false]
  3. 0

    Apache Ignite Users - org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

    nabble.com | 8 months ago
    org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor [name=Hktvproduct, fields={hjmpts=class java.lang.Object, typepkstring=class java.lang.Object, ownerpkstring=class java.lang.Object, modifiedts=class java.sql.Timestamp, createdts=class java.sql.Timestamp, pk=class java.lang.Object, pThumbnail=class java.lang.Object, code=class java.lang.Object, unitpk=class java.lang.Object, pPicture=class java.lang.Object, pStartlinenumber=class java.lang.Object, pEan=class java.lang.Object, pOfflinedate=class java.sql.Timestamp, pSupplieralternativeaid=class java.lang.Object, pPricequantity=class java.lang.Object, pErpgroupsupplier=class java.lang.Object, pLogo=class java.lang.Object, pBuyerids=class java.lang.Object, pContentunit=class java.lang.Object, pOthers=class java.lang.Object, pErpgroupbuyer=class java.lang.Object, pEndlinenumber=class java.lang.Object, pOrderquantityinterval=class java.lang.Object, pNormal=class java.lang.Object, pManufactureraid=class java.lang.Object, pVarianttype=class java.lang.Object, pMaxorderquantity=class java.lang.Object, pManufacturername=class java.lang.Object, pCatalog=class java.lang.Object, pNumbercontentunits=class java.lang.Object, pThumbnails=class java.lang.Object, pSpecialtreatmentclasses=class java.lang.Object, pDeliverytime=class java.lang.Object, pDetail=class java.lang.Object, pCatalogversion=class java.lang.Object, pOrder=class java.lang.Object, pDataSheet=class java.lang.Object, pApprovalstatus=class java.lang.Object, pOnlinedate=class java.sql.Timestamp, pMinorderquantity=class java.lang.Object, pEurope1pricefactoryPpg=class java.lang.Object, pEurope1pricefactoryPdg=class java.lang.Object, pEurope1pricefactoryPtg=class java.lang.Object, pProductorderlimit=class java.lang.Object, pGalleryimages=class java.lang.Object, pSequenceid=class java.lang.Object, pWeightunit=class java.lang.Object, pPrimarysku=class java.lang.Object, pProductcode=class java.lang.Object, pReturndays=class java.lang.Object, pPenalty=class java.lang.Object, pPackingdepth=class java.lang.Object, pReadypickupdays=class java.lang.Object, pPickuptimeslot=class java.lang.Object, pProductvideo=class java.lang.Object, pCommissionpos=class java.lang.Object, pCreditpercent=class java.lang.Object, pLoyaltypoint=class java.lang.Object, pBarcode=class java.lang.Object, pMerchantproductid=class java.lang.Object, pManufactuercountry=class java.lang.Object, pDeposit=class java.lang.Object, pPackingboxtype=class java.lang.Object, pPackingheight=class java.lang.Object, pProductmodel=class java.lang.Object, pTemplatecode=class java.lang.Object, pPackinglength=class java.lang.Object, pCommission=class java.lang.Object, pPickupdays=class java.lang.Object, pWeight=class java.lang.Object, pPackingdimensionunit=class java.lang.Object, pHktvproductvideo=class java.lang.Object, pStore=class java.lang.Object, pHotpickstreetproduct=class java.lang.Object, pHotpickstoreproduct=class java.lang.Object, aclts=class java.lang.Object, propts=class java.lang.Object, pCommissiontype=class java.lang.Object, pHotpickrank=class java.lang.Object, pHotpickstreetrank=class java.lang.Object}, indexes={null=IndexDescriptor [type=FULLTEXT], PRIMARY=IndexDescriptor [type=SORTED], productorderlimitRelIDX_20005=IndexDescriptor [type=SORTED], commissionposPosIDX_20005=IndexDescriptor [type=SORTED], catalogIDX_20005=IndexDescriptor [type=SORTED], Product_Code_20005=IndexDescriptor [type=SORTED], commissionRelIDX_20005=IndexDescriptor [type=SORTED], versionIDX_20005=IndexDescriptor [type=SORTED]}, fullTextIdx=IndexDescriptor [type=FULLTEXT], keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false, registered=false]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.h2.jdbc.JdbcSQLException

      Column "EMP_NO" not found; SQL > statement: > CREATE TABLE "EmployeesCache".Employees (_key OTHER NOT NULL,_val > OTHER,empNo OTHER,birthDate DATE,firstName OTHER,lastName OTHER,gender > OTHER,hireDate DATE) engine > "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine" > [42122-175] at > org.h2.message.DbException.getJdbcSQLException(DbException.java:332)

      at org.h2.message.DbException.get()
    2. H2 Database Engine
      Table.getColumn
      1. org.h2.message.DbException.get(DbException.java:172)
      2. org.h2.message.DbException.get(DbException.java:149)
      3. org.h2.table.Table.getColumn(Table.java:626)
      3 frames