SQL Power Business Intelligence Productivity Tools
Company OverviewBusiness Intelligence Productivity ToolsQuick-Start Implementation ServicesDemos & TurotialsFrequently Asked Questions (FAQ)Open Source Community ResourcesSQL Power ForumImplementation & Technology PartnersGet SQL Power SoftwareContact Us

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 
Wabit connection to Real SQL Server database  XML
Forum Index » SQL Power Wabit Support
Author Message
Ryan Paligo


Joined: 2009-03-25 00:49:46
Messages: 1
Offline

Is it possible to connect to a Real SQL Server database? It is based on SQLite. I have tried a couple different SQLite JDBC drivers, but I receive this error when I try to connect:

path to '//75.127.72.165:4430/ManageDev': '/75.127.72.165:4430' does not exist

The database is running just fine on my server. Any help would be greatly appreciated.
Thomas


Joined: 2008-12-08 10:14:11
Messages: 165
Offline

Hi Ryan,

You should be able to connect to Real SQL Server with a JDBC driver that works with it. Maybe you have some settings wrong in Wabit that is preventing it from connecting to the database. If you could attach a screen shot of your connection properties, the JDBC driver settings, and the stack trace we can see if anything is missing.

Thomas
SPLESH


Joined: 2009-06-10 10:49:25
Messages: 1
Offline

I too had problems with SQLite I did use driver from http://www.zentus.com/sqlitejdbc/ and it did work but when i try to use it i got message "Couldn't get children of Imported Keys folder of ..."
and stack trice:

ca.sqlpower.sqlobject.SQLObjectException: relationship.populate
at ca.sqlpower.sqlobject.SQLRelationship.fetchImportedKeys(SQLRelationship.java:548)
at ca.sqlpower.sqlobject.SQLTable.populateRelationships(SQLTable.java:378)
at ca.sqlpower.sqlobject.SQLTable.access$200(SQLTable.java:39)
at ca.sqlpower.sqlobject.SQLTable$Folder.populateImpl(SQLTable.java:1035)
at ca.sqlpower.sqlobject.SQLObject.populate(SQLObject.java:249)
at ca.sqlpower.sqlobject.SQLObject.getChildren(SQLObject.java:309)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.ensurePopulated(PlayPen.java:1509)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.ensurePopulated(PlayPen.java:1509)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.doStuff(PlayPen.java:1486)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:99)
at java.lang.Thread.run(Thread.java:636)
Caused by: java.sql.SQLException: not yet implemented
at org.sqlite.MetaData.getImportedKeys(MetaData.java:503)
at ca.sqlpower.sqlobject.SQLRelationship.fetchImportedKeys(SQLRelationship.java:543)
... 10 more

This message was edited 2 times. Last update was at 2009-06-10 14:09:19

Thomas


Joined: 2008-12-08 10:14:11
Messages: 165
Offline

Hi SPLESH,

Thanks for posting this issue to the forums. I got the SQLiteJDBC driver you are using and was able to reproduce the error. It seems that the driver does not yet implement retrieving imported keys from the database meta data. As a fix I added a new database meta data wrapper for the SQLite driver that will prevent this exception. You can try a new version with this fix from http://pag.sqlpower.ca:8080/hudson/job/wabit/1097/. Let us know what you think and feel free to post any additional feedback.

Thomas
taksan


Joined: 2009-08-18 23:10:04
Messages: 6
Offline

Hi,

Since this problem was bugging me so much, I took the matter in my own hands and fixed sqlitejdbc to implement getImportedKeys. I'm putting the patch down here for anyone who's interested. If you'd like the fixed jar driver, just let me know, I can mail or put in a place everyone can grab it. You should patch Metada.java

patch -p0 Metadata.java patchfile

--- patch starts below---

This message was edited 1 time. Last update was at 2009-08-23 00:48:17

 
Forum Index » SQL Power Wabit Support
Go to:   
Powered by JForum 2.1.8 © JForum Team