SQL Server Java driver not working in class path -


i have written simple java file handle sql integrated sql server.

i downloaded appropriate driver , stored jar in correct class path works if run file directly.

i have tried calling methods within sql class class , following error:

java.lang.classnotfoundexception: com.microsoft.sqlserver.jdbc.sqlserverdriver

i understand issue documented doesn't address unique problem works within file not externally.

another issue after program closed , rebuild program forgets jar added library , requires me add again not good.

i have tried adding class path manually copying , pasting xml config file hacky solution , rather properly. please let me know going wrong.

    <classes>        <root url="jar://$user_home$/.gradle/caches/modules-2/files-2.1/org.ow2.asm/asm/5.0.4/da08b8cce7bbf903602a25a3a163ae252435795/asm-5.0.4.jar!/" />        <root url="jar://$user_home$/ideaprojects/r3prototypingcfs/contracts/src/main/kotlin/com/r3corda/protocols/sqljdbc42.jar!/" />     </classes> 
class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver");

use jdts driver ..it work sql server 2014.

pom.xml

<dependencies>     <!-- https://mvnrepository.com/artifact/net.sourceforge.jtds/jtds -->     <dependency>         <groupid>net.sourceforge.jtds</groupid>         <artifactid>jtds</artifactid>         <version>1.3.1</version>     </dependency>  </dependencies>

and src

import java.sql.*;  public class main {      public static void main(string[] args) throws sqlexception {     // write code here         connection conn = null;         resultset rs = null;         string url = "jdbc:jtds:sqlserver://localhost:1433/databasename";         string driver = "net.sourceforge.jtds.jdbc.driver";         string username = "username";         string password = "yourpassword";         try {             class.forname(driver);             conn = drivermanager.getconnection(url, username, password);             system.out.println("connected database!!! getting table list...");             statement stmt = conn.createstatement();              string sql = "select top 10 phonenumber,registrationdate\n" +                     "      \n" +                     "  tblproductregistration";            // resultset resultset = stmt.executequery(sql);            //  string selectsql = "select user_id, username dbuser user_id = ?";             //statement stmt = conn.createstatement();             resultset resultset = stmt.executequery(sql);            // preparedstatement.setint(1, 1001);            // resultset resultset = preparedstatement.executequery( );             //step 5: extract data result set             while(resultset.next()){                 //retrieve column name                 string phonenumber  = resultset.getstring("phonenumber");                 string registrationdate  = resultset.getstring("registrationdate");                   //display values                 system.out.print("phonenumber: " + phonenumber);                 system.out.print("registrationdate: " + registrationdate);              }         } catch (exception e) {             e.printstacktrace();         } {             conn.close();             rs.close();         }      } }

Comments

Post a Comment

Popular posts from this blog

sql server - Cannot query correctly (MSSQL - PHP - JSON) -

i have little problem on project. , turns out query result returns nothing when value of first name or last name has 'ñ' in it. here's code config.php: <?php ini_set('mssql.charset', 'utf-8'); header('content-type: text/html; charset=utf-8'); $servername = "192.168.1.21"; /* ip add of db server */ $connection = array("database" => "db", "uid" => "?", "pwd" => "***"); $conn = sqlsrv_connect($servername, $connection); if(!$conn){ echo "connection not established."; die(print_r(sqlsrv_errors(), true)); } ?> myquery: $idnumber = $_post["idnum"]; $response = array(); $query2 = "select clname, cfname, cmname, cqualifier student cidno = '$idnumber'"; try{ $stmt2 = sqlsrv_query($conn, $query2); } catch(pdoexeption $ex){ $response["success"] = 0; $response["message"] = "d...
Read more

php - trouble displaying mysqli database results in correct order -

i have table in database stores events , date expire. want display events on website display current events first expired events after? i have tried following sql $sql = "select noticeid, notice, noticedesc, noticeimg, noticedate, expirydate tbl_notices group noticeid ,expired order expirydate asc"; but returns expired results first due expirydate being ordered asc in query. my tbl_notice structure looks this noticeid => int(4) notice => varchar(100) noticedesc => text noticedate => timestamp noticeimg => varchar(40) expirydate => datetime expired => int(1) 0 current or 1 expired my php code is $sql = "select noticeid, notice, noticedesc, noticeimg, noticedate, expirydate tbl_notices group noticeid ,expired order expirydate asc"; $result = mysqli_query($conn,$sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { ...
Read more

C++ Linked List -

i trying create linked list download txt file , use linked list handle file line line. when handling downloaded linked list operations performed on such text editor would. encountering problems however. seems "node(string value)" section of code has wrong though original node() declaration no arguments passes. unable figure out quite is. node.h class node { public: node(); node(string value); void setnext(node *nextnode); // allows user set "next" pointer of node points friend class linkedlist; private: string data; // data box node* next; // pointer box }; node.cpp # include <string> # include "node.h" using namespace std; node::node() { data = ""; next = null; } node::node(string value) { data = value; next = null; } void node::setnext(node *nextnode) // allows user set "next" pointer of node points { this->next = nextnode; } your #include <string> ...
Read more