Problem with JDBC Driver for MS SQL Server

Dear All,

I developed an web application which use MS SQL Server 2000. I
encounter the following SQLException "[Microsoft][SQLServer 2000
Driver for JDBC]Error setting up static cursor cache". Did anyone
encounter this problem before? What does this exception mean and how
to solve this problem?

[Remarks: The web application work properly on development machine and
this machine but encounter this exception when move to another
machine, so is this exception related to the machine?]

Thank you for your attention.

Yours faithfully,
Benny
Benny wrote:

> Dear All,
> I developed an web application which use MS SQL Server 2000. I
> encounter the following SQLException "[Microsoft][SQLServer 2000
> Driver for JDBC]Error setting up static cursor cache". Did anyone
> encounter this problem before? What does this exception mean and how
> to solve this problem?

I think it has to do with OS user file permissions in temp directories.
Joe Weinstein at BEA

> [Remarks: The web application work properly on development machine and
> this machine but encounter this exception when move to another
> machine, so is this exception related to the machine?]
> Thank you for your attention.
> Yours faithfully,
> Benny|||I have been investigating the same thing. I have added the C:\Documents and Settings\Administrator\Local Settings\Temp to every policy file that I could find (both the java.policy and catalina.policy files). This does not seem to help. Hmmmmm.... I will keep working on it, but if you have figured it out, I would really appreciate you letting me know how to resolve this.

This is a win2k environ w sqlserver 2000.

Problem with INSERT INTO statement

When I try to run INSERT INTO statement, I receive
following message:
[Microsoft][ODBC Microsoft Access Driver] Characters
found after end of SQL statement.
SQL state: 37000
Error code: -3517
Thanx in advance
Simon
The whole code for the program is:
public boolean RUNSQL(Zapis zapis, int id, int nacin)
throws java.rmi.RemoteException{
try {
Connection connection = DriverManager.getConnection
("jdbc:odbc:Zapis", "", "");
connection.setAutoCommit(false);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
if(nacin == 1)
{
Statement stmt = connection.createStatement();
String query = "INSERT INTO zapisi ("+
"agent, indeks, vrsta, velikost,
lokacija, lastnik"+
") VALUES ('"+
zapis.getAgent() + "','"+
zapis.getId() + "','"+
zapis.getVrsta() + "','"+
zapis.getVelikost() + "','"+
zapis.getLokacija() + "','"+
zapis.getLastnik() + "');'";
int result = stmt.executeUpdate(query);
stmt.close();
}
}
catch(ClassNotFoundException cnfe)
{
System.out.println("Class " + cnfe);
return false;
}
catch(SQLException i)
{
try
{
connection.rollback();
}
catch(SQLException s)
{
System.out.println("Rollback failed");
return false;
}
System.out.println("SQL exception " + i);
return false;
}
finally{
try
{
connection.commit();
connection.close();
}
catch(SQLException sqle)
{
System.out.println("Commit failed");
return false;
}
}
connection.close();
return true;
}
catch(Exception e){
System.out.println("Error connecting to database");
}
return true;
}
You have an extra semicolon after the closing parenthesis in your INSERT
statement. The line that reads
zapis.getLastnik() + ");";
should read
zapis.getLastnik() + ")";
"Simon" <simon.sauperl@.uni-mb.si> wrote in message
news:3bab01c42a56$aaa32870$a601280a@.phx.gbl...
> When I try to run INSERT INTO statement, I receive
> following message:
> [Microsoft][ODBC Microsoft Access Driver] Characters
> found after end of SQL statement.
> SQL state: 37000
> Error code: -3517
> Thanx in advance
> Simon
> The whole code for the program is:
> public boolean RUNSQL(Zapis zapis, int id, int nacin)
> throws java.rmi.RemoteException{
> try {
> Connection connection = DriverManager.getConnection
> ("jdbc:odbc:Zapis", "", "");
> connection.setAutoCommit(false);
> try{
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> if(nacin == 1)
> {
> Statement stmt = connection.createStatement();
> String query = "INSERT INTO zapisi ("+
> "agent, indeks, vrsta, velikost,
> lokacija, lastnik"+
> ") VALUES ('"+
> zapis.getAgent() + "','"+
> zapis.getId() + "','"+
> zapis.getVrsta() + "','"+
> zapis.getVelikost() + "','"+
> zapis.getLokacija() + "','"+
> zapis.getLastnik() + "');'";
> int result = stmt.executeUpdate(query);
> stmt.close();
> }
> }
> catch(ClassNotFoundException cnfe)
> {
> System.out.println("Class " + cnfe);
> return false;
> }
> catch(SQLException i)
> {
> try
> {
> connection.rollback();
> }
> catch(SQLException s)
> {
> System.out.println("Rollback failed");
> return false;
> }
> System.out.println("SQL exception " + i);
> return false;
> }
> finally{
> try
> {
> connection.commit();
> connection.close();
> }
> catch(SQLException sqle)
> {
> System.out.println("Commit failed");
> return false;
> }
> }
> connection.close();
> return true;
> }
> catch(Exception e){
> System.out.println("Error connecting to database");
> }
> return true;
> }
sql

Problem with DTS Source using Pervasive SQL 2000 (Btrieve) ODBC driver

I am trying to use a DTS package to extract data from an old Pervasive SQL 2000 (Btrieve) data source, and copy into an MS SQL Server table.

I have installed the Pervasive ODBC driver and got linked tables in Access working. I can see the data.

When I create the DTS package, it shows a list of the tables in the drop-down, but when I hit the Preview button I get an unspecified error. I can finish setting up the DTS package, the new MS SQL Sever table gets created, and the field transformations all look correct. However, when I execute the package it fails. In the logs, I get an unspecified error, the only error code I get in log is: 80074005.

Please help.

Thanks!

This is a SSIS forum. Try the DTS newsgroup instead: http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.dts

-Jamie

|||

Carson,

Feel free to email me at tcarcieri@.rihousing.com and I can walk you through what I did. In addition, you wouldn't happen to know if there is a way to only install Pervasive 2000i ODBC drivers on a server would you? I do not want to install the whole pervasive app to do so nor do I want to buy drivers.

THanks,
Tony

Problem with DTS Source using Pervasive SQL 2000 (Btrieve) ODBC driver

I am trying to use a DTS package to extract data from an old Pervasive SQL 2000 (Btrieve) data source, and copy into an MS SQL Server table.

I have installed the Pervasive ODBC driver and got linked tables in Access working. I can see the data.

When I create the DTS package, it shows a list of the tables in the drop-down, but when I hit the Preview button I get an unspecified error. I can finish setting up the DTS package, the new MS SQL Sever table gets created, and the field transformations all look correct. However, when I execute the package it fails. In the logs, I get an unspecified error, the only error code I get in log is: 80074005.

Please help.

Thanks!

This is a SSIS forum. Try the DTS newsgroup instead: http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.dts

-Jamie

|||

Carson,

Feel free to email me at tcarcieri@.rihousing.com and I can walk you through what I did. In addition, you wouldn't happen to know if there is a way to only install Pervasive 2000i ODBC drivers on a server would you? I do not want to install the whole pervasive app to do so nor do I want to buy drivers.

THanks,
Tony