Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 442 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Unrecognized JDBC URL

BAO.SZ
Member Posts: 422
hi, all:
i'm working in jdev 11.1.2.3
i have created a simple adf app(one table for the moment) which works well only after i ALTER TABLE to add some columns.
1.edit EO to add attribute from the newly altered table.
--it's ok.
2.edit the VO (or even delete the old VO to create a new one) based on the refreshed EO, to include new attributes.
--in the QUERY tab for the VO, when press TEST AND EXPLAIN button, an error occured like this:
"Error encountered:java.sql.SQLException: Unrecognized JDBC URL
subtype: null"
--but connection to the db in jdev is ok.
3. if i ignore these alert and go on ,and run the jspx agian. errors in log file like this:
JBO-27021: java.sql.SQLException, .....
...
Caused by: java.sql.SQLException: invalid index ...
Can anyone give helps?
Thanks.
i'm working in jdev 11.1.2.3
i have created a simple adf app(one table for the moment) which works well only after i ALTER TABLE to add some columns.
1.edit EO to add attribute from the newly altered table.
--it's ok.
2.edit the VO (or even delete the old VO to create a new one) based on the refreshed EO, to include new attributes.
--in the QUERY tab for the VO, when press TEST AND EXPLAIN button, an error occured like this:
"Error encountered:java.sql.SQLException: Unrecognized JDBC URL
subtype: null"
--but connection to the db in jdev is ok.
3. if i ignore these alert and go on ,and run the jspx agian. errors in log file like this:
JBO-27021: java.sql.SQLException, .....
...
Caused by: java.sql.SQLException: invalid index ...
Can anyone give helps?
Thanks.
Answers
-
hi user,
"add attribute from the newly altered table." instead of this you may try "synchnorizse the db changes" for eo. then continue. -
I tried "synchnorizse the db changes" for EO, and related info:
i changed the data type id of the EO from varchar2 to DBSequence, and when sync the EO, restored to the string type.
but the problem remains.
any ideas?
Thanks.
This discussion has been closed.