CData JDBC Couchbase Java app connection problem

Question

I can't manage to get this right. I'm not sure of what is wrong. Apparently the connection is ok but can't get the result back of the query.

package probandoCouch;
import cdata.jdbc.couchbase.CouchbaseDriver;
import java.sql.Statement;
import java.util.Properties;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class App {
public static void main(String[] args) {

    try {
        Connection conn = DriverManager.getConnection(
                "jdbc:couchbase:User=\"Administrator\";Password=\"Administrator\";Server=\"127.0.0.1\";");
        Statement stat = conn.createStatement();
        boolean ret = stat.execute("SELECT message FROM greeting WHERE author='foo';");
        if (ret) {
            ResultSet rs = stat.getResultSet();
            while (rs.next()) {
                for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
                    System.out.println(rs.getMetaData().getColumnName(i) + "=" + rs.getString(i));
                }
            }
        }

    } catch (SQLException e) {
    }
}

}

The N1QL runs fine when you execute it directly in Couchbase's Query Workbench? — Matthew Groves, Sep 17 '20 at 14:11

score 1 · Answer 1 · answered Sep 17 '20 at 13:41

Can you please remove semicolon(;) from query and try

SELECT message FROM greeting WHERE author='foo';

Updated Query:

SELECT message FROM greeting WHERE author='foo'

With semicolon jdbc will fail with error

java.sql.SQLException: ORA-00933: SQL command not properly ended

In your code you may print the exception to see if any exception is thrown.

CData JDBC Couchbase Java app connection problem

1 Answers1