Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » JDBCType handling during SP Execution
JDBCType handling during SP Execution [message #21073] Tue, 29 August 2006 06:44 Go to next message
Anil Samuel is currently offline Anil SamuelFriend
Messages: 108
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: [dtp-dev] JDBCType handling during SP Execution [message #21091 is a reply to message #21073] Tue, 29 August 2006 07:05 Go to previous message
Anil Samuel is currently offline Anil SamuelFriend
Messages: 108
Registered: July 2009
Senior Member
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

Report message to a moderator

Re: [dtp-dev] JDBCType handling during SP Execution [message #581971 is a reply to message #21073] Tue, 29 August 2006 07:05 Go to previous message
Anil Samuel is currently offline Anil SamuelFriend
Messages: 108
Registered: July 2009
Senior Member
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

Report message to a moderator

Previous Topic:JDBCType handling during SP Execution
Next Topic:EDataType inheritance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 00:01:16 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly