Hey all, I'm pulling my hair out on this one.
I've checked all my permissions, on both the database server (SQL Server 2000) and the file system to ensure that what I ... |
I have some Java code that accesses SQL Server 2005 which looks something like this:
CallableStatement cstmt = ...;
... // Set input parameters
cstmt.registerOutParameter(11, Types.INTEGER);
cstmt.execute();
int out = cstmt.getInt(11);
And the following exception is thrown ... |
I'm doing a simple preparedstatement query execution and its throwing me this error:
java.sql.SQLException: Use of the executeQuery(string) method is not supported on this type of statement at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.notSupported(JtdsPreparedStatement.java:197) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:822) ... |
I have a java programs that gives me an error after working fine for a few hours ... these programs used to work fine on our earlier server which had windows ... |
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Procedure 'STP_Insert_tblReceipt' expects parameter '@CPVFlag', which was not supplied.
I m getting error at This Point when trying to call procedure...
Everything is perfect ,,,Count of Question marks ... |
Possible Duplicate:
Error while connecting to ODBC Database
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
|
I've tryed to create a connection with a Microsoft SQl Server 2008 database through JDBC on Eclipse SDK. I've dowloaded JDBC driver from microsoft and I've installed it, then I've added ... |
|
I am trying to add records to Sql Server in Java. In this function, program gives an error like that:
Connected
1
2
Error java.lang.NullPointerException
It is the output..
Function is below:
public class DB {
...
|
When I start Sonar (StartSonar.bat), I get the following error in the log file.
Wrong column type in SONAR.dbo.rules for column description.
Found: ntext, expected: nvarchar(max)
Looking at the column ... |
Just got done setting everything up and ran my code. but java doesn't throw any errors so I don't know what is wrong. Here is my setup
win7 - sql server 2008 ... |
Hello everybody, I developed a GUI using Java to enter some data into a SQL-Database using Netbeans 6.5. When opening the project with Netbeans 6.7.1, the connection will be established, however ... |
|
|
Hi, I am successfully able to call a simple (INSERT) SP in sql-server. I am trying to understand what would be the best way to check to see if the INSERT in my SP failed or succeeded. Here is my code: SP: -------------------------------- CREATE Procedure dbo.AddReport ( @rpt_idVarChar(5), @rpt_nameVarChar(35), @FileDataImage ) As /******************************************************************************* Funtion: AddReport Author: Jason Skaggs Created Date: 4/18/2001 ... |
I am attempting to run a callable statement and I am getting this error: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Error converting data type nvarchar to uniqueidentifier. this is the signature of the stored procedure. CREATE PROCEDURE p_order_create @output_message AS varchar(255) OUTPUT, @executer_entity_id AS uniqueidentifier, @executer_entity_hierarchy_id AS uniqueidentifier, @executer_company_id AS uniqueidentifier, @order_id AS uniqueidentifier OUTPUT, @u_id_order_type AS uniqueidentifier, @u_id_order_origination AS uniqueidentifier, @entity_id_customer ... |
I am trying to use connection pooling for connecting sqlserver2000 on tomcat webserver using datasource i make a following entry in server.xml Host name="localhost" appBase="webapps" debug="0" unpackWARs="false"> - - - - factory org.apache.commons.dbcp.BasicDataSourceFactory - maxActive 100 - maxIdle ... |
// Connection to the FIN SQL server String hostname = "ftwfinsql01"; try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conFin = DriverManager.getConnection("jdbc:microsoft:sqlserver://"+ hostname +":1433;DatabaseName=fincl_prod;User=fincl;Password=xxsykdl1"); conFin.setAutoCommit(false); } catch(Exception e) { log.error("createConnection() caught an unexpected exception: " + e.getMessage(), e); } [code] sql = "SELECT e.descrtext "+ "from ftwfinsql01.fincl_prod.dbo.gl_expentity_view e "+ "where e.entitycode = '" + requisitionID.getEntity() + "' "+ // in the POI table this is equal ... |
Can anyone tell me how to look up the SQL Server error logs? An update query is not executing from Java application. It is working fine when I am directly entering the query in SQL Server query window. If I know the log file, I can see the recorded messages based on the time of application execution |
int id = 0; Connection conn; conn = DBUtils.getConnection(); String sql = "SELECT imgId FROM MyDB." + LIBRARY_TABLE + " WHERE fileName = " + fileName; PreparedStatement stmt = conn.prepareStatement(sql); //blows up on the following line ResultSet rs = stmt.executeQuery(); while (rs.next()) { try { id = rs.findColumn("imgId"); } catch (Exception e) { e.printStackTrace(); } } return id; } |
|
I am trying to create a sequence in SQL Server 2005 following is the sql code CREATE SEQUENCE SEQ_NAME MINVALUE 1 MAXVALUE 99999 INCREMENT BY 1 START WITH 1 CACHE 20; But its giving the error as: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'SEQUENCE'. Msg 319, Level 15, State 1, Line 5 Incorrect syntax near the ... |