JDBC
JDBC command to insert/delete/update multiple records?
suppose I have a table that has the following keys: 1 2 3 and then I get a new request (JSON list) to update that table with开发者_运维问答:[详细]
2023-04-12 16:54 分类:问答JDBC - INSERT and return generated id, or if DUPLICATE KEY return old id
The title is pretty clear... I want to be able to add an item to the database, and in case there\'s already an item with a matching unique column, return that item\'s id...[详细]
2023-04-12 15:51 分类:问答Hibernate and Batch Update
Although I can see a lot of discussions around Hibernate and Batch Update, here is my specific scenario I hope to get comments from you all experts.[详细]
2023-04-12 15:06 分类:问答Two web applications pointing to same jndi in sun glassfish server
Are there any issues if two web applications is pointing to the same jndi to the same connection pool in sun glassfish server? Or do I need to sctualy setup different jndi to connec开发者_开发问答t to[详细]
2023-04-12 11:04 分类:问答Java Connecting to remote MySQL database
Hey guys im trying to connect to my remote mysql database and my code gives me this error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver[详细]
2023-04-12 10:48 分类:问答Using batch SQL commands with MySQL JDBC
I am tryi开发者_Go百科ng to figure out the best way to get MySQL to use batch updates. I create, let\'s say, 10,000 records. Each record needs to be inserted into the DB like so:[详细]
2023-04-12 09:21 分类:问答Can any one tell me what is wrong with PrepareStatement syntax
public ResultSet readSubSet(int No, String name, String case) throws SQLException { preparedStatement = connect.prepareStatement(\"SELECT *FROM target WHERE myName=? AND myCase=? LIMIT ?,10\")开发者_高[详细]
2023-04-12 08:44 分类:问答Update statement only runs once.?
So Im having an issue where the results of the first query are only getting updated once. Statement statement = con1.createStatement();[详细]
2023-04-12 05:37 分类:问答preparedStatement.setString taking over 5 seconds longer then hardcoding parameters
I am connecting to a Microsoft sql server database via java jdbc and having a very strange issue. Whenever I use the place holder parameters (?) in my query in the where clause and then do preparedSta[详细]
2023-04-12 05:18 分类:问答Easy way to dump a table's contents to a ASCII formatted table string?
I am debuging some database codeon the Java Platform and it would be convenient to dump the contents of a database table at various points to a log file.[详细]
2023-04-12 04:00 分类:问答