|
|||||||
|
|
|
![]() |
|
|
Strumenti |
|
|
#1 |
|
Senior Member
Iscritto dal: Dec 2003
Città: Hamburg/Torino
Messaggi: 2757
|
[JAVA] Non si connette al database
Come da titolo. Quello che devo fare è questo:
First, you have to create an ANT build.xml file. Write two ANT tasks: One for starting the database server and another one for stopping it. Later in the course, you will use these ANT tasks to start and stop the database server for the web application. Your task is to write two SQL-scripts. One in order to create the database structure with its tables and relations. And another one which fills your newly created tables with test data. Create an ANT task for each SQL-script, which executes that script. Questo è il mio build.xml: Codice:
<?xml version="1.0" encoding="UTF-8"?>
<project name="FirstLab">
<path id="derby.classpath">
<fileset dir="lib">
<include name="**/*.jar" />
</fileset>
</path>
<target name="server_start">
<java classname="org.apache.derby.drda.NetworkServerControl" classpathref="derby.classpath" fork="true">
<arg value="start" />
</java>
</target>
<target name="server_stop">
<java classname="org.apache.derby.drda.NetworkServerControl" classpathref="derby.classpath" fork="true">
<arg value="shutdown" />
</java>
</target>
<target name="test">
<property name="DBURL" value="jdbc:derby:test" />
<property name="DRIVER" value="lib/org.apache.derby.jdbc.EmbeddedDriver" />
<property name="USERID" value="" />
<property name="PASSWORD" value="" />
<property name="USERS" value="users" />
<property name="IMAGES" value="images" />
<property name="COMMENTS" value="comments" />
<property name="FRIENDSHIP" value="friendship" />
<sql driver="${DRIVER}" url="${DBURL}" userid="${USERID}" password="${PASSWORD}" autocommit="yes" onerror="continue" caching="yes">
DROP TABLE USERS;
DROP TABLE IMAGES;
DROP TABLE COMMENTS;
DROP TABLE FRIENDSHIP;
CREATE TABLE USERS (userid int not null generated always as
identity (start with 1, increment by 1), username char(255) not null,
password char(255), firstname char(255) not null, lastname char(255) not null, city char(255),
country char(255), text char(255), birthdate DATE not null, photofilename char(255), UNIQUE (username) );
CREATE TABLE IMAGES (imageid int not null generated always as
identity (start with 1, increment by 1), userid int not null, filename char(255) not null, insertdate timestamp not null,
CONSTRAINT userid_fk FOREIGN KEY(userid) REFERENCES USERS(userid) ON DELETE CASCADE);
CREATE TABLE COMMENTS (commentid int not null generated always as
identity (start with 1, increment by 1) PRIMARY KEY, fromuserid int, touserid int,
insertdate TIMESTAMP, text char(255),
CONSTRAINT fromuserid_fk FOREIGN KEY (fromuserid) REFERENCES USERS(userid) ON DELETE CASCADE,
CONSTRAINT touserid_fk FOREIGN KEY (touserid) REFERENCES USERS(userid) ON DELETE CASCADE);
CREATE TABLE FRIENDSHIP (fromuserid int, touserid int, state int, CONSTRAINT
fromuserid_fk FOREIGN KEY (fromuserid) REFERENCES USERS(userid) ON DELETE CASCADE,
CONSTRAINT touserid_fk FOREIGN KEY (touserid) REFERENCES USERS(userid) ON DELETE CASCADE);
</sql>
</target>
</project>
Codice:
Buildfile: C:\Documents and Settings\elect\workspace\FirstLab\build.xml test: BUILD FAILED C:\Documents and Settings\elect\workspace\FirstLab\build.xml:31: Class Not Found: JDBC driver lib/org.apache.derby.jdbc.EmbeddedDriver could not be loaded Total time: 986 milliseconds Ho la strana sensazione che la soluzione sia molto semplice e veloce, ma non c'arrivo @.@, voi avete qualche idea? |
|
|
|
|
| Strumenti | |
|
|
Tutti gli orari sono GMT +1. Ora sono le: 15:27.



















