[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [dtp-dev] executing SQL instructions contained in a file
|
Hi Max,
this is what I did the first time, but I am getting again the following
errors in the 'Error Log' tab after setting the connection profile as
described in 2.:
Unhandled event loop exception
Failed to execute runnable (java.lang.NoSuchMethodError:
org.eclipse.datatools.sqltools.sql.parser.SQLParser.isComplete()Z)
org.eclipse.swt.SWTException: Failed to execute runnable
(java.lang.NoSuchMethodError:
org.eclipse.datatools.sqltools.sql.parser.SQLParser.isComplete()Z)
at org.eclipse.swt.SWT.error(SWT.java:3374)
at org.eclipse.swt.SWT.error(SWT.java:3297)
at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:126)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3325)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2971)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336)
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)
Caused by: java.lang.NoSuchMethodError:
org.eclipse.datatools.sqltools.sql.parser.SQLParser.isComplete()Z
at
org.eclipse.datatools.sqltools.sqleditor.internal.editor.SQLUpdater.enableSyntaxValidation(SQLUpdater.java:488)
at
org.eclipse.datatools.sqltools.sqleditor.internal.editor.SQLUpdater.run(SQLUpdater.java:128)
at
org.eclipse.datatools.sqltools.sqleditor.SQLEditor$3.run(SQLEditor.java:865)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:123)
... 20 more
I used a generic JDBC driver to connect to a SQLite DB.
Thanks
Benedetta
From: Hui.Cao@xxxxxxxxxx
Reply-To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
Subject: Re: [dtp-dev] executing SQL instructions contained in a file
Date: Fri, 10 Nov 2006 22:48:39 +0800
Hi Benedetta,
Here're the steps:
1. Give your sql file a ".sql" file extension, then open it using
DTP sql file editor. Note here, if you installed WTP RDB as well, you
should double check it's really opened by DTP, since RDB also registers as
the default editor for ".sql" files.
2. In the editor, set the right connection profile via "Set
Connection Info..." context menu. The connection profile type should be
"Generic", and if the dialog fails to load database list, you can type in
the database name manually.
3. Choose the "Execute All" context menu and the results will be
shown in sql results view.
Best Regards!
Max ( Hui ) Cao
Sybase, Inc. Shanghai, China
"Benedetta Turchi" <bturchi@xxxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx
11/10/2006 07:21 PM
Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>
To
dtp-dev@xxxxxxxxxxx
cc
Subject
Re: [dtp-dev] executing SQL instructions contained in a file
Hi,
can I execute the SQL instructions contained in the following 2 files to
create a DB:
- SQL file containing the DB schema,
- SQL file containing its data,
using DTP?
How can I?
Thank you
Benedetta
>From: "Benedetta Turchi" <bturchi@xxxxxxxxxxx>
>Reply-To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>To: dtp-dev@xxxxxxxxxxx
>Subject: Re: [dtp-dev] DTP support for SQLite DB
>Date: Thu, 09 Nov 2006 15:42:15 +0100
>
>Hi Brian,
>
>wth the latest DTP build I was able to connect and browse my SQLite DB.
>
>Thank you!
>Benedetta
>
>>From: brian.fitzpatrick@xxxxxxxxxx
>>Reply-To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>>To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>>Subject: Re: [dtp-dev] DTP support for SQLite DB
>>Date: Wed, 8 Nov 2006 08:21:19 -0800
>>
>>Ok. Final update and then I'll stop on this topic for now. Using the
>>driver you mentioned for SQLite yesterday (
>>http://www.ch-werner.de/javasqlite/ )... I was able to connect to and
>>browse my SQlite test database just fine. You might want to verify that
>>everything looks copacetic, but it came back with my table and displayed
>>its columns.
>>So let me know how it works for you.
>>
>>Brian Fitzpatrick
>>Senior Software Engineer/DTP Committer
>>Sybase, Inc.
>>
>>-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
>>
>>To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>>From: brian.fitzpatrick@xxxxxxxxxx
>>Sent by: dtp-dev-bounces@xxxxxxxxxxx
>>Date: 11/08/2006 08:58AM
>>Subject: Re: [dtp-dev] DTP support for SQLite DB
>>
>>By the way, we were unable to find the driver you mentioned for SQLite
>>yesterday ( http://www.ch-werner.de/javasqlite/ ) (seems to be
accessible
>>today). Ended up finding a different one at
>>http://www.zentus.com/sqlitejdbc/ . At any rate, ended up with the same
>>issue you found with the first driver. And I was able to connect to a
>>local SQlite database with one table. Note however that the Generic
JDBC
>>catalog loaders don't seem to get what they need from the SQLlite
driver.
>>It brings up the Schemas folder, but there's nothing beneath it. In
order
>>to read a SQLite db, we may need to come up with a custom catalog loader
>>like we did for Derby.
>>--Fitz
>>
>>Brian Fitzpatrick
>>Senior Software Engineer/DTP Committer
>>Sybase, Inc.
>>
>>-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
>>
>>To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>>From: brian.fitzpatrick@xxxxxxxxxx
>>Sent by: dtp-dev-bounces@xxxxxxxxxxx
>>Date: 11/08/2006 08:40AM
>>Subject: Re: [dtp-dev] DTP support for SQLite DB
>>
>>Just delivered the fix last night. Should appear in today's build. The
>>issue still remains if a driver has been loaded into a classloader. At
>>this time, there isn't a way to "unload" it if the jars or classname for
a
>>given driver instance have changed. You can change the jars and class
name
>>and try to reconnect to any profile using that driver. If you get an
error
>>saying the class was already loaded in a classloader, you will have to
>>close and restart Eclipse before the change will be picked up.
>>
>>Can you give it a shot with today's build when it becomes available?
>>
>>Brian Fitzpatrick
>>Senior Software Engineer/DTP Committer
>>Sybase, Inc.
>>
>>-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
>>
>>To: dtp-dev@xxxxxxxxxxx
>>From: "Benedetta Turchi" <bturchi@xxxxxxxxxxx>
>>Sent by: dtp-dev-bounces@xxxxxxxxxxx
>>Date: 11/08/2006 08:02AM
>>Subject: Re: [dtp-dev] DTP support for SQLite DB
>>
>>Hi,
>>
>>since I need to decide if I can use DTP for my next project, can I ask
you
>>when approximately is this defect
>>( https://bugs.eclipse.org/bugs/show_bug.cgi?id=162625 ) going to be
>>fixed?
>>
>>Thank you!
>>Benedetta
>>
>> >From: jograham@xxxxxxxxxx
>> >Reply-To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>> >To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>> >Subject: Re: [dtp-dev] DTP support for SQLite DB
>> >Date: Fri, 3 Nov 2006 16:50:35 -0500
>> >
>> >Hi Benedetta,
>> >
>> >While DTP doesn't support SQLite specifically at the moment, we do
have
>> >generic JDBC support through our SQL model. If you can get a JDBC
>> >connection to SQLite, then there's a chance you can use DTP as-is
today.
>>I
>> >say "a chance" because the generic support makes assumptions about the
>> >behavior of the JDBC driver, and we do have a bug about using native
>>code
>> >( https://bugs.eclipse.org/bugs/show_bug.cgi?id=162625 ).
>> >
>> >Also, in the bug mentioned above, a reporter mentions successfully
using
>> >SQLite with DTP. I'll forward this email to him to see if he can help
>>out.
>> >
>> >Regards,
>> >John Graham
>> >Eclipse Data Tools Platform PMC Chair
>> >Staff Software Engineer, Sybase, Inc.
>> > http://dataplat.blogspot.com/
>> >
>> >
>> >
>> >
>> > "Benedetta
>> > Turchi"
>> > <bturchi@hotmail.
>> To
>> > com> dtp-dev@xxxxxxxxxxx
>> > Sent by:
>>cc
>> > dtp-dev-bounces@e
>> > clipse.org
>> Subject
>> > [dtp-dev] DTP support for
SQLite
>>DB
>> >
>> > 11/03/2006 12:52
>> > PM
>> >
>> >
>> > Please respond to
>> > DTP development
>> > mailing list
>> > <dtp-dev@eclipse.
>> > org>
>> >
>> >
>> >
>> >
>> >
>> >
>> >Hi,
>> >
>> >my next project is to create a tool to enable a user to create an
SQLite
>> >database file using SQL scripts for schema and data. So I was
wondering
>>if
>> >I
>> >could use DTP.
>> >I know that SQLite DB is not supported by DTP at the moment, so I was
>> >wondering about the effort of adding this support.
>> >
>> >Thank you
>> >Benedetta
>> >
>> >_________________________________________________________________
>> >Manda messaggi istantanei dal tuo account di Hotmail!
>> > http://join.msn.com/hotmail/features-std#6
>> >
>> >_______________________________________________
>> >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
>>
>>_________________________________________________________________
>>Aggiungi il modulo Amici al tuo Spaces con un click!
>>http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=it-it
>>
>>_______________________________________________
>>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
>>
>
>
>>_______________________________________________
>>dtp-dev mailing list
>>dtp-dev@xxxxxxxxxxx
>>https://dev.eclipse.org/mailman/listinfo/dtp-dev
>
>_________________________________________________________________
>Aggiungi i tuoi nuovi contatti di Hotmail anche in Messenger.Con un
click!
>http://join.msn.com/hotmail/features-std#6
>
>_______________________________________________
>dtp-dev mailing list
>dtp-dev@xxxxxxxxxxx
>https://dev.eclipse.org/mailman/listinfo/dtp-dev
_________________________________________________________________
Aggiungi i tuoi nuovi contatti di Hotmail anche in Messenger.Con un click!
http://join.msn.com/hotmail/features-std#6
_______________________________________________
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
_________________________________________________________________
Manda messaggi istantanei dal tuo account di Hotmail!
http://join.msn.com/hotmail/features-std#6
