JDBC
JDBC returning MySQLSyntaxError Exception with correct statement
I\'m writing an application in java which communicates with a MySQL db, and while I was testing it I noticed that the code to insert new rows in a table threw a MySQLSyntaxError Exception, so I tried[详细]
2023-04-07 20:39 分类：问答Oracle jdbc creating a table, sequence and trigger
I\'m trying to create a table with a sequence and with a trigger for that sequence. When I do this within Oracle Express edition I have the following SQL statements. Which DO run correctly inside Orac[详细]
2023-04-07 17:35 分类：问答MySQL: Data truncation: Incorrect datetime value: '2006-10-01 02:22:44'
I\'m getting the following exception updating a row using MySQL via JDBC: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: \'2006-10-01 02:22:44\'[详细]
2023-04-07 15:06 分类：问答Using LDAP authentication with liquibase
Is it possible to use LDAP authentication with Liquibase? If not, how have others solved the problem of automating changes to production database schemas using Liquibase (yet still 开发者_如何学JAVAk[详细]
2023-04-07 14:25 分类：问答Where to put sql queries? Code style. Java. JDBC
I am working with JDBC driver and my problem is storing SQL queries in a good place. The point is that it will be making a large number of queries.[详细]
2023-04-07 13:39 分类：问答getting java.sql.SQLException: Closed Connection when accessing large resultset
Hello i have big data in my oracle 10g database and have to perform some calculations on every row of resultset. So i call a separate calculation class after fetching value of single row in the while([详细]
2023-04-07 11:46 分类：问答GlassFish 3.1.1 - getting jdbc connection
I\'m trying to get开发者_如何学C OracleConnection from glassfish by this lines: EntityManager em = getEntityManager();[详细]
2023-04-07 09:15 分类：问答Paged retrieval of a large ResultSet
A database query retu开发者_如何学运维rns a large ResultSet, and I would like to page the result, something like a cursor where I can choose how many results to retrieve and then in a next loop retrie[详细]
2023-04-07 04:42 分类：问答Optimising a lot of inserts with JDBC and MySQL
I have to perform a large number of inserts (in this instance 27k) and I want to find an optimal to do this. Right now this is the code that I have. As you can see I\'m using prepared statement and ba[详细]
2023-04-07 03:14 分类：问答Total Number of Row Resultset getRow Method
Read the Following Code: public class selectTable { public static ResultSet rSet; public static int total=0;[详细]
2023-04-07 02:49 分类：问答
加载中,请稍侯......