Recent questions tagged jdbc

0 votes

992 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

747 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.1k 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

942 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

814 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

861 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

685 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

784 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

866 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

962 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

802 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

855 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

858 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

730 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

831 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

783 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

953 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

796 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

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

900 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

705 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

751 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

816 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

831 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

898 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