facebook

JDBC connectivity

  1. MyEclipse IDE
  2.  > 
  3. Off Topic
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #328904 Reply

    lrine
    Member

    I am new to Java and to myeclipse so hopefully I won’t embarrass myself. I am trying to connect to MSSQL Server using the Microsoft provided JDBC driver.

    The connection string I am using works in an Eclipse environment. The driver template (Other MSSQL 2008 is not available from myeclipse.

    With myeclipse, I either get an error that the driver is not supported for integrated logon, or when I remove the integrated logon criteria from the connection string the message is that logon fails for the administrative user id.

    I have placed the dll files is the appropriate location (I think) although I repeat that it works in eclipse.

    #328944 Reply

    support-swapna
    Moderator

    lrine,

    Sorry that you are seeing this issue.

    Can you answer some more questions for us ?

    1. Can you please copy paste the Installation Details from MyEclipse > Installation Summary > Installation Details ?

    2. Can you let us know on which version of Eclipse is the connection string working ?

    3. Please give us details about the version of MSSQL Server you are working with and the connection string you are using.

    4. Can you please check if you can configure and connect to the said database from the MyEclipse Database explorer ? Here is the tutorial to configure the DB :
    http://www.myeclipseide.com/documentation/quickstarts/dbexplorer/

    Let us know how it works for you.

    #328970 Reply

    lrine
    Member

    The installation summary is:

    *** Date:
    Thursday, August 9, 2012 9:18:54 AM CDT

    *** System properties:
    OS=Windows Server 2008
    OS version=6.1.0
    OS arch=x86
    Profile arch=x86
    Window system=win32
    Java version=1.6.0_13
    Workspace=file:/C:/Users/administrator.INTERSECT/Workspaces/MyEclipse Bling Edition 10/
    VM Args=-Xmx512m
    -XX:MaxPermSize=256m
    -XX:ReservedCodeCacheSize=64m
    -Dosgi.nls.warnings=ignore
    -Djava.class.path=C:\Users\ADMINI~1.INT\AppData\Local\MYECLI~1\MYECLI~1\../Common/plugins/ORB7B5~1.JAR

    *** Subscription information
    Your 30-day trial period expires on Sep 03, 2012

    *** Eclipse details:
    MyEclipse Blue Edition

    Version: 10.6 Blue
    Build id: 10.6-Blue-20120727

    Blueprint: MyEclipse Bling Edition 10

    com.genuitec.myeclipse.blue.feature – 10.6.0.me201207261914
    com.genuitec.myeclipse.database – 10.6.0.me201207261914
    com.genuitec.myeclipse.db2 – 10.6.0.me201207261914
    com.genuitec.myeclipse.desktop – 10.6.0.me201207261914
    com.genuitec.myeclipse.editor – 10.6.0.me201207261914
    com.genuitec.myeclipse.geronimo – 10.6.0.me201207261914
    com.genuitec.myeclipse.glassfish – 10.6.0.me201207261914
    com.genuitec.myeclipse.icefaces.feature – 10.6.0.me201207261914
    com.genuitec.myeclipse.iedebugger – 10.6.0.me201207261914
    com.genuitec.myeclipse.imageeditor – 10.6.0.me201207261914
    com.genuitec.myeclipse.jboss – 10.6.0.me201207261914
    com.genuitec.myeclipse.jetty – 10.6.0.me201207261914
    com.genuitec.myeclipse.jonas – 10.6.0.me201207261914
    com.genuitec.myeclipse.jrun – 10.6.0.me201207261914
    com.genuitec.myeclipse.jsf – 10.6.0.me201207261914
    com.genuitec.myeclipse.matisse – 10.6.0.me201207261914
    com.genuitec.myeclipse.maven – 10.6.0.me201207261914
    com.genuitec.myeclipse.oracle – 10.6.0.me201207261914
    com.genuitec.myeclipse.orion – 10.6.0.me201207261914
    com.genuitec.myeclipse.persistence – 10.6.0.me201207261914
    com.genuitec.myeclipse.pulse – 10.6.0.me201207261914
    com.genuitec.myeclipse.reports – 10.6.0.me201207261914
    com.genuitec.myeclipse.resin – 10.6.0.me201207261914
    com.genuitec.myeclipse.struts – 10.6.0.me201207261914
    com.genuitec.myeclipse.sun – 10.6.0.me201207261914
    com.genuitec.myeclipse.tomcat – 10.6.0.me201207261914
    com.genuitec.myeclipse.uml2 – 10.6.0.me201207261914
    com.genuitec.myeclipse.visualvm – 10.6.0.me201207261914
    com.genuitec.myeclipse.visualvm.server – 10.6.0.me201207261914
    com.genuitec.myeclipse.weblogic – 10.6.0.me201207261914
    com.genuitec.myeclipse.ws – 10.6.0.me201207261914
    com.genuitec.myeclipse.ws.blue – 10.6.0.me201207261914
    com.skyway.myeclipseforspring.feature – 10.0.0.201111091436
    org.eclipse.birt – 2.6.1.me201207261914
    org.eclipse.datatools.connectivity.feature – 1.9.0.me201207261914
    org.eclipse.datatools.enablement.feature – 1.9.0.me201207261914
    org.eclipse.datatools.modelbase.feature – 1.9.0.v201106031100-77078CcNBHCBYKYEbNV
    org.eclipse.datatools.sqldevtools.feature – 1.9.0.me201207261914
    org.eclipse.emf – 2.7.0.v20110606-0949
    org.eclipse.gef – 3.7.0.v20110425-2050-777D-81B2Bz0685C3A6E34272
    org.eclipse.graphiti.feature – 0.8.0.v20110607-1252
    org.eclipse.jpt.jpa.feature – 3.0.0.me201207261914
    org.eclipse.jpt.jpadiagrameditor.feature – 1.0.0.me201207261914
    org.eclipse.jst.common.fproj.enablement.jdt – 3.3.0.me201207261914
    org.eclipse.jst.enterprise_ui.feature – 3.3.0.me201207261914
    org.eclipse.jst.server_adapters.ext.feature – 3.3.0.me201207261914
    org.eclipse.jst.server_adapters.feature – 3.2.100.me201207261914
    org.eclipse.jst.server_ui.feature – 3.3.0.me201207261914
    org.eclipse.jst.ws.axis2tools.feature – 1.1.200.me201207261914
    org.eclipse.m2e.feature – 1.0.0.me201207261914
    org.eclipse.sapphire.platform – 0.3.0.201106221325
    org.eclipse.wst.common.fproj – 3.3.0.me201207261914
    org.eclipse.wst.server_adapters.feature – 3.2.100.me201207261914
    org.eclipse.xsd – 2.7.0.v20110606-0949
    org.springframework.ide.eclipse.feature – 2.9.1.me201207261914

    fr.obeo.acceleo.bridge.feature – 2.6.0.200906261742
    org.eclipse.cvs – 1.3.100.v20110520-0800-7B78FHl9VF7BD7KBM4GP9C
    org.eclipse.draw2d – 3.7.0.v20110425-2050-46-7w3122153603161
    org.eclipse.equinox.p2.core.feature – 1.0.1.v20110906-1605-8290FZ9FVKHVRKtmx3fpNuo02129
    org.eclipse.equinox.p2.extras.feature – 1.0.1.v20110906-1605-7A4FD4DiVOMap8cHSc6vPuny4gqO
    org.eclipse.equinox.p2.rcp.feature – 1.0.1.v20110906-1605-782EqBqNKGVkiV-PUsgz-uny4gqO
    org.eclipse.equinox.p2.user.ui – 2.1.2.R37x_v20110815-1155-6-Bk8pYWZz0qUTX5I15GZWwbXkrl
    org.eclipse.help – 1.3.0.v20110530-0844-7i7uFFmFFl8nvqbDpEqTvx
    org.eclipse.jdt – 3.7.2.v20120120-1414-7z8gFcuFMP7BW5XTz0jLTnz0l9B1
    org.eclipse.jsf.feature – 3.3.0.me201207261914
    org.eclipse.ocl – 3.1.0.v20110606-1427
    org.eclipse.pde – 3.7.2.v20120120-1420-7b7rFUOFEx2Xnqafnpz0E–0
    org.eclipse.platform – 3.7.2.v20120207-1839-9gF7UHPDFxGjd-PqDr2jX_4yKaumkoHTz04_q-q
    org.eclipse.rcp – 3.7.2.v20120120-1424-9DB5FmnFq5JCf1UA38R-kz0S0272

    Eclipse startup command=-os
    win32
    -ws
    win32
    -arch
    x86
    -showsplash
    -launcher
    C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\myeclipse-blue.exe
    -name
    Myeclipse-blue
    –launcher.library
    C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\../Common/plugins/org.eclipse.equinox.launcher.i18n.win32.win32.x86_4.2.0.v201201111650\eclipse_4201.dll
    -startup
    C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\../Common/plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
    -install
    C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10
    -configuration
    C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\configuration
    -vm
    C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\jre\bin\client\jvm.dll

    The Eclipse version is:

    Eclipse Java EE IDE for Web Developers.

    Version: Indigo Service Release 2
    Build id: 20120216-1857

    (c) Copyright Eclipse contributors and others 2005, 2012. All rights reserved.
    Visit http://www.eclipse.org/webtools

    The working connection string is:

    jdbc:sqlserver://localhost:1433;databaseName=intersect;integratedSecurity=true;

    I am using SQL Server 2012 which is reverse compatible with SQL 2008.

    Thanks for your help.

    #329030 Reply

    support-swapna
    Moderator

    lrine,

    Thank you for the details.

    1.Did you get a chance to try to connect to the database from the MyEclipse Database Explorer view ?

    2. Clear the contents of the .log file which is located at <workspace dir>/.metadata/.log. Now replicate the issue and copy paste the contents of the .log file here for us to investigate further.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: JDBC connectivity

You must be logged in to post in the forum log in