Does SQLite JDBC driver supports the resultset cursor to move backwards

[maxx...@umn.edu]

Hi,

I am so sorry to ask here this simple question, but does SQLite JDBC supports resultset cursor to move backwards? I am using the sqlite-jdbc-3.6.17.1.jar for an android application which requires server to read from database. However the server reports java heap space outOfMemory error when I try "resultset.previous" code.
I think maybe the problem is in my code (I didn't get an SQLFeatureNotSupported Exception) but I may I ask for double check, whether SQLite JDBC driver supports the "resultset.previous" feature?

Thank you so much for your concern.

Best Regards

Yue

[Peter Borissow]

I don't think so. I'm using 3.7.2. When I try to create a scroll insensitive cursor, I get an exception.

Example:
stmt = conn.createStatement(rs.TYPE_SCROLL_INSENSITIVE, rs.CONCUR_READ_ONLY);

Throws:
java.sql.SQLException: SQLite only supports TYPE_FORWARD_ONLY cursors

Would be nice though!

Also, just as an FYI, the JDBC driver doesn't support inserts and updates via the resultset. You have to use prepared statements instead. Which is a real bummer - especially if you have to update a table without a primary key...

Peter

---

From: "maxx...@umn.edu" <maxx...@umn.edu>
To: xer...@googlegroups.com
Sent: Friday, January 4, 2013 1:40 PM
Subject: [xerial 592] Does SQLite JDBC driver supports the resultset cursor to move backwards

--
You received this message because you are subscribed to the Google Groups "Xerial" group.
To view this discussion on the web visit https://groups.google.com/d/msg/xerial/-/yHY6fsMo-zQJ.
To post to this group, send email to xer...@googlegroups.com.
To unsubscribe from this group, send email to xerial+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/xerial?hl=en.

[Peter Borissow]

Grace/Taro-

    Any plans to update the xerial.org website? I tried to find the latest snapshot this afternoon and didn't see it up there. Lots of links still point to the maven repo. The News section hasn't been updated since 2011. Simple one line announcements like "We've moved to Github" or "New Snapshot available" would be nice to see. 

Just a thought.

Thanks!

Peter

[Peter Borissow]

PS. I was referring to this site:

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC

---

From: Peter Borissow <peter.b...@yahoo.com>
To: "xer...@googlegroups.com" <xer...@googlegroups.com>
Sent: Tuesday, January 8, 2013 4:21 PM
Subject: [xerial 593] Xerial.org Website

[Taro L. Saito]

Hi,

Thank you for the suggestion.

I would like to create a new web site for sqlite-jdbc, using jekyll on github,

which is easier for maintenance and accepting contributions made by the other people.

As a quick fix, I added a link to https://bitbucket.org/xerial/sqlite-jdbc

in the web site. 

Regards,

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

--

You received this message because you are subscribed to the Google Groups "Xerial" group.

[grace]

On Thursday, January 10, 2013 9:15:51 AM UTC-5, Taro L. Saito wrote:

Hi,

Thank you for the suggestion.

I would like to create a new web site for sqlite-jdbc, using jekyll on github,

which is easier for maintenance and accepting contributions made by the other people.

Hi Taro,

Have you considered using bitbucket's wiki? https://bitbucket.org/xerial/sqlite-jdbc/wiki/Home

In this way, everything (source code, issue tracker and website) would all be in the same place.

[Taro L. Saito]

Thank you for the information.

Previously the bitbucket had no support of embedding the google analytics scripts, so I have 

been reluctant to use it, but now it has this feature.

OK. I would like to use the wiki page to maintain the information of sqlite-jdbc.

https://bitbucket.org/xerial/sqlite-jdbc/wiki

And added a link to this page from the original web site: http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC

--

Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

--
You received this message because you are subscribed to the Google Groups "Xerial" group.

To view this discussion on the web visit https://groups.google.com/d/msg/xerial/-/OMxTBB1b4M0J.

[Peter Borissow]

Cool! Great first step. Couple suggestions:


(1) Remove all content from the original website and add a redirect to the new site. If a redirect is not possible, replace the content with a link saying "This site has moved", or something like that.


(2) Update links to the maven repo. For example, the "Beta Release" section has this link:

http://www.xerial.org/maven/repository/snapshot/org/xerial/sqlite-jdbc

Should be:

https://bitbucket.org/xerial/sqlite-jdbc/downloads

Ditto for this link:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/

(3) Move all previous snapshots and releases to the new site

https://bitbucket.org/xerial/sqlite-jdbc/downloads

(4) Some of the hyperlinks don't look right. I think its a wiki, formatting difference between trac and github. For example, on the new site I see text like "[http://maven.apache.org Maven]".

That's it for now.

Thanks!

Peter

---

From: Taro L. Saito <tar...@gmail.com>
To: xer...@googlegroups.com
Sent: Monday, January 14, 2013 7:51 PM
Subject: Re: [xerial 598] Xerial.org Website

[grace]

On Monday, January 14, 2013 7:51:03 PM UTC-5, Taro L. Saito wrote:

Thank you for the information.

Previously the bitbucket had no support of embedding the google analytics scripts, so I have 

been reluctant to use it, but now it has this feature.

OK. I would like to use the wiki page to maintain the information of sqlite-jdbc.

https://bitbucket.org/xerial/sqlite-jdbc/wiki

Could you change the landing page for https://bitbucket.org/xerial/sqlite-jdbc/ to point to the wiki.

The setting for this is under Administration > Repository Details. Select "wiki" for the Landing Page drop down.

[grace]

On Tuesday, January 15, 2013 7:46:44 AM UTC-5, Peter wrote:

Cool! Great first step. Couple suggestions:

... 

(4) Some of the hyperlinks don't look right. I think its a wiki, formatting difference between trac and github. For example, on the new site I see text like "[http://maven.apache.org Maven]".

I will take care of fixing the format this weekend.

[Taro L. Saito]

I changed the landing page of https://bitbucket.org/xerial/sqlite-jdbc to the wiki page:

My suggestion is:

The new wiki page should add usage examples shown in 

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC#Usage

I can add a redirection setting pointing to the bitbucket page. 

I am looking forward to wiki updates by Grace. 

Many thanks.

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

--
You received this message because you are subscribed to the Google Groups "Xerial" group.

To view this discussion on the web visit https://groups.google.com/d/msg/xerial/-/UIWUHhBBUy4J.

[Peter Borissow]

Maybe the "Overview" page should include the first couple paragraphs you currently have in the "Wiki" page (SQLite JDBC Driver, What is different from Zentus's SQLite JDBC?, etc). Leave the wiki for wiki things like build instructions, usage example, etc. Just a thought...

Peter

---

From: Taro L. Saito <l...@xerial.org>
To: xer...@googlegroups.com
Sent: Tuesday, January 15, 2013 8:51 AM
Subject: Re: [xerial 602] Xerial.org Website

[grace]

On Tuesday, January 15, 2013 8:51:21 AM UTC-5, Taro L. Saito wrote:

I changed the landing page of https://bitbucket.org/xerial/sqlite-jdbc to the wiki page:

My suggestion is:

The new wiki page should add usage examples shown in 

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC#Usage

I can add a redirection setting pointing to the bitbucket page. 

I am looking forward to wiki updates by Grace. 

I have cleaned up the formatting of links and content.

Also added the usage examples from the old wiki.

Feedback is welcome.

[grace]

On Tuesday, January 15, 2013 9:23:05 AM UTC-5, Peter wrote:

Maybe the "Overview" page should include the first couple paragraphs you currently have in the "Wiki" page (SQLite JDBC Driver, What is different from Zentus's SQLite JDBC?, etc). Leave the wiki for wiki things like build instructions, usage example, etc. Just a thought...

Umm... this could work. 

Though, the "Overview" page is tied to the README file in the repo. I am thinking this makes it more suited for source code related issues like build instructions.

 

 

Peter

[Peter Borissow]

Thanks Grace. Downloads section points to a dead link. Can we move the all binaries from the old site to the new one?

---

From: grace <grace.b...@gmail.com>
To: xer...@googlegroups.com
Sent: Monday, January 21, 2013 10:14 AM
Subject: Re: [xerial 614] Xerial.org Website

On Tuesday, January 15, 2013 8:51:21 AM UTC-5, Taro L. Saito wrote:

I changed the landing page of https://bitbucket.org/ xerial/sqlite-jdbc to the wiki page:

My suggestion is:

The new wiki page should add usage examples shown in 

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC#Usage

I can add a redirection setting pointing to the bitbucket page. 

I am looking forward to wiki updates by Grace. 

[Peter Borissow]

I don't know much about bitbucket. I glanced at some of the "featured" projects and some of the projects have an Overview section that include much more that build instructions. Here are a few examples:

https://bitbucket.org/mchaput/whoosh/overview

https://bitbucket.org/thomaswaldmann/moin-2.0

https://bitbucket.org/rude/love

---

From: grace <grace.b...@gmail.com>
To: xer...@googlegroups.com

Cc: Peter Borissow <peter.b...@yahoo.com>
Sent: Monday, January 21, 2013 10:16 AM

Subject: Re: [xerial 602] Xerial.org Website

[grace]

On Monday, January 21, 2013 11:04:46 AM UTC-5, Peter wrote:

I don't know much about bitbucket. I glanced at some of the "featured" projects and some of the projects have an Overview section that include much more that build instructions. Here are a few examples:

https://bitbucket.org/mchaput/whoosh/overview

https://bitbucket.org/thomaswaldmann/moin-2.0

https://bitbucket.org/rude/love

I guess  you are right, Overview does seem like a good place to have information about the project. 

[Taro L. Saito]

I am now collecting usage examples in a wiki page:

https://bitbucket.org/xerial/sqlite-jdbc/wiki/Usage

I agree with Peter. The overview page should have the general information of the project and 

the current build instruction in README.md shold be moved to something like BUILD.md.

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

--

You received this message because you are subscribed to the Google Groups "Xerial" group.

To view this discussion on the web visit https://groups.google.com/d/msg/xerial/-/sTZGDfkTptoJ.

[grace]

On Monday, January 21, 2013 9:02:43 PM UTC-5, Taro L. Saito wrote:

I am now collecting usage examples in a wiki page:

https://bitbucket.org/xerial/sqlite-jdbc/wiki/Usage

I agree with Peter. The overview page should have the general information of the project and 

the current build instruction in README.md shold be moved to something like BUILD.md.

That settles it, I will add this to my backlog.

[grace]

Moved general information into READE.md 

Moved build instructions to README_BUILD.md.

Taro,

Please configure the repository to use "overview" as the landing page.

Thanks.

 

[Taro L. Saito]

Great,

Now the top page becomes the "overview" page.

I noticed we should fix some links. #Usage etc.

I am going to add a redirection setting from www.xerial.org to the bitbucket page.

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

 

--

You received this message because you are subscribed to the Google Groups "Xerial" group.

To view this discussion on the web visit https://groups.google.com/d/msg/xerial/-/GHNFAOlSEDgJ.

[Taro L. Saito]

I added a redirection setting from 

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC

to the bitbucket page. 

Thanks.

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

[Peter Borissow]

Thanks Taro-

    Only issue I see is that the downloads section in the bitbucket site only includes the latest snapshot. I suggest moving some of the other "stable" releases over.

Thanks Again,

Peter

---

From: Taro L. Saito <l...@xerial.org>
To: xer...@googlegroups.com

Sent: Monday, January 21, 2013 11:24 PM
Subject: Re: [xerial 628] Xerial.org Website

[grace]

On Monday, January 21, 2013 11:08:34 PM UTC-5, Taro L. Saito wrote:

Great,

Now the top page becomes the "overview" page.

I noticed we should fix some links. #Usage etc.

Fixed the usage link and moved the links to the top before Sample.java 

[Taro L. Saito]

I added an old release 3.7.2 to the new download page and 

a link to the other old releases in the overview page.

--
Taro L. Saito
<l...@xerial.org>
University of Tokyo
http://www.xerial.org/leo
Tel. +81-47-136-4065 (64065)

--
You received this message because you are subscribed to the Google Groups "Xerial" group.