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…
I have a DATETIME column in a MySQL database. I use ResultSet metadata to retrieve the column type and it returns TIMESTAMP which is incorrect. How can I get the correct java.sql.SQLType value for this column? I will try to…
I want to use JDBC for preparedStatement in Java for inserting data into a PostgreSQL database. I have the following DDL CREATE SEQUENCE serial_no; CREATE TABLE distributors ( did DECIMAL(3) DEFAULT NEXTVAL('serial_no'), dname VARCHAR(40) DEFAULT 'lusofilms' ); I want to…