1. ArrayIndexOutOfBoundsException at CallableStatement.getClob() stackoverflow.comI'm using hsqldb 2.0-GA, both at the server and the client. I've defined the following procedure at the database: |
2. what does jdbc:hsqldb:hsqlTempFiles mean stackoverflow.comIn SimpleORM (a JAVA ORM library) examples, I see a code like: 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.comHi 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.comHi, 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.comWe'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.comHello, 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.comI'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.comhi 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.comHey 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.comHi 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.comhello. 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.comhello, 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. |
17. How to store chinese characters in hsqldb? coderanch.com |
18. hsqldb's sqltool coderanch.comhello, 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.comHi 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.comHi, I am using HSQLDB version=1.9.0 + Eclipse galileo + JPA + Eclipselink Here is the persistence properties |
22. HSQLDB - user lacks privilege or object not found coderanch.comprivate static final String SELECT_USERS = "SELECT user_seq_id, username, password " + "FROM users_tbl"; @Override public List |
23. HSQLDB arguments coderanch.com |
24. HSQLDB and group by coderanch.comPostgreSQL 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.comHi 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.comI 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.comI have an Hibernate application with the mapping: |
29. Configure HSQLDB in RedHatEnterpriseLinux 4 java-forums.org |
30. Hsqldb java-forums.orgHello, 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.orgHello, 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 |