This is the code where I'm trying to use the insert query: int insertItems(String name,double amt,String exp)throws Exception{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement("insert into itemsList (null,name,amt,expire) values (?,?,?,?);");//when I use the 4?s it displays [Exception in thread "main" java.sql.SQLException: No value…
String accountQuery = "insert into Account (accountNumber,currentBalance,type,personId) values (?,?,?,?);"; PreparedStatement accountPs = null; try { // These are my prepare Statements for my queries accountPs = conn.prepareStatement(accountQuery); // accountPs.setInt(1, personId.getPersonId()); accountPs.setInt(1, accountHolder.getAccountNumber()); accountPs.setDouble(2, accountHolder.getCurrentBalance()); accountPs.setString(3, accountHolder.getType()); accountPs.setInt(4, personId.getPersonId()); accountPs.executeUpdate(); accountPs.close();…
I'm trying to get the primary auto incremented key from one table and store this in another using MySQL connector and JDBC. Although its giving me this error: statement.executeupdate() cannot issue statements that produce result sets. I think its something…
I am working on a project where I am trying to insert values into a MySQL table. Before starting this project I verified that I had the necessary JAR file setup and tested the SQL connection. I thought I was…
I have some code that connects to a database using JDBC using a basic URL: String url = "jdbc:mysql://" + getHostname() + ":" + getPort(); I am using the following arguments: setProperty("connectTimeout", "2000"); setProperty("autoReconnect", "true"); I don't include the database…
I need to connect to my database but I keep getting an error that says "driver not found". I have added mariadb-java-client-3.0.8.jar jar file and it is still not working. And this works pretty well on NetBeans, but I need…
I am able to import other packages like java.io to eclipse but, I am unable to import java.sql to my project in eclipse. What could be the reason? I don't know how to proceed. I have tried a couple of…
I'm new to multithreading and don't even understand what to do with a thread in my application. The application is a console game. The player chooses a hero, clan and actions. Gold is credited to the treasury for various actions.…
any idea how to improve this code to avoid the java.sql.SQLException: No operations allowed after statement closed. I can't understand where the error actually occurs, I guess after if (resultSet.next()) the connection is closed. This method is executed when a…
I have installed a postgres image on a docker container - I also installed pgadmin and connected the postgres and pgadmin by adding them to a docker network. I am able to connect to the db via pgadmin I now…