Member Avatar

Hey new to JDBC SQL DERBY and Java so I don't know why but my Jtable only shows the columns. Here are my codes for my LeaderboardDAO class. public class LeaderboardDAO extends Dao { private static final Logger LOG = LogManager.getLogger(PlayerDAO.class); public static final String TABLE_NAME = "leaderboard"; private static LeaderboardDAO leaderboardDao; private LeaderboardDAO() { super(TABLE_NAME); } public static LeaderboardDAO getLeaderboardDao() { if (leaderboardDao == null) { leaderboardDao = new LeaderboardDAO(); } return leaderboardDao; } @Override public void create() throws SQLException { LOG.debug("Creating database table " + TABLE_NAME); final String createStatement = "create table leaderboard(wins INTEGER(10), losses INTEGER(10), game_name VARCHAR(64), …

Member Avatar
+0 forum 4
Member Avatar

Hello guys, I created two database in derby: DB1 with one table Customers and its columns id,name,last And DB2 with one table Purchases anf its colums CustID, total I would like to makes queries from data in both of these database. I tried SELECT C.name, C.last, U.Total FROM DB1.Customers C INNER JOIN DB2.Purchases U ON C.id=U.CustID; Can anybody help me...

Member Avatar
+0 forum 1
Member Avatar

Dear Daniweb Members, First of all sorry my english writing. I installed JavaJDK 7u13 with NetBeans 7.2.1 and db-derby-10.5.3.0-bin.zip on a fresh OS. Then i set the environment variables according to their relative paths as seen below. By using ij the test database and the test table created, records inserted and displayed by using select. In command line and also in NetBeans IDE the HelloWorld console app run successfully. So far everything was fine. But when i try to make a connection inside NetBeans by using the code below i got the following exception. It prevents the application run correctly. …

Member Avatar
+0 forum 3
Member Avatar

I've got this exception after running my project Really don't know what to do! SQLException: No suitable driver found for jdbc:derby://localhost:1527 I've add derbyclient.jar to Library.but I didn't get any different result.I also don't want to create a new database. I wasn't able to attach it here but here are two links to download project files. source: http://bia2internet.com/dl/java/java.zip database: http://bia2internet.com/dl/java/db.zip

Member Avatar
+0 forum 4
Member Avatar

Let me tell you I already got the tutorial on how to do this [url]http://db.apache.org/derby/docs/10.3/adminguide/tadminconfig814963.html[/url] But sincerely speaking I did not understood how to do any of the two methods described. Let me tell you my confusions and what I didn't understood and I am developing my project in netbeans. 1) How to set up a properties file(I never worked with them, so really have no idea) and if not required then where to find this derby.properties file and exactly how to enter that string in it. 2) And how to make my java code to execute that propeties file …

Member Avatar
+0 forum 8
Member Avatar

Hi guys this is the first time ive posted to this forum, and ive tried getting my answer by asking others and google, but what i'm after is to complete an assignment that is asking me to complete a program that basically works as an ATM machine. it reads in a customer file and using that data it will determine what customer has what account. The assignment has to include inheritance and four classes so what i have posted below doesnt work but it has the four classes. Also the program must have basic ATM functionality like being able to …

Member Avatar
+0 forum 12
Member Avatar

Hello, I'm using NetBeans 6.7.1, and Derby 10.5.3.0. I'm trying to learn how to write Database applications, and I'm having trouble connecting to my Database. It loads the Derby Driver (EmbeddedDriver), but won't connect to the the Database named test. I looked at tests Properties in NetBeans, and it said that it was using the org.apache.jdbc.derby.ClientDriver. I did create the Database, and give it no username or password. Below is the code that I have. If anybody could help, that would be great =D [code] package jdb.test; import java.sql.*; public class DatabaseTest { public static void main(String[] args){ try{ // …

Member Avatar
+0 forum 7

The End.