java.sql.SQLException: No database selected Error Code: 1046 Call: SELECT WID, Absorption, CASNumber, Clearance, Created, DataSet_WID, Description, HalfLife, Id, Indication, MechanismOfAction, Name, Pharmacology, ProteinBinding, RouteOfElimination, SynthesisRef, Toxicity, Type, Updated, VolumeOfDistribution FROM DrugBank WHERE Id LIKE ? bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=DrugBank sql="SELECT WID, Absorption, CASNumber, Clearance, Created, DataSet_WID, Description, HalfLife, Id, Indication, MechanismOfAction, Name, Pharmacology, ProteinBinding, RouteOfElimination, SynthesisRef, Toxicity, Type, Updated, VolumeOfDistribution FROM DrugBank WHERE Id LIKE ?")

Google Groups | Douglas Myers-Turnbull | 2 years ago
  1. 0

    Using the Java API; "No database selected" exception

    Google Groups | 2 years ago | Douglas Myers-Turnbull
    java.sql.SQLException: No database selected Error Code: 1046 Call: SELECT WID, Absorption, CASNumber, Clearance, Created, DataSet_WID, Description, HalfLife, Id, Indication, MechanismOfAction, Name, Pharmacology, ProteinBinding, RouteOfElimination, SynthesisRef, Toxicity, Type, Updated, VolumeOfDistribution FROM DrugBank WHERE Id LIKE ? bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=DrugBank sql="SELECT WID, Absorption, CASNumber, Clearance, Created, DataSet_WID, Description, HalfLife, Id, Indication, MechanismOfAction, Name, Pharmacology, ProteinBinding, RouteOfElimination, SynthesisRef, Toxicity, Type, Updated, VolumeOfDistribution FROM DrugBank WHERE Id LIKE ?")
  2. 0

    java - "Cannot call methods on bigint." error (using JPA)

    Stack Overflow | 3 years ago | brytstrit94
    java.sql.SQLException: Cannot call methods on bigint. Error Code: 258 Call: SELECT t0.VehicleID, t0.AutomaticTrans, t0.BodyType, t0.CRNo, t0.CatalyticConverter, t0.ChassisNo, t0.Classification, t0.Color, t0.EngineNo, t0.FuelType, t0.GrossWeight, t0.MVFileNo, t0.MVType, t0.Make, t0.NaturallyAspirated, t0.NetCapacity, t0.ORNo, t0.ORType, t0.PlateNo, t0.Series, t0.Turbo, t0.VehicleFirstReg, t0.YearModel, t2.ClientID, t2.Address, t2.City, t2.FirstName, t2.isCompany, t2.LastName, t2.MiddleName, t1.VehicleHistoryID, t1.AuthenticationNo, t1.BCTechPersonCode, t1.BCUserCode, t1.CECNumber, t1.CertIssued, t1.DENR_Result, t1.DateInserted, t1.DateTimeTested, t1.DateTimeUploaded, t1.DocStatus, t1.EmissionPurpose, t1.HDDSerial, t1.isUrban, t1.LocalCertDateIssued, t1.PETC_AmountPaid, t1.PETC_CompanyCode, t1.PETC_OrNumber, t1.PETC_PriorityNo, t1.PETC_Result, t1.PETC_UnitCode, t1.Remarks, t1.Reprint, t1.Retest, t1.Server_DateUploaded, t1.Server_UploadConfirmationCode, t1.StatusCode, t1.StatusDesc, t1.TEST_OilTemp, t1.Technician, t1.TESDA, t1.TEST_AVE, t1.TEST_CO, t1.TEST_CO2, t1.TEST_HC, t1.TEST_O2, t1.TRAN_ID, t1.VHGuidKey, t1.ClientID, t1.VehicleID FROM vehicles t0, clients t2, vehiclehistory t1 WHERE (((t0.VehicleID = t1.VehicleID) AND (t1.VehicleID = t0.VehicleID.t0.VehicleID)) AND ((t2.ClientID = t1.ClientID) AND (t1.ClientID = t2.ClientID.t2.ClientID))) Query: ReportQuery(referenceClass=Vehiclehistory sql="SELECT t0.VehicleID, t0.AutomaticTrans, t0.BodyType, t0.CRNo, t0.CatalyticConverter, t0.ChassisNo, t0.Classification, t0.Color, t0.EngineNo, t0.FuelType, t0.GrossWeight, t0.MVFileNo, t0.MVType, t0.Make, t0.NaturallyAspirated, t0.NetCapacity, t0.ORNo, t0.ORType, t0.PlateNo, t0.Series, t0.Turbo, t0.VehicleFirstReg, t0.YearModel, t2.ClientID, t2.Address, t2.City, t2.FirstName, t2.isCompany, t2.LastName, t2.MiddleName, t1.VehicleHistoryID, t1.AuthenticationNo, t1.BCTechPersonCode, t1.BCUserCode, t1.CECNumber, t1.CertIssued, t1.DENR_Result, t1.DateInserted, t1.DateTimeTested, t1.DateTimeUploaded, t1.DocStatus, t1.EmissionPurpose, t1.HDDSerial, t1.isUrban, t1.LocalCertDateIssued, t1.PETC_AmountPaid, t1.PETC_CompanyCode, t1.PETC_OrNumber, t1.PETC_PriorityNo, t1.PETC_Result, t1.PETC_UnitCode, t1.Remarks, t1.Reprint, t1.Retest, t1.Server_DateUploaded, t1.Server_UploadConfirmationCode, t1.StatusCode, t1.StatusDesc, t1.TEST_OilTemp, t1.Technician, t1.TESDA, t1.TEST_AVE, t1.TEST_CO, t1.TEST_CO2, t1.TEST_HC, t1.TEST_O2, t1.TRAN_ID, t1.VHGuidKey, t1.ClientID, t1.VehicleID FROM vehicles t0, clients t2, vehiclehistory t1 WHERE (((t0.VehicleID = t1.VehicleID) AND (t1.VehicleID = t0.VehicleID.t0.VehicleID)) AND ((t2.ClientID = t1.ClientID) AND (t1.ClientID = t2.ClientID.t2.ClientID)))")
  3. 0

    JPQL: when embedded class is used in LHS of In clause DB Exception occurs

    Eclipse Bugzilla | 3 years ago | vgkumbhar
    java.sql.SQLException: Invalid column type Error Code: 17004 Call: SELECT DOMAIN_DESC, DOMAIN_NAME, DOMAIN_CODE, DOMAIN_VERSION FROM TST_DOMAINS_B WHERE ((?, ?) IN (?,?)) bind => [null, null, DomainKey [domainId=Finance, domainVersion=1], DomainKey [domainId=Telecom, domainVersion=1]] Query: ReportQuery(referenceClass=Domain sql="SELECT DOMAIN_DESC, DOMAIN_NAME, DOMAIN_CODE, DOMAIN_VERSION FROM TST_DOMAINS_B WHERE ((?, ?) IN ?)")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java jpa error querying a wordpress database that contains empty fields

    Stack Overflow | 2 years ago
    java.sql.SQLException: Value '390open;http://127.0.0.1/wordpress/?post_type=optionsframework&p=390open Error Code: 0 Call: SELECT ID, comment_count, comment_status, guid, menu_order, ping_status, pinged, post_author, post_content, post_content_filtered, post_date, post_date_gmt, post_excerpt, post_mime_type, post_modified, post_modified_gmt, post_name, post_parent, post_password, post_status, post_title, post_type, to_ping FROM wp_posts Query: ReadAllQuery(referenceClass=WpPost sql="SELECT ID, comment_count, comment_status, guid, menu_order, ping_status, pinged, post_author, post_content, post_content_filtered, post_date, post_date_gmt, post_excerpt, post_mime_type, post_modified, post_modified_gmt, post_name, post_parent, post_password, post_status, post_title, post_type, to_ping FROM wp_posts")
  6. 0

    JPA EclipseLink - Get multiple objects by primary key maintaining order

    Stack Overflow | 3 months ago | Deviling Master
    java.sql.SQLException: Operand should contain 1 column(s) Error Code: 1241 Call: SELECT .... FROM webcontent_type WHERE (ID IN (?,?,?,?,?,?,?)) ORDER BY FIELD(ID, (?,?,?,?,?,?,?)) bind => [14 parameters bound] Query: ReadAllQuery(referenceClass=WebContentType sql="SELECT .... FROM webcontent_type WHERE (ID IN ?) ORDER BY FIELD(ID, ?)")

    1 unregistered visitors
    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

      No database selected Error Code: 1046 Call: SELECT WID, Absorption, CASNumber, Clearance, Created, DataSet_WID, Description, HalfLife, Id, Indication, MechanismOfAction, Name, Pharmacology, ProteinBinding, RouteOfElimination, SynthesisRef, Toxicity, Type, Updated, VolumeOfDistribution FROM DrugBank WHERE Id LIKE ? bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=DrugBank sql="SELECT WID, Absorption, CASNumber, Clearance, Created, DataSet_WID, Description, HalfLife, Id, Indication, MechanismOfAction, Name, Pharmacology, ProteinBinding, RouteOfElimination, SynthesisRef, Toxicity, Type, Updated, VolumeOfDistribution FROM DrugBank WHERE Id LIKE ?")

      at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException()
    2. EclipseLink (non-OSGi)
      QueryImpl.getResultList
      1. org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:378)
      2. org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
      3. org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:469)
      3 frames
    3. org.jbiowhpersistence.utils
      SearchFactory.search
      1. org.jbiowhpersistence.utils.search.SearchFactory.search(SearchFactory.java:94)
      1 frame
    4. org.jbiowhpersistence.datasets
      SearchDrugBank.search
      1. org.jbiowhpersistence.datasets.drug.drugbank.search.SearchDrugBank.search(SearchDrugBank.java:85)
      1 frame
    5. org.drugbanksearch
      Main.main
      1. org.drugbanksearch.Main.run(Main.java:40)
      2. org.drugbanksearch.Main.main(Main.java:61)
      2 frames