I'm using WebSphere 4 with DB2. I have had to make a few changes to get everything working but all seems okay now. Here's what I'm doing:
- repository_database.xml (included in zip)
- datasource config from web.xml:
<resource-ref id="ResourceRef_1053700341519">
<res-ref-name>jdbc/sqmsdev</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>CONTAINER</res-auth>
</resource-ref>- Sample class-descriptor:
<class-descriptor
class="ReportTypeImpl"
table="SQMS_FIELD.REPORT_TYPE">
<field-descriptor
name="id"
column="REPORT_TYPE_ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
access="readonly"
/>
<field-descriptor
name="name"
column="REPORT_TYPE"
jdbc-type="CHAR"
/>
</class-descriptor>- OJB.properties (included in zip).
- Patch for PlatformDb2Impl (included in zip). This adds support for getLastInsertIdentityQuery() in DB2. I have submitted a request in Jira for this one.
- Patch for SequenceManagerNativeImpl (included in zip). The change to afterStore() is required if any tables do not have identity fields.
setReferenceFKs() has been commented out, as it causes errors. It should probably be fixed, but I haven't spent the time to figure it out.
Enjoy,
Mike
[EMAIL PROTECTED] wrote:
Hi Oliver, all,
I'm experiencing similar problems with the Websphere AS (pooling with Websphere, not OJB). Does anybody have a working example of a Websphere/OJB installation (properties-file, modified RC4 sources?) and some example query code (including the JNDI lookup part)?
Regards Lasse
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
