FAQ
Frequently Asked Questions
Last updated
Was this helpful?
Frequently Asked Questions
Last updated
Was this helpful?
YES!
It's free to use and distributed, and the source code is included. See also license.
No, currently commercial support is not available.
By default, a new database is automatically created if it does not yet exist when the embedded URL is used.
The database driver is org.guinsoo.Driver, and the database URL starts with jdbc:guinsoo:. To connect to a database using JDBC, use the following code:
When using database URLs like jdbc:guinsoo:~/tset, the database is stored in the user directory.
See Guinsoo Limits and Limitations.
Slow SELECT (or DELETE, UPDATE, MERGE) statement can have multiple reasons. Follow this checklist:
Run ANALYZE (see documentation for details)
Run the query with EXPLAIN and check if indexes are used
If required, create additional indexes and try again using ANALYZE and EXPLAIN
If it doesn't help please report the problem.
For a table defined as CREATE TABLE TSET(X FLOAT) the method ResultSet.getObject() returns a java.lang.Double, I expect it to return a java.lang.Float. What's wrong?
Use REAL or FLOAT(24) data type for java.lang.Float values.
This is not a bug. According to the JDBC specification, the JDBC data type FLOAT is equivalent to DOUBLE, and both are mapped to java.lang.Double. See also .