Posted the last message prematurely. Here is the continuation:
When I try to look at any individual table, I get the following:
Can't open Table window
Cannot set row prefetch to zero
jdbcnav.util.NavigatorException
at jdbcnav.JDBCDatabase.getJavaTypes(JDBCDatabase.java:2416)
at jdbcnav.JDBCDatabase$JDBCTable.updateDetails(JDBCDatabase.java:1562)
at jdbcnav.JDBCDatabase$JDBCTable.<init>(JDBCDatabase.java:1423)
at jdbcnav.JDBCDatabase.newJDBCTable(JDBCDatabase.java:1013)
...
java.sql.SQLException: Cannot set row prefetch to zero
at sanchez.jdbc.dbaccess.ScDBError.check_error(Unknown Source)
at sanchez.jdbc.driver.ScStatement.setFetchSize(Unknown Source)
at sanchez.jdbc.driver.ScPreparedStatement.getMetaData(Unknown Source)
at jdbcnav.JDBCDatabase.getJavaTypes(JDBCDatabase.java:2409)
at jdbcnav.JDBCDatabase$JDBCTable.updateDetails(JDBCDatabase.java:1562)
And lots more where that came from. Also, when I try to use the console to issue a SQL command like, "select * from SCAU" I get all the correct field names, but no data is returned. Are these problems likely setup issues? Has anyone else seen anything like this? Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I haven't used the JDBC Navigoator, yet. I use a tool called DbVisualizer to check the data or the queries. Are there any settings in the Navigator to specify the row size for each Fetch. It's defined as 0 (zero) then driver returns an error "Cannot set row prefetch to zero".
Manoj
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No reply or activity on their forum. I have to assume that this product does not have vigorous community support. I have downloaded and installed DbVisualizer and am having good results. Thanks.
--Ray
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using JDBC Navigator to try to take a peek at the tables in PIP. I am using the following setup information:
Name: pipv01
Driver Class: sanchez.jdbc.driver.ScDriver
URL: protocol=jdbc:sanchez:/database=127.1:61012:SCA$IBS
Username: xxxxxxxxxxx
Password: xxxxxxxxxxx
I seem to be connecting to the database OK, as I am getting a list of tables that looks correct.
Posted the last message prematurely. Here is the continuation:
When I try to look at any individual table, I get the following:
Can't open Table window
Cannot set row prefetch to zero
jdbcnav.util.NavigatorException
at jdbcnav.JDBCDatabase.getJavaTypes(JDBCDatabase.java:2416)
at jdbcnav.JDBCDatabase$JDBCTable.updateDetails(JDBCDatabase.java:1562)
at jdbcnav.JDBCDatabase$JDBCTable.<init>(JDBCDatabase.java:1423)
at jdbcnav.JDBCDatabase.newJDBCTable(JDBCDatabase.java:1013)
...
java.sql.SQLException: Cannot set row prefetch to zero
at sanchez.jdbc.dbaccess.ScDBError.check_error(Unknown Source)
at sanchez.jdbc.driver.ScStatement.setFetchSize(Unknown Source)
at sanchez.jdbc.driver.ScPreparedStatement.getMetaData(Unknown Source)
at jdbcnav.JDBCDatabase.getJavaTypes(JDBCDatabase.java:2409)
at jdbcnav.JDBCDatabase$JDBCTable.updateDetails(JDBCDatabase.java:1562)
And lots more where that came from. Also, when I try to use the console to issue a SQL command like, "select * from SCAU" I get all the correct field names, but no data is returned. Are these problems likely setup issues? Has anyone else seen anything like this? Thanks.
I haven't used the JDBC Navigoator, yet. I use a tool called DbVisualizer to check the data or the queries. Are there any settings in the Navigator to specify the row size for each Fetch. It's defined as 0 (zero) then driver returns an error "Cannot set row prefetch to zero".
Manoj
No reply or activity on their forum. I have to assume that this product does not have vigorous community support. I have downloaded and installed DbVisualizer and am having good results. Thanks.
--Ray