Re: [dtp-dev] JDBCType handling during SP Execution

[Anil T Samuel <anil.samuel@xxxxxxxxxx>]

Bug logged BZ155622

Anthos
Anil Samuel wrote:

> work around for this would have been to override IDBItem 
> getDBItem(ProcIdentifier) in the IControlConnection implementation 
> which returns a overridden SQLObjectItem(=>IDBItem) instance, where 
> the ParameterDescriptor[] getParameterDescriptor() method is 
> overridden to handle this type mapping.
>
> But SQLObjectItem is not exported by the 
> org.eclipse.datatools.sqltools.editor.core plugin and so results 
> following error when attempted to import into code.
>
> Access restriction: The type SQLObjectItem is not accessible due to 
> restriction on required library 
> ....\eclipse\plugins\org.eclipse.datatools.sqltools.editor.core_0.9.0.200605101.jar 
>
>
> So a quick fix would be to export the class,  
> org.eclipse.datatools.sqltools.editor.core.internal.dbitem.SQLObjectItem, 
> in org.eclipse.datatools.sqltools.editor.core plugin.
>
> Regards
> Anthos
> Anil Samuel wrote:
>
> > Hi
> >
> > The following static method is used to obtain the JDBC Type for a 
> > datatype which is then used to register the IN/OUT parameters.
> >
> > DataTypeHelper.getJDBCTypeForNamedType(String dataTypeName)
> >
> > This static implementation doesnot allow DTP extensions to extend it 
> > for DB specific datatype, VARCHAR2 for eg. in case of Oracle 
> > database. My suggestion would be to extend SQLDataService (which 
> > currently has String[] getDataTypes()) to handle this mapping.
> >
> > Is there any other way of achieving this in this context ?
> >
> > Regards
> > Anthos
> > _______________________________________________
> > dtp-dev mailing list
> > dtp-dev@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/dtp-dev
>
>
> _______________________________________________
> dtp-dev mailing list
> dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev