Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unrecognized JDBC URL

BAO.SZApr 8 2013 — edited Apr 8 2013
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.

Comments

hi user,

"add attribute from the newly altered table." instead of this you may try "synchnorizse the db changes" for eo. then continue.
BAO.SZ
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.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2013
Added on Apr 8 2013
2 comments
259 views