Press Ctrl+Alt+S to open the IDE settings and select Plugins. The Database tools and SQL plugin is available only in IntelliJ IDEA Ultimate. If the relevant features aren't available, make sure that you didn't disable the plugin. ![]() This functionality relies on the Database tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default. However, I will attach patches for the .sqlite plug-in and the .sqlite.dbdefinition plug-ins here for you to test with if you'd like along with a screen shot of the table editor editing data from one of the tables in your sample database.SQLite Enable the Database tools and SQL plugin I'm going to say that because of the significant change to the SQLite database definition xmi file this will have to be pushed into 1.9 once we have a branch for the 1.9 release. That said, I believe I have the database definition whipped back into shape now that I have a bit more understanding of how SQLite handles types. So I'm not all that comfortable with including it in the data types list. The recognosco.db database that's attached has a column with data type "timestamp" - this is not one of the datatypes in the page, section 2.2. When I initially created the definition I asked for help I never got and nobody has found anything wrong until now. The issue doesn't lie in the SQL Table Editor, but instead lies with the SQLite database definition. I think the DTP plug-in code causing the problem might actually be shown in Brian's blog post(?): This can be confirmed by executing a query in the SQL Scrapbook view: ![]() I believe that sqlite is using 'main' instead of 'DEFAULT' as the standard database name. Here's the error emitted to the Status tab of the SQL Results view: !MESSAGE Unable to create editor ID .editor.tableDataEditor: An unexpected exception was thrown.Īt .(TableDataTableCursor.java:108)Īt .editor.TableDataTableCursor.(TableDataTableCursor.java:39)Īt .editor.TableDataTableCursorExternalEditingSupport.(TableDataTableCursorExternalEditingSupport.java:46)Īt .(TableDataEditor.java:124)Īt .(EditorReference.java:670)Īt .(EditorReference.java:465)Īt .(WorkbenchPartReference.java:595)Īt .(PartPane.java:313)Īt .(PresentablePart.java:180)Īt .select(PresentablePartFolder.java:270)Īt .select(LeftToRightTabOrder.java:65)Īt .selectPart(TabbedStackPresentation.java:473)Īt .(PartStack.java:1254)Īt .(PartStack.java:1207)Īt .(PartStack.java:1606)Īt .(PartStack.java:497)Īt .(EditorStack.java:103)Īt .(PartStack.java:483)Īt .(EditorStack.java:112)Īt .(EditorSashContainer.java:63)Īt .(EditorAreaHelper.java:225)Īt .(EditorAreaHelper.java:213)Īt .(EditorManager.java:778)Īt .(EditorManager.java:677)Īt .(EditorManager.java:638)Īt .(WorkbenchPage.java:2860)Īt .(WorkbenchPage.java:2768)Īt .$11(WorkbenchPage.java:2760)Īt .internal.WorkbenchPage$10.run(WorkbenchPage.java:2711)Īt .BusyIndicator.showWhile(BusyIndicator.java:70)Īt .(WorkbenchPage.java:2707)Īt .(WorkbenchPage.java:2691)Īt .(WorkbenchPage.java:2674)Īt .(EditTableDataAction.java:63)Īt .nWithEvent(Action.java:498)Īt .ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)Īt .ActionContributionItem.access$2(ActionContributionItem.java:501)Īt .ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)Īt .ndEvent(EventTable.java:84)Īt .ndEvent(Widget.java:1258)Īt .nDeferredEvents(Display.java:3552)Īt .Display.readAndDispatch(Display.java:3171)Īt .(Workbench.java:2629)Īt .(Workbench.java:2593)Īt .$4(Workbench.java:2427)Īt .internal.Workbench$7.run(Workbench.java:670)Īt .(Realm.java:332)Īt .(Workbench.java:663)Īt .PlatformUI.createAndRunWorkbench(PlatformUI.java:149)Īt .start(IDEApplication.java:115)Īt .(EclipseAppHandle.java:196)Īt .(EclipseAppLauncher.java:110)Īt .(EclipseAppLauncher.java:79)Īt .(EclipseStarter.java:369)Īt .(EclipseStarter.java:179)Īt 0(Native Method)Īt (NativeMethodAccessorImpl.java:39)Īt (DelegatingMethodAccessorImpl.java:25)Īt .invoke(Method.java:597)Īt .Main.invokeFramework(Main.java:619)Īt .Main.basicRun(Main.java:574)Īt .n(Main.java:1407)Īt .Main.main(Main.java:1383)Īfter following the same steps but choosing "Sample Contents", a clue can be found in the SQL Results view.ġ) Download the Zentus SQLite JDBC driver fromĥ) Change the JDBC URL in the Test.java class with a path pointing to where youĩ) Right-click and select Data->Sample Contents I am able to sample the contents of the database - the results of which shows up fine in the Results view. It should create a PEOPLE database with some data.Ĩ) Drill in, look for the PEOPLE database 1) Download the Zentus SQLite JDBC driver from ( )Ģ) Create a new SQLite driver definition and point to the driverģ) Create a new SQLite connection profileĤ) Import the attached project into your workspace.ĥ) Change the JDBC URL in the Test.java class with a path pointing to where you put your database.Ħ) Run the class.
0 Comments
Leave a Reply. |