| Product: | JDBC DBConnectivity Product for IBM Db2 (HiT JDBC/DB2) |
| Version: | All |
| ID: | 1017 |
| Summary: | How to avoid the error message "java.sql.SQLException: [BINDING] invalid authorization id:..." |
The very first time the driver is used to connect to the database, the driver will attempt to create a package and bind statements to the package. If the initial driver user does not have the CREATE IN COLLECTION and BINDADD privileges, the following exception occurs:
"java.sql.SQLException: [BINDING] Invalid authorization id: BIND?T70THW0?DB2GCH.DB2GCH.HITJDBC0?BINDADD"
To avoid this problem, make sure that the user ID for the initial connection has the CREATE IN COLLECTION and BINDADD privileges. Once the package is created and statements are bound, subsequent users do not need these privileges.