Re: [dtp-dev] headless dtp

[brian.fitzpatrick@xxxxxxxxxx]

No worries. :)

Well... Unfortunately that's not really
my cup of tea. I've been very focused on using this in an Eclipse environment,
so I don't have any first-hand experience using Eclipse code outside Eclipse...

Can someone else help Sam here? 

--Fitz

Brian Fitzpatrick
Eclipse Data Tools Platform PMC Chair
Eclipse Data Tools Platform Connectivity Team Lead
Staff Software Engineer, Sybase, Inc.

Sam Donnelly <samd@xxxxxxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

04/13/2009 12:57 PM

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>

To	DTP development mailing list <dtp-dev@xxxxxxxxxxx>
cc
Subject	Re: [dtp-dev] headless dtp

Fitz,

Thanks so much for the quick help.

To answer the question from your previous mail: I'd like to execute the
DDL using the DTP API's. What I'd like to have is the ability to execute
DDL against any of the DTP supported databases, with the target(s) 
configured at runtime.

At the moment, I'm exploring the possibility of doing this outside of 
the Eclipse environment, in a standalone app. Do you know if this is 
possible?

When I go ahead in a standalone program and try to build a transient 
profile, I get the exception below, which occurs when the code is 
looking to the extension registry for a plug-in.

Thanks!

Sam

java.lang.NullPointerException
                
at 
org.eclipse.datatools.connectivity.internal.ConnectionProfileManager.processExtensions(ConnectionProfileManager.java:141)
                
at 
org.eclipse.datatools.connectivity.internal.ConnectionProfileManager.getProviders(ConnectionProfileManager.java:92)
                
at 
org.eclipse.datatools.connectivity.internal.ConnectionProfileManager.getProvider(ConnectionProfileManager.java:97)
                
at 
org.eclipse.datatools.connectivity.internal.ConnectionProfile.<init>(ConnectionProfile.java:104)
                
at 
org.eclipse.datatools.connectivity.internal.InternalProfileManager.createTransientProfile(InternalProfileManager.java:477)
                
at 
org.eclipse.datatools.connectivity.ProfileManager.createTransientProfile(ProfileManager.java:139)
                
at 
edu.upenn.cis.orchestra.sql.dtp.DtpSqlCreate.toString(DtpSqlCreate.java:126)
                
at java.lang.String.valueOf(String.java:2827)
                
at java.lang.StringBuilder.append(StringBuilder.java:115)
                
at edu.upenn.cis.orchestra.sql.TestCreate.testCreate(TestCreate.java:19)
                
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                
at java.lang.reflect.Method.invoke(Method.java:597)
                
at 
org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
                
at 
org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
                
at 
org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
                
at 
org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
                
at 
org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
                
at 
org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:75)
                
at 
org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:36)
                
at 
org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
                
at 
org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
                
at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
                
at 
org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
                
at 
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
                
at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
                
at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
                
at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
                
at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)



brian.fitzpatrick@xxxxxxxxxx wrote:
> 
> Hey Sam...
> 
> I've posted an example on my blog here: 
> http://fitzdtp.blogspot.com/2009/04/dtp-apis-and-how-to-use-transient.html
> 
> Hopefully that's enough to get you started. Please feel free to ask
any 
> more questions you may have.
> 
> --Fitz
> 
> Brian Fitzpatrick
> Eclipse Data Tools Platform PMC Chair
> Eclipse Data Tools Platform Connectivity Team Lead
> Staff Software Engineer, Sybase, Inc.
> 
> 
> 
> *Sam Donnelly <samd@xxxxxxxxxxxxxx>*
> Sent by: dtp-dev-bounces@xxxxxxxxxxx
> 
> 04/12/2009 11:28 PM
> Please respond to
> DTP development mailing list <dtp-dev@xxxxxxxxxxx>
> 
> 
>                  
> To
>                  dtp-dev@xxxxxxxxxxx
> cc
>                  
> Subject
>                  [dtp-dev]
headless dtp
> 
> 
>                  
> 
> 
> 
> 
> 
> Hello,
> 
> I'm interested in using the DTP api's in a headless (non-gui)
> environment. I've seen it mentioned that it's possible to do, but
so far
> I've had no luck. What I'm trying to start with is creating a transient
> profile.
> 
>  From there I'd like to issue DDL to a database.
> 
> Any guidance would be much appreciated!
> 
> Thanks,
> 
> Sam
> _______________________________________________
> 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

_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev