Re: [dtp-dev] Help wanted in creating a custom JSBCProcedureColumnLoader

[Lawrence E Dunnell <ledunnel@xxxxxxxxxx>]

Ivar,

You should be able to register the procedure
column loader like this:

   <extension
         point="org.eclipse.datatools.connectivity.sqm.core.catalog">
     <overrideLoader
           eclass="org.eclipse.datatools.modelbase.sql.routines.Parameter"
           product="SQL
Server"
           provider="org.eclipse.datatools.enablement.msft.internal.sqlserver.loaders.MyProcedureColumnLoader"
           version="2005"/>
  </extension> 

Larry Dunnell
DB2 Tooling, RAD Data Tools and Eclipse Data Tools Project (DTP)
IBM DB2 Information Management Software

From:	"Ivar Meikas" <imeikas@xxxxxxxxx>
To:	dtp-dev@xxxxxxxxxxx
Date:	07/06/2008 04:37 PM
Subject:	[dtp-dev] Help wanted in creating a custom JSBCProcedureColumnLoader

---

Hi,

I'm trying to create a custom DDL editor for MS SQL Stored Procedures,
but I'm having couple of problems. I think I'm missing something obvious
as I don't know how to do register a custom JDBCProcedureColumnLoader.

Currently in JDBCProcedure I get an java.lang.ClassCastException: org.eclipse.datatools.enablement.msft.internal.sqlserver.loaders.SQL2005ColumnLoader
    at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCProcedure.createParameterLoader(JDBCProcedure.java:85)
    at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCProcedure.getParameterLoader(JDBCProcedure.java:94)

One thing that I don't understand is why "SQLTablesFactory.eINSTANCE.createColumn().eClass().getInstanceClassName()"
(in line 82) gives "org.eclipse.datatools.modelbase.sql.tables.Column"
(SQL2005ColumnLoader is registered as tables.Column loader in extensions).
I haven't found any way to register my own version of JDBCProcedureColumnLoader
or found out if I should be doing something else.

This error is also reproducible in current CVS head and my modifications
have had no impact at all. 

Any help pointing me in the right direction is greatly appreciated :)

Thanks in advance,
Ivar Meikas
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev