Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

auto increment with MySQL

hi, when creating a table in design view in the embedded datbase, it is straightforward to get a primary key that auto-increments. You fill in the key name, select integer (integer), and a yes/no box appears in the lower part of the screen for auto-increment.

The same does not seem to happen when attempting the same in MySQL, whether connected to a localhost database or over the internet. In both cases I am connecting using JDBC with the Oracle recommended connector.

I can create an auto incrmement field by connecting to the mysql database using the mysql client.

I am not clear if I am doing something wrong, forgetting something, or whether this is a gap in the Oracle JDBC class.

Any advice would be appreciated?

auto increment with MySQL

hi, when creating a table in design view in the embedded datbase, it is straightforward to get a primary key that auto-increments. You fill in the key name, select integer (integer), and a yes/no box appears in the lower part of the screen for auto-increment.

The same does not seem to happen when attempting the same in MySQL, whether connected to a localhost database or over the internet. In both cases I am connecting using JDBC with the Oracle recommended connector.

I can create an auto incrmement field by connecting to the mysql database using the mysql client.

I am not clear if I am doing something wrong, forgetting something, or whether this is a gap in the Oracle JDBC class.

Any advice =======

Edit 20th Aug: Additional detail

If I open a table created from the mysql cli that has an autofield, the <autofield> value shows on new records and this works normally and shows <autofield> in the relevant "cell", as your screenshot shows.

However, when I edit that table and select the row defining that field, the Autovalue drop down never appears.

If I copy & paste the table the copy loses the autovalue.

If Base offers to create a new PK for the copy table, the checkbox for AutoValue is greyed out.

My Base is version 5.2.7.2 and is using Oracle Java 1.8.0.181 so when I downloaded the connector it seemed sensible to use mysql-connector-java8.0.11.jar

When I instaled it, I did the "Test Class" and it seemed to load OK (but then I know it partly works...)

Do you recommend I change to the java.5.1 connector?

If so, should I also downgrade the Java runtime that was installed before I consciously did anything to choose a JRE?RE does your Base use?

And if so, how would I downgrade the runtime? I am worried that other things in my OS might depend on Java 8 if I do downgrade it...

ON the other side of the argument, there is something clunky going on here ... I can get Firebird, FlameRobin, and MySQL running ish, but none of them in a fully featured way.... the common factor seems to be appreciated?the JRE as the respctive connectors are different.

I did wonder if the difference was caused by using a local connection rather than the net, but I can't get AutoValue to work on a test/demo server running the latest MySQL version at db4free.net

In the meantime the work-around is to create those tables using the cli. For production work that is what I would do anyway; for prototyping I prefer to use a GUI to tweak things and test variations....

R~~

auto increment with MySQL

hi, when creating a table in design view in the embedded datbase, it is straightforward to get a primary key that auto-increments. You fill in the key name, select integer (integer), and a yes/no box appears in the lower part of the screen for auto-increment.

The same does not seem to happen when attempting the same in MySQL, whether connected to a localhost database or over the internet. In both cases I am connecting using JDBC with the Oracle recommended connector.

I can create an auto incrmement field by connecting to the mysql database using the mysql client.

I am not clear if I am doing something wrong, forgetting something, or whether this is a gap in the Oracle JDBC class.

=======

Edit 20th Aug: Additional detail

If I open a table created from the mysql cli that has an autofield, the <autofield> value shows on new records and this works normally and shows <autofield> in the relevant "cell", as your screenshot shows.

However, when I edit that table and select the row defining that field, the Autovalue drop down never appears.

If I make any change to that field, it loses its AutoField attribute.

If I copy & paste the table the copy loses the autovalue.

If Base offers to create a new PK for the copy table, the checkbox for AutoValue is greyed out.out. Altogether it seems clear that Base is not communicationg this fact to the underlying database.

My Base is version 5.2.7.2 and is using Oracle Java 1.8.0.181 so when I downloaded the connector it seemed sensible to use mysql-connector-java8.0.11.jar

When I instaled it, I did the "Test Class" and it seemed to load OK (but then I know it partly works...)

Do you recommend I change to the java.5.1 connector?

If so, should I also downgrade the Java runtime that was installed before I consciously did anything to choose a JRE?RE does your Base use?

And if so, how would I downgrade the runtime? I am worried that other things in my OS might depend on Java 8 if I do downgrade it...

ON the other side of the argument, there is something clunky going on here ... I can get Firebird, FlameRobin, and MySQL running ish, but none of them in a fully featured way.... the common factor seems to be the JRE as the respctive connectors are different.

I did wonder if the difference was caused by using a local connection rather than the net, but I can't get AutoValue to work on a test/demo server running the latest MySQL version at db4free.net

In the meantime the work-around is to create those tables using the cli. For production work that is what I would do anyway; for prototyping I prefer to use a GUI to tweak things and test variations....

R~~