Re: [OT] DatabaseMetaData.getProcedureColumns() and You!
Re: [OT] DatabaseMetaData.getProcedureColumns() and You!
- Subject: Re: [OT] DatabaseMetaData.getProcedureColumns() and You!
- From: Ted Thibodeau Jr <email@hidden>
- Date: Sat, 30 Apr 2005 14:07:51 -0400
* PA [2005/04/30 10:42 AM +0200] wrote:
> The procedure parameters information is retrieved using
> DatabaseMetaData.getProcedureColumns() to automatically
> construct the relevant CallableStatement. Works pretty
> nicely and without too much fuss :)
>
> But... some databases (e.g. Oracle) have a pronounced tendency
> to return inconsistent column DATA_TYPE... for example,
> java.sql.Types.FLOAT masquerading as java.sql.Types.OTHER and
> other maddening discrepancies...
>
> Right now, when confronted with the "OTHER", I'm abased to
> double check the column TYPE_NAME against information provided
> by DatabaseMetaData.getTypeInfo(). This catches most of the
> incongruities, but is very much a wacky hack. Sigh...
>
> Anyone else ran into this? Workarounds? Fixes?
Try a different driver.
The issue you're hitting is not due to the Oracle back-end, but
to the JDBC driver you're working with, which I'm guessing is
the freebie you can get from the OTN site.
As you're discovering, with `free`, you often get what you pay
for, and that's not always a good thing.
You may benefit by trying OpenLink's solution (either in Single-
Tier form, which is installed entirely on the JDBC client host,
or in Multi-Tier form, which is split across the JDBC client and
the Oracle [or an intervening "gateway"] host).
http://www.openlinksw.com/download/downwiz.vsp
A 30-day evaluation license, unrestricted in all ways except
this expiration date, will be automatically sent to the email
address you register with the download site.
Free web-based support is available through our Support Center
and Case System --
http://support.openlinksw.com/
Other vendors provide JDBC solutions you may also wish to test.
OpenLink also maintains and supports an open-source benchmarking
utility, OpenLink JDBC Bench, inspired by and based on the TPC-A
and TPC-C suites (similar to OpenLink ODBC Bench). You can use
this tool to test JDBC Drivers, URLs, JVMs, and other variables
in the connection.
As this tool is open-source, you can inspect the tests to make
sure that they are not slanted to benefit any driver or database,
and you can extend or modify them to suit your own testing needs.
http://www.openlinksw.com/download/util.vsp
Please let me know if I can be of any assistance in the process.
Be seeing you,
Ted
--
A: Yes. http://learn.to/attribute
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:email@hidden
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden