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 ?")

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by Douglas Myers-Turnbull, 1 year ago
, 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
via Eclipse Bugzilla by vgkumbhar, 1 year ago
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
via eclipse.org by Unknown author, 2 years ago
Fail to convert to internal representation: Error Code: 17059 Call: DECLARE P_RECORDS_TARGET HR_DEPARTMENTS.DEPTTABTYPE; P_RECORDS_COMPAT HR_DEPARTMENT_TYPE := :1; FUNCTION EL_SQL2PL_1(aSqlItem HR_DEPARTMENT_ROW_TYPE) RETURN
via Coderanch by Kameyama Sato, 1 year ago
JZ0SB: Parameter index out of range: 1. Error Code: 0 Call: DECLARE x_TARGET INTEGER := :1; y_TARGET INTEGER := :2; z_TARGET VARCHAR(10) := :3; message_TARGET VARCHAR(255); BEGIN zzzSP(x=>x_TARGET, y=>y_TARGET, z=>z_TARGET, message
via Stack Overflow by Ravi.Kumar
, 2 years ago
[OWLS][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. Error Code: 701 Call: SELECT DISTINCT t0.PRIMARY_KEY, t0.TOTAL_ACCRUAL, t0.TOTAL_ALLOCATED, t0.ALLOC_LIMIT, t0.APPL_END_ON, t0
via Stack Overflow by Poyraz
, 2 years ago
Statement has already been closed Error Code: 0 Call: SELECT ID, FIRST_NAME, ISBLOCKED, LAST_NAME, MODIFIED, MSISDN, VERSION, OWNER_ID, CONTACT_ID FROM CONTACTS WHERE (OWNER_ID = ?) bind => [1 parameter bound] Query: ReadAllQuery(name
java.sql.SQLException: No database selected
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:682)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2738)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2691)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:495)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1168)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1127)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:403)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1215)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1751)

Users with the same issue

Once, 5 days ago
5 times, 5 days ago
Once, 1 week ago
4 times, 1 week ago
77 times, 2 weeks ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.