Recent questions tagged JDBC

0 votes

988 views

1 answer

jdbc - java error (No suitable driver found)

public class ReportView extends JFrame { Connection con=null; void showReport() throws SQLException, ClassNotFoundException, ... is the wrong? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

744 views

1 answer

jdbc - Java, looping through result set

In Java, I have a query like this: String querystring1= "SELECT rlink_id, COUNT(*)" + "FROM dbo.Locate ... asString = Arrays.toString(actuate); See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

jdbc - How to set up datasource with Spring for HikariCP?

Hi I'm trying to use HikariCP with Spring for connection pool. I'm using jdbcTempLate and JdbcdaoSupport. This is ... please tell me how to solve this issue? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

938 views

1 answer

jdbc - How to get row count using ResultSet in Java?

I'm trying to create a simple method that receives a ResultSet as a parameter and returns an int that contains ... sets. Thanks in advance for the pointers! Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

810 views

1 answer

jdbc - ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position

When I run the following servlet: // package projectcodes; public void doPost(HttpServletRequest request,HttpServletResponse ... logs) in the servlet code. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

855 views

1 answer

jdbc - How to execute multiple SQL statements from java

I want to execute the multiple queries or job in one execute. Something like this eg: String query="select ... to run multiple queries separated by semi colon. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

681 views

1 answer

jdbc - How does Java's PreparedStatement work?

I am planning to replace repeatedly executed Statement objects with PreparedStatement objects to improve performance. I ... values? I am quite confounded. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

779 views

1 answer

jdbc - java.util.stream with ResultSet

I have few tables with big amount of data (about 100 million records). So I can't store this data in memory ... ).fetch(resultSet).stream(); takes too much time Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

862 views

1 answer

jdbc - Retrieve column names from java.sql.ResultSet

With java.sql.ResultSet is there a way to get a column's name as a String by using the column's index? I had ... through the API doc but I can't find anything. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

958 views

1 answer

jdbc - Java ResultSet how to check if there are any results

Resultset has no method for hasNext. I want to check if the resultSet has any value is this the correct way if (! ... ) { System.out.println("no data"); } Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

jdbc - java.sql.SQLException: Column count doesn't match value count at row 1

The structure of my table: id int AUTO_INCREMENT PRIMARY KEY title text url text age int Here's how I am trying to ... be in the id column, how to solve it? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

798 views

1 answer

jdbc - Get query from java.sql.PreparedStatement

This question already has answers here: Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

851 views

1 answer

jdbc - Splunk not showing all databases from Snowflake

I have successfully made connection between splunk and snowflake and able to get test db data from snowflake ... /questions/65904688/splunk-not-showing-all-databases-from-snowflake...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

854 views

1 answer

jdbc - Even though my RESULTSET is not empty I am not getting output. Using JAVA AND ORACLE DB

The database has the same format of date. Query is working fine in Oracle DB. In java the resultset is not empty. Cannot ... -is-not-empty-i-am-not-getting-output-using-java-and-or...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

jdbc - incompatible types java.sql.timestamp cannot be converted to java.security.timestamp

I am trying to fetch Data at what that Details has been added to my Database using Timestamp() but is show ... -types-java-sql-timestamp-cannot-be-converted-to-java-security-times...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

jdbc - Apache NiFi - DBCPConnectionPool cannot load database driver (Salesforce)

I use NiFi to get data from SalesForce using DBCPConnectionPool component. For this purpose I use ... /apache-nifi-dbcpconnectionpool-cannot-load-database-driver-salesforce...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

726 views

1 answer

jdbc - How to fetch column and its value from db using soapui free version (connection is established already)

I want to see if any db entry came on that day by running it from soap ui E.g. any 'Success' record ... to-fetch-column-and-its-value-from-db-using-soapui-free-version-connection...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

826 views

1 answer

jdbc - How to avoid storing passwords in the clear for tomcat's server.xml Resource definition of a DataSource?

The resource definition in tomcat's server.xml looks something like this... <Resource name="jdbc/tox" scope=" ... storing-passwords-in-the-clear-for-tomcats-server-xml-resource-def...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

778 views

1 answer

jdbc - How to avoid storing passwords in the clear for tomcat's server.xml Resource definition of a DataSource?

The resource definition in tomcat's server.xml looks something like this... <Resource name="jdbc/tox" scope=" ... storing-passwords-in-the-clear-for-tomcats-server-xml-resource-def...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

948 views

1 answer

jdbc - How to set up datasource with Spring for HikariCP?

Hi I'm trying to use HikariCP with Spring for connection pool. I'm using jdbcTempLate and JdbcdaoSupport. This is ... /23172643/how-to-set-up-datasource-with-spring-for-hikaricp...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

789 views

1 answer

jdbc - How to set up datasource with Spring for HikariCP?

Hi I'm trying to use HikariCP with Spring for connection pool. I'm using jdbcTempLate and JdbcdaoSupport. This is ... /23172643/how-to-set-up-datasource-with-spring-for-hikaricp...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

892 views

1 answer

jdbc - OracleDataSource vs. Oracle UCP PoolDataSource

I was researching some JDBC Oracle Connection Pooling items and came across a new(er) Oracle ... stackoverflow.com/questions/1427890/oracledatasource-vs-oracle-ucp-pooldatasource...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

896 views

1 answer

jdbc - OracleDataSource vs. Oracle UCP PoolDataSource

I was researching some JDBC Oracle Connection Pooling items and came across a new(er) Oracle ... stackoverflow.com/questions/1427890/oracledatasource-vs-oracle-ucp-pooldatasource...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

700 views

1 answer

jdbc - Where to close java PreparedStatements and ResultSets?

Consider the code: PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.createStatement( ... com/questions/321418/where-to-close-java-preparedstatements-and-resultsets...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

745 views

1 answer

jdbc - Where to close java PreparedStatements and ResultSets?

Consider the code: PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.createStatement( ... com/questions/321418/where-to-close-java-preparedstatements-and-resultsets...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

811 views

1 answer

jdbc - Java, looping through result set

In Java, I have a query like this: String querystring1= "SELECT rlink_id, COUNT(*)" + "FROM dbo. ... https://stackoverflow.com/questions/7643576/java-looping-through-result-set...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

828 views

1 answer

jdbc - Java, looping through result set

In Java, I have a query like this: String querystring1= "SELECT rlink_id, COUNT(*)" + "FROM dbo. ... https://stackoverflow.com/questions/7643576/java-looping-through-result-set...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

893 views

1 answer

jdbc - Even though my RESULTSET is not empty I am not getting output. Using JAVA AND ORACLE DB

The database has the same format of date. Query is working fine in Oracle DB. In java the resultset is not empty. Cannot ... -is-not-empty-i-am-not-getting-output-using-java-and-or...

asked Apr 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags