derby Questions

6

I tried to install hive on a raspberry pi 2. I installed Hive by uncompress zipped Hive package and configure $HADOOP_HOME and $HIVE_HOME manually under hduser user-group I created. When running hi...
Valedictory asked 26/2, 2016 at 15:14

8

Solved

When running spark-shell it creates a file derby.log and a folder metastore_db. How do I configure spark to put these somewhere else? For derby log I've tried Getting rid of derby.log like so spar...
Bael asked 14/7, 2016 at 14:40

2

Solved

I'm trying to allow users from a web front end to search for some attributes in a database. The attribute names may include the special SQL characters % and _ used in like. Is there a way to escape...
Nickelson asked 23/8, 2019 at 14:18

3

Solved

I have two tables in a derby database that I want to query together. Orders +----+--------+--------------+------------+ | ID | UserID | PurchaseDate | TotalPrice | +----+--------+--------------+--...
Tiga asked 3/5, 2012 at 10:30

6

Solved

I'd like to use SEQUENCE support in Apache Derby 10.7. I've created the sequence with the following statement: CREATE SEQUENCE SAMPLE_SEQ AS INT MAXVALUE 999999 CYCLE; How can I select next/curr...
Sergias asked 20/4, 2011 at 10:48

4

Solved

First, this is my first time with Apache Derby. I am using netbeans, willing to use embedded apache derby, and I followed the following tutorial for configuring and installing the database. Then, I...
Glacial asked 29/9, 2012 at 18:16

22

Solved

I have example web application Hibernate 4.3.5 + Derby database 10.10.1.1+ Glassfish4.0 with IDE NetBeans 8.0Beta. I have the next exception: Caused by: org.hibernate.hql.internal.ast.QuerySyntax...
Trakas asked 11/4, 2014 at 17:20

12

Solved

Why does it say null URL and gives a empty ' ' class in the exception when I have provided the database URL? I am trying to connect to a derby database via a servlet while using Tomcat. When the se...
Gillette asked 17/7, 2012 at 5:54

4

Solved

I would like to use Derby in a Network Server Mode and followed the instructions on their website. Starting derby: /opt/glassfish/4.0/javadb/bin/NetworkServerControl start -noSecurityManager Su...
Brass asked 13/4, 2014 at 22:13

3

I have problem with starting derby server. My derby version: db-derby-10.11.1.1 I followed this tutorial: http://db.apache.org/derby/papers/DerbyTut/ns_intro.html but after typing: startNetworkSe...
Jacquard asked 19/11, 2014 at 9:59

4

Solved

I have a class that looks something like this: @Entity public class EdgeInnovation { @Id public long id; @ManyToOne public NodeInnovation destination; @ManyToOne public NodeInnovation origin...
Atrophied asked 25/3, 2016 at 0:36

2

Solved

I deleted the ExampleDS from Wildfly.Now I can't deploy my app, because I got errors like this. Any tips? "WFLYCTL0412: Required services that are not installed:" => ["jboss.naming.context.java...
Spiritism asked 7/12, 2017 at 17:39

2

Solved

I used the statement below to create a Derby database table with auto-increment primary column. CREATE TABLE \"table\" (\n" + " \"id\" INTEGER NOT NULL GENERATED ALWA...
Shrimp asked 4/8, 2015 at 8:23

11

Solved

How do i delete all the tables in the schema on Apache Derby DB using JDBC?
Somaliland asked 5/10, 2008 at 9:1

2

Solved

Following this tutorial about Vaadin 7 and SQLContainer I encountered the following problem. I am coding inside Netbeans 8.0.2 and would like to use the embedded JavaDB/Derby database over JDBC in ...
Patroclus asked 9/11, 2015 at 16:32

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...
Legist asked 27/9, 2010 at 7:17

19

I get this error in Netbeans: java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/ How is this caused and how can I solve it?
Academician asked 28/9, 2010 at 18:46

2

Solved

UPDATE - July 2021: While the accepted answer using the dependency plugin was the best solution at the time, the answer from @ltlBeBoy leverages the 'copyDependencies' support since added to libert...
Subterranean asked 22/9, 2019 at 16:11

8

Solved

I have created a table in derby Netbeans and now i realize that i need to make a column as auto incremented by 1 which is a primary key. How can i do so? I tried the following code but was in vain....
Anglofrench asked 14/1, 2013 at 9:53

7

We are doing research right now on whether to switch our postgresql db to an embedded Derby db. Both would be using glassfish 3 for our data layer. Anybody have any opinions or knowledge that could...
Pietje asked 26/1, 2010 at 18:0

1

Solved

I have 3 sql tables customer, employee and manager. I want to access dynamically to my tables. I had a statement like this, "update customer set AMOUNT where ID= ?" But in this situation...
Alcaeus asked 2/1, 2021 at 20:56

11

I am trying to run SparkSQL : val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc) But the error i m getting is below: ... 125 more Caused by: java.sql.SQLException: Another insta...
Collectanea asked 25/12, 2015 at 18:56

3

I have seen following topics, but they doesn't post solution to my question: java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver JDBC Derby driver not found SQLException: No...

10

Solved

I am new to apache derby and I cant seem to make work CREATE TABLE IF NOT EXISTS table1 ... as can be achieved in MySql etc. I am getting a 'Syntax error: Encountered "NOT" at line 1, column 17...
Assessor asked 3/5, 2011 at 6:59

7

Solved

I'm trying to persist an object to a database. Keep getting 'Column ID cannot accept null value error'. My object looks like this: @Entity public class TestTable { @Id @GeneratedValue(strategy ...
Simonides asked 26/2, 2011 at 20:30

© 2022 - 2024 — McMap. All rights reserved.