jdbc database

I use com.mysql.jdbc.Driver I need insert and get id. My query: INSERT INTO Sessions(id_user) VALUES(1); SELECT LAST_INSERT_ID() FROM Sessions LIMIT…

I have the following JDBC code. Note that I am attempting to use PostGIS geography: PreparedStatement stmt = db.prepareStatement("INSERT INTO " +…

When trying to connect to my local MySQL server via JDBC, I get the following error: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:…

Hallo, I am writing a database application that does alot of inserts and updates with fake serialisable isolation level ( snapshot isolation ). To…

I need to maintain a table there's a column 'total'. Each time I have to retrieve original total by p-code: int oldTotal = SELECT total from table……

I'm going to attempt to write to an app that needs to access a remote database running on a server. I know you can use jdbc when writing java…

I used to connect my java app to a remote database ( MySQL ) through jdbc with: url="jdbc:mysql://mydomain.com/myDataBase" But now, the remote…

I am using Java+MySql. I am trying to add bulk data (around 40 million records). My application works fine for couple of hundred thousands records…

how to check for database schema existence in MYSQL using JDBC ?

how to get list of Databases "Schema" names of MySql using java JDBC ?

I have an error updating my database because of variables. This is my code: UPDATE `payment` SET `paid`=1 AND `amoun`=$amountpaid WHERE `paid`=0 AND…

The title says it all, I'm trying to insert in the following table ABC(user text, num int), Where user is primary key two tuples: (aaa, 1) (aaa, 2)…

I have a query string that is dynamic. The items I am searching for in the database are based upon what the user selects in a checkbox on an html…

I have to connect to a PostgreSQL server in LAN without web service. At the moment I think JDBC is the only way I can consider of. How can I fulfill…

Using Connector/J, I would like to do a batch insert into a master table followed by a batch insert into a details table (…

I am trying to connect to a remote mysql database but I get the following error java.sql.SQLException: Cannot connect to MySQL server on…

I am setting up Funambol 8.7 on a Linux host (using Amazon AWS). I need to connect to a MySQL datbase that is hosted on a different server. Per the…