Not logged in |
SQLite JDBC Driver - plugin detailSQLite JDBC database driver
[ You have to be logged in to be able to comment. ] User CommentsXode Developers reading SQLLite from Simulator using Netbeans:
Xcode has no way to talk with SQLite when an App runs on the Device Simulator, if you already have Netbeans on your Mac, do the following:
Follow the instructions below "Posted by Dredd on Jun 05, 2012" to get and install the driver, then for the JDBC URL use: jdbc:sqlite://Volumes/Mac OSX/Users/**YOUR_USER**/Library/Application Support/iPhone Simulator/5.0/Applications/**YOUR_APP_ID**/Documents/**YOUR_PROJECT**.sqlite
Posted by jmerinoh on Jun 04, 2013
Solution to the problem - noob friendly
Hello programmers.
To implement sqlite connection with a specific netbeans project, just do the steps below, after downloading sqlite-jdbc-3.7.2.jar (jar file) : 1) Right- click to the exact project and select "Properties". 2) Select "Libraries" from the left list, named "Categories". 3) Select "Add JAR/Folder" from the right button choices. 4) Find the jar file that you just downloaded and select it. You are ready to go.
Posted by theo75 on Apr 05, 2013
Customize Connection" in "JDBC URL"
I have file in : c:\Temp\main.db which is sqllite database file. I have downloaded and added sqllite-jdbc jar file but i can't get over "JDBC URL" : jdbc:sqlite://c:/Temp/main.db isnt working. ERROR: Cannot establish a connection to jdbc:sqlite://c:/Temp/main.db using org.sqlite.JDBC (invalid database address: jdbc:sqlite://c:/Temp/main.db)
Using Netbeans 7.2.1 and sqllite-jdbc-3.7.2.jar file. What Am I doing wrong ?
Posted by nodream on Dec 13, 2012
It seems to work fine on Netbeans 7.2
I haven't tested it thoroughly but so far it's working fine on Netbeans 7.2.
Thanks for this plugin, it really helps to have everything inside of Netbeans and not have to use a different software to manage an SQLite database.
Posted by bluescreenjunky on Jul 29, 2012
SQLite driver
Download sqlite-jdbc-3.7.2.jar from
http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.7.2/ and place it where you want. In "Services" start "New Connection Wizard", then in "Driver" select - scroll to bottom to find "New driver ..." entry. Press "Add..." and locate previously downloaded file. Press "Find", give it a name. On "Customize Connection" in "JDBC URL" field enter : jdbc:sqlite://C:/data/sampledb.sqlite (change path to your needs).
Posted by Dredd on Jun 05, 2012
Version 7
+1 for version 7
Posted by abalint21 on May 11, 2012
Version 7
+1 for version 7
Posted by xav0989 on Nov 13, 2011
Version 7
I don't want to be a complainer, but it seems like this has fallen behind. Is there any chance there will be a SQLite driver for NetBeans 7??
Thanks, R.
Posted by GapDragon on May 10, 2011
Issue tracker?
Thanks for the plugin. Is there an issue tracker for this plugin?
I tried this plugin for the first time today but have the following issues: 1. I can't INSERT text because the driver expects VARCHAR not TEXT type. 2. The View Table... window does not auto-size columns so it takes ages to resize the columns manually on refresh. 3. In the View Table.. window the Next Page and Last Page buttons return empty views rather than data. 4. The SQL case is inverted: I thought that the convention was to capitalise SQL keyword and have everything else in lower case e.g. "SELECT my_col FROM my_table". The SQL command window does the opposite.
Posted by blokeley on Mar 13, 2009
|
By use of this website, you agree to the NetBeans Policies and Terms of Use.
© 2012, Oracle Corporation and/or its affiliates. Sponsored by 
