This content has been marked as final. Show 18 replies
That didn't do it - I already have the database name defined in my Connection String.
For configuring SQL Server with JDeveloper please refer
Those are the steps I go through - and everything goes smoothly.
I am having my problem when I get to Figure 16. I expand the dropdown for that connection. It shows me the list of schemas. I open a schema and it shows me the Tables and Views directories. When I try to expand the Tables directory - no tables are displayed.
I know they are there - because I am able to query them using the connection I set up (using SQL Worksheet).
I am experiencing the same issue, is it possible this is a bug in JDev?
I have the same problem in mysql 5.x with JDeveloper 10.1.3.3. I get the database connection test successful..but tables doe not show up when i navigate to the tables under Database Coonection.
Did anyone figure out how to address this?
May be bug with JDeveloper ??
Hmm, I have exactly the same problem. Has anyone cracked this yet? I have a SQL Server admin guy trying some things at that end as well - will let y'all know if we come up with anything.
We can get the list working on 1 SQL Server database but not another.
Not sure if this has anything to do with it, but on the one that works the user we are connecting as, was the original creator of the database, and is a member of the db_owner group (in SQL server). Whereas on the one that's not working the user is a member of the db_owner group but is not the original creator of the database (i.e it has been subsequently added to the db_owner group). We don't know which user was the original creator.
Interestingly, there's a diagnostic console in SQL Server that shows the queries JDev is sending through to get the table list. It's calling a stored procedure. When you run that query at the console it runs ok and returns the list.
We're just trying some more things so we'll let y'all know how we get on.
Message was edited by:
Hot off the press. Turns out the user doesn't make a difference as mentioned above. We just created a new user in the database that's working (see my above posts) and added it to the db_owner group and it also worked.
But - the plot thickens... The database where the list works was created from scratch as a SQL Server 2005 database, whereas the one that's not working was migrated from SQL Server 2000 into 2005. Apparently SQL Server 2000 did not have the concept of schemas. Again, I don't know if this has anything to do with this problem...
I now suspect this is a permissions issue in SQL Server...
ok forget that - we've solved it. You wouldn't believe it, the connection url string appears to be case-sensitive, especially in regards the database name. Doh!
I've the same problem. I've created a Database Connection to Sql Server 2005 Express and I can see the tables in Database Navigator and I can do sql queries too. But, when I go to create
Business Tier - EJB - Entities from tables following the next steps in the Wizard:
Step 2 of 8. Persistence Unit: Model (value by default)
Step 3 of 8. I select Online Database Connection
Step 4 of 8. I've selected the database connection I've created earlier
Step 5 of 8. I select dbo Schema and I press Query button but any table is displayed in Available multi-line text box
I'm trying jDeveloper 18.104.22.168.0 and the connection user is "sa"
Can you help me?
Thanks in advance
I don't know why but if you choose "EJB 2.1 -- EJB Entity Beans" from "Create Entities from Tables", the list of tables, views or synomyms is displayed in Available item
When you choose "EJB 3.0 -- JPA Entities" any table, view or synonym is displayed
Has anyone found a consistent answer to what might be causing this?
I am experiencing the same issue trying to create ADF Business Components against a SQL Server 2005 database. The JDBC connection string is fine, as I can access the database in the Database Navigator and run queries against the tables.
However, the tables don't appear in the Tables folder of the dbo schema when looking in the Connections section of the Application Resources item - also the table names never appear in step 1 of the Create Business Components from Tables wizard. I have tried using a SQL Server 2005 database that was a SQL 2000 conversion and one that was a native 2005 database and I get the same results - I am using JDeveloper 22.214.171.124.0 on XP SP2 and with SQL Server 2005 Developer Edition.
I am trying to evaluate ADF against a C# tool for a major project. If I can't get this to work, I am going to have to recommend Microsoft on the basis that I can't get JDeveloper to work "out-of-the-box".