Hi, Does this work (connect ok & execute the query) if you just code a plain old java console program, in Eclipse for example ?
Regards On Jul 21, 9:04 pm, Boozel <[email protected]> wrote: > Hi > > I'm trying to connect to SQL Server 2008 using JDBC. I downloaded the JDBC > from microsoft and there were two java files sqljdbc.jar and sqljdbc4.jar. I > imported sqljdbc4.jar into my application but when i get to conn = > DriverManager.getConnection(connString); i get the error below: the > connection string is > "jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;encrypt=fasle;user=username;password > =password;" > Can any one tell me what is going wrong? my code is below the error below. I > know that there are other ways to connect to a db and using JDBC isnt the > best but it the only suitable method for my application. > > any help would be great and Thanks in advance. > > I/MobileTrend(13984): ERROR 1: > com.microsoft.sqlserver.jdbc.SQLServerException:The driver could not > establish a secure connection to SQL Server by using Secure Sockets Layer > (SSL) encryption. Error: "Socket closed". > W/System.err(13984): com.microsoft.sqlserver.jdbc.SQLServerException: The > driver could not establish a secure connection to SQL Server by using Secure > Sockets Layer (SSL) encryption. Error: "Socket closed". > W/System.err(13984): at > com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnect > ion.java:1352) > W/System.err(13984): at > com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1533) > W/System.err(13984): at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerCon > nection.java:1042) > W/System.err(13984): at > com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection. > java:817) > W/System.err(13984): at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnectio > n.java:700) > W/System.err(13984): at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:8 > 42) > W/System.err(13984): at > java.sql.DriverManager.getConnection(DriverManager.java:180) > W/System.err(13984): at > java.sql.DriverManager.getConnection(DriverManager.java:145) > W/System.err(13984): at > com.boozel.mobiletrend.MobileTrendActivity.query(MobileTrendActivity.java:7 7) > W/System.err(13984): at > com.boozel.mobiletrend.MobileTrendActivity.onOptionsItemSelected(MobileTren > dActivity.java:50) > W/System.err(13984): at > android.app.Activity.onMenuItemSelected(Activity.java:2205) > W/System.err(13984): at > com.android.internal.policy.impl.PhoneWindow.onMenuItemSelected(PhoneWindow > .java:748) > W/System.err(13984): at > com.android.internal.view.menu.MenuItemImpl.invoke(MenuItemImpl.java:143) > W/System.err(13984): at > com.android.internal.view.menu.MenuBuilder.performItemAction(MenuBuilder.ja > va:855) > W/System.err(13984): at > com.android.internal.view.menu.IconMenuView.invokeItem(IconMenuView.java:53 2) > W/System.err(13984): at > com.android.internal.view.menu.IconMenuItemView.performClick(IconMenuItemVi > ew.java:122) > W/System.err(13984): at > android.view.View$PerformClick.run(View.java:9080) > W/System.err(13984): at > android.os.Handler.handleCallback(Handler.java:587) > W/System.err(13984): at > android.os.Handler.dispatchMessage(Handler.java:92) > W/System.err(13984): at android.os.Looper.loop(Looper.java:130) > W/System.err(13984): at > android.app.ActivityThread.main(ActivityThread.java:3683) > W/System.err(13984): at java.lang.reflect.Method.invokeNative(Native > Method) > W/System.err(13984): at java.lang.reflect.Method.invoke(Method.java:507) > W/System.err(13984): at > com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java: > 839) > W/System.err(13984): at > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597) > W/System.err(13984): at dalvik.system.NativeStart.main(Native Method) > W/System.err(13984): Caused by: java.net.SocketException: Socket closed > W/System.err(13984): at > org.apache.harmony.xnet.provider.jsse.NativeCrypto.SSL_do_handshake(Native > Method) > W/System.err(13984): at > org.apache.harmony.xnet.provider.jsse.OpenSSLSocketImpl.startHandshake(Open > SSLSocketImpl.java:474) > W/System.err(13984): at > org.apache.harmony.xnet.provider.jsse.OpenSSLSocketImpl.startHandshake(Open > SSLSocketImpl.java:328) > W/System.err(13984): at > com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1483) > W/System.err(13984): ... 24 more > > package com.boozel.mobiletrend; > > import java.sql.Connection; > import java.sql.DriverManager; > import android.app.Activity; > import android.content.Intent; > import android.content.SharedPreferences; > import android.os.Bundle; > import android.text.method.ScrollingMovementMethod; > import android.util.Log; > import android.view.Menu; > import android.view.MenuInflater; > import android.view.MenuItem; > import android.widget.TextView; > import com.microsoft.sqlserver.jdbc.*; > > public class MobileTrendActivity extends Activity { > SharedPreferences sharedPreferences; > TextView tv; > /** Called when the activity is first created. */ > @Override > public void onCreate(Bundle savedInstanceState) { > super.onCreate(savedInstanceState); > setContentView(R.layout.main); > > sharedPreferences = getSharedPreferences("MobileTrend", 0); > > tv = (TextView)findViewById(R.id.output); > tv.setMovementMethod(new ScrollingMovementMethod()); > > } > > @Override > public boolean onCreateOptionsMenu(Menu menu) { > MenuInflater inflater = getMenuInflater(); > inflater.inflate(R.xml.mainmenu, menu); > return true; > } > > @Override > public boolean onOptionsItemSelected(MenuItem item) { > // Handle item selection > switch (item.getItemId()) { > case R.id.settings: > Intent myIntent = new Intent(MobileTrendActivity.this, > Settings.class); > MobileTrendActivity.this.startActivity(myIntent); > return true; > case R.id.connect1: > query(); > return true; > case R.id.connect2: > query2(); > return true; > case R.id.clear: > tv.setText(""); > return true; > default: > return super.onOptionsItemSelected(item); > } > } > > public void query() > { > Log.i("MobileTrend","1) MySQL Connect Example."); > Connection conn = null; > > try { > outputToConsole("\n1) Attempting to connect..."); > String driver = > sharedPreferences.getString("driver","com.microsoft.sqlserver.jdbc.SQLServe > rDriver"); > outputToConsole("Driver: "+driver); > Class.forName(driver).newInstance(); > //test = com.microsoft.sqlserver.jdbc.SQLServerDriver.class; > outputToConsole("Driver Instance Created"); > String connString = sharedPreferences.getString("connectionstring1",""); > outputToConsole("Connection String: "+connString); > conn = DriverManager.getConnection(connString); > //conn = DriverManager.getConnection(url+dbName,userName,password); > outputToConsole("Connected to the database"); > conn.close(); > outputToConsole("Disconnected from database"); > } catch (Exception e) > { outputToConsole("ERROR 1: "+e); > e.printStackTrace(); > } > } > > public void query2() > { > Log.i("MobileTrend","2) MySQL Connect Example."); > Connection conn = null; > try { > outputToConsole("\n2) Attempting to connect..."); > String driver = > sharedPreferences.getString("driver","com.microsoft.sqlserver.jdbc.SQLServe > rDriver"); > outputToConsole("Driver: "+driver); > Class.forName(driver).newInstance(); > //test = com.microsoft.sqlserver.jdbc.SQLServerDriver.class; > outputToConsole("Driver Instance Created"); > String connString = sharedPreferences.getString("connectionstring2",""); > outputToConsole("Connection String: "+connString); > String username = sharedPreferences.getString("username2",""); > outputToConsole("User Name: "+username); > String password = sharedPreferences.getString("password2",""); > outputToConsole("Password: "+password); > conn = DriverManager.getConnection(connString,username,password); > //conn = DriverManager.getConnection(url+dbName,userName,password); > outputToConsole("Connected to the database"); > conn.close(); > outputToConsole("Disconnected from database"); > } catch (Exception e) > { outputToConsole("ERROR 2: "+e); > e.printStackTrace(); > } > } > public void outputToConsole(String message) > { > > tv.append(message+"\n"); > Log.i("MobileTrend",message); > } > > > > > > > > } -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
