Do these drivers support the DatabaseMetaData stuff???
On a related note can anyone tell me how the DatabaseMetaData methods
..getTables and .getColumns return ResultSets ?
I have some code that works with the Access Odbc driver , but not the SQL
Server driver via the Odbc-bridge
The code in question uses DatabaseMetaData.getTables
to return the DB tables and loops over the ResultSet returned and retrieves
the Columns of each table using DatabaseMetaData.getColumns() and an inner
loop loops over the column name.
However I get an ODBC error, "Database busy waiting for another hinst"
(something like that, haven't got the exact test here)
I thought that because the DatabaseMetaData.getTables()
method had executed that the connection would be free (not using pooling).
It works if I put the getColumns method outside the getTable loop.
Any ideas?
Thanks Justin
>-----Original Message-----
>From: Scott M. Stirling [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, January 04, 2001 6:18 AM
>To: JRun-Talk
>Subject: Re: JDBC Drivers
>
>
>On 26 Dec 2000 11:45:22 -0500, Bob Smith wrote:
>> Hi,
>> I am new to JRUN. We are required to integrate with SQL
>Server7.0. We also
>> develop applications with ColdFusion. I was wondering if
>JRUN/Allaire has some
>> recommendations for JDBC drivers or perhaps JRUN has its own
>JDBC drivers and
>> I have missed it.
>>
>>
>> Thanks,
>> Bob
>
>
>Funny you should ask, Bob. We'll be shipping Merant Type IV JDBC
>drivers with a new JRun Advanced Edition very soon. Meanwhile, for
>development you can use the Weblogic JDBC driver for SQLServer (see
>www.bea.com) or try www.inetsoftware.de -- they have very popular, tried
>and true JDBC drivers for SQLServer.
>
>--
>Scott Stirling
>West Newton, MA
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
