-
Bug
-
Resolution: Fixed
-
P2
-
7u21
-
JDK7u21
Issue | Fix Version | Assignee | Priority | Status | Resolution | Resolved In Build |
---|---|---|---|---|---|---|
JDK-8132188 | 7u40 | Debra Masada | P2 | Closed | Fixed |
First, I got the following error when trying to run DataAppLoader:
Failed to execute: INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL)
/Users/Steven/Documents/javafx-samples-2.2.21/src/DataApp/DataAppLoader/build.xml:84:
java.sql.SQLException: Column count doesn't match value count at row 1
The following one-line patch for build.xml fixes this:
--- <html>build.xml (<b>Today 12:33:42 PM</b>)</html>
+++ <html><b>Current File</b></html>
@@ -84,7 +84,7 @@
>
DELETE FROM user WHERE User = 'dataapp';
DELETE FROM db WHERE User = 'dataapp';
- INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL);
+ INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL,'N');
INSERT INTO db VALUES ('localhost','APP','dataapp','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y');
DROP DATABASE IF EXISTS APP;
CREATE DATABASE APP;
Then, I could not deploy DataAppServer because the EJB Timer Service wasn't available. The steps described here fixed this: http://stackoverflow.com/questions/13292473/set-configure-the-ejb-timer-services-datasource. In my case, "your JDBC Resource" was jdbc/dataapp
Failed to execute: INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL)
/Users/Steven/Documents/javafx-samples-2.2.21/src/DataApp/DataAppLoader/build.xml:84:
java.sql.SQLException: Column count doesn't match value count at row 1
The following one-line patch for build.xml fixes this:
--- <html>build.xml (<b>Today 12:33:42 PM</b>)</html>
+++ <html><b>Current File</b></html>
@@ -84,7 +84,7 @@
>
DELETE FROM user WHERE User = 'dataapp';
DELETE FROM db WHERE User = 'dataapp';
- INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL);
+ INSERT INTO user VALUES ('localhost','dataapp','*B974A83D18BB105D0C9186756F485406E6E6039B','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL,'N');
INSERT INTO db VALUES ('localhost','APP','dataapp','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','Y');
DROP DATABASE IF EXISTS APP;
CREATE DATABASE APP;
Then, I could not deploy DataAppServer because the EJB Timer Service wasn't available. The steps described here fixed this: http://stackoverflow.com/questions/13292473/set-configure-the-ejb-timer-services-datasource. In my case, "your JDBC Resource" was jdbc/dataapp
- backported by
-
JDK-8132188 DataApp sample will not run
-
- Closed
-
- duplicates
-
JDK-8119492 DataApp mysql script doesn't work with latest mysql
-
- Closed
-
- relates to
-
JDK-8124546 DataApp: DataAppLoader not runnable
-
- Closed
-