RE: [cinjug-users] DB2 JDBC Driver

["Arnett, Matt" <Matt.Arnett@xxxxxxxxxx>]

No.  But this could be an option to keep in mind if we choose to go the hibernate route for these queries.

Thanks,
- Matt

---

From: Chris Nelson [mailto:cnelson4eii@xxxxxxxxx]
Sent: Tuesday, November 27, 2007 10:18 AM
To: Arnett, Matt
Cc: users@xxxxxxxxxx
Subject: Re: [cinjug-users] DB2 JDBC Driver

 

Matt,

Is Hibernate generating the SQL in question?  If so, you could write a new dialect that builds the SQL correctly for your environment.  I've done this kind of thing before and found the dialect code to be fairly straightforward to work with (at least compared with the rest of the hibernate codebase).

--Chris

----- Original Message ----
From: "Arnett, Matt" <Matt.Arnett@xxxxxxxxxx>
To: users@xxxxxxxxxx
Sent: Tuesday, November 27, 2007 10:05:08 AM
Subject: [cinjug-users] DB2 JDBC Driver

Is anyone aware of a DB2 JDBC Driver that can “interpret/convert/dumb down” SQL queries that have features supported by higher levels of OS/400 (i.e. V5R2) to lower levels of OS/400 (i.e. V4R5)?  Does Hibernate have any support like this?

We are using the jt400.jar (v5.3) from IBM (IBM Toolbox for Java, JTOpen 4.1, http://jt400.sourceforge.net/).

We have several versions of OS/400 floating around on several remote systems.  We have found some queries that were designed against OS/400 V5R2 will not work on older versions of OS/400.  I have heard that there is a way to use DDM on a central AS400 to act as a view to the remote AS400s and the DDM can convert the queries to the supported version of OS/400 on the target system.  Although, this is yet to be tested/proven to work.

Thanks,

Matt

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.

 

 

---

Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.