Java

25-Jun-13 23:23

Java

static Connection Connectionstring()
   {
       Connection con = null;
       try {
           Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
       } catch (ClassNotFoundException e1) {
           // TODO Auto-generated catch block
           e1.printStackTrace();
       }
       String conUrl = "jdbc:sqlserver://localhost;databaseName=paytest;user=PC;password=;integratedSecurity=true";

       try
       {
                con = DriverManager.getConnection(conUrl);
                JOptionPane.showMessageDialog(null,"Connection is open!","Connection",JOptionPane.WARNING_MESSAGE);

                }
       catch (SQLException e)
       {

           e.printStackTrace();
       }
       return con;

   }//connection string method ends

I have got this error

Java

Exception in thread "main" java.lang.NoSuchFieldError: address
	at java.net.InetAddress.init(Native Method)
	at java.net.InetAddress.<clinit>(Unknown Source)
	at java.net.InetSocketAddress.<init>(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SocketFinder.getDefaultSocket(IOBuffer.java:2430)
	at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2094)
	at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at SpringSample.Connectionstring(SpringSample.java:290)
	at SpringSample.main(SpringSample.java:120)

How to connect ?

thanh_bkhn28-Jun-13 1:12

thanh_bkhn

28-Jun-13 1:12

You should check the port where sqlserver is installed and specify the port number. Ex
jdbc:sqlserver://localhost:1433;databaseName=paytest;user=PC;password=;integratedSecurity=true

chdboy28-Jun-13 4:06

28-Jun-13 4:06

If I use this code in a different class(Just the connection code)it works fine with

Java

jdbc:sqlserver://localhost:1433;databaseName=paytest;user=PC;password=;integratedSecurity=true

this code

but when I'm using it with GUI it does not work ?I hope connection string is not related to GUI I'm using ?

Richard MacCutchan28-Jun-13 4:12

28-Jun-13 4:12

chdboy wrote:
I hope connection string is not related to GUI I'm using ?

How do you think it could be? It is much more likely that you have made a mistake in one application that is not in the other one. Try stepping through the code with your debugger to trace the exact sequence of events when you try to connect.

Use the best guess

chdboy28-Jun-13 5:06

28-Jun-13 5:06

Java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;

public abstract class ConnectionDB 
{	
	
	/**
	 * @param args
	 */
	public static void main(String[] args)
	{	
		
		try {						 
			insertRecordIntoDbUserTable();
			selectfromdb();
		} 
		catch (SQLException e)
		{
 
			System.out.println(e.getMessage());
 
		}
}
	
		
	private static void insertRecordIntoDbUserTable() throws SQLException
	{
		Connection con = null;
		Statement statement = null;
		String insertTableSQL = "INSERT INTO LoginDetails" + "(Username, Password) " + "VALUES" + "('user1','user1')";
		try 
		{
			con = DBConnectionstring();
			statement = con.createStatement(); 
			System.out.println(insertTableSQL);			
			statement.executeUpdate(insertTableSQL);			
			
			JOptionPane.showMessageDialog(null,"Your Data has been Inserted","Data Inserted",JOptionPane.WARNING_MESSAGE);
		} 
		catch (SQLException e)
		{
 
			System.out.println(e.getMessage()); 
		} 
		finally 
		{
 
			if (statement != null)
			{
				statement.close();
				
				JOptionPane.showMessageDialog(null,"Statement is closed","Statement",JOptionPane.WARNING_MESSAGE);
			}
 
			if (con != null)
			{
				con.close();
				
				JOptionPane.showMessageDialog(null,"Connection is closed!","Connection",JOptionPane.WARNING_MESSAGE);
			}
 
		}
		
		
	}
	
	private static void selectfromdb() throws SQLException
	{		
	    Statement stmt = DBConnectionstring().createStatement();
		ResultSet rs = stmt.executeQuery("SELECT Username,Password FROM LoginDetails");
		while (rs.next())
		{
			  String lastName = rs.getString("Username");
			  String Pass = rs.getString("Password");
			  System.out.println(lastName + "" + Pass + "\n");
			 
			}		
	}
	
	 static Connection DBConnectionstring()
	{		
		Connection con = null;
		String conUrl = "jdbc:sqlserver://localhost:1433; databaseName=paytest; user=PC; password=; integratedSecurity=true;";
		
		try 
		{
				 con = DriverManager.getConnection(conUrl);
				
				 JOptionPane.showMessageDialog(null,"Connection is open!","Connection",JOptionPane.WARNING_MESSAGE);
				 
				 }
		catch (SQLException e)
		{
			
			e.printStackTrace();
		}		
		return con;
		
	}
	

	}

The only difference is that this is an Abstract class.

And this is the code I'm using now with copy for connection string to the above code .

Java

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.awt.Container;
import javax.swing.JOptionPane;
import java.awt.Frame;
import java.awt.event.*;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.SpringLayout;



public class SpringSample extends Frame implements ActionListener

{
	
	 JLabel F_namelbl = new JLabel("Username: ");
	    JLabel L_namelbl = new JLabel("Password: ");
	    JTextField tf_Fname = new JTextField(15);
	    JPasswordField tf_Lname = new JPasswordField(15);
	    JLabel Lbl_HW = new JLabel("< Login Area >");
	    JButton Btn = new JButton("Login");
	    JButton btn_cancel = new JButton("Cancel");
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	SpringSample()
	{
		
	    
		 JFrame frame = new JFrame("Login Area!");
		    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		    Container contentPane = frame.getContentPane();
		    JPanel p = new JPanel(new SpringLayout());
		    SpringLayout layout = (new SpringLayout());
		    contentPane.setLayout(layout);		   
		    JPanel p1=new JPanel();    
		   
		     
		    //--------------------------------------------------------------------------------------------------------------------
		    
		    //---------------------------------------------------------------------------------------------------------------------
		    /*Adding Components to the ContentPane */
		    frame.add(p1);
		    contentPane.add(F_namelbl);
		    contentPane.add(L_namelbl);
		    contentPane.add(tf_Fname);
		    contentPane.add(tf_Lname);
		    contentPane.add(Lbl_HW);
		    contentPane.add(Btn);
		    contentPane.add(btn_cancel);
		    	    
		      //--------------------------------------------------------------------------------------------------------------------
		    /*Lay out Components according to the position and coordinates on the SpringLayout*/
		    
		    layout.putConstraint(SpringLayout.WEST, Lbl_HW, 140, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, Lbl_HW, 0, SpringLayout.NORTH, contentPane);    
		    layout.putConstraint(SpringLayout.WEST, Lbl_HW, 140, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, Lbl_HW, 0, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, F_namelbl, 30, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, F_namelbl, 25, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, L_namelbl, 30, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, L_namelbl, 50, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, tf_Fname, 25, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, tf_Fname, 15, SpringLayout.EAST, F_namelbl);
		    layout.putConstraint(SpringLayout.NORTH, tf_Lname, 50, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, tf_Lname, 15, SpringLayout.EAST, F_namelbl);
		    layout.putConstraint(SpringLayout.NORTH, Btn, 80, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, Btn, 110, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, btn_cancel, 80, SpringLayout.NORTH, p1);
		    layout.putConstraint(SpringLayout.WEST, btn_cancel, 200, SpringLayout.WEST, p1);	    
		    
		    //---------------------------------------------------------------------------------------------------------------------
		    /*Adding Action Listener/Action*/
		    btn_cancel.addActionListener(this);
		    Btn.addActionListener(this);
		    
		    //------------------------------------------------------------------------------------------------------------------------
		    /*Setting up JFrame*/
		    
		    frame.pack();
		    frame.setSize(350, 200);
		    frame.setVisible(true);	
	}
  public static void main(String args[]) 
  {	 
	  
    new SpringSample();
    Connectionstring();
    
    
    try {						 
		insertRecordIntoDbUserTable();
		selectfromdb();
	} 
	catch (SQLException e)
	{

		System.out.println(e.getMessage());

	}  
	  
  }
  //connection string method
  static Connection Connectionstring()
 	{		
 		Connection con = null;
 		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
 		String conUrl = "jdbc:sqlserver://localhost:1433; databaseName=paytest; user=PC; password=; integratedSecurity=true;";
 		
 		try 
 		{
 				 con = DriverManager.getConnection(conUrl); 				 
 				 JOptionPane.showMessageDialog(null,"Connection is open!","Connection",JOptionPane.WARNING_MESSAGE);
 				 
 				 }
 		catch (SQLException e)
 		{
 			
 			e.printStackTrace();
 		}		
 		return con;
 		
 	}
  
  private static void insertRecordIntoDbUserTable() throws SQLException
	{
		Connection con = null;
		Statement statement = null;
		String insertTableSQL = "INSERT INTO LoginDetails" + "(Username, Password) " + "VALUES" + "('user1','user1')";
		try 
		{
			con = Connectionstring();
			statement = con.createStatement(); 
			System.out.println(insertTableSQL);			
			statement.executeUpdate(insertTableSQL);			
			
			JOptionPane.showMessageDialog(null,"Your Data has been Inserted","Data Inserted",JOptionPane.WARNING_MESSAGE);
		} 
		catch (SQLException e)
		{

			System.out.println(e.getMessage()); 
		} 
		finally 
		{

			if (statement != null)
			{
				statement.close();
				
				JOptionPane.showMessageDialog(null,"Statement is closed","Statement",JOptionPane.WARNING_MESSAGE);
			}

			if (con != null)
			{
				con.close();
				
				JOptionPane.showMessageDialog(null,"Connection is closed!","Connection",JOptionPane.WARNING_MESSAGE);
			}

		}
		
		
	}
 
  private static void selectfromdb() throws SQLException
	{		
	    Statement stmt = Connectionstring().createStatement();
		ResultSet rs = stmt.executeQuery("SELECT Username,Password FROM LoginDetails");
		while (rs.next())
		{
			  String lastName = rs.getString("Username");
			  String Pass = rs.getString("Password");
			  System.out.println(lastName + "" + Pass + "\n");
			 
			}		
	}
  
  
  

 public void actionPerformed(ActionEvent e) 
{
	 
	if(e.getSource() == btn_cancel)
	{
		JOptionPane.showMessageDialog(null,"You have clicked on Cancel","button cancel",JOptionPane.WARNING_MESSAGE);
	}
	else if(e.getSource() == Btn)
	{
		JOptionPane.showMessageDialog(null,"You have clicked login","button login",JOptionPane.WARNING_MESSAGE);		
		
	}
	
	

}
}

Richard MacCutchan28-Jun-13 5:14

28-Jun-13 5:14

And what happens when you debug it?

Use the best guess

chdboy28-Jun-13 5:17

28-Jun-13 5:17

Java

Exception in thread "main" java.lang.NoSuchFieldError: address
	at java.net.InetAddress.init(Native Method)
	at java.net.InetAddress.<clinit>(Unknown Source)
	at java.net.InetSocketAddress.<init>(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SocketFinder.getDefaultSocket(IOBuffer.java:2430)
	at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2094)
	at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at SpringSample.Connectionstring(SpringSample.java:130)
	at SpringSample.main(SpringSample.java:101)

this error happens As above code is being run.

Richard MacCutchan28-Jun-13 6:00

28-Jun-13 6:00

See http://docs.oracle.com/javase/7/docs/api/java/lang/NoSuchFieldError.html[^]. Also, looking at the top four messages above, I am tempted to suspect that the version of the Microsoft library you are using is either out of date or has been corrupted somehow. Check the documentation to see if it is the latest version.

Use the best guess

chdboy28-Jun-13 6:16

28-Jun-13 6:16

I'm using sqljdbc4.jar if you are pointing towards it.I'm not sure how to check if it is latest version?

Richard MacCutchan28-Jun-13 6:45

28-Jun-13 6:45

Sorry, nor do I. I would guess you go to wherever the library comes from and ask there.

Use the best guess

chdboy28-Jun-13 6:46

How to implement a Struts project with Spring together?

28-Jun-13 6:46

ok thanks a lot Smile | :)

JasminHan25-Jun-13 18:22

JasminHan

25-Jun-13 18:22

Hello! Everyone,

May I ask for Struts project configuration with Spring.
I've used the "struts-config.xml" in Struts configuration.
But when I used it with Spring. It need to use together with "ApplicationContext.xml" for Spring. But I don't know how to connect these files together with others classes (like Action,Form and Bean). Please help me to advice and suggest for this matter.
Thanks you so much.......... *(^__^)*

Re: How to implement a Struts project with Spring together?

Arindam Mondal from India28-Jun-13 6:56

Arindam Mondal from India

28-Jun-13 6:56

I am assuming you are using Struts 1.x and Spring 2.5.x and able to solve jar dependency by your own.

If you have to integrate Struts with Spring you can follow this approach. This is the simplest way to integrate those two.

1. First you have to register spring ready-made struts plug-in in the struts-config.xml. Other things will be remain the same.

XML

 <struts-config>
   <plug-in  className="org.springframework.web.struts.ContextLoaderPlugIn">
<set-property property="contextConfigLocation"
		value="/WEB-INF/classes/ApplicationContext.xml" />
  </plug-in>
</struts-config>

The ContextLoaderPlugIn will handle all the integration work between Struts and Spring.

2. Inside your ApplicationContext.xml you have to mention all the Service and DAO and other stuff, what you want manage by Spring.

XML

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<bean id="someService" class="com.some.Service.SomeService" >
 <property name="someDao" ref="someDao" />
</bean>
</beans>

3. All struts action class must extends spring ActionSupport instead of extending struts action. This will make the spring bean available via getWebApplicationContext() method.

Java

public class SomeAction extends ActionSupport{

public ActionForward execute(ActionMapping mapping,ActionForm form, HttpServletRequest request,HttpServletResponse response) 
        throws Exception {
SomeService someService =
		(SomeService) getWebApplicationContext().getBean("someService");

Now you can invoke spring service from struts.

Re: How to implement a Struts project with Spring together?

JasminHan30-Jun-13 22:03

JasminHan

30-Jun-13 22:03

Thanks you very much for your valuable answer, Arindam Mondal! Smile | :)

Okay, I will implement and configure those part of codes like that. ^^

Re: How to implement a Struts project with Spring together?

Arindam Mondal from India1-Jul-13 3:54

Arindam Mondal from India

1-Jul-13 3:54

If you have any difficulties with this implementation (lots of action class need to be change) let me know there are other types of implementation available. Smile | :)

reading and writing using smartcard??

Sairam3925-Jun-13 0:36

Sairam39

25-Jun-13 0:36

Hi folks

I need a java program which can able to read and write smart card data.
how to do this??
I did not get any accurate programs through which I can able to get this functionality.
Valuable suggestions highly welcome.

$ai

Beginner in Java. I want to test my knowledge

Adrian Manuel Tan Cleofe22-Jun-13 16:51

Adrian Manuel Tan Cleofe

22-Jun-13 16:51

I'm a beginner in Java, learning on my own. And I want to test my knowledge in multiple classes and method with parameters.

Can you suggest any simple machine problem? Smile | :)

Re: Beginner in Java. I want to test my knowledge

Richard MacCutchan22-Jun-13 23:51

Re: Beginner in Java. I want to test my knowledge

22-Jun-13 23:51

Look at the Java Tutorials[^] where you will find lots of samples that you can easily modify.

Use the best guess

JasminHan25-Jun-13 18:43

JasminHan

25-Jun-13 18:43

Hi!! ^^
Here are some links for Java Beginner.
Some of these may be useful to help your learning.... Smile | :)

1.http://www.javabeginner.com/[^]
2.http://www.freejavaguide.com/corejava.htm[^]
3.http://www.java-made-easy.com/java-for-beginners.html[^]
4.http://www.java-examples.com/[^]
5.http://www.courses.coreservlets.com/[^]
6.http://www.java2s.com/[^]
7.http://java.about.com/[^]

Re: Beginner in Java. I want to test my knowledge

MarlBermudoNights3-Jul-13 22:31

MarlBermudoNights

3-Jul-13 22:31

Do you want a practice with class inheritance?
If yes: create a command line chess set, no AI need, just recreate the basic methods of movements,etc.

no: create a command line turtle graphics app. Here is a turtle graphics problem definition:
http://www.bfoit.org/itp/IntroCmdsScreencast.html[^]

Java application path in Eclipse juno show wrong neet to set correct

Balmukund Dewangan21-Jun-13 4:21

Balmukund Dewangan

21-Jun-13 4:21

Hi..

I am using eclipse juno,tomcat6.
I want to read the property file only by name. and path should be my current location.
currenttly i have hard coded the path. "E:\SERENE0121201311\phibro\param.properties". But when i read the current path it shows "E:\Eclipse_Juno" but it should be ""E:\SERENE0121201311\phibro".

Can anyone help me to set application path..

Thanks

Re: Java application path in Eclipse juno show wrong neet to set correct

Richard MacCutchan21-Jun-13 5:25