I know most databases have restrictions, but Postgres doesn’t. You can run any number table creations, column changes and index changes in a transaction, and the changes aren’t visible to other users unit COMMIT succeeds. That’s how databases should be! 🙂 As for SQL Server you can run DDL inside of a transaction, but SQL … Read more
Getting error “ClassNotFoundException” while using JTDS on ANDROID to direct access SQLSERVER? After 3 hours RND, for finding solution for the same above error. I didnt get there is no error in the code, also I have import “jtds-1.3.0” library properly continues debugging of code still getting same error again and again. { Class.forName(“net.sourceforge.jtds.jdbc.Driver”); Connection … Read more
As detailed in the jTDS Frequenlty Asked Questions, the URL format for jTDS is: jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;…]] So, to connect to a database called “Blog” hosted by a MS SQL Server running on MYPC, you may end up with something like this: jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS;user=sa;password=s3cr3t Or, if you prefer to use getConnection(url, “sa”, “s3cr3t”): jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS EDIT: Regarding your Connection … Read more
You probably want to add “static” to the declaration of con2. In Java, things (both variables and methods) can be properties of the class (which means they’re shared by all objects of that type), or they can be properties of the object (a different one in each object of the same class). The keyword “static” … Read more