You cannot post messages because only members can post, and you are not currently a member.
Description:
Discussions related to Xerial (XML DBMS) and other derivative projects.
|
|
|
runtime exceptions
|
| |
Hi I have the following code: ... rs = stmt.executeQuery(selectQuery) ; boolean isClosed = rs.isClosed(); ... and using both sqlite-jdbc-3.7.6.3-20110609.0 81603-3.jar and sqlite-jdbc-3.7.15-SNAPSHOT-2. jar get the following exception thrown at the call to ResultSet.isClosed():... more »
|
|
|
DatabaseMetaData.getTables() Memory Leak?
|
| |
Taro/Grace- I found a pretty significant memory leak when calling this routine: java.sql.DatabaseMetaData dbmd = conn.getMetaData(); java.sql.ResultSet rs = dbmd.getTables(null,null,null, new String[]{"TABLE"}); rs.close();... more »
|
|
|
comparing two byte arrays
|
| |
Hi When comparing two byte arrays [of type BLOB] is the correct method as follows: "CREATE TABLE BytesTable(id INTEGER PRIMARY KEY NOT NULL, bytes BLOB)"; ... byte[] byteArray; ... String query = "select * from BytesTable where bytes==byteArray"; Thanks Graham
|
|
|
Trying to create new database on connection
|
| |
I am trying to create a database in an embedded java program with the following code: String dbName = "testdb"; String driver = "org.sqlite.JDBC"; String connectString = "jdbc:sqlite::memory:" (i have also tried "jdbc:sqlite:") try { Class.forName(driver);... more »
|
|
|
Parsing out multiple sqlite queries
|
| |
Hi there, Ideally, I'd like to use Xerials' jdbc-sqlite to run queries like "SELECT 1; SELECT 2"; i.e., running multiple queries in one go. JDBC doesn't tend to allow this, so the trick is to parse out the SQL. Does anyone have here have any recommendations on solutions that do that, using sqlite's parser?... more »
|
|
|
using sqlite native library from OS/environment
|
| |
Hello, I was wondering if it is possible to *not* use the bundled sqlite native library but instead use an external library (i.e. the one coming with the linux distro)? I have also another question. I will be using the database as a local cache store so schema would be very simplistic. Ease of configuration is a major... more »
|
|
|
snappy-java-1.1.0-M1 release
|
| |
Hi, I released a new version of snappy-java-1.1.0-M1: [link] This version is already available in the Maven central repository. This update slightly improves the compression performance. For details see: [link]... more »
|
|
|
Understanding basic functionality
|
| |
Hi everyone, I'm relatively new to this technology and before I dive in using it to create my first Java program I am wondering if it is capable of the following: I have a java program that uses a database and constantly updates a Highscores.db file. Instead of adjusting the current java program code - i'd like to rather... more »
|
|
|
