jdbc - Connecting to a SQL Server 2000 db from Java -

-

i receiving error did see on site, novice java coder think flubbed implementation of solution.

i getting message "sql server version 8 not supported driver. clientconnectionid:602d619d-c033-41d0-9109-80f56e3ab9b3"

i using eclipse mars 1 database sql server 2000, downloaded sqljdbc.jar microsoft site suggested earlier question. loaded c:\temp , added classpath , rebooted.

code snippet reads:

package texaslampconversion;  import java.sql.*; import java.io.bufferedreader; import java.io.file; import java.io.filereader; import java.io.filewriter; import java.io.ioexception;  public class texaslampconversion {      public static void main(string[] args) {         // todo auto-generated method stub         string host = "jdbc:sqlserver://servername\\instancename";         string uname = "*********";         string upass = "*********";         connection conn = null;          try {              conn  = drivermanager.getconnection(host, uname,upass);              if (conn != null) {                                system.out.println("connected database");               }          } catch (sqlexception ex) {             system.out.println(ex.getmessage() );             ex.printstacktrace();         } {             if (conn != null) {                 try {                     conn.close();                 } catch (sqlexception ex) {                     ex.printstacktrace();                 }             }         }          filewriter fw= null;         file file =null;            try {                 file=new file("c:/temp/generated_stmts_update_t_customer_master.sql");                 if(!file.exists()) {                     file.createnewfile();                 }                 fw = new filewriter(file);            }catch (ioexception e) {                 e.printstacktrace();                 }          string  oldkey = "8000001234", newkey = "8";         int     lenacct = 10;         oldkey = reformatoldacct(lenacct, oldkey );         newkey = leftzeroacct(lenacct, newkey);         system.out.println("oldkey = " + oldkey + " , newkey = " + newkey);      }      private static string reformatoldacct(int lenacct, string oldkey) {         // todo auto-generated method stub         string reformatedacct = "";         reformatedacct = "0" + oldkey.substring(2, lenacct);         return (reformatedacct);      }      private static string leftzeroacct(int lenacct, string acctno) {         // todo auto-generated method stub         int index =0;         int currentlengthacct;         string  leadingzero = "";         currentlengthacct = acctno.length();          while (index < (lenacct -currentlengthacct) ) {             leadingzero = '0'  + leadingzero;             index ++;         }         return (leadingzero + acctno);     }  }

and throwing complete message

apr 19, 2016 11:29:44 com.microsoft.sqlserver.jdbc.sqlserverconnection prelogin warning: connectionid:1 clientconnectionid: 602d619d-c033-41d0-9109-80f56e3ab9b3 server major version:8 not supported driver. apr 19, 2016 11:29:44 com.microsoft.sqlserver.jdbc.sqlserverconnection prelogin warning: connectionid:1 clientconnectionid: 602d619d-c033-41d0-9109-80f56e3ab9b3 server major version:8 not supported driver. com.microsoft.sqlserver.jdbc.sqlserverexception: sql server version 8 not supported driver. clientconnectionid:602d619d-c033-41d0-9109-80f56e3ab9b3com.microsoft.sqlserver.jdbc.sqlserverexception: sql server version 8 not supported driver. clientconnectionid:602d619d-c033-41d0-9109-80f56e3ab9b3

at com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:2226)    @ com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:2226) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:2210) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:2210) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.prelogin(sqlserverconnection.java:2095)  @ com.microsoft.sqlserver.jdbc.sqlserverconnection.prelogin(sqlserverconnection.java:2095) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.connecthelper(sqlserverconnection.java:1799) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.connecthelper(sqlserverconnection.java:1799) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.login(sqlserverconnection.java:1454) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.login(sqlserverconnection.java:1454) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.connectinternal(sqlserverconnection.java:1285) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.connectinternal(sqlserverconnection.java:1285) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.connect(sqlserverconnection.java:700) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.connect(sqlserverconnection.java:700) @ com.microsoft.sqlserver.jdbc.sqlserverdriver.connect(sqlserverdriver.java:1131) @ com.microsoft.sqlserver.jdbc.sqlserverdriver.connect(sqlserverdriver.java:1131) @ java.sql.drivermanager.getconnection(unknown source) @ java.sql.drivermanager.getconnection(unknown source) @ java.sql.drivermanager.getconnection(unknown source) @ java.sql.drivermanager.getconnection(unknown source) @ texaslampconversion.texaslampconversion.main(texaslampconversion.java:20) @ texaslampconversion.texaslampconversion.main(texaslampconversion.java:20)

sql server version 8 not supported driver. clientconnectionid:602d619d-c033-41d0-9109-80f56e3ab9b3 sql server version 8 not supported driver. clientconnectionid:602d619d-c033-41d0-9109-80f56e3ab9b3

any thoughts novice java programmer moving away powerbuilder?


Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more