SQLite JDBC Driver - plugin detail

SQLite JDBC database driver

NetBeans Plugin - SQLite JDBC Driver
Plugin owner: sozen
Website: http://www.class.pm
Added: 2009-02-15
License: GPL
Category: Databases
Downloaded: 30,963 times
Rating:
 4.47, by 2 users

Plugin Log Show log

Versions available

Download plugin   Download size: 2.19 MB   Last Update: 2012-04-15

What's new in this version

Small fixes, signed the module.

Verifications for NetBeans versions

Plugin is not subject to any verification

Download plugin   Download size: 2.19 MB   Last Update: 2012-04-15

This plugin is also available on the NetBeans Plugin Portal Update Center. Use 'Tools > Plugins' action from the NetBeans IDE main menu for convenient installation of this plugin


What's new in this version

Small fixes, signed the module.

Verifications for NetBeans versions

6.5 verification PASSED See verification details
Download plugin   Download size: 2.19 MB   Last Update: 2012-04-15

What's new in this version

Small fixes, signed the module.

Verifications for NetBeans versions

6.1 verification PENDING See verification details
Download plugin   Download size: 2.19 MB   Last Update: 2012-04-15

What's new in this version

Small fixes, signed the module.

Verifications for NetBeans versions

6.0 verification PENDING See verification details


Introduction

This plugin provides the SQLite JDBC database driver for NetBeans.

[ You have to be logged in to be able to comment. ]

User Comments

  

Working on Netbeans 8.0

Working on Netbeans 8.0 on linux, thanks for useful plugin!
Posted by Caffeine on Jun 19, 2014
  

Works with NetBeans 8.0 RC1

Works also well with NetBeans 8 Release Candidate 1 for Linux.
Posted by teelo on Mar 03, 2014
  

New User

Sorry! But i am new to this. So can anyone tell me how to use a plugin?
I have installed .nbm file and I have added sqlite-jdbc library in my project. Now how can i use this plug-in??
Posted by MuneeB on Nov 18, 2013
  

Using with NetBeans 7.4 Beta

Works well with the latest NetBeans version - currently tested on 7.4 Beta.
Posted by ondrejd on Jul 30, 2013
  

Xode 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 Oracle logo