jdbc « hsqldb « Java Database Q&A





1. ArrayIndexOutOfBoundsException at CallableStatement.getClob()    stackoverflow.com

I'm using hsqldb 2.0-GA, both at the server and the client. I've defined the following procedure at the database:

create procedure BR1.PROC_A(out p1 clob, out p2 int) 
READS SQL DATA BEGIN ...

2. what does jdbc:hsqldb:hsqlTempFiles mean    stackoverflow.com

In SimpleORM (a JAVA ORM library) examples, I see a code like:

java.sql.DriverManager.getConnection("jdbc:hsqldb:hsqlTempFiles;shutdown=true;", "sa", "")
I am not able to understand the meaning of hsqlTempFiles in above. My basic understanding of ...

3. hsqldb vs access    coderanch.com

4. HSQLDB database server    coderanch.com

5. HSQLDB - Java Database Engine    coderanch.com

Hi Joe, Thanks for the reply. But as I told you in my earlier post, this is my first app and dont know much about hsqldb, so just typed in the code as is from the sample in Notepad and compiled as I dont have any IDE for java at my work but I shall go home and try it in ...

6. Mckoi vs HSQLDB    coderanch.com

7. JDBC - HSQLDB problem...    coderanch.com

8. hsqldb and jenny the db code generator    coderanch.com

Hi, When I run my code using jenny I get the following exception: java.sql.SQLException: Connection is broken: Software caused connection abort: socket write error at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source) at org.hsqldb.jdbcConnection.executeHSQL(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcConnection.close(Unknown Source) at com.javaranch.db.DBFacade.search(DBFacade.java:370) at com.javaranch.db.DBFacade.search(DBFacade.java:393) at com.javaranch.db.TableFacade.search(TableFacade.java:61) at src.testdb.SampleTable$Implementation.getRow(SampleTable.java:145) at src.testdb.SampleTable.getRow(SampleTable.java:439) at src.testdb.testdb.main(testdb.java:138) Exception in thread "main" I am using J2SE v1.4.2-b28 and ...

9. HSQLDB users take note    coderanch.com

We're using it in the automated integration tests for the Spring/Hibernate/Oracle project we've been working on for the last nine months. Can't say anything about its behaviour in a production situation, but it is happy enough to handle the sometimes hefty SQL statements Hibernate throws at it during the tests. - Peter





10. Performance: HSQLDB specifiс and common issues    coderanch.com

Hello, I'm designing an application right now. It is a system used to collect statistics from 10-1000 agent PCs and provide some web-access to it. I've decided to use in-process HSQLDB as persistent storage. What i see from some research: 1)Every agent will write some small amount of data (say, 256 bytes) to my server every 10 seconds via XML-RPC. The ...

11. HSQLDB whats the proper way to escape stuff?    coderanch.com

I'm getting the following error: java.sql.SQLException: Unexpected token: S in statement [s] I'm 90% sure its a problem with an apostrophe (I'm trying to put some fairly large blocks of text into the database). I have function to escape single quotes: static public String in(String s) { if (s==null) // Depending on context, you might really want "is null" return "''"; ...

12. how to create a database instance in HSQLDB    coderanch.com

hi all, I have two applications (J2EE applications) running on JBoss 4.0 and Hsqldb as the database. The problem is , im having a table UserInfo(say) for each of the application. ( but ofcourse the column values are different). and the requirement is that i have to deploy both the applications on the same Jboss. So i need to create two ...

13. hsqldb - how to create db?    coderanch.com

Hey all! I'm new to JDBC so bear with me, I'm not quite sure what I'm doing. I've gotten as far as to find and download a dmbs (I'm using hsqldb) and now I've no idea how to actually go about creating a database and creating tables, entering data, etc. I've been searching for help but many resources assume that you've ...

14. hsqldb    coderanch.com

Hi Guys : I tried porting mysql to hsqldb and found it virtually impossible. I also find the hsqldb has the worst documentation of any major database product that Ive come across .... for example, there is no hello world tutorial. I was quite dissapointed because I thought a standalone java database would be easy to install. I even found that ...

15. Concurrency Issue with HSQLDB    coderanch.com

hello. I am using IDENTITY to auto-generate my ID in one of my tables and using CALL IDENTITY() to get back the newly created ID. However, as I am doing this over a network. I noticed that my JDBC code executes CALL INDENTITY() before my INSERT INTO ... statement is completed and thus returning the the incorrect ID. when I put ...

16. sqlexception with hsqldb-please help    coderanch.com

hello, Thanks for your reply. I have created a table demo with 2 columns id,item and there is one record.If I execute the same query in hsqldb analyser, it is showing the record. but I dont understand why not thru this jdbc code...Is there anything else I should do? thanks & regards, nivas.





18. hsqldb's sqltool    coderanch.com

hello, i'm attempting to use windows batch files to run sql scripts against hsqldb database. I would like to use a RC file for authentication. I've placed the sqltool.rc file in the same path as hsqldb.jar to use hsqldb's import/export utility. I've successfully used inline authentication to execute sql scripts using essentially the same methods. Here's a sample of I've done: ...

19. Timing Issues Error/normal HSQLDB/ Java doubt    coderanch.com

Hi Well I am a bit confused if its a hsqldb question or java question but still if some one can answer; here it goes: Test run approx gave me the time to run second query each time (code: read_2 string - for table2) is some Milli seconds. Isnt it too much time Full run: Time approx: 5 days (estimate based ...

20. HSQLDB and TO_DATE    coderanch.com

21. HSQLDB properties file    coderanch.com

Hi, I am using HSQLDB version=1.9.0 + Eclipse galileo + JPA + Eclipselink Here is the persistence properties The problem is, each time the test.script, ...

22. HSQLDB - user lacks privilege or object not found    coderanch.com

private static final String SELECT_USERS = "SELECT user_seq_id, username, password " + "FROM users_tbl"; @Override public List findUsers() { List userList = null; if (jdbcTemplate.getDataSource() != null){ userList = jdbcTemplate.query(SELECT_USERS, new UserDTORowMapper() ); } //if null, return an empty list if (userList == null){ userList = new ArrayList(0); } return userList; } public static final class UserDTORowMapper implements RowMapper{ @Override public ...

23. HSQLDB arguments    coderanch.com

24. HSQLDB and group by    coderanch.com

PostgreSQL also does not accept such "loose" syntax. I am, in fact, surprised at the way MySQL implemented this. If you don't aggregate over a column which you don't group by, which value do you want/expect? MySQL, it seems, just returns the first value encountered, or a random value in the set perhaps? Either way it's a little misleading. Here is ...

25. Identity function in HSQLDB    coderanch.com

Hi All, I am using HSQLDB for my application. I have already created a table with a primary key. Now i want to modify it and want to make the primary key column also an Auto incrementing one. I saw in HSQLDB it can be achieved by the IDENTIY() function. Could please some one please show me the correct SQL syntax ...

26. Trouble Using HSQLDB using myEclipse    coderanch.com

I have create a data base using Myeclipse database explorer, however I am not able to connect to that database. I am getting the following error, " 2010-06-27T21:39:58.250+0530 SEVERE could not reopen database org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@8e64f300[file =null, exists=false, locked=false, valid=false, ] method: setPath reason: java.io.IOException: The filename, directory name, or volume label syntax is incorrect at org.hsqldb.error.Error.error(Unknown ...

27. jdbc functions not working for HSQLDB    coderanch.com

28. Not in aggregate function or group by clause - HSQLDB doesn't like the ORDER BY clause    coderanch.com

I have an Hibernate application with the mapping: I get an exception in HSQLDB only and not in MySQL. Here is the exception: Caused by: java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@4c8167 in statement [select count(*) as y0_ from admin this_ order ...

30. Hsqldb    java-forums.org

Hello, For doing O/R mapping, I'm using for creating the tables "HSQLDB". I have started up HSQLDB GUI by typing: java -cp hsqldb.jar org.hsqldb.util.DatabaseManager And the settings as follows: Type: HSQL Database Engine Standalone URL: jdbc:hsqldb:../../hsqldb/hibernateDB And created two tables "A" and "B" On the other hand, I started the server using the following command: java -cp hsqldb.jar org.hsqldb.Server -database hibernateDB ...

31. Hsqldb    java-forums.org

Hello, For doing O/R mapping, I'm using for creating the tables "HSQLDB". I have started up HSQLDB GUI by typing: java -cp hsqldb.jar org.hsqldb.util.DatabaseManager And the settings as follows: Type: HSQL Database Engine Standalone URL: jdbc:hsqldb:../../hsqldb/hibernateDB And created two tables "A" and "B" On the other hand, I started the server using the following command: java -cp hsqldb.jar org.hsqldb.Server -database hibernateDB ...

32. HSQLDB problem    java-forums.org

...