java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/ This exception has two causes: The driver is not loaded. The JDBC URL is malformed. In your case, I’d expect to see a database name at the end of the connection string. For example (use create=true if you want the database to be created if it doesn’t exist): … Read more
You don’t need to. The primary key is already an index.
I was getting the same error while creating Data frames on Spark Shell : Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /metastore_db. Cause: I found that this is happening as there were multiple other instances of Spark-Shell already running and holding derby DB already, so when i was … Read more
You need a ResourceLink in your META-INF/context.xml file to make the global resource available to the web application. <ResourceLink name=”jdbc/mydb” global=”jdbc/mydb” type=”javax.sql.DataSource” />
After installing hive, if the first thing you did was run hive, hive attempted to create/initialize the metastore_db, but apparently might not get it right. On that initial run, maybe you saw your error: Exception in thread “main” java.lang.RuntimeException: Hive metastore database is not initialized. Please use schematool (e.g. ./schematool -initSchema -dbType …) to create … Read more
This is what I did: Find out exactly where the java home is by executing this instruction from NetBeans 7.4 : System.out.println(System.getProperty(“java.home”)); This is the output for my case: C:\Program Files\Java\jdk1.7.0_51\jre which is quite important for me, I was modifying another java.policy and took no effect and wasted me a couple of hours. For reason … Read more
I can’t see anything obviously wrong, but perhaps a different approach might help you debug it? You could try specify your datasource in the per-application-context instead of the global tomcat one. You can do this by creating a src/main/webapp/META-INF/context.xml (I’m assuming you’re using the standard maven directory structure – if not, then the META-INF folder … Read more
Finally I found a mistake! Hope this is useful to someone. When doing a request to the database(in my case it Apache Derby), name of base need write the first letter upper case other in lower case. This is wrong query: session.createQuery(“select first_name from CUSTOMERV”). This is valid query session.createQuery(“select first_name from Customerv”). And class … Read more