SQL Power Business Intelligence Productivity Tools

SQL Power Software Forum

SQL Power Software Forum

  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
error when adding a table to a query  XML
Forum Index » SQL Power Wabit Support
Author Message
JohnS50


Joined: 2012-02-13 10:03:52
Messages: 2
Offline

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
JohnS50


Joined: 2012-02-13 10:03:52
Messages: 2
Offline

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


Joined: 2016-09-20 01:46:53
Messages: 4
Offline

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
[WWW]
 
Forum Index » SQL Power Wabit Support
Go to:   
Powered by JForum 2.1.8 © JForum Team