Reverse Engineering SQL Server 2008 Schema

General discussions about code engineering

Moderator: Moderators

Reverse Engineering SQL Server 2008 Schema

Postby brandon.gibson@lmco.com » Mon Aug 23, 2010 12:12 pm

I am having difficulty reverse engineering an SQL Server 2008 schema using MagicDraw.

I have tried both the 2.0 and the 3.0 versions of the jdbc driver for SQL Server, but the only status I receive is "Connection failed!"
brandon.gibson@lmco.com
Forum Beginner
Forum Beginner
 
Posts: 40
Posts Rating:0
Joined: Mon Aug 23, 2010 12:09 pm

Re: Reverse Engineering SQL Server 2008 Schema

Postby Justinas Bisikirskas » Tue Aug 24, 2010 1:18 am

Hi,
It could be possible that you provide the incorrect DB Connection URL or use the incorrect JDBC driver class .
The older JDBC drivers of SQL server and the new ones have some changes in this area.

If you use JDBC 2.0/3.0 driver, the DB Connection URL shall be : "jdbc:sqlserver://<server.address>".
The driver class also should be updated to "com.microsoft.sqlserver.jdbc.SQLServerDriver".

Please try to update these values and let us know if it does not help.

--

Best regards,

Justinas Bisikirskas
--

Best regards,

Justinas Bisikirskas
System Analyst
No Magic Inc.
Justinas Bisikirskas
Customer Support
Customer Support
 
Posts: 1
Posts Rating:0
Joined: Tue Aug 24, 2010 1:08 am
Location: Kaunas, Lithuania

Re: Reverse Engineering SQL Server 2008 Schema

Postby brandon.gibson@lmco.com » Tue Aug 24, 2010 7:26 am

Could you clarify what you mean by host.address...

I had already changed the driver URL and the driver name but I was still having the same issue.

When I put in host.address I get the following exception...

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host mvnswft2.158.187.195.29, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1033)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at com.nomagic.magicdraw.ce.ddl.g.f(g.java:124)
at com.nomagic.magicdraw.ce.ddl.g.c(g.java:45)
at com.nomagic.magicdraw.ce.ddl.v.r(v.java:79)
at com.nomagic.magicdraw.ce.core.e.rb.a(rb.java:186)
at com.nomagic.magicdraw.ce.core.e.rb.a(rb.java:462)
at com.nomagic.magicdraw.ce.core.rtproject.objects.p.accept(p.java:162)
at com.nomagic.magicdraw.ce.core.e.rb.c(rb.java:107)
at com.nomagic.magicdraw.ce.core.r.a(r.java:435)
at com.nomagic.magicdraw.ce.core.r.a(r.java:423)
at com.nomagic.magicdraw.ce.core.r.c(r.java:752)
at com.nomagic.magicdraw.ce.core.r.b(r.java:729)
at com.nomagic.magicdraw.ce.core.e.ub.actionPerformed(ub.java:44)
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.AbstractButton.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.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.dispatchEvent(Unknown Source)
at com.nomagic.utils.EventTracker.dispatchEvent(EventTracker.java:33)
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)
SQLState(08S01) vendor code(0)
brandon.gibson@lmco.com
Forum Beginner
Forum Beginner
 
Posts: 40
Posts Rating:0
Joined: Mon Aug 23, 2010 12:09 pm

Re: Reverse Engineering SQL Server 2008 Schema

Postby jusbis » Tue Aug 24, 2010 7:47 am

Please check if your SQL server allows remote connections.
More information about this error could be found at http://social.msdn.microsoft.com/Forums ... 3943180172
Best regards,

Justinas Bisikirskas
No Magic Inc.
jusbis
Customer Support
Customer Support
 
Posts: 75
Posts Rating:6
Joined: Tue Aug 24, 2010 7:28 am
Location: Kaunas, Lithuania

Re: Reverse Engineering SQL Server 2008 Schema

Postby brandon.gibson@lmco.com » Tue Aug 24, 2010 10:07 am

Thanks for the help. We were able to resolve the issue.

The DDL import works great :D
brandon.gibson@lmco.com
Forum Beginner
Forum Beginner
 
Posts: 40
Posts Rating:0
Joined: Mon Aug 23, 2010 12:09 pm

Re: Reverse Engineering SQL Server 2008 Schema

Postby dellprintersupport » Tue Jun 19, 2018 2:08 pm

The process where engineering is finding the error on the driver of the SQL server which is going to be solved out fro which you can take the support fromDell printer supportwhich will be the best part.
dellprintersupport
Forum Newbie
Forum Newbie
 
Posts: 1
Posts Rating:0
Joined: Tue Jun 19, 2018 2:00 pm


Return to Code engineering

Who is online

Users browsing this forum: No registered users and 1 guest