Member Avatar for de.ICeman

I want to create a Entity class with database in Netbeans.

When i select a Data source jdbc/Ionbank (custom Jdbc connection Using JDBC-ODBC bridge with Ms SQL 2005 as database).

I see all the table from that database.
All tables show no primary key, but they have primary keys in them.

I am trying to find out what is problem.

Thing i tried :-
1. Created new 4-5 data source.
2. Created tables using query, and not the New table option.
3. Tried changing Odbc connection.
4. Tried using different drivers for the Jdbc-Odbc bridge like Sql4jdbc.jar, Jdts.jar.


Still No luck. Plz help
I have Attached PrintScreen Image of this No primary key tables.

No_primary_key.png 296.14 KB
  • 2 Contributors
  • 1 Reply
  • 368 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by StephNicolaou
Member Avatar for StephNicolaou

Actually go/log into the database to see if primary keys are set, show that print screen. When you wrote your queries, you included 'int not null' and primary key(whatever) lines (?).

If then Netbeans is still not showing the primary keys, I would code the database link as it must be the Netbeans settings playing up. I haven't heard about Ionbank so try selecting other data sources to check whether it's happening for each type.

JDBC connection setup
http://www.mkyong.com/jdbc/how-to-connect-to-mysql-with-jdbc-driver-java/

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.