#322 SQL Scripts plugin fails to create table script for Axion DB

2.1rc2
closed-fixed
Rob Manning
5
2005-12-11
2005-12-09
Rob Manning
No

Create a table in Axion:

create table test ( bigint_column numeric(38,0) );

right-click on test in the object tree, and select
"Create table script".

You'll see the following error:

Error: getPrimaryKeys() is not supported
SQLState: null
ErrorCode: 0

The stack trace is:

java.sql.SQLException: getPrimaryKeys() is not supported
at
org.axiondb.jdbc.AxionDatabaseMetaData.getPrimaryKeys(AxionDatabaseMetaData.java:906)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getPrimaryKey(SQLDatabaseMetaData.java:1595)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateTableScriptCommand.createTableScriptString(CreateTableScriptCommand.java:128)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateTableScriptCommand.scriptTablesToSQLEntryArea(CreateTableScriptCommand.java:78)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateTableScriptCommand.execute(CreateTableScriptCommand.java:72)
at
net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateTableScriptAction.actionPerformed(CreateTableScriptAction.java:50)
at
javax.swing.AbstractButton.fireActionPerformed(Unknown
Source)
at
javax.swing.AbstractButton$Handler.actionPerformed(Unknown
Source)
at
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown
Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown
Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown
Source)
at
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown
Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown
Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown
Source)
at
java.awt.LightweightDispatcher.processMouseEvent(Unknown
Source)
at
java.awt.LightweightDispatcher.dispatchEvent(Unknown
Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:172)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Granted, the primary key is important for the table
definition, but for drivers that don't support it, it
would still be nice to produce "a" table script even
when it isn't "the" exact table definition.

Discussion

  • Rob Manning
    Rob Manning
    2005-12-11

    • status: open --> closed
     
  • Rob Manning
    Rob Manning
    2005-12-11

    • status: closed --> closed-fixed