Skip to main content



      Home
Home » Eclipse Projects » DTP » JDBCType handling during SP Execution
JDBCType handling during SP Execution [message #21073] Tue, 29 August 2006 02:44 Go to next message
Eclipse UserFriend
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
Re: [dtp-dev] JDBCType handling during SP Execution [message #21091 is a reply to message #21073] Tue, 29 August 2006 03:05 Go to previous message
Eclipse UserFriend
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.S QLObjectItem,
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@eclipse.org
> https://dev.eclipse.org/mailman/listinfo/dtp-dev
Re: [dtp-dev] JDBCType handling during SP Execution [message #581971 is a reply to message #21073] Tue, 29 August 2006 03:05 Go to previous message
Eclipse UserFriend
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.S QLObjectItem,
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@eclipse.org
> https://dev.eclipse.org/mailman/listinfo/dtp-dev
Previous Topic:JDBCType handling during SP Execution
Next Topic:EDataType inheritance
Goto Forum:
  


Current Time: Mon Jul 07 00:13:15 EDT 2025

Powered by FUDForum. Page generated in 0.03009 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top