hsqldb Questions
3
Solved
I'm working on a Spring Batch application that needs to execute jobs periodically. Here's a fragment of my configuration file that sets up the in-memory (hsqldb) database used for transaction handl...
Vantage asked 10/7, 2014 at 23:10
1
I have this class:
@AllArgsConstructor
@NoArgsConstructor
@Entity
@Table(name = "SECURITY_AUTHORITIES")
public class SecurityAuthority implements GrantedAuthority {
@Serial
private sta...
Existential asked 30/3 at 6:39
22
I am trying to use hsqldb-2.3.4 to connect from Spring applicastion.
I created data base using the following details
Type : HSQL Database Engine Standalone
Driver: org.hsqldb.jdbcDriver
URL: jdbc...
Maymaya asked 16/7, 2016 at 21:19
7
Solved
I am not too familiar with database triggers and/or views. I am currently using PostgreSQL and HSQL, even though the database is not too important. I am just wondering if any database offers someth...
Kimkimball asked 16/1, 2009 at 16:45
10
Solved
I was trying to connect to a hsql db. I created one by running from C:\myhsql:
java -cp .;C:\hsql\lib\hsqldb.jar org.hsqldb.Server -database.0 file:db\mydb -dbname.0 MYDB
This created mydb in a ...
Muckraker asked 19/10, 2010 at 13:3
3
Solved
I am trying to connect to a hsqldb (using version 2.2.9).
I created one using the following:
java -cp hsqldb-2.2.9.jar org/hsqldb/util/DatabaseManagerSwing
When trying to connect to the db thru...
6
Solved
I want to sort according to date first and then if date is similar then according to id..How to do that in Informix/HSQL query?
5
Solved
I am using Hibernate + JPA as my ORM solution.
I am using HSQL for unit testing and PostgreSQL as the real database.
I want to be able to use Postgres's native UUID type with Hibernate, and use t...
Anjelicaanjou asked 17/6, 2009 at 13:52
8
Solved
I'm using Spring 3.1.1.RELEASE, Hibernate 4.1.0.Final, JPA 2, JUnit 4.8.1, and HSQL 2.2.7. I want to run some JUnit tests on my service methods, and after each test, I would like any data written t...
Barbarbarbara asked 15/1, 2013 at 18:0
3
Solved
How can I see the structure (details of the columns etc) of a table in HSQLDB? It is not "desc" like Oracle, so what?
Trilateration asked 15/8, 2011 at 20:28
5
Solved
I'm trying to save a nested object using hibernate and I receive could not execute statement; SQL [n/a] Exception
CODE
@Entity
@Table(name = "listing")
@Inheritance(strategy = InheritanceType.JOI...
3
Solved
I am looking for information how to check if a database exists -- from Java code -- in hsqldb and in Apache derby. In Mysql it is quite easy, because I can query a system table -- INFORMATION_SCHEM...
5
Solved
Can't seem to find a way to get one string from table using JdbcTemplate query.
This is the table my sql returns:
ID | STREET_NAME
------------------------
1 | Elm street
Now how am I supposed t...
Deventer asked 26/3, 2015 at 18:58
2
Solved
I have a table in an HSQL database which has an identity(integer) column. I'd like to support querying against the column using an arbitrary string(potentially non-numeric). However, the HSQL JDBC ...
8
Solved
We're using hdsqldb in memory to run junit tests which operate against a database. The db is setup before running each test via a spring configuration. All works fine.
Now when a tests fails it can...
Seibel asked 23/4, 2010 at 9:3
3
Solved
suppose i have a sequence, called TEST_SEQ
what would be the correct way of selecting its next value ?
this does not work:
select next value for TEST_SEQ
probably because it expects a "FROM" clau...
3
Solved
I don't want to use it in embedded mode as I may allow other external applications to access it as well. And I want to execute the startup of the server at the same time as Tomcat loads my applicat...
4
Solved
I have an embedded Hsqldb set up in my project. But it dumps a lot of info on the output when working, and I currently do not need that info:
Mar 29, 2012 10:18:11 PM org.hsqldb.persist.Logger log...
11
Solved
Is there a way to browse the content of an H2 or an HSQLDB in-memory database for viewing? For example, during a debugging session with Hibernate in order to check when the flush is executed; or to...
Were asked 5/9, 2011 at 14:20
3
Solved
In a Java project I'm working on I've got the following setup for our unit tests:
I'm using Spring Test MVC, @RunWith(SpringJUnit4ClassRunner.class) and @WebAppConfiguration to run the unit tests...
Accuracy asked 20/4, 2015 at 20:22
3
I have successfully created User Types with Postgres, and can read and write successfully.
@org.hibernate.annotations.Type(type = "com.xxx.datamodel.ext.FooType" )
@Column(name = "foo", nullable =...
6
Solved
I am trying to run some Hibernate/JPA examples using an in-memory HSQL DB. The error message I get is the following:
13:54:21,427 ERROR SchemaExport:425 - HHH000389: Unsuccessful: alter table Refe...
3
Solved
When using hsql for running test I'm getting this exception:
NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String; ZZ)Lorg/hsqldb/persist/HsqlProperties
I found this problem in a...
4
I have a table in an in-memory HSQLDB database for integration test, with an ARRAY column (categories VARCHAR(256) ARRAY NOT NULL), notice it's defined as VARCHAR array.
Is there a way to tweak th...
2
Solved
I want to test my program with an inmemory hsqldb. To create the table I use hibernate.hbm2ddl.auto=create
But I get an exception because the schemas, defined in the entity classes by annotations, ...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.