Latest topics for the forum "SQL Power Wabit Support"

Performance using JDBC, OSX 10.7 and Oracle 11g

TL009 — GMT

I have Wabit Community Edition

- running on OSX 10.7 (Lion)
- using JDBC for Oracle (tried both ojdbc14 and ojdbc5)
- have Oracle 11g

The JDBC test connect is fine, the DB is found, the tables show ... so all the setup and connections seem ok.

However, whenever trying to add a table to the QueryPen it can take 30 minutes before it has updated. If I run an SQL instead, same problem to view results.

Can anyone give me a pointer as to why this would be and how to fix it ?

Thanks in advance

Oracle 8i JDBC connect issue

bitdoger — GMT

Oracle 8i connect does NOT correctly to linked tables...not matter what
ODJDBC.jar driver i use....I am able to correctly connect to my
oracle 8i database...but any use off foriegn key linked tables
does not show up on the sql edit tab and when i manually put it in
DOES NOT run the SQL stmt...running with the latest/greatest wabbit
under windows XP....thanx dave

Installation error

wshazlett — GMT

When running the installation for version 1.3.4 on Windows 7 Enterprise 64bit I get the following error at the installation directory step.

"This directory cannot be written! Please choose another directory!."

Any clues? I am an administrator on my machine.

"java.lang.RuntimeException: java.lang.NullPointerException" on copying query

trumaj — GMT

Hi,

When attempting to copy an existing query (any query), I get a the following error:

java.lang.RuntimeException: java.lang.NullPointerException
at ca.sqlpower.swingui.DataEntryPanelBuilder$2.actionPerformed(DataEntryPanelBuilder.java:160)
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.plaf.basic.BasicButtonListener.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.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$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: java.lang.NullPointerException
at ca.sqlpower.query.TableContainer.createCopy(TableContainer.java:268)
at ca.sqlpower.query.QueryImpl.(QueryImpl.java:424)
at ca.sqlpower.query.QueryImpl.(QueryImpl.java:408)
at ca.sqlpower.wabit.rs.query.QueryCache.(QueryCache.java:396)
at ca.sqlpower.wabit.swingui.action.CopyQueryAction.copy(CopyQueryAction.java:52)
at ca.sqlpower.wabit.swingui.action.CopyAction$1.applyChanges(CopyAction.java:57)
at ca.sqlpower.swingui.DataEntryPanelBuilder$8.call(DataEntryPanelBuilder.java:378)
at ca.sqlpower.swingui.DataEntryPanelBuilder$8.call(DataEntryPanelBuilder.java:375)
at ca.sqlpower.swingui.DataEntryPanelBuilder$2.actionPerformed(DataEntryPanelBuilder.java:155)
... 36 more

The SQL Power Wabit "About" screen, shows the following information:

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.6.0_24-b07

VM info:
Java HotSpot(TM) 64-Bit Server VM
19.1-b02
Sun Microsystems Inc.

Memory:
271MiB allocated (910MiB max); 208MiB free

Unable to connect to SQL Server 2005 - "Login failed for user" error

supremegood — GMT

Hello all. I am extremely new to this and so I apologize if I have missed something obvious. I have installed the SQL Power Wabit software and am trying to connect to a SQL Server 2005 instance but I am getting an error telling me the login failed for my user name. I am certain of the user name and password credentials so I am little lost as to what to do to get connected and start evaluating the software. Any help?

Thank you!

Not recognizing sqljdbc4.jar

dpedersen — GMT

I've installed wabit on my OS X Mac, downloaded the microsoft JDBC4.jar package, gone into the sql windows 2005 and added the jar, but still get the message "Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0."

I'm using a sql login (not windows authentication). I've looked in the pl.ini it reads:
JDBC JAR Count=1
JDBC JAR_0=file:/Applications/Utilities/sqljdbc_3.0/enu/sqljdbc4.jar

I'm assuming there is a step I'm missing, any and all help is appreciated.

Thanks,
Dylan

SQL or MySQL login failed

hakdur — GMT

I tried to connect SQL2008 server. But I received an error like this "login failed for user "hakanduran".I am sure the user information.

I also tried to a MySQL database, but I received another error message:"Access denied for user "administrator@172.27.125.29.
But I did not this ip address in hostname field. Why is wabit connecting to this ip address?

I downloaded the JDBC drivers for both of SQL2008 and mysql.
I installed and add to wabit.

Please help me, because I'm willing to try this product immediately.

Best regards.

Help with an error in SQL Power Wabit BI Tool

dhavalshrikhande — GMT

It gives me following error:

Exception type: java.lang.StringIndexOutOfBoundsException

Detail String: String Index out of range: 25978

I am using Windows 7 64 bit OS

Any comments will be helpful.

Outer Joins

sfrizzell — GMT

I can't seem to figure out how to have an Outer Join in the Query Pen. The default is an Inner Join and I can change that in the SQL view, but the changes are lost when switching back to the Query Pen.

So, is it possible to set the join type within the Query Pen?

Thanks.

Shawn

Unable to connect to SQL

bako — GMT

I am really excited to be able to use the Wabit SQL reporting but I am finding it impossible to connect to my SQL.

I have a .udl which is another type of connector (which works) and I was wondering if you can have a look at it and tell me what is the correct process to connect the JDBC

Here is the link to the udl file as I cannot attach anything to this message:
http://www.typos.com.cy/baret/fleet.zip

I am getting an "I/O error occured while receiving the TDS prelogin response."

Connection name: SQL reporting tool BK
Database type: SQL 2005
Connect options: what shall I put here? (host name SERVER\SQLEXPRESS as per .udl file
name of database: SATCOM as per .udl file
Port:1433 (?)

(I have downloaded the SQL JDBC drivers already from the MS site)
Name: SQL Server 2005
Driver Class:com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String Template: jdbc:sqlserver://:
Sample options: Blank
Port:1433
I add it and it seems to add them as intended to.

I would be grateful if you help me out.

Thank you

Baret Kouyoumdjian

multiple bugs

Tomislav — GMT

Hi,

I'm using PostgreSQL 8.4 on Ubuntu 10.4 and have just downloaded (the most recent) Wabit to give it a try. I've added a few JDBC connections, but multiple issues prevent me from getting anywhere with the tool.

I get the following exception when I try to join two tables manually (no FK defined):
[code]
java.awt.geom.IllegalPathStateException: missing initial moveto in path definition
at java.awt.geom.Path2D$Float.needRoom(Path2D.java:280)
at java.awt.geom.Path2D$Float.lineTo(Path2D.java:350)
at sun.java2d.pisces.PiscesRenderingEngine$1.lineTo(PiscesRenderingEngine.java:99)
at sun.java2d.pisces.Stroker.emitLineTo(Stroker.java:742)
at sun.java2d.pisces.Stroker.finish(Stroker.java:705)
at sun.java2d.pisces.Stroker.close(Stroker.java:592)
at sun.java2d.pisces.PiscesRenderingEngine.pathTo(PiscesRenderingEngine.java:315)
at sun.java2d.pisces.PiscesRenderingEngine.strokeTo(PiscesRenderingEngine.java:297)
at sun.java2d.pisces.PiscesRenderingEngine.createStrokedShape(PiscesRenderingEngine.java:85)
at java.awt.BasicStroke.createStrokedShape(BasicStroke.java:296)
at edu.umd.cs.piccolo.nodes.PPath.getPathBoundsWithStroke(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.updateBoundsFromPath(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.append(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.createEllipse(Unknown Source)
at ca.sqlpower.swingui.querypen.JoinLine.(JoinLine.java:328)
at ca.sqlpower.swingui.querypen.QueryPen$4.joinAdded(QueryPen.java:532)
at ca.sqlpower.wabit.rs.query.QueryCache$2.run(QueryCache.java:957)
at ca.sqlpower.wabit.swingui.WabitSwingSessionImpl.runInForeground(WabitSwingSessionImpl.java:762)
at ca.sqlpower.wabit.AbstractWabitObject.runInForeground(AbstractWabitObject.java:140)
at ca.sqlpower.wabit.rs.query.QueryCache.fireJoinAdded(QueryCache.java:953)
at ca.sqlpower.wabit.rs.query.QueryCache$1.joinAdded(QueryCache.java:146)
at ca.sqlpower.query.QueryImpl.fireJoinAdded(QueryImpl.java:1519)
at ca.sqlpower.query.QueryImpl.addJoin(QueryImpl.java:1154)
at ca.sqlpower.wabit.rs.query.QueryCache.addJoin(QueryCache.java:713)
at ca.sqlpower.wabit.rs.query.QueryCache.addJoin(QueryCache.java:798)
at ca.sqlpower.swingui.querypen.event.CreateJoinEventHandler.mousePressed(CreateJoinEventHandler.java:107)
at edu.umd.cs.piccolo.event.PBasicInputEventHandler.processEvent(Unknown Source)
at edu.umd.cs.piccolo.util.PPickPath.processEvent(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.dispatchEventToListener(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.mousePressed(Unknown Source)
at edu.umd.cs.piccolo.event.PBasicInputEventHandler.processEvent(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.processInput(Unknown Source)
at edu.umd.cs.piccolo.PRoot.processInputs(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.processEventFromCamera(Unknown Source)
at edu.umd.cs.piccolo.PCanvas.sendInputEventToInputManager(Unknown Source)
at edu.umd.cs.piccolo.PCanvas$1.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Component.java:6172)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:5940)
at java.awt.Container.processEvent(Container.java:2105)
at java.awt.Component.dispatchEventImpl(Component.java:4536)
at java.awt.Container.dispatchEventImpl(Container.java:2163)
at java.awt.Component.dispatchEvent(Component.java:4362)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4461)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4122)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4055)
at java.awt.Container.dispatchEventImpl(Container.java:2149)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4362)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:604)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)
[/code]

I get the following [i]two[/i] exceptions when I left-click in the black workspace area:

[code]
java.lang.NullPointerException
at edu.umd.cs.piccolox.event.PSelectionEventHandler.endMarqueeSelection(Unknown Source)
at edu.umd.cs.piccolox.event.PSelectionEventHandler.endDrag(Unknown Source)
at edu.umd.cs.piccolo.event.PDragSequenceEventHandler.mouseReleased(Unknown Source)
at edu.umd.cs.piccolo.event.PBasicInputEventHandler.processEvent(Unknown Source)
at edu.umd.cs.piccolo.util.PPickPath.processEvent(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.dispatchEventToListener(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.mouseReleased(Unknown Source)
at edu.umd.cs.piccolo.event.PBasicInputEventHandler.processEvent(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.processInput(Unknown Source)
at edu.umd.cs.piccolo.PRoot.processInputs(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.processEventFromCamera(Unknown Source)
at edu.umd.cs.piccolo.PCanvas.sendInputEventToInputManager(Unknown Source)
at edu.umd.cs.piccolo.PCanvas$1.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Component.java:6175)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:5940)
at java.awt.Container.processEvent(Container.java:2105)
at java.awt.Component.dispatchEventImpl(Component.java:4536)
at java.awt.Container.dispatchEventImpl(Container.java:2163)
at java.awt.Component.dispatchEvent(Component.java:4362)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4461)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4125)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4055)
at java.awt.Container.dispatchEventImpl(Container.java:2149)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4362)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:604)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)

[/code]

and

[code]
java.awt.geom.IllegalPathStateException: missing initial moveto in path definition
at java.awt.geom.Path2D$Float.needRoom(Path2D.java:280)
at java.awt.geom.Path2D$Float.lineTo(Path2D.java:350)
at sun.java2d.pisces.PiscesRenderingEngine$1.lineTo(PiscesRenderingEngine.java:99)
at sun.java2d.pisces.Stroker.emitLineTo(Stroker.java:742)
at sun.java2d.pisces.Stroker.finish(Stroker.java:705)
at sun.java2d.pisces.Stroker.close(Stroker.java:592)
at sun.java2d.pisces.PiscesRenderingEngine.pathTo(PiscesRenderingEngine.java:315)
at sun.java2d.pisces.PiscesRenderingEngine.strokeTo(PiscesRenderingEngine.java:297)
at sun.java2d.pisces.PiscesRenderingEngine.createStrokedShape(PiscesRenderingEngine.java:85)
at java.awt.BasicStroke.createStrokedShape(BasicStroke.java:296)
at edu.umd.cs.piccolo.nodes.PPath.getPathBoundsWithStroke(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.updateBoundsFromPath(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.append(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.(Unknown Source)
at edu.umd.cs.piccolo.nodes.PPath.createRectangle(Unknown Source)
at edu.umd.cs.piccolox.event.PSelectionEventHandler.initializeMarquee(Unknown Source)
at edu.umd.cs.piccolox.event.PSelectionEventHandler.startDrag(Unknown Source)
at edu.umd.cs.piccolo.event.PDragSequenceEventHandler.mousePressed(Unknown Source)
at edu.umd.cs.piccolo.event.PBasicInputEventHandler.processEvent(Unknown Source)
at edu.umd.cs.piccolo.util.PPickPath.processEvent(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.dispatchEventToListener(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.mousePressed(Unknown Source)
at edu.umd.cs.piccolo.event.PBasicInputEventHandler.processEvent(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.processInput(Unknown Source)
at edu.umd.cs.piccolo.PRoot.processInputs(Unknown Source)
at edu.umd.cs.piccolo.PInputManager.processEventFromCamera(Unknown Source)
at edu.umd.cs.piccolo.PCanvas.sendInputEventToInputManager(Unknown Source)
at edu.umd.cs.piccolo.PCanvas$1.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Component.java:6172)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:5940)
at java.awt.Container.processEvent(Container.java:2105)
at java.awt.Component.dispatchEventImpl(Component.java:4536)
at java.awt.Container.dispatchEventImpl(Container.java:2163)
at java.awt.Component.dispatchEvent(Component.java:4362)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4461)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4122)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4055)
at java.awt.Container.dispatchEventImpl(Container.java:2149)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4362)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:604)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)
[/code]

I added another JDBC connection, but there was no way to get it to appear in the connection drop-down other than restarting the application.

Finally, even the forum software seems to be acting up: the message "Preview" button seems to do nothing. :\

I guess I should get something to read and go to bed and give it a fresh go another day...

Cheers,
Tomislav

java.sql.SQLException: JDBC Driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" not found.

Clayton Randall — GMT

Just installed the update, and now am getting the above error. Is there a fix, or am I dead in the water today?

SQL Format Question with Wabit133

cosburgin — GMT

I downloaded Wabit133 today to replace Wabit 111. Now, it appears that in my SQL queries, Ampersands and CRLFs are being stored as text which makes the SQL unuseable. Seems like I remember a similar issue in an earlier version.
I'll go back to Version 111 for now.
Also, I'm unable to attach files but here is an example of the code.

select paf.assignment_number,&crlf;papf.full_name,&crlf;paf.effective_start_date,&crlf;paf.effective_end_date,&crlf;paf.payroll_id&crlf;from per_assignments_f paf &crlf;join hr.per_all_people_f papf&crlf; on papf.person_id = paf.person_id&crlf;where paf.payroll_id IN (503, 804) &crlf;and paf.ass_attribute8 not like 'OMI%' &crlf;and paf.assignment_status_type_id = 1 &crlf;and trunc(sysdate) between paf.effective_start_date &crlf;and paf.effective_end_date &crlf;and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date &crlf;order by full_name

Can't locate MySQL jdbc driver :-(

ccrvic — GMT

Hi All.

This is probably a newbie question, but I'm not really that familiar with Java.

I'm using Fedora 13 in what is pretty much a vanilla configuration. I've installed the mysql-connector-java package, which gives me Connector/J.

I'm trying to run Wabit against my local MySQL database, and it fails miserably when I test the connection - I get a "Could not locate class com.mysql.jdbc.Driver" error.

I've tried with all sorts of combinations (including nothing) of the CLASSPATH variable, with the -classpath option to java - nothing works.

Can anyone put me out of my misery?

Thanks.

Vic.

OLAP Query Editor and java.lang.NullPointerException

Yanis — GMT

Hi community,

I am new to Wabit, I am currently testing it so we can adopt it in the company I am working for.

I just dowloaded the 30 days evalutation version, and I tried to make a first basic report with data coming from an homemade OLAP cube but it doesn't matter what dimension do I put in the Query Editor GUI I always get "Could not execute the query due to the following error: java.lang.NullPointerException:null"

Then, I told myself I would try with the MDX query editor, but when I hit Create Chart I just get nothing the page open but I have no data displayed in the box. But then when I put the same query in another software I do have the expected result.

I selected Omit Empty Rows on the top menu, but still the same, no data.

So here are my questions:
- How to do chart from homemade OLAP cube ?
- Do null values are problems ?

Edit : I am using a Mondrian Cube, based on a PostgreSQL database engine under Ubuntu 10.10

Any help is welcome,

Thank you in advance.