Database Connection - various issues

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Database Connection - various issues

John Aspinall-3
Database Connection has been split into two packages, but the 'Database
Connection Base' package still has the development system as a prerequisite.
Repackaging DBResultSet>>publishedAspectsOfInstances into the 'Database
Connection' package sorts this out.

DBAbstractStatement>>describeCols: references
DBConnection>>maxColumnNameLen, which is deprecated.

DBConnection>>traceFile: references DBConnection>>trace, which is
deprecated.

Transactions are broken, giving an 'Invalid access...' error on commit or
rollback. The problem seems to be that  ODBCLibrary>>sqlEndTran...has been
changed as if to use the SQLEndTran call (which expects SQL_HANDLE_DBC as
the first parameter), but is still actually using SQLTransact as in D4,
which expects the ODBC Environment Handle (HEnv) as the first parameter.
Changing the call to SQLEndTran fixes this.

Cheers.

John Aspinall


Reply | Threaded
Open this post in threaded view
|

Re: Database Connection - various issues

Blair McGlashan
"John Aspinall" <[hidden email]> wrote in message
news:[hidden email]...
> Database Connection has been split into two packages, but the 'Database
> Connection Base' package still has the development system as a
prerequisite.

> Repackaging DBResultSet>>publishedAspectsOfInstances into the 'Database
> Connection' package sorts this out.
>
> DBAbstractStatement>>describeCols: references
> DBConnection>>maxColumnNameLen, which is deprecated.
>
> DBConnection>>traceFile: references DBConnection>>trace, which is
> deprecated.
>
> Transactions are broken, giving an 'Invalid access...' error on commit or
> rollback. The problem seems to be that  ODBCLibrary>>sqlEndTran...has been
> changed as if to use the SQLEndTran call (which expects SQL_HANDLE_DBC as
> the first parameter), but is still actually using SQLTransact as in D4,
> which expects the ODBC Environment Handle (HEnv) as the first parameter.
> Changing the call to SQLEndTran fixes this.
>


Thanks John, issues #632 thru #634, all fixed for the next release.

Regards

Blair