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 
Links to JDBC Driver download pages  XML
Forum Index » SQL Power Architect Technical Support
Author Message
ryan_b


Joined: 2007-01-04 10:35:10
Messages: 5
Offline

This is a topic created to maintain a list of links to the download pages of various JDBC drivers. Feel free to post about updates or additional links that may be needed.

Oracle
Download Page

SQL Server
Download Page

PostgreSQL
Download Page

HSQL
Download Page

This message was edited 1 time. Last update was at 2007-01-08 15:10:07

Ian Darwin

[Avatar]

Joined: 2007-01-08 10:34:36
Messages: 3
Offline

If all else fails, you can find JDBC drivers for just about every imaginable RDBMS at this JavaSoft page:
http://developers.sun.com/product/jdbc/drivers
[WWW]
nmiles


Joined: 2010-08-30 17:44:03
Messages: 2
Offline

Informix drivers:
http://www-01.ibm.com/software/data/informix/downloads.html
Andreas Dzionsky


Joined: 2009-09-04 14:04:11
Messages: 4
Offline

i found a new jdbc driver for ms sql server here:

http://www.microsoft.com/downloads/de-de/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707

unfortunately i donĀ“t know how to implement this in sql power archictect. there are to files:

- sqljdbc4.jar
- sqljdbc.jar


located in "/Users/andreasdzionsky/architect-enterprise-server/jdbc/sqljdbc_3.0/deu/".

do i have to change the class path and/or pl.ini???

what ever i do it results in this error:


java.sql.SQLException: JDBC Driver ".:/Users/andreasdzionsky/architect-enterprise-server/jdbc/sqljdbc_3.0/deu/sqljdbc4.jar" not found.
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:309)
at ca.sqlpower.swingui.JDBCDataSourcePanel$1.actionPerformed(JDBCDataSourcePanel.java:16
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:202
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6374)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6139)
at java.awt.Container.processEvent(Container.java:2085)
at java.awt.Component.dispatchEventImpl(Component.java:4736)
at java.awt.Container.dispatchEventImpl(Container.java:2143)
at java.awt.Component.dispatchEvent(Component.java:4566)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4621)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4282)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212)
at java.awt.Container.dispatchEventImpl(Container.java:2129)
at java.awt.Window.dispatchEventImpl(Window.java:247
at java.awt.Component.dispatchEvent(Component.java:4566)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:680)
at java.awt.EventQueue.access$000(EventQueue.java:86)
at java.awt.EventQueue$1.run(EventQueue.java:639)
at java.awt.EventQueue$1.run(EventQueue.java:637)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:9
at java.awt.EventQueue$2.run(EventQueue.java:653)
at java.awt.EventQueue$2.run(EventQueue.java:651)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:650)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:18
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.ClassNotFoundException: .:/Users/andreasdzionsky/architect-enterprise-server/jdbc/sqljdbc_3.0/deu/sqljdbc4.jar
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:274)
... 37 more


has anyone an idea how to fix this problem???

joyfajardo


Joined: 2013-11-19 15:38:53
Messages: 1
Offline

HAS ANYONE KNOWS HOW TO CONFIGURE SQL ARCHITECT FOR DB2 v 9.7 and what where to download the JDBC driver?


java.sql.SQLException: Data Source Type "DB2" has no JDBC Driver class specified.
at ca.sqlpower.sql.JDBCDataSourceType.checkConnectPrereqs(JDBCDataSourceType.java:717)
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:254)
at ca.sqlpower.swingui.JDBCDataSourcePanel$1.actionPerformed(JDBCDataSourcePanel.java:16
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$200(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)

Kirti M


Joined: 2015-02-12 16:21:34
Messages: 71
Offline

Hi joyfajardo,

you can download DB2 JDBC Driver from
http://www-01.ibm.com/support/docview.wss?uid=swg21363866

and then copy .jar file into 'jdbc_drivers' folder of your SQL Power Architect project.

Hope this will help you.

-Kirti
Gianny


Joined: 2015-04-29 17:34:43
Messages: 5
Offline

Hi!!!

How I configure Power Architect with SQL anywhere 16

I use the jconn4.jar

I connect successfull to the database but when I have to display the database I hava a error

ca.sqlpower.sqlobject.SQLObjectException: Failed to get schema names from source database
Gianny


Joined: 2015-04-29 17:34:43
Messages: 5
Offline

Hi!!!

How I configure Power Architect with SQL anywhere 16

I use the jconn4.jar

I connect successfull to the database but when I have to display the database I hava a error

ca.sqlpower.sqlobject.SQLObjectException: Failed to get schema names from source database
 
Forum Index » SQL Power Architect Technical Support
Go to:   
Powered by JForum 2.1.8 © JForum Team