| Uploader: | Fenrirr |
| Date Added: | 8 June 2010 |
| File Size: | 21.96 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 39052 |
| Price: | Free* [*Free Regsitration Required] |
This table must be jvbc up at each DB2 V7 location that is accessed. Do not set this property if driverType is set to 2. Choose XA Data Source if you plan to use driver type 4, and your application requires connections that support two-phase commit transactions.
Begin by clicking the Custom Properties link that is now displayed on the administrative console page.
Hi Glenn, To resolve this issue, grant the following privileges on the DB2 owner: Sometimes they are also called transaction monitors. Application Server calls them custom propertiesand jjdbc that you set them on the data source as well.
Please ensure that the user has permissions to create packages. Most likely you also do not need to change the native library path or the data source implementation class name. A component-managed alias consists of an ID and password that are specified in an application for data source authentication. It's a manual process that I want to automate.
Application Server requires these properties to implement your JDBC db classes; see the topic, Data source minimum required settings, by jcbc to learn about acceptable values.

Please enter a title. Stack Overflow works best with JavaScript enabled.
Using the DB2 Universal JDBC Driver to access DB2 for z/OS
Thank you Gopinath for your quick response. Sign up using Email and Password. Please turn JavaScript back on and reload this page.
Click New to proceed to the console page for defining required properties. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.
fail to get XA DataSource connection using DB2 (JDBC and Relational Databases forum at Coderanch)
You don't have JavaScript enabled. To configure a Version 4 data source complete the following steps: The Type 2 driver uses these properties for the selected server Click Ok.
Do you know if the user in the connection defined on the Administrator page has necessary privilege to execute the package? Jdc a value for this property only if driverType is set to 4.
JDBC and Non-XA Data Source
That is, a transaction running across say 2 databases. You now see the page entitled Enter database-specific properties for the data source. It's pretty slow so should avoid it if you don't really need it. I wonder if it's because I have only Read access to the tables?
This content has been marked as final. Use only driverType 4 connectivity for the XA data source. Use only driverType 4 connectivity for the XA implementation.

Can you give some addition information on what you are trying to do? You just point to the data sourse and use a connection string and you get back the tables. Packages cannot be created in an XA Connection. Configuring two resource reference files on the same data source Xx can configure two resource reference files on the same data source.

Comments
Post a Comment