1. Calling stored procedure from web application on UNIX throwing error on xp_cmdshell stackoverflow.comHey 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 ... |
2. What can cause the SQL Server JDBC error 'The value is not set for the parameter number 0' for an output parameter access? stackoverflow.comI have some Java code that accesses SQL Server 2005 which looks something like this: |
3. java : use of executeQuery(string) method not supported error? stackoverflow.comI'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) ... |
4. Is this error related to the OS or the database? stackoverflow.comI 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 ... |
5. JAVA Procedure Error stackoverflow.comjava.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 ... |
6. JDBC/ODBC error in windows 7 64 bit stackoverflow.comPossible Duplicate:java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length |
7. Connection JDBC SQL Server Error stackoverflow.comI'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 ... |
8. java.lang.NullPointerException** error? stackoverflow.comI am trying to add records to Sql Server in Java. In this function, program gives an error like that: |
9. Error Running Sonar connected to SQL Server 2005. SONAR.dbo.rules for column description stackoverflow.comWhen I start Sonar (StartSonar.bat), I get the following error in the log file. Wrong column type in SONAR.dbo.rules for column description.Looking at the column ... |
10. execution stops with no errors thrown during jdbc connection stackoverflow.comJust 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 ... |
11. Error while trying to get data out of SQL-Server forums.netbeans.orgHello 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 ... |
12. Error while using jdbc2.0 features with SqlServer coderanch.com |
13. SQl Server error converting datetime to smalldatetime coderanch.com |
14. Simple DB Error check in SQL-Server Stored Proc coderanch.comHi, 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 ... |
15. JDBC Error MSSQL Uniqueidentifier coderanch.comI 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 ... |
16. Error in datasource using SQLSERVER coderanch.comI 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"> - - |
17. Help needed on SQL Server Error coderanch.com// 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 ... |
18. SQL Server 2005 Express error logs coderanch.comCan 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 |
19. ms sql server could not be bound error coderanch.comint 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; } |
20. JDBC to SQL Server 2005 connectivity error coderanch.com |
21. Error in creating a sequence in SQL Server 2005 java-forums.orgI 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 ... |