SQL Power Software Forum

Any help with this would be greatly appreciated.

SQL Power Wabit 1.3.4
Copyright 2003-2010 SQL Power Group Inc.

Operating System:
Windows 7 6.1 (amd64)

Runtime Environment:
Java(TM) SE Runtime Environment
1.7.0_02-b13

VM info:
Java HotSpot(TM) 64-Bit Server VM
22.0-b10
Oracle Corporation

I connected to MS SQL 2008 R2

I dragged a table from the list under my connection to the query workspace and got this error:

java.lang.RuntimeException: ca.sqlpower.sqlobject.SQLObjectException: Failed to populate columns of tables
at ca.sqlpower.query.TableContainer.loadColumnsFromTable(TableContainer.java:171)
at ca.sqlpower.query.TableContainer.<init>(TableContainer.java:80)
at ca.sqlpower.swingui.querypen.QueryPen$QueryPenDropTargetListener.drop(QueryPen.java:222)
at java.awt.dnd.DropTarget.drop(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetEvent.dispatch(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.processDropTargetEvent(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.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(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)
Caused by: ca.sqlpower.sqlobject.SQLObjectException: Failed to populate columns of tables
at ca.sqlpower.sqlobject.SQLTable.populateAllColumns(SQLTable.java:442)
at ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:365)
at ca.sqlpower.sqlobject.SQLTable.getColumns(SQLTable.java:1566)
at ca.sqlpower.query.TableContainer.loadColumnsFromTable(TableContainer.java:153)
... 34 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from char to SMALLINT is unsupported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117)
at com.microsoft.sqlserver.jdbc.IntColumnIdentityFilter.apply(SQLServerDatabaseMetaData.java:2320)
at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:114)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1981)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1966)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(SQLServerResultSet.java:2255)
at ca.sqlpower.sql.jdbcwrapper.ResultSetDecorator.getObject(ResultSetDecorator.java:502)
at ca.sqlpower.sql.CachedRowSet.populate(CachedRowSet.java:255)
at ca.sqlpower.sql.CachedRowSet.populate(CachedRowSet.java:214)
at ca.sqlpower.sql.CachedRowSet.populate(CachedRowSet.java:202)
at ca.sqlpower.sql.jdbcwrapper.SQLServerDatabaseMetaDataDecorator.getColumns(SQLServerDatabaseMetaDataDecorator.java:56)
at ca.sqlpower.sql.jdbcwrapper.SQLServer2008DatabaseMetaDataDecorator.getColumns(SQLServer2008DatabaseMetaDataDecorator.java:87)
at ca.sqlpower.sqlobject.SQLColumn.fetchColumnsForTable(SQLColumn.java:481)
at ca.sqlpower.sqlobject.SQLTable.populateAllColumns(SQLTable.java:407)
... 37 more

Never mind.
Another quality microsoft product.
JDBC driver version 3 is broken.
version 4 (CTP3) works

The user default database is unavailable at the time of connection. It is possible that the database:

Is in suspect mode.
No longer exists.
Is in single user mode and the only available connection is already being used by someone else or by something else.
Has been detached.
Has been set to the RESTRICTED_USER state.
Is offline.
Is set to emergency status.
Does not have the login account mapped to a user or the user has been denied access.
Is part of a database mirror.

Additionally, the login account may be a member of multiple groups and the default database for one of those groups is unavailable at the time of connection