UniDataJDBC - wendysmoak/wiki GitHub Wiki

JDBC access to UniData

How to set up an account w/out Visual Schema Generator (VSG) http://www.mail-archive.com/[email protected]/msg12006.html
Trouble with SQL Privileges for JDBC access to UniData http://www.mail-archive.com/[email protected]/msg12766.html
JDBC test

      Statement stmt = con.createStatement();
      String sql = "select @ID from STAFF";
      ResultSet rs = stmt.executeQuery( sql );

java.sql.SQLException: You have no privilege on file STAFF
	at com.ibm.u2.jdbc.UniJDBCMsgFactory.createException(UniJDBCMsgFactory.java:101)
	at com.ibm.u2.jdbc.UniJDBCExceptionSupport.addException(UniJDBCExceptionSupport.java:87)
	at com.ibm.u2.jdbc.UniJDBCProtocolU2Impl.addServerError(UniJDBCProtocolU2Impl.java:2789)
	at com.ibm.u2.jdbc.UniJDBCProtocolU2Impl.associateServerCursor(UniJDBCProtocolU2Impl.java:1655)
	at com.ibm.u2.jdbc.UniJDBCProtocolU2Impl.associateCursor(UniJDBCProtocolU2Impl.java:1712)
	at com.ibm.u2.jdbc.UniJDBCProtocolU2Impl.prepare(UniJDBCProtocolU2Impl.java:1895)
	at com.ibm.u2.jdbc.UniJDBCProtocolU2Impl.doExecuteAll(UniJDBCProtocolU2Impl.java:2263)
	at com.ibm.u2.jdbc.UniJDBCProtocolU2Impl.executeStatementQuery(UniJDBCProtocolU2Impl.java:606)
	at com.ibm.u2.jdbc.UniJDBCStatementImpl.executeQuery(UniJDBCStatementImpl.java:223)
	at edu.asu.vpia.AppTest.testStaffQuery(AppTest.java:150)
	at edu.asu.vpia.AppTest.testQueryBentest(AppTest.java:59)

Granting permissions (as root or as the owner of all the files in the account) does not work:

:sql
sql> GRANT ALL PRIVILEGES ON STAFF TO PUBLIC;
Sorry, you have no privilege on this file!
sql>
sql>
sql> QUIT
:quit
# whoami
root
#